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/
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?
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.
THANKS ALOT FOR YOUR GREAT TEACHING.
HOW CAN I MAKE WEEKLY OR MONTHLY LIVE DASHBOARD IN EXCEL
Can you update the Trading View link please?
For Mac Users with no Get Data from Web: https://www.youtube.com/watch?v=Kyps7tI7OnU
Excellent. Thanks!
Really good tutorial mate, thanks, saved me a lot of time googling answer
does not work, import only the first 150 coins
Thank you. is it possible to get BTC.D, MarketCap, Total2 data fro tradingview to excel?
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?
How can I load Mana and Gala prices?
Perfect, thanks!
Hi very useful , but simple question i need ticker crypto in excel how ca i do it?
Only imports 150 of the 840 data points. How do you expand this to include all coins?
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
thanks, i'm curious how can i take the value at a certain time and copy it into a cell, then save the sheet
Thank you! So helpful, simple and it works. Just thank you.
There is no "From Web" option on MS Excel 16.55 Mac Version
Godsend. And only 5 minutes long. Thanks.
Hello, It only shows 150 Coins only. Balance coins not showing at atll.
thanks for sharing
Nabeel, If data such as Shiba has a very large decimal point position can this be changed to display?
Hi, when i'm importing the data the column 5 is text type but on your video it's number type. Do anyone know why?
Prices for Shiba-Inu import as '0' any ideas on how to import the 11 decimal points? Thank you
theres a huge buzz going around the vechain coin and ik that happens before the price skyrockets!
Absolutely brilliant! Thanks. :o)
some coins are always showing zero in excel even after refreshing.. whereas in real it isn't. for eg. SHIB
Also have a problem with getting more than 150 rows loaded into excel, any ideas?
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?
IT is not import all the cryptos