How is the information refreshed in a stock table? Obviously the information for a given stock is grabbed when you enter that stock symbol, but is there a way to update that data? Is it done automatically periodically? If so, what is the period?
If you enter the stock symbol in Numbers, any information 'grabbed' is already contained in the same document. Nmbers has no means of communicating on its own with applications outside the open document or with other open documents, with two exceptions: You can enter a link in a cell that, when clicked will open a new email message in Mail, or a link that will open a specific webpage.
AppleScripts have been written that will collect stock data from a specified webpage and deliver that data to a Numbers the clipboard or to a Numbers document. These scripts need to be triggered by the user each time an update is required.
Two scripts related to this topic can be found in this (much earlier) discussion Re: Getting Stock Quotes Into iWork 3.1. The author, SGIII, is active, and will likely respond later today or early tomorrow.
Regards,
Barry
There is a Numbers update available now in the App Store that claims to add the ability to download live stock data
Maybe download the update to see if it addresses your question
Thanks Barry. I'm aware of the latest update and it is that which promoted my original question.
To put it another way, when entering a stock symbol in the appropriate cell Numbers now goes off and retrieves data. Is the only way to refresh that data by deleting the stock symbol and re-entering it thereby forcing Numbers to retrieve again?
I got the update, and entered my TIAA fund symbols. It worked great for 3 days and now they don't update at all - they are all stuck on May 10th 6:35 PM.
Tried in a new sheet and the same thing - prices retrieved are from May 10th.
Anybody know why this is?
based on my limited testing, the value updates as tim progresses. If you select the cell with the formula:
=stock("AAPL", 0)
Thanks for the update, Wayne. Peter Breise has posted a similar message regarding the update to Pages, which also received this new feature in tables.
Regards,
Barry
It seems a little glitchy here too. You can try a couple of things. Make a change (any change) in the table with the formulas. Quit Numbers and reopen the document.
SG
It's only the TIAA prices that are stuck - DJI, AAPL, etc all work fine.
Restarting Numbers after making a change didn't help. I think a reboot might be in order.
TIAA Symbols:
QREARX |
TIQRX |
TLIRX |
Might want to go to Yahoo! Finance and see if the TIAA prices have been updated there, to make sure the problem isn't there instead of in Numbers.
SG
Yup! Not updated on Yahoo! Finance either.
Thanks
This also happens to me. Still haven't found out a way to force it. Let you know if I find something that works.
Re-installing app does not address this bug.
Refresh of stock data
