Stock formula does not recognize Money Market Fund Ticker Symbols - NUMBERS ON MAC ONLY

Hi community, hopefully someone has seen this, relevant for Mac Software Only, seems to be fine on iOS.


I have a table that gives me the name/price of stocks/ETFs.

It has been working since Apple released the function, until last week when it decided that for any Money Market funds it would not recognize the ticker symbol.

The funds I specifically care about FDRXX, VMFXX and VMMXX.


Columns A-I

Asset Class - Symbol - Name - Price - Shares - Amount/Value

Asset Class --> Cash/US Large Cap/International/etc

Symbol ---> VMFXX / VTSAX / VONV / VEA ....

Name ---> IFERROR ( STOCK ($B2, C$1), "---")

Price --> IFERROR ( STOCK ($B2, D$1), "---")

Shares ---> quantity

Amount ---> Price * Shares


Is this some known issue, I'm using Numbers version 6.2.1 (6529) if that helps, it is the latest version.

I've recreated my formulas in brand new worksheets, no dice.


For now i can use my phone to do this but, i kind want this working on my mac.


Thanks for reading.

Really just want Apple Support to know about this, wish there was a way to submit a bug/QA note.

iMac Line (2012 and Later)

Posted on Feb 19, 2020 9:28 PM

Reply
Question marked as Top-ranking reply

Posted on Feb 19, 2020 10:25 PM

I input the symbols in the 'My Stocks' template at File > New in the menu and this is what I get:




Clearly the prices are not incorrect. Very likely this is some sort of problem with the feed from Yahoo! Finance (the data provider) to Apple.


You can give feedback to Apple via Numbers > Provide Numbers Feedback in you menu, perhaps giving a link to this thread.


SG



Similar questions

2 replies
Question marked as Top-ranking reply

Feb 19, 2020 10:25 PM in response to SpookyU

I input the symbols in the 'My Stocks' template at File > New in the menu and this is what I get:




Clearly the prices are not incorrect. Very likely this is some sort of problem with the feed from Yahoo! Finance (the data provider) to Apple.


You can give feedback to Apple via Numbers > Provide Numbers Feedback in you menu, perhaps giving a link to this thread.


SG



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 formula does not recognize Money Market Fund Ticker Symbols - NUMBERS ON MAC ONLY

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