Is it possible to reference values of a stock using googlesheets?
I can pull in the “current” stock value, but, is there a way of referencing the value on a particular day?
For example, it would be interesting to pull stock values before the Covid-19 market dip, say reference the 20th of February or the 31st of December if you want the end of the financial year. Is there an easy googlesheets function for this?