Real-time Crypto Prices on Google Sheets — 3 Simple Steps

The portfolio of a retail investor is getting more diverse in recent years, now cryptocurrencies often make up a significant part of capital invested. It is very important for investors to be able to continuously track the performance of their portfolio, but often this can become tricky when investments are on different trading platforms and in different types of securities.

The portfolio of a retail investor is getting more diverse in recent years, now cryptocurrencies often make up a significant part of capital invested. It is very important for investors to be able to continuously track the performance of their portfolio, but often this can become tricky when investments are on different trading platforms and in different types of securities.

DOWNLOAD MY GOOGLE SHEETS CRYPTO PORTFOLIO TRACKER HERE.

A novel way to track performance is to use a simple Google Sheets document. Google Finance has made it very easy for anybody, even those who are not tech savvy, to set up a portfolio tracker in a couple of minutes.

Here are some useful formulae to that can be used to stocks:

Company Name =GOOGLEFINANCE(B2,"name")

Share Price =GOOGLEFINANCE(B2,"price")