I have been trying to get Net Assets and 1 Week Return for SPY on Google Spreadsheets but keep ending up with #N/A.

I have been following the information from this sheet but have yet to figure out what I am doing wrong: https://support.google.com/docs/answer/3093281?hl=en

My Spreadsheet: https://docs.google.com/spreadsheets/d/1kuAhDjzZT845s0tfAMM8s85ZUkONKF_7qlAX2JKW4yA/edit?usp=sharing

Have the codes for Google Finance stopped working or am I writing the codes wrong?


1 Answer 1


The following formula works fine:

=googlefinance("spy", "price")

There are some attributes that are not available for some stocks, this could the the case for SPY.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.