![]() In this example we will use the GOOGLEFINANCE function to find the price of Bitcoin, displayed in US Dollars. Example: Pulling crypto prices with GOOGLEFINANCE In this article I will stick to teaching how to pull the current price for cryptocurrencies. The GOOGLEFINANCE function can also be used to pull a wide variety of data for stocks, such as past prices, shares outstanding, etc./ but I will go over that in another article. When using the GOOGLEFINANCE function with ordinary stock symbols, there is more criteria that you can specify, which would allow you to show many other types of stock data other than just the current price… but we are going to use the most basic criteria for this function by specifying a cryptocurrency symbol only, to display the current price of the specified crypto (When no additional criteria is given to the formula, the default is to show the current price). When entering the cryptocurrency symbol that Google Sheets will expect, you have to enter the cryptocurrency “pair”, such as the pair between Bitcoin and US Dollars, which is represented as “BTCUSD”. With this method, all that you have to do is specify the cryptocurrency symbol for the criteria in the formula, and the formula will display the current price for that cryptocurrency. (See below for how to use this method provided by ) Pull cryptocurrency prices into Google Sheets with the GOOGLEFINANCE functionįirst let's go over the more simple method for pulling crypto prices into Google Sheets, which is by using the GOOGLEFINANCE function. =GOOGLEFINANCE("BTCUSD") Using IMPORTXML to pull crypto prices (Formula) Using GOOGLEFINANCE to pull crypto prices (Formulas) *Note that when using the IMPORTXML function, websites often change the XPath of their website elements and so you will need to follow the lesson below to learn how to retrieve the correct XPath for your formula. The formulas below can be used to pull crypto prices into a Google spreadsheet. Formulas for pulling crypto prices into Google Sheets ETHUSD (Ethereum) is another symbol that the GOOGLEFINANCE function will pull. ![]() The IMPORTXML function is able to pull in any crypto price, where the GOOGLEFINANCE function is limited on the cryptocurrencies that it can pull. You can also click here to get even more detail on using IMPORTXML.Ĭlick here to get your Google Sheets cheat sheet Watch the other video further down the page to get more detail on using the IMPORTXML function. This IMPORTDATA method is described in the video directly below, or you can scroll down to the bottom of the page to read about it. Note that a new method for pulling crypto prices has been added to this page, (the ability to use the IMPORTDATA function for crypto prices). Press enter on the keyboard (Final formulas will look like this: =GOOGLEFINANCE("BTCUSD")īelow I go over an example of using this method in detail, and then further below I will teach you how to use the IMPORTXML function.Type a symbol for a cryptocurrency (between quotation marks), like this "BTCUSD".Type =GOOGLEFINANCE( in a spreadsheet cell to begin the formula.To pull cryptocurrency prices into Google Sheets, follow these steps:
0 Comments
Leave a Reply. |