1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

calling stock price used to work, but not in newer version

Our take

It seems you've encountered an issue with your spreadsheet after upgrading your macOS from Sequoia to Tahoe. While the stock data feature and ticker function still work perfectly on your old computer, the formula =_FV(B4,"Price") now returns a #NAME? error on the new setup. This is likely due to changes in how Excel interacts with stock data in the latest macOS version. To resolve this, consider checking for updates in Excel or reviewing the formula syntax to ensure compatibility with the new environment.

I have a spreadsheet which automatically calls the current stock price into it, worked great until I upgraded my apple computer / mac OS / excel version. Now it's broken. Can anyone help?

Edit: same excel version, but macOS changed from Sequoia to Tahoe

I can easily set the stock name / ticker field, I can select "price" from the data dropdown. What doesn't work is the old function from the next field over with the formula: =_FV(B4,"Price") in which B4 holds the ticker, set as stock data, and "price" selected. It still works perfect on my old computer, but shows a #NAME? error on the new computer.

Does anyone know what I can do to fix this error?

Layout: column A holds text label

B holds ticker converted to stock data

C holds my current quantity of holdings

D holds the above function to call price of ticker

E then sums the current value and quantity into a value of the account

submitted by /u/Mysterious-Ad-6690
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#Excel alternatives for data analysis#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#Excel compatibility#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#rows.com#AI formula generation techniques#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools