Adding "marketcap" and deriving "exposure %" as "Today's Value"/"marketcap"

[champbronc2]

Just requires adding the following column in Google sheets =GOOGLEFINANCE("TCKR","marketcap")

This makes it easy to see the level of conviction or exposure

[nvk]

I tried that before, but google finance doesn't seem to have lots of the non US exchanges like CSE.

My draft

[champbronc2]

Some of the Googlefinance exchange definitions are different https://www.google.co.uk/googlefinance/disclaimer/ but good point that some of these just don't exist on Google Finance at all (BTCE and COINXBT from what I can tell)

Or another easy way to find the googlefinance compatible ticker is just searching on Google Finance (e.g. https://www.google.com/search?tbm=fin&sxsrf=ALeKk02C1wnDAiKrJjN8kkIxB_W3brvPQw%3A1602462514931&ei=MqODX_y8OJm7tAbnzJP4DQ&stick=H4sIAAAAAAAAAONgecRowS3w8sc9YSn9SWtOXmPU5OIKzsgvd80rySypFJLmYoOyBKX4uXj10_UNDZPNCovTyjIKeACABEg-PQAAAA&q=TSE%3A+HUT&oq=hut+8&gs_l=finance-immersive.1.0.81l3.1238.4906.0.7032.4.4.0.0.0.0.149.501.1j3.4.0....0...1c.1.64.finance-immersive..0.3.410....0.U1Od3jkACCc#scso=_O6ODX_LWGNjWtAaqw5-4Bw7:0)

For your convenience:

=GOOGLEFINANCE("TSE:HUT","marketcap")
=GOOGLEFINANCE("ASX:DCC","marketcap")
=GOOGLEFINANCE("LON:ARB","marketcap")

Since the two missing are trackers, maybe it's not necessary to display? For consistency, could treat GBTC and QBTC.U the same.

[nvk]

Worked it out, live. Thx!