Latest updates.. plus we
Latest updates.. plus we answer viewer questions..
Not financial advice.
Support the channel for free.. like, subscribe, ring the bell, and share..
Thanks for the not-boring video.
Thanks, very informative!
I know the video didnt
I know the video didnt record, was in a hurry, look at the links below to read urself.
Support the stream: https://streamlabs.com/cryptolivin We Update You With Whats Going On IN Crypto. Bitcoin News, ICOs, Tech, and New Potentially and Historically Skyrocketing Platforms, and Hype. We Review The Current Markets And Top Tokens.
Mentioned In This Video:
Join Us On Ethconnect
Join Us On Twitter: @CryptoLivin
****Coinmarketcap has changed and you now need a premium API to get historic information on Cryptocurrency. For an alternative try this new video and article using the API for currency data https://youtu.be/_5sXO9H6k6I https://theexcelclub.com/how-to-connect-excel-to-coinmarketcap-api/****
and for the major coins you can get historic cryptocurrency data into excel with this option
Please visit the blog post for a copy of the urls and a detailed step by step blog, including a learn and earn activity so you can earn cryptocurrency rewards for completing the activity
Learn how to connect to Coinmarketcap from Excel and create a cryptocurrency dashboard using both historical data and live ticker information. You will also learn how to create a parameter in power query to make the date on the historic url dynamic.
how to create a cryptocurrency dashboard in excel. First, we will connect to the web API for live ticker information on the top 100 cryptocurrencies then we will connect to a web table for historic data and create a power query parameter to make the date dynamic
This article also contains a learn and earn activity.
Find out more about our Learn and Earn Activities
Watch more Power BI videos
Watch more Excel Videos
That URL does not work anymore and the guideline for the new URL which also now requires an API key simply does not work either. Have you figured this out?
can i collect data for every coin and not just top 100? half my investments are lower market caps, outside of 100. i need a ticker for top 3000
hot to get real time
This website dosn't work: https://api.coinmarketcap.com/v1/ticker/
Hi Paula.. thanks for this video. Good tips. Thumbs up!