​​ ​

The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.


You can continue to find trusted guidance and support on the official Apple Support site. 


We want to thank the community members who have contributed their time and expertise to help others with their Apple products.


STOCK Function Not Returning Current Price

I have a cell with this function:

Stock,"TSLA","price"

It's returning the previous closing price and not the current price. Of all the functions available to me in this cell, all are working normally except "price" (Open, High, Low, etc).


Do you see this as well?


Posted on Jan 27, 2020 8:51 AM

Question marked as Top-ranking reply

Posted on Jan 27, 2020 1:31 PM

Apple gets the stock data from Yahoo Finance.

Sometime after the STOCK function was added to Numbers, Yahoo underwent an ownership change.

The new owners changed what data they would supply from 'more or less current' to 'previous day's close.'


Any change to this is in the hands of Apple and Yahoo Finance, and beyond the scope of these user to user communities.


You can make a request to Apple via the Feedback channel. Closest portal is the Provide Numbers Feedback item in the Numbers menu.


Regards,

Barry

1 reply
Question marked as Top-ranking reply

Jan 27, 2020 1:31 PM in response to Wingsy

Apple gets the stock data from Yahoo Finance.

Sometime after the STOCK function was added to Numbers, Yahoo underwent an ownership change.

The new owners changed what data they would supply from 'more or less current' to 'previous day's close.'


Any change to this is in the hands of Apple and Yahoo Finance, and beyond the scope of these user to user communities.


You can make a request to Apple via the Feedback channel. Closest portal is the Provide Numbers Feedback item in the Numbers menu.


Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

STOCK Function Not Returning Current Price

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.