How to import live cryptocurrency and stock prices into Google Sheets

Having your cryptocurrency and stock portfolios spread across multiple apps can make it difficult to know your net holdings across the board. A spreadsheet can be a great way to track all of your crypto and stock balances in one place to give you exact figures on your total standings.

Trying to find formulas for importing crypto and stock prices into Google sheets, I found many formulas that were outdated and resulted in broken results. In this article I’ll show you formulas that work and also explain how they work so that you can continue to use working and sustainable formulas in your spreadsheets without the need to download any tools or extensions. I’ll also explain how to convert prices from one currency to another, so that you can decide which currency you wish to display your values in.

Importing live stock data

Let’s begin with importing live stock data, which thankfully is a fairly simple process in Google Sheets. All you need to know is the ticker symbol for the stock you would like to retrieve data for and we can use the GOOGLEFINANCE function in order to retrieve data about our chosen stock.

The structure for our command is as follows, replacing the word TICKER with the ticker symbol for your chosen stock. Copying this formula into a cell in Google Sheets will automatically load live price data for the chosen stock.

=GOOGLEFINANCE("TICKER")