Google Finance portfolio tracking


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

(Alex Sherwood) #95

Has anyone worked out the formula for retrieving market cap’s from Google Finance?

=googlefinance(symbol, "marketcap", date(2019, 1, 2))

isn’t working :grimacing:

(Simran Cashyap) #96

Without tinkering, not sure if historic market caps work. Try without the date?

(Alex Sherwood) #97

That worked, thanks!