As far as I can tell you’ll need a script with a ‘Time-driven’ trigger to store the value every week to sheet, and then use those values to chart it.
Hmm ok will have a gander
Thanks for your time
Has anyone worked out the formula for retrieving market cap’s from Google Finance?
=googlefinance(symbol, "marketcap", date(2019, 1, 2))
Without tinkering, not sure if historic market caps work. Try without the date?
That worked, thanks!