I am using following query to get 1 year price change percentage for a list of stocks,but some stocks were not available 1 year ago ,some got listed during the year. How can I modify the query to include those stocks

=GOOGLEFINANCE("GOOG","price") / index(GOOGLEFINANCE("GOOG","price", datevalue(today()-365) ) , 2,2) - 1

For ex. Get % return for last 1 year and if the stock was not available then from its listing date.

Your Answer

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

Browse other questions tagged or ask your own question.