STOCK
WHY THE PRICING OF THE STOCKS NOT ACCURATE ON MY STOCK TEMPLATE
Apple’s Worldwide Developers Conference to kick off June 10 at 10 a.m. PDT with Keynote address
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
The Keynote will be available to stream on apple.com, the Apple Developer app, the Apple TV app, and the Apple YouTube channel. On-demand playback will be available after the conclusion of the stream.
WHY THE PRICING OF THE STOCKS NOT ACCURATE ON MY STOCK TEMPLATE
If your problem is the STOCK function not giving you real-time prices, it does not do that. It provides the previous market day's closing price. If your problem is incorrect or missing data then you are not alone. Below are recent threads on STOCK, STOCKH, CURRENCY and CURRENCYH functions, all of which get their data from the same place, Yahoo Finance.
https://discussions.apple.com/thread/252729162
https://discussions.apple.com/thread/252727000
https://discussions.apple.com/thread/252719789
https://discussions.apple.com/thread/252719789
https://discussions.apple.com/thread/252688012
https://discussions.apple.com/thread/252710287
https://discussions.apple.com/thread/252685115
https://discussions.apple.com/thread/252669202
https://discussions.apple.com/thread/252695426
https://discussions.apple.com/thread/252684878
https://discussions.apple.com/thread/252691959
If your problem is the STOCK function not giving you real-time prices, it does not do that. It provides the previous market day's closing price. If your problem is incorrect or missing data then you are not alone. Below are recent threads on STOCK, STOCKH, CURRENCY and CURRENCYH functions, all of which get their data from the same place, Yahoo Finance.
https://discussions.apple.com/thread/252729162
https://discussions.apple.com/thread/252727000
https://discussions.apple.com/thread/252719789
https://discussions.apple.com/thread/252719789
https://discussions.apple.com/thread/252688012
https://discussions.apple.com/thread/252710287
https://discussions.apple.com/thread/252685115
https://discussions.apple.com/thread/252669202
https://discussions.apple.com/thread/252695426
https://discussions.apple.com/thread/252684878
https://discussions.apple.com/thread/252691959
You should be getting the closing price of the previous trading day. If you aren't getting those (many users have reported problems recently, especially with non-US securities) then you might consider filing a bug report with Apple via Numbers > Provide Numbers Feedback in your menu.
SG
Is someone from Apple reading this, normally these problems are solved within a week or two. This time it is taking unusually longer than normal. I've already send multiple messages via "provide feedback".
STOCK is functioning as expected, but STOCKH does not provide data for a lot of exchanges outside the USA after the 23th of April 2021.
If you haven't already, or even if you already have, go in your menu to Numbers > Provide Numbers Feedback and file a bug report.
SG
STOCK