CoinMarketCap data

[RustyBits]

I have a few altcoin holdings and occasionally visit a few alt faucets and get a few airdrops for relatively minimal total value. At some point I found and used an excel spreadsheet formula that pulls current value data from coinmarketcap.com. I integrated that into an existing spreadsheet I use to keep track of my cryptos.  So in my spreadsheet, I track that I own 0.00012345 of altcoin X and I am able to see that I have $12.35 in USD value of that altcoin X. As the price value varies per coinmarketcap, the spreadsheet automatically updates each time that I open it.

I think I heard recently that coinmarketcap.com is going to start charging a fee or requiring a paid subscription for this information (unless I am thoroughly confused or did not hear all of the story and misinterpreted what I heard). Because my holdings are so low, I can't justify paying for that as it will essentially eat up the value of all of my holdings in fairly short order.
EDIT: I do not recall where I heard this or if I even heard it correctly, so I am unable to provide a source link

So my questions = (1) am I correct that the coinmarketcap 'free ride' is coming to an end or did I misinterpret this?
(2) do I have another 'free' option of getting this information automatically updated in my spreadsheet?

If not - I'm okay with that. No sense spending more value than I own just for the convenience of knowing how much my minuscule holdings are fluctuating. But if I can keep this convenience, I would like to do that.  

[bavian]

I think yes, coinmartketcap have pro api and we need paid for service. You can use api of etherscan or ethplorer. For me, I use telegram bot to track my ethereum wallet.

[RustyBits]

Thanks, I'll look into those options. I was trying to find the source of the page I inserted into my excel file to see what if anything he/she recommended.  I am pretty sure that formula came from someone in Bitcointalk, but I didn't bookmark a thread and so far I haven't found his/her thread in the search feature.  I may just need to do some more digging and experimenting. If I am correct, I think I have until the end of the year to keep using the coinmarketcap API.

[tomahawk9]

So my questions = (1) am I correct that the coinmarketcap 'free ride' is coming to an end or did I misinterpret this?

Where did you read that? it would be nice to know the source to see if someone here can confirm the info.

(2) do I have another 'free' option of getting this information automatically updated in my spreadsheet?

There are several CMC alternatives like Cryptocompare, Coingecko, Coincap.io, Coincodex. Perhaps you could use one of those to keep your spreadsheet up to date, check to see if one of those provides an API

[FlamingFingers]

Do you mean this: https://pro.coinmarketcap.com/features ? I think your specific use of their API falls under the 'Starter' plan, which is free, and you can still have that 'convenience.' I haven't found anything related to charging that API in a future plan, though.

[Slash61]

What do you really worry about? If there are still many alternatives other than CMC, I think other sites are more accurate than CMC, there are many tricks that I don't overcome in the occasional movement, there will be no paid services on the site because of what they get from loyal visitors.

[RustyBits]

Where did you read that? it would be nice to know the source to see if someone here can confirm the info.

That's the thing - I don't even think that I read it - I think it was something I heard on the radio or in a tech podcast (no idea which one as I listen to several and didn't keep track of listened/deleted episodes). It was one of those situations where I wasn't listening closely and just had it playing in the background as background noise. Sorry for my inattentiveness!

[RustyBits]

What do you really worry about? If there are still many alternatives other than CMC, I think other sites are more accurate than CMC.

Yes - in the end it is really not a big deal either way and I may have jumped the gun in asking my question. I will probably just continue on as I am - business as usual - and then if the sheet calculation goes wonky somewhere down the road, I can just deal with it at that point. It's not like it will impact my bottom line.

[adzino]

Where did you read that? it would be nice to know the source to see if someone here can confirm the info.

That's the thing - I don't even think that I read it - I think it was something I heard on the radio or in a tech podcast (no idea which one as I listen to several and didn't keep track of listened/deleted episodes). It was one of those situations where I wasn't listening closely and just had it playing in the background as background noise. Sorry for my inattentiveness!

Went through their social media and I don't see them mentioning that they will remove their "free plan" from their API.  In fact one of their recent post was advertising and welcoming people to use their free plan to try out their API. You were probably misinformed or it was me that missed out. Anyways, try googling and you might find your answer. Or use other sites the users provided above.

[Rath_]

That's the thing - I don't even think that I read it - I think it was something I heard on the radio or in a tech podcast (no idea which one as I listen to several and didn't keep track of listened/deleted episodes). It was one of those situations where I wasn't listening closely and just had it playing in the background as background noise. Sorry for my inattentiveness!

You probably have heard of their "professional" paid API. The price tag might scare you off ($79-$699 per month!) but it won't replace the current API. For example, the most expensive plan extends the available historical data. I don't think that you need any of these features. The target audience are mostly developers and large funds.

The new API also tracks crypto-based derivatives markets, with support for futures, options and over-the-counter (OTC) exchanges.

[Everglow]

You can integrated API of Coinmarketcap to excel file, that's so great, so if possible, can you provide your file? And I remember CMC just charge fee for individuals or organizations who want to have an API with premium function, and with reference purpose, i think it's free.

[RustyBits]

You can integrated API of Coinmarketcap to excel file, that's so great, so if possible, can you provide your file?

Rather than provide my file (because it is not my own original work and I cannot find the original creator to give him/her the necessary credit due) - you can find several spreadsheet options if you do a Google search for "Cryptocurrency tracker excel CoinMarketCap".  I just don't want to pass off something someone else spent a lot of time putting together and have anyone else get confused into thinking that it is my work; or worse yet, have someone tip me for work that is not mine.  Also - since I did not create it, I could not give any real tech support on getting it setup to work with your data.  I know just enough to be dangerous, but am not all that adept at the underlying spreadsheet coding and most of my alterations are simply made through trial and error.

[Slimztee]

I think yes, coinmartketcap have pro api and we need paid for service. You can use api of etherscan or ethplorer. For me, I use telegram bot to track my ethereum wallet.

Can you please reply with a link for the telegram bot? I lost it with my telegram account that got banned. I would appreciate if you can help me have it back.

[Crypdon]

Not sure about that but you can use an altcoin portfolio instead that keeps track of all your altcoins. I used to use the cointracking website but that took too much time to maintain, now i just put everything in blockfolio which has 95% of my coins, but doesn't have my new / low volume alts (aka shitcoins)

[Noobaru]

Interesting, because I am also a CoinMarketCap daily user. I track cryptos with Blockfolio though, since it seems easier to have it with me wherever I go. But I will look into an idea of having a spreadsheet for that too. Thanks!

[bigcash2011]

I do not think the cmc will charge fee for its service becausethey are already making good money from ads and huge userbase, if they implementpaid service they will loose most of their userbase and all those users will be directed to some alternative free service, so i think cmc will not like to loose its daily visitors and users.

[cryptorampage963]

I think there is no reason that CMC will charge money based on this they also make good revenue also if they implement paid service that time they may lose their customers which they don’t want also to use altcoins portfolio may help them to reduce this problem.

[BlackAngel999]

Yes, you are right. Coinmarketcap has stopped it's free API service and soon it will launch a professional API service. In pro API, there will be limited user request and data access according to the price of the service plan.

[bitcoinhunter888]

There really seems to be no reason that cmc will be charging money because they are making a pretty decent revenue. Implementing paid services might result in the loss of the customers which they would not want to happen.It will be better to use an altcoin portfolio so that you will have ease in keeping tracks of the altcoins that you possess.

[Bitsinmyhead]

They should be allowed to charge for a pro product as they have built a very nice site. Just hope they still will offer a nice free service for us non pro guys!