STOCK
WHY THE PRICING OF THE STOCKS NOT ACCURATE ON MY STOCK TEMPLATE
Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
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