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
[link] [comments]
Want to read more?
Check out the full article on the original site