You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Stock formula no longer working

I was tracking the price of gold and a few other metals using the stock function <STOCK("GC=F", price)> and this has stopped working the past few days. Other stocks are working normally as far as I can tell so the function itself hasn't broken just its ability to get these specifically.


Any ideas on why this would be?

Posted on Jan 21, 2025 1:44 PM

Reply
1 reply

Jan 22, 2025 12:55 AM in response to thermalhound114

Numbers gets its data from Yahoo! Finance. There have been many reports here over the years of problems with the data. I can confirm that "GC=F" is the symbol that Yahoo! Finance uses, so this "should" work. I suggest you file a bug report at Numbers > Provide Numbers Feedback in the menu (or follow this link Feedback - Numbers - Apple). Bug Report is a choice in the Feedback Type dropdown.


SG


Stock formula no longer working

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