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)