How to Connect Excel to Coinmarketcap for historic and ticker information

24 comentários em “How to Connect Excel to Coinmarketcap for historic and ticker information”

1. Hi Paula. How can i set the historical date within 90 days?

2. API endpoint no longer works. 🙁

3. OUTDATED.

4. What strange to me is that i am stuck at the part where i have filtered Bitcoin Historic data to the last 180 days but my URL doesn't show the startdate and enddate part in the url?

5. code "410 Gone"
   reason "We no longer serving this endpoint here"

6. poor quality of voice , volume is going up and down which is making confused

7. Unfortunately, CMC have now updated their address and requires a key to access the data. Would you be interested in recording a new video? Thanks

8. I don't have "From Web" option in the data button.

9. HI, That was a very helpful vdo. I am trying to connect my binance trade history to excel and building P&L tracker. Is there any way you can create a video on that or if you have already made a video can you please direct me ?

10. Would be awesome if you could you do a similar one for Google Sheets!

11. Hey Paula, Thanks for the amazing video, I am trying to do something similar only I am looking for Bitcoin data and historical data that would update in real-time on a 5-minute time frame? Would you have any idea how to achieve this?

12. hot to get real time

13. My graph will only show when the coins were listed/starting date. I can’t get the price in the graph. What could it be???

14. How about a video on connecting EXCEL to CMC using the new API which requires a key?

15. Nice video, I have come to realize that with the right strategy and experience, trading crypto would indeed be very profitable. I started trading crypto one year ago. Learnt the hard way by losing a lot of money trading all alone and trying out YouTube strategies, i soon realized that i needed a proper guidance and professional help, and Mr James Carlson filled that space.He provides me accurate signals to trade on my platform. Ever since i started investing and trading through James, I have recorded a very good amount of profits. James can be reached on Whatspp: +447476717980 and Telgram @ JamesC51 for inquiries into profitable trading systems

16. This website dosn't work: https://api.coinmarketcap.com/v1/ticker/

17. Is there a workout for not using power pivot, office 2016 home edition doesn't have power pivot unfortunately

18. 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?

19. can I get the daily RSI on coins in Google Sheets?

20. Hi Paula, I've managed to pull the data into the queries as you have so eloquently taught, but the data shows up as text. When I try to change the type to decimal number, it give an error or each field and record. This means that I cannot complete the pivot charts as the pivot chart will not allow a sum function on text fields and will only allow the COUNT function (Excel 365) Any work around you might suggest?

21. how do i get data from the other coins (not only the top 100)?

22. 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

23. Hey paula, thank you for this video! But when i import the table @ 9:32 the first column data type is indeed date but the other ones are tekst now. And when I try to convert them to decimal numbers or whole numbers for that matter it just gives me error in all the colums? Could maybe help me out with that? Many thanks in advance!

24. Hi Paula.. thanks for this video. Good tips. Thumbs up!

Os comentários estão fechados.