How to set up a Google Sheets CoinMarketCap API in order to auto-update Crypto prices.
ฝัง
- เผยแพร่เมื่อ 2 พ.ย. 2021
- ✅ Feel free to check out my Patreon: / martinvalk
In this video, I teach you how to set up an API in Google Sheets to auto-update the Crypto prices. Give it a try and let me know what you think!
✅ Please consider subscribing: bit.ly/3gDnvMy
- - - - - - - - - -
𝐈𝐍𝐅𝐎:
🔗 𝐂𝐨𝐢𝐧𝐌𝐚𝐫𝐤𝐞𝐭𝐂𝐚𝐩 𝐀𝐏𝐈 𝐋𝐢𝐧𝐤:
coinmarketcap.com/api/
𝐌𝐞𝐭𝐡𝐨𝐝:
GET
𝐀𝐏𝐈 𝐔𝐑𝐋 𝐩𝐚𝐭𝐡:
pro-api.coinmarketcap.com/v1/...
𝐎𝐀𝐮𝐭𝐡:
None
𝐇𝐞𝐚𝐝𝐞𝐫𝐬:
X-CMC_PRO_API_KEY
API Key
Accept
application/json
𝐃𝐞𝐬𝐭𝐢𝐧𝐚𝐭𝐢𝐨𝐧 𝐬𝐡𝐞𝐞𝐭:
CMC API
𝐍𝐚𝐦𝐞:
CMC API
- - - - - - - - - -
𝐋𝐈𝐍𝐊𝐒:
𝐊𝐞𝐯𝐢𝐧 𝐂𝐚𝐠𝐞 𝐰𝐚𝐥𝐤𝐢𝐧𝐠 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐦𝐲 𝐂𝐫𝐲𝐩𝐭𝐨 𝐏𝐨𝐫𝐭𝐟𝐨𝐥𝐢𝐨 𝐓𝐫𝐚𝐜𝐤𝐞𝐫:
🔗 • Exit Plan & FREE CRYPT...
𝐌𝐲 𝐂𝐫𝐲𝐩𝐭𝐨 𝐏𝐨𝐫𝐭𝐟𝐨𝐥𝐢𝐨 𝐓𝐫𝐚𝐜𝐤𝐞𝐫:
🔗 docs.google.com/spreadsheets/...
- - - - - - - - - -
🔗 𝐖𝐞𝐛𝐬𝐢𝐭𝐞: www.BullishSwag.com
High-quality Crypto gifts and merchandise, check it out and let me know if you would like me to add anything specific.
🔗 𝐓𝐰𝐢𝐭𝐭𝐞𝐫: / martincpvalk
Please consider following me on Twitter, it means a lot to me, and it is where I share the most information.
🔗 𝐓𝐢𝐤𝐓𝐨𝐤: / martincpvalk
On TikTok, I put out short (60-second max) videos keeping you up to date with all the crypto news.
🔗 𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: / mcpvalk
On Instagram, I share my "Falcon Crypto Rating" scores as well as short videos (60-second max) to keep you up to date with all the important news.
🔗 𝐔𝐧𝐬𝐭𝐨𝐩𝐩𝐚𝐛𝐥𝐞 𝐃𝐨𝐦𝐚𝐢𝐧𝐬: unstoppabledomains.com/r/2ce1...
Use this link and get $10 off your first purchase worth $40 or more!
- - - - - - - - - -
⚠️ Everything I talk about is my opinion and is for information purposes only. It is not intended to be investment advice. Seek a duly licensed professional for investment advice.
#Crypto #API #Price - บันเทิง
![[TH] VCT Pacific Stage 2 - Week 1 Day 1 // DRX vs ZETA | BLD vs TS](http://i.ytimg.com/vi/AWaOqaxN6Y0/mqdefault.jpg)
![[TH] VCT Pacific Stage 2 - Week 1 Day 2 // GEN vs T1 | PRX vs TLN](http://i.ytimg.com/vi/ZkFjjJNwzH0/mqdefault.jpg)
![Fc ครับ ขอแนะนำให้รู้จักกับ "น้องเปียโน" l [Nickynachat]](http://i.ytimg.com/vi/HQU6Q_IYTLo/mqdefault.jpg)
Thank you so much for this amazing spreadsheet. It took a little tweaking for it to work, but it's awesome! Thanks Martin!
Thank you! That was very helpful! Really appreciate the content you are producing :)
This is great Martin! Very excellent, I never knew you could add the APIs into Sheets! This helps with the passive income and node tracker sheet I was working on.
Many thanks for this, it worked perfectly!
CMC is the next Bloomberg
Why hasn't anyone made this video before? Martin, you made this really easy to setup.. Most videos are absolute garbage.. Cheers bro.
Thank you for such an informative and helpful content.
Thank you! had issues with the formula syntax
Martin you're a champ! Thanks
Nicely explained . Thanks :)
Amazing content Martin!
Excellent work! thank you very much
Thank you for this 🙏🏽
Gran bel lavoro Martin, tutto molto chiaro, bravo!
Thanks for the Content! I really enjoyed that. I would love to see more of what you can do with google sheets.
That was awsome. Thank you so much
Really useful, thanks! Works perfectly
Is there any similar system which we can set up to auto-update hourly? This API connector needs to be manually refreshed and others for automatic scheduling need to pay
Thanks Martin
Great video Martin. I’ve had this exact question for a while now, glad to see this as a solution!
Question for you - Would this same type of CMC API integration be possible in the Mac Notes app for documents that aren’t spreadsheets? Of course I see you’re using an extension for the API via Google Sheets, but I’m wondering if something similar is possible in Notes, maybe with a bit of coding? Let me know your thoughts, and thanks for all your work. ✊🏽
Thank you! Thank you! Thank you! 👏🏾👏🏾👏🏾👏🏾👏🏾👏🏾👏🏾👏🏾
Fantastico! Grazie !
Hi Mate, Excellent video. Would you be able to tell what to do to get prices in AUD?
Cheers mate
thnx!,. Dat wilde ik net op gaan zoeken!.
but the very first thing to do is ALWAYS ,.. add some colour :)
Perfect. Thank you.
QUESTION: Is it possible to update prices via the mobile version of Google sheets?
Will this work with exchanges to keep track of profit and losses? And buy and sell orders etc.
hello, can you help me i just want to download the data of play to earn, what API url should i use?
Nice one !!
Based on your idea, I did an improvment of it if you'd like it.
Let's say you have your crypto portfolio on several lines where the first column is the id of the crypto.
The sheet is going to take the first values of the first colum to query the only crypto needed. Then it will fill the portfolios prices as you did.
The request is going really fast and only request for 10 cryptos if the portfolio contains 10 cryptos.
If you'd like to have this version, just tell me.
how to do this can you share thanks
Hey Martin. Love this tracker. Great visual aid. Asked some questions on Patreon also, but today it seems there is an issue with the API refreshing. Can you confirm the issue ?
Answered my own question. If anyone else has an issue. the API has changed slightly so it added more columns. Under the MAIN tab you'll have to adjust the FROM-TO column range and the amount of rows it needs to look for. In my case this was column H-BD and the range to 48
Thanks, I tried and followed all steps. API set up and CMC API tab is filled with data. But on the MAIN tab, it does not fetch the prices of the crypto i have filled out on the tab Exchanges Used & Crypto Owned. Is there a solution?
Thanks Martin - was very easy to follow. I got the price to display and all went well until the very last step of Refreshing All on the API Connector. Got the following Error Message:
Reports ran: 2
1) Demo Request: Request ran successfully
2) CMC API: Completed with errors
- We received an error from the API server (400) show response
{"status":{"timestamp":"2021-11-06T01:40:41.187Z","error_code":400,"error_message":"\"limit\" must be less than or equal to 5000","elapsed":0,"credit_count":0}}
I have my limit set to 9000 in order to fetch the small caps that I play with (certified degen right here). This worked initially to pull the data but appears will not work when refreshing the data?
Hey great tutorial. By the way, how to pull more than 5000 coins?
Great video and explanations! Is the API connector free version enough to use for this purpose? I saw there saying subsription valid until 2021 Nov 24 in your video.
API connector free should be enough
and i want to download data by month (30 days) help me please for thesis purposes
it doesn't let us to limit coinmarketcap to 10.000 or anything higher than 5k. is there a way to increase that limit ? or just disable limit all
Martin the API URL path link is not all there - it’s cut off… can you post the whole thing please?
Was here
Found the error in the example sheet: ON the line
=iferror(vlookup(A13,'CMC API'!I:IR,match("data.quote.USD.price",'CMC API'!$I$1:$IR$1,0),false),"")
my man!
Hi Martin, How can I import more than 5000 lists of coins into spreadsheet?
Not possible for as far as I know. Maybe with a paid version.
Nice presentation -- but how to you get it to automatically update --- it really annoys when you guys leave this stuff out and I know you do it on purpose. Plus you don't answer any of the questions. Now why would someone join your account?
i get this message : It looks like your formula is missing one or more open parentheses. If you don't want to enter a formula, begin your text with an apostrophe (').
i done exactly what you did?? =VLOOKUP(AG3,'CMC API'!I:BE,47,false)
fully stressing me out lol
strangley i done this method before and it worked so whats going on?? please help..somebody..anyone out there??