I inset functions for stock quotes and exchange rates in a Numbers sheet an it works fine, except it never refreshes the data. If I open the sheet after few days, it’s still showing the same quotes.
Is there a way to refresh the quotes ? Maybe when you reopen the Numbers sheet ?
Thank you.
—–
Roberto Mancini
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Make Stock Quotes and Exchange Rates Refresh In Numbers?
Comments: 2 Responses to “How Do I Make Stock Quotes and Exchange Rates Refresh In Numbers?”
Comments Closed.
The data should update automatically. But keep in mind it is daily data, with the closing from the previous day. So you won't see the numbers update in a given day. You'll have to wait until the next day's closing time to see the numbers change. Not sure when the exact time of the change happens, but it only comes 5 times per week.
Thank you Gary, will check that out.
Please keep up the excellent job you are doing, appreciate it.