{"id":262431,"date":"2024-03-13T20:08:44","date_gmt":"2024-03-13T19:08:44","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=262431"},"modified":"2026-09-25T19:43:54","modified_gmt":"2026-09-25T17:43:54","slug":"precos-de-criptomoedas-google-finance","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/google-finance-crypto\/","title":{"rendered":"Use o Google Finance para obter pre\u00e7os de criptomoedas no Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

If you use Google Sheets and need current prices for various cryptocurrencies, the GOOGLEFINANCE function<\/a> will import them using only the ticker symbol for that cryptocurrency. In minutes, you can have current and historical cryptocurrency data in your Google Sheets. However, a 20-minute delay between updates makes it unsuitable for real-time decisions.<\/p>\n

In this article, you will learn how to use the GOOGLEFINANCE function to pull cryptocurrency prices into your Google Sheets. You will also learn about other ways of getting crypto prices from Google Sheets, including other functions in Google Sheets.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”can-i-use-google-finance-for-crypto-pric” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Can I use Google Finance for crypto prices?<\/h2>\n

Google Sheets\u2019 GOOGLEFINANCE function can be used to get cryptocurrency prices. Simply type the ticker symbol for the cryptocurrency between quotation marks as the only argument for the function. Alternatively, type the ticker symbol, without quotation marks, into a cell and use the cell reference in the formula.<\/p>\n

GOOGLEFINANCE only covers the best-known coins, such as Bitcoin and Ethereum. If a plain ticker like BTCUSD returns an error, add the currency prefix: =GOOGLEFINANCE("CURRENCY:BTCUSD"). For other coins, use one of the methods further down.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-get-crypto-prices-in-google-sheet” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to get crypto prices in Google Sheets with the Google Finance function?<\/h2>\n

1.<\/strong> Open Google Sheets.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-blank-sheet.webp” alt=”Google Finance crypto prices \u2014 blank Google Sheets spreadsheet for the price tracker” title_text=”Blank Google Sheets spreadsheet for the price tracker” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2.<\/strong> In an empty cell, type in the ticker symbol for the cryptocurrency you want. In this example, I will get the price for Bitcoin in USD. The ticker symbol is BTCUSD.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-ticker-symbol.webp” alt=”Google Finance crypto prices \u2014 BTCUSD ticker symbol typed in a cell” title_text=”BTCUSD ticker symbol typed in a cell” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

3.<\/strong> In a separate cell, type in the GOOGLEFINANCE formula. Select the cell with the ticker symbol as the only parameter and close the parenthesis.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-googlefinance-formula.webp” alt=”Google Finance crypto prices \u2014 GOOGLEFINANCE formula referencing the ticker cell” title_text=”GOOGLEFINANCE formula referencing the ticker cell” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

4.<\/strong> Once you press \u201cEnter\u201d, you may see \u201cLoading\u2026\u201d in the cell for a few seconds, and then you\u2019ll see the price for your chosen cryptocurrency.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-bitcoin-price.webp” alt=”Google Finance crypto prices \u2014 Bitcoin price in USD returned by GOOGLEFINANCE” title_text=”Bitcoin price in USD returned by GOOGLEFINANCE” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

5.<\/strong> To format as a currency ($), click on the dollar symbol on the toolbar, as shown below.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-currency-format.webp” alt=”Google Finance crypto prices \u2014 Bitcoin price formatted as currency” title_text=”Bitcoin price formatted as currency” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Apply this knowledge and learn to build a stock portfolio tracker in Google Sheets<\/a>.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”other-ways-to-get-crypto-prices-in-googl” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Other ways to get crypto prices in Google Sheets<\/h2>\n

There are multiple methods for getting crypto prices into Google Sheets, including other native functions and add-ons.<\/p>\n

Get crypto prices with IMPORTXML<\/h3>\n

Google Sheets\u2019 IMPORTXML function<\/a> can be used to get crypto prices from many web pages. All you need are the URL and the XPath to the object that represents the price of your chosen cryptocurrency.<\/p>\n

There are many ways to get the XPath for a specific object, but using Chrome\u2019s Inspect feature is quick and simple.<\/p>\n

For example, CoinMarketCap<\/a> provides prices for a variety of cryptocurrencies.<\/p>\n

Find the XPath<\/h4>\n

1.<\/strong> Open the website in Chrome and find the price for the cryptocurrency you want.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-coinmarketcap.webp” alt=”Crypto prices with IMPORTXML \u2014 CoinMarketCap price table open in Chrome” title_text=”CoinMarketCap price table open in Chrome” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2.<\/strong> Select the value and right-click. From the menu, choose \u201cInspect.\u201d<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-inspect-price.webp” alt=”Crypto prices with IMPORTXML \u2014 right-click menu with Inspect on the Bitcoin price” title_text=”Right-click menu with Inspect on the Bitcoin price” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

3.<\/strong> In the Inspect window, the line of code corresponding to the price will be selected. If the highlighted section is not quite right, hover over the lines of code around the selected one until you find one that highlights the price exactly.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-highlighted-code.webp” alt=”Crypto prices with IMPORTXML \u2014 the price element highlighted in Chrome DevTools” title_text=”The price element highlighted in Chrome DevTools” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

4.<\/strong> Right-click on the line of code and select Copy > Copy full XPath.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-copy-full-xpath.webp” alt=”Crypto prices with IMPORTXML \u2014 Copy > Copy full XPath in Chrome DevTools” title_text=”Copy > Copy full XPath in Chrome DevTools” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Use IMPORTXML with URL and XPath<\/h4>\n

1.<\/strong> In Google Sheets, type the URL and the XPath into separate cells.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-url-xpath-cells.webp” alt=”Crypto prices with IMPORTXML \u2014 CoinMarketCap URL and XPath typed in separate cells” title_text=”CoinMarketCap URL and XPath typed in separate cells” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2.<\/strong> In another cell, type in the formula and select the cell with the URL as the first parameter.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-importxml-url.webp” alt=”Crypto prices with IMPORTXML \u2014 URL cell added as the first parameter” title_text=”URL cell added as the first parameter” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

3.<\/strong> Select the cell with the XPath as the second parameter and close the parenthesis.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-importxml-xpath.webp” alt=”Crypto prices with IMPORTXML \u2014 XPath cell added as the second parameter” title_text=”XPath cell added as the second parameter” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

4.<\/strong> Press \u201cEnter\u201d to get the price for your chosen cryptocurrency.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-importxml-price.webp” alt=”Crypto prices with IMPORTXML \u2014 Bitcoin price imported from CoinMarketCap” title_text=”Bitcoin price imported from CoinMarketCap” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Get crypto prices with IMPORTDATA<\/h3>\n

Cryptoprices.cc<\/a> website offers a simple API where all the endpoints return text. You just need to use the URL for the cryptocurrency you need. All the URLs are available on the sitemap<\/a>, which is also a text file. This means you can also use IMPORTDATA to get that list and choose the URL from Sheets.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/google-finance-crypto-importdata.webp” alt=”Crypto prices with IMPORTDATA \u2014 Bitcoin price from cryptoprices.cc returned by IMPORTDATA” title_text=”Bitcoin price from cryptoprices.cc returned by IMPORTDATA” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

What about the CRYPTOFINANCE add-on?<\/h3>\n

The CRYPTOFINANCE add-on used to be a popular way to do this, but it pulled its prices from Cryptowatch, which Kraken has since shut down. Recent reviews on the Google Workspace Marketplace report that the add-on no longer returns data, so the IMPORTXML and IMPORTDATA methods above are the more reliable choice.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Conclusion<\/h2>\n

As you have seen, it\u2019s easy to get cryptocurrency prices using the Google Sheets GOOGLEFINANCE function<\/a>. Although it\u2019s possible to do it with other Sheets\u2019 functions used to import external data, they are only useful if you have a source that provides crypto prices in the required format.<\/p>\n

You now know how to use Google Sheets\u2019 GOOGLEFINANCE function to get cryptocurrency prices<\/a>. You also know about some other methods you can use to get these prices, like the Google Sheets IMPORTXML function<\/a> and the IMPORTDATA function<\/a>.<\/p>\n

To learn more about importing financial data, as well other types of data into Google Sheets, check out these related articles.<\/p>\n