Bitcoin Forum
May 29, 2024, 02:44:46 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1] 2 3 »  All
  Print  
Author Topic: CoinMarketCap data  (Read 562 times)
RustyBits (OP)
Member
**
Offline Offline

Activity: 64
Merit: 15


View Profile WWW
August 27, 2018, 03:29:15 PM
Last edit: August 30, 2018, 04:17:03 PM by RustyBits
 #1

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

Visit GetPaid! for ways to earn money online - You won't Get Rich Quick... but you will GetPaid!
bavian
Member
**
Offline Offline

Activity: 115
Merit: 10


View Profile
August 27, 2018, 03:38:03 PM
 #2

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 (OP)
Member
**
Offline Offline

Activity: 64
Merit: 15


View Profile WWW
August 27, 2018, 03:50:38 PM
 #3

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.

Visit GetPaid! for ways to earn money online - You won't Get Rich Quick... but you will GetPaid!
tomahawk9
Hero Member
*****
Offline Offline

Activity: 2086
Merit: 994


Cats on Mars


View Profile
August 27, 2018, 04:07:52 PM
 #4

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


.
Duelbits
            ▄████▄▄
          ▄█████████▄
        ▄█████████████▄
     ▄██████████████████▄
   ▄████▄▄▄█████████▄▄▄███▄
 ▄████▐▀▄▄▀▌████▐▀▄▄▀▌██

 ██████▀▀▀▀███████▀▀▀▀█████

▐████████████■▄▄▄■██████████▀
▐██████████████████████████▀
██████████████████████████▀
▀███████████████████████▀
  ▀███████████████████▀
    ▀███████████████▀
.
         ▄ ▄▄▀▀▀▀▄▄
         ▄▀▀▄      █
         █   ▀▄     █
       ▄█▄     ▀▄   █
      ▄▀ ▀▄      ▀█▀
    ▄▀     ▀█▄▄▄▀▀ ▀
  ▄▀  ▄▀  ▄▀

Live Games

   ▄▄▀▀▀▀▀▀▀▄▄
 ▄▀ ▄▄▀▀▀▀▀▄▄ ▀▄
▄▀ █ ▄  █  ▄ █ ▀▄
█ █   ▀   ▀   █ █  ▄▄▄
█ ▀▀▀▀▀▀▀▀▀▀▀▀▀ █ █   █
█▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀█  █▄█
█ ▀▀█  ▀▀█  ▀▀█ █  █▄█

Slots
.
        ▄▀▀▀▀▀▀▀▀▀▀▀▀▀▄
        █         ▄▄  █
▄▀▀▀▀▀▀▀▀▀▀▀▀▀▄       █
█  ▄▄         █       █
█             █       █
█   ▄▀▀▄▀▀▄   █       █
█   ▀▄   ▄▀   █       █

Blackjack
|█▀▀▀▀▀█▄▄▄
       ▀████▄▄
         ██████▄
▄▄▄▄▄▄▄▄█▀    ▀▀█
████████▄        █
█████████▄        █
██████████▄     ▄██
█████████▀▀▀█▄▄████
▀▀███▀▀       ████
   █          ███
   █          █▀
▄█████▄▄▄ ▄▄▀▀
███████▀▀▀
.
                 NEW!                  
SPORTS BETTING 
|||
[ Đ ][ Ł ]
AVAILABLE NOW
FlamingFingers
Sr. Member
****
Offline Offline

Activity: 1330
Merit: 288



View Profile
August 27, 2018, 04:16:00 PM
 #5

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.

█▀▀▀











█▄▄▄
▀▀▀▀▀▀▀▀▀▀▀
e
▄▄▄▄▄▄▄▄▄▄▄
█████████████
████████████▄███
██▐███████▄█████▀
█████████▄████▀
███▐████▄███▀
████▐██████▀
█████▀█████
███████████▄
████████████▄
██▄█████▀█████▄
▄█████████▀█████▀
███████████▀██▀
████▀█████████
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
c.h.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀█











▄▄▄█
▄██████▄▄▄
█████████████▄▄
███████████████
███████████████
███████████████
███████████████
███░░█████████
███▌▐█████████
█████████████
███████████▀
██████████▀
████████▀
▀██▀▀
Slash61
Member
**
Offline Offline

Activity: 633
Merit: 14


View Profile
August 27, 2018, 04:29:23 PM
 #6

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 (OP)
Member
**
Offline Offline

Activity: 64
Merit: 15


View Profile WWW
August 27, 2018, 04:40:50 PM
 #7


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!

Visit GetPaid! for ways to earn money online - You won't Get Rich Quick... but you will GetPaid!
RustyBits (OP)
Member
**
Offline Offline

Activity: 64
Merit: 15


View Profile WWW
August 27, 2018, 04:47:08 PM
 #8

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.

Visit GetPaid! for ways to earn money online - You won't Get Rich Quick... but you will GetPaid!
adzino
Copper Member
Hero Member
*****
Offline Offline

Activity: 2968
Merit: 574


www.Crypto.Games: Multiple coins, multiple games


View Profile
August 27, 2018, 04:57:05 PM
 #9


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.

█████████████████████████
███████▄▄▀▀███▀▀▄▄███████
████████▄███▄████████
█████▄▄█▀▀███▀▀█▄▄█████
████▀▀██▀██████▀██▀▀████
████▄█████████████▄████
███████▀███████▀███████
████▀█████████████▀████
████▄▄██▄████▄██▄▄████
█████▀▀███▀▄████▀▀█████
████████▀███▀████████
███████▀▀▄▄███▄▄▀▀███████
█████████████████████████
.
 CRYPTOGAMES 
.
 Catch the winning spirit! 
█▄░▀███▌░▄
███▄░▀█░▐██▄
▀▀▀▀▀░░░▀▀▀▀▀
████▌░▐█████▀
████░░█████
███▌░▐███▀
███░░███
██▌░▐█▀
PROGRESSIVE
      JACKPOT      
██░░▄▄
▀▀░░████▄
▄▄▄▄██▀░░▄▄
░░░▀▀█░░▀██▄
███▄░░▀▄░█▀▀
█████░░█░░▄▄█
█████░░██████
█████░░█░░▀▀█
LOW HOUSE
         EDGE         
██▄
███░░░░░░░▄▄
█▀░░░░░░░████
█▄░░░░░░░░█▀
██▄░░░░░░▄█
███▄▄░░▄██▌
██████████
█████████▌
PREMIUM VIP
 MEMBERSHIP 
DICE   ROULETTE   BLACKJACK   KENO   MINESWEEPER   VIDEO POKER   PLINKO   SLOT   LOTTERY
Rath_
aka BitCryptex
Legendary
*
Offline Offline

Activity: 1876
Merit: 3132



View Profile
August 27, 2018, 05:00:31 PM
 #10

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
Jr. Member
*
Offline Offline

Activity: 287
Merit: 6


View Profile
August 27, 2018, 05:09:22 PM
 #11

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 (OP)
Member
**
Offline Offline

Activity: 64
Merit: 15


View Profile WWW
August 27, 2018, 07:01:28 PM
 #12

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.

Visit GetPaid! for ways to earn money online - You won't Get Rich Quick... but you will GetPaid!
Slimztee
Newbie
*
Offline Offline

Activity: 126
Merit: 0


View Profile
August 27, 2018, 07:08:42 PM
 #13

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
Member
**
Offline Offline

Activity: 616
Merit: 11


View Profile
August 27, 2018, 07:09:20 PM
 #14

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
Jr. Member
*
Offline Offline

Activity: 504
Merit: 3


View Profile WWW
August 27, 2018, 07:47:56 PM
 #15

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!

▄▄▄▄▄▄▄▄▄▄▄ ▄ ■       SKYNET.co       ■ ▄ ▄▄▄▄▄▄▄▄▄▄▄
▐▬▬▬▬▬▬▬▬▬     PRIVATE SALE is LIVE     ▬▬▬▬▬▬▬▬▬▌
bigcash2011
Sr. Member
****
Offline Offline

Activity: 1442
Merit: 265


View Profile WWW
August 27, 2018, 08:33:10 PM
 #16

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
Newbie
*
Offline Offline

Activity: 56
Merit: 0


View Profile
August 29, 2018, 06:54:52 PM
 #17

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
Newbie
*
Offline Offline

Activity: 225
Merit: 0


View Profile
August 29, 2018, 07:15:03 PM
 #18

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
Newbie
*
Offline Offline

Activity: 84
Merit: 0


View Profile
August 29, 2018, 07:51:32 PM
 #19

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
Sr. Member
****
Offline Offline

Activity: 465
Merit: 254


View Profile
August 29, 2018, 07:54:22 PM
 #20

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!

            ▄▄████▄▄
        ▄▄██████████████▄▄
      ███████████████████████▄▄
      ▀▀█████████████████████████
██▄▄       ▀▀█████████████████████
██████▄▄        ▀█████████████████
███████████▄▄       ▀▀████████████
███████████████▄▄        ▀████████
████████████████████▄▄       ▀▀███
 ▀▀██████████████████████▄▄
     ▀▀██████████████████████▄▄
▄▄        ▀██████████████████████▄
████▄▄        ▀▀██████████████████
█████████▄▄        ▀▀█████████████
█████████████▄▄        ▀▀█████████
██████████████████▄▄        ▀▀████
▀██████████████████████▄▄
  ▀▀████████████████████████
      ▀▀█████████████████▀▀
           ▀▀███████▀▀



.SEMUX
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
  Semux uses 100% original codebase
  Superfast with 30 seconds instant finality
  Tested 5000 tx per block on open network
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
█ █
Pages: [1] 2 3 »  All
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!