Live Price Tracking With Excel Through API v2

There are bunch of step by step explanations on how to import data directly from coinmarktcap.com API to your excel and track the coin prices on live. But none of those, including the ones in Bitcointalk.org has it for v2

Coinmarketcap API v1 will be shutting down at the end of this year so everyone has to switch to V2 now.

So is there anyone that can explain us step by step how to import coinmarketcap.com API v2 to excel in a way we can see the prices and even maybe customize the content to have it on our excel sheets?

This is the API page. You can see the warning message on top and if you scroll down to the middle, you`ll see the v2 explanations
https://coinmarketcap.com/api/

Just as an example you can see this video for v1
https://www.youtube.com/watch?v=CjnsX81qWUg

But it doesnt work the same way for v2. I tried but had bunch of problems. Either no price or errors or didnt have the data I was looking for etc.

So I`m sure everyone will greatly appreciate if someone can help us about this

Thanks in advance

Topic: Live Price Tracking With Excel Through API v2 (Read 111 times)