Help with Apple Numbers "stock" function.

Hi. I want to use the "stock" function in a Numbers spreadsheet, in this instance to report the current price of Nestle, a company listed on the Swiss stock exchange. As you can see from the image below, I'm getting the red triangle error when I try to use the function. Am I somehow using it incorrectly?


FYI the "stockh" function is working fine for me. Thx.

MacBook Pro 13″, macOS 11.4

Posted on May 31, 2021 2:38 PM

Reply
Question marked as Top-ranking reply

Posted on May 31, 2021 6:32 PM

It should look like this in the Formula Editor:



Or better yet, like this:




See the 'My Stocks' template at File > New in your menu for live examples of using the STOCK and STOCKH functions.


SG

2 replies

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.

Help with Apple Numbers "stock" function.

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