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.