Hi All
I tried using the Stock Quote feature in Numbers and found it doesn't update the quotes. I've read lots of threads but none seem to work for me. Is there away to use the Stock Quote insert that updates? This insert can be used for, Yield, P/E, 52wkLow, 52wkHigh etc. What use is this if it can't be updated?
John
iMac 27″, macOS 10.15
I update the latest prices in just a few seconds by doing the following. Create a watch list with your broker and download it whenever you need an update. Sort the codes alphabetically and paste the prices into your spreadsheet. Your spreadsheet list should also be alphabetically listed to match. After pasting into a column the table can be transposed into a row. In Numbers, select "Table", then "Transpose Rows and Columns".
Hi John,
The stock function, unfortunately, returns stock information from the previous day's close. The information is not updated in real time.
-tom
Tom,
thanks, at least its only a day old!
John
John,
Mutual Fund financials update the same day, when yahoo updates that data, usually a few hours after market close.
-tom
See my earlier reply above
See my reply below
Stock Quote
