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

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]

Want to read more?

Check out the full article on the original site

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