Add Real-Time Crypto Prices to Google Sheets (2023 Update)
In this article we will show how to add real time crypto prices to google sheets with the GOOGLEFINANCE function. Simply follow the steps below.
Add Crypto Prices to Google Sheets Using GOOGLEFINANCE Function
The GOOGLEFINANCE function uses the following syntax for crypto prices:
Ticker is the symbol for the crypto in google finance that you want to import into your sheet. It should be enclosed in double quotes.
GOOGLEFINANCE can import the current prices for a given crypto. Here are the steps:
1. Identify The Crypto to Import
What we need to identify is the crypto and its corresponding ticker in Google Finance. For example, we want to import Bitcoin prices. Go to https://www.google.com/finance/ and then search for Bitcoin. We will be able to reach the following page: