krijnsent / crypto_vba

An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
MIT License
155 stars 54 forks source link

API limit reached (where API key stored) #52

Closed ITJusus closed 4 years ago

ITJusus commented 5 years ago

I've been running into an issue where the app stops pulling price data. Once I'm in this state, when I go to the CryptoCompare api website (https://min-api.cryptocompare.com/)...I'm presented with a message similar to the following, rather than the normal webpage:

_{"Response":"Error","Message":"You are over your rate limit please upgrade your account!","HasWarning":false,"Type":99,"RateLimit":{"calls_made":{"second":1,"minute":1,"hour":44,"day":44,"month":2010716,"total_calls":2125796},"maxcalls":{"second":50,"minute":1000,"hour":20000,"day":200000,"month":2000000}},"Data":{}}

I eventually went ahead and generated my own API Key from the site (when I could access it again), but I don't know where I would plug my new API Key into the crypto_vba code.

Can you tell me if there is a way around getting stuck in this situation as well as where I might plugin my own API Key for CryptoCompare.?

krijnsent commented 5 years ago

Good point, I included it in the update I made for Cryptocompare. Could you check that code?

ITJusus commented 4 years ago

Thank you. Closing ticket now.

akshitv1 commented 2 years ago

Same issue. Was this resolved ?

krijnsent commented 2 years ago

It has been a while. In principle, the issue is solved. Are you using your own API key? How many queries are you running?

akshitv1 commented 2 years ago

No, i guess they count the api calls using the ip address and not via api key. Correct me if i am wrong here. Yes i am using my own api key, calls just reached 50k.

krijnsent commented 2 years ago

No, i guess you guys count the api calls using the ip address and not via api key. Correct me if i am wrong here. Yes i am using my own api key, calls just reached 50k.

I don't understand you. Who are "you guys"? I built the connector from Excel trough VBA to get data from crypto compare, using their API. They (cryptocompare) are responsible for their API infrastructure, so they are the ones limiting the number of usages and sending back the message that you've reached your limit. All my VBA code does is pass that message on to you. To contact them, see https://www.cryptocompare.com/ (contact link is at the bottom).