Google Finance portfolio tracking


#93

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.


#94

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!