3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA

Published: 09 March 2022
on channel: Spreadsheet Class
9,871
114

Get help with your spreadsheet project, or personalized training:
https://www.spreadsheetclass.com/cons...

Get the ultimate formulas cheat sheet
https://www.spreadsheetclass.com/best...

Learn to build dashboards in Google Sheets:
https://www.spreadsheetclass.com/goog...

Learn more about using the IMPORTXML function:
   • Pull data from websites in Google She...  

Learn to pull stock prices:    • Pull stock prices & stock data with t...  

Read the article on how to pull crypto prices:
https://www.spreadsheetclass.com/pull...

For using the IMPORTDATA method (credit to cryptoprices.cc):
https://cryptoprices.cc/
https://cryptoprices.cc/sitemap.txt

In this video I will teach you three different ways to pull crypto prices into your Google spreadsheet.

First I will show you how to use the GOOGLEFINANCE function to pull the prices of major cryptocurrencies, and then I will show you how to use the IMPORTXML function to pull the price of any crypto, from a specified website that you want to pull data from. Then I'll show you how to use the IMPORTDATA function to pull crypto prices from cryptoprices.cc


Watch video 3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA online without registration, duration hours minute second in high quality. This video was added by user Spreadsheet Class 09 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,871 once and liked it 114 people.