real time stock quote update in Numbers

Is there a way to get a real time stock quote update in numbers? The current stock quote is 2 days behind and very useless that way.

Posted on Jan 26, 2022 3:58 PM

Reply
Question marked as Top-ranking reply

Posted on Jan 26, 2022 6:41 PM

There is no provision to have real-time stock quotes. I suppose an AppleScript could be written to gather that data from the web and populate cells in a table. The built-in functions provide historic data only and are at the mercy of Yahoo! Finance which has some spotty data that is not always correct or available.

4 replies
Question marked as Top-ranking reply

Jan 26, 2022 6:41 PM in response to TCLDocta

There is no provision to have real-time stock quotes. I suppose an AppleScript could be written to gather that data from the web and populate cells in a table. The built-in functions provide historic data only and are at the mercy of Yahoo! Finance which has some spotty data that is not always correct or available.

Jan 27, 2022 5:25 AM in response to TCLDocta


TCLDocta wrote:

If it at least updated right at the close.


Generally the prices from the STOCK function are from the close of the previous trading day as reported on Yahoo! Finance.


True real-time quotes generally are available only for a significant price It is possible to get free delayed intra-day quotes (i.e. not as old as the previous day but not real time either). One way is to set up a list of symbols and price retrieval functions in Google Sheets and copy-paste from there into Numbers.


SG


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

real time stock quote update in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.