Import ALL Crypto Stock Prices into Excel Office 365

Import crypto currency market data into excel without writing code.
In this tutorial we will import data from TradingView.com and read it as a table in Excel.
The web table will be imported into Power Query. We will clean the data and then import it into our worksheet

Link to tradingview is:
https://www.tradingview.com/markets/cryptocurrencies/prices-all/

Recommended For You

About the Author: James Whorton

30 Comments

  1. Hi, great demonstration. It works perfectly as described. Now I have an issue to import required parameters: how can I get the ATH and ATL parameters which were initially not proposed in the imported parameters?

  2. THANKS ALOT FOR YOUR GREAT TEACHING.

    HOW CAN I MAKE WEEKLY OR MONTHLY LIVE DASHBOARD IN EXCEL ? IF I REFRESH IT ALL PRICES COME UP AUTOMATICLY. PLEASE ANY SOLUTION.

  3. Hello, thanks for the tutorial. I was able to load the data but I bumped into a bit of a problem. Essentially, I can't change the data type of the crypto price. It is currently set as a text type. And when I change to currency or any other type, I have the value error, so the data is unusable. Could somebody please help?

  4. this works well with site in USD – does anyone know of a Euro chart online to load data from ?? i cant seem to find one that works for Euro

  5. The problem I have is that when I refresh the data, some Cryptos change rows. That modifies the data I use in some formulas, like when I input the price. Somebody knows what to do?

Leave a Reply

Your email address will not be published. Required fields are marked *