How to create your own portfolio Spreadsheet on Google Sheets

Create a NEW Google Sheet in Google Drive. You can leave the first row for Headers.

For fetching LIVE Coin Prices:

(1) You will need the coin's URL from CoinmarketCap (e.g. for BTC)

CELL A2 = https://coinmarketcap.com/currencies/bitcoin/

​

(2) To fetch BTC's price in CELL B2 paste this formula in CELL B2:

=RIGHT(Index(ImportHTML(A2,"table",1),1,2),LEN(Index(ImportHTML(A2,"table",1),1,2))-1)

​

(3) Just for fun: (Optional)

If you need to find an ATH for a Coin, e.g. Bitcoin's All Time High here, Fetch it like this; say in CELL C2

=TRIM(MID((RIGHT(Index(ImportHTML(A2,"table",9),5,2),LEN(Index(ImportHTML(A2,"table",9),5,2))-1)),1,SEARCH(CHAR(10),(RIGHT(Index(ImportHTML(A2,"table",9),5,2),LEN(Index(ImportHTML(A2,"table",9),5,2))-1)),1)))

​

You can expand the Google Sheet Rows like this for more coins and do the logic however you want, by adding up Assets' Values etc with these Prices in Real time.

​

Note that the prices will be in USD ($) but are presented as a plain unformatted number here removing $ sign, so you can format the Currency however you want.

Had to do it this way as the fetched prices with the $ sign were not allowing me to do mathematical operation in google sheet for some reason.

Edited to Add this:

USDT to GBP Rate example:

(4) CELL A3 = https://coinmarketcap.com/currencies/tether/usdt/gbp/

(5) CELL D3 =RIGHT(Index(ImportHTML(A3,"table",2),2,2),LEN(Index(ImportHTML(A3,"table",2),2,2))-0)