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.
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.
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.
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.
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
No. It's the closing from the prior day.
It’s really too bad. If it at least updated right at the close.
real time stock quote update in Numbers