I am creating an index that follows several tickers from 2014 to the present (daily data) by using Google Finance in Google Sheets. I want to add all of the tickers’ new prices at the end of each of day that passes without deleting the previous day’s numbers. In other words, the index builds over time automatically.
Does anyone have insight into how to accomplish this?
Thank you in advance for any help here!