Stock Prices in Apple Numbers incorrect

The stock price is the previous day closing price. It is provided by Yahoo! Finance. If it is incorrect, that is where the trouble is (or so we have been led to believe). The most commonly reported problem has been missing data. That usually clears up after a few days for the person reporting it but then someone else will report that their stocks quit working. I get the feeling that Yahoo! Finance doesn't feel that this is a priority for them.

StickyMonkey wrote:

Where is it pulling the data from.

Yahoo! Finance. Previous day.

Do NOT try to use Numbers, or any other spreadsheet for that matter, for day trading!

They're good for investment analysis, but not for short-term speculation.

SG

AndrewJ99 wrote:

The prices are correct on Yahoo Finance but not on Numbers.

Are you sure that the price you are looking at on Yahoo! Finance is the closing price for the previous trading day?

In general you can only get relatively old prices via Numbers, not good enough for trading, but useful for analysis and historical trends.

If you are sure that the price you are getting via Numbers is not the same as the previous day's closing price on Yahoo! Finance, then you can try filing a bug report with Apple at Numbers > Provide Numbers Feedback in your menu.

SG

As far as I know, Apple's Stocks app works fine. It, too, gets it data from Yahoo! Finance but it does not have random data dropouts for days at a time, old data, and possibly incorrect data like Numbers does. Maybe it is a Yahoo! problem, maybe it is an Apple Numbers problem. I am thinking the link is to an Apple server, not directly to Yahoo!, so it could be either. Until someone sniffs their network traffic to determine where the data is coming from, we won't know.

This is way off. Where is it pulling the data from. Price is what numbers is pulling.

If I recall, the Stock functions cache data. I've seen prices get "stuck" before. It seems to be a related problem but who knows.

AndrewJ99 wrote:

I've managed to get it to update but only by double clicking individually on each cell.

What is the "it"? What is the formula that you are using?

SG