When exactly does Numbers refresh stock quote data?

Question

Level 1

120 points

When exactly does Numbers refresh stock quote data?

I know Apple says it provides the previous day’s closing price, and I’ve noticed the stock price updated in my spreadsheet at the following midnight (EST) after close, but today my spreadsheet hasn’t updated yesterday’s closing price yet and it’s almost closing time for today. (Today is Thursday 3/25 and it’s still showing the closing price from Tuesday 3/23.) I’ve reopened the spreadsheet and viewed on multiple devices. Cryptocurrency prices update in the spreadsheet with every refresh, by the way.

Do stock prices not update at a consistent time? Could it update at 11:59pm today, then immediately update again at midnight, giving me no time to see yesterday’s data?

Or worse, do they not even always update every day?

I’m a novice at spreadsheets, but I was hoping to set up some sort of automation in my spreadsheet that would pull updated data from the sheet daily, but that might be tricky or impossible if I don’t know if and when the data is going to be updated each day.

Much appreciated!

Posted on Mar 25, 2021 1:18 PM

Reply

Answer 1

Mar 25, 2021 3:07 PM in response to BobnCarol

I got the quotes to update. After installing the latest Numbers update, close any active spreadsheets, then close Numbers, then kill the Numbers task. Open Numbers, then open the spreadsheet that uses the quote function and the quotes should update to the previous day’s close.

And above I said 9pm Eastern, I meant 12 am Eastern, 9pm Pacific, sorry.

Reply

Answer 2

Mar 25, 2021 1:44 PM in response to oregonjoe

They had been updating at 9:00 pm Eastern time, but they have stopped updating since the Numbers app update a couple of days ago. Apple support, please help fix this!!!

Reply

Answer 3

Apr 27, 2021 12:59 AM in response to oregonjoe

My suggestion is to learn about STOCKH function and forget about STOCK. Then, put your stock code at the top of the column and put consecutive dates in a column (A) then you can use the same formula ( copy /paste) to get the closing price for each day. THEN, you will get the data you want for each day.

Reply

Answer 4

oregonjoe Author

Level 1

120 points

Mar 25, 2021 1:59 PM in response to BobnCarol

9pm EST of the following day or same day? That’s weird because of the few days since I made this spreadsheet, mine updated twice at midnight EST after close, and then missed it the third time. But I’ll check again today after 9pm to see if it updates yesterday’s.

I haven’t updated Numbers in a couple weeks so that shouldn’t be the issue for me. But that’s bad to hear it stopped working. Hopefully Apple gets on that.

Reply

Answer 5

oregonjoe Author

Level 1

120 points

Mar 25, 2021 8:04 PM in response to BobnCarol

My spreadsheet quotes finally updated too, but just on its own, I didn’t do anything. Maybe there was just something funky going on with the servers. ?

I think I’ll keep checking over the next several days to see if it goes back to consistently updating at midnight.

Thanks anyway.

Reply

Answer 6

oregonjoe Author

Level 1

120 points

Mar 25, 2021 2:18 PM in response to BobnCarol

Deleted

Reply

When exactly does Numbers refresh stock quote data?

Similar questions