0

I need to formulate the SPX500 return from "x start date" to "x end date".

I have managed to figure out "x start date" to current date (year to date return) but I cant work out how to do historical to fixed date.

Here's what I have thus far for year to date yield.

I need to work out returns from 1/1/21 to 31/1/21 for the S&P500

=(googlefinance("INDEXSP:.INX","price")/index(googlefinance("INDEXSP:.INX","price",date(2021,1,1)),2,2)-1)

1 Answer 1

0

You have the syntax for allows you to get the GOOGLE FINANCE data for 1 January (using INDEX()). Surely, then you use the same syntax for the relevant end date

Try this formula:

=(index(GoogleFinance($B$1,$B$2,B5),2,2)-index(GoogleFinance($B$1,$B$2,B4),2,2))/index(GoogleFinance($B$1,$B$2,B4),2,2)


SAMPLE

sample

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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