Comments (3)
The coinmarketcap API seems to have changed.
They now seem to require an API key : https://coinmarketcap.com/api/documentation/v1/#
The below function works but I suspect the array is in a different format or something as using this function seems to break other parts of the sheet.
Im super noob and dont really know what Im doing though
Put your API key in
sheet = config
cell = B35
function coinmarketcap() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Config");
var key = sheet.getRange("B35").getValue()
var url="https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?convert=EUR&limit=400"
var requestOptions = {
method: 'GET',
uri: 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest',
headers: {
'X-CMC_PRO_API_KEY': key
},
};
var request = UrlFetchApp.fetch(url, requestOptions);
var text = request.getContentText();
var obj_array = JSON.parse(text);
return obj_array;
}
from list.
Hi,
Yeah, coinmarketcap change their api and you need a login. Even then there's a limit of 10k points per month or approximately 333 points a day. Each time you call for the full list of coins and prices it uses 11 points, so you can only call it like 30 times per day.
Take a look at my sheet which does similar to this one.
https://t.co/umUpMF3mNk
You could either use it or you can dig into the code I've used and re-purpose it for your own ends.
Personally, I set up 4 different API keys with coinmarketcap and I make the sheet randomly select one each time it calls the API... that way I'm unlikely to hit my cap no matter how many times I refresh.
from list.
Duplicate of #42
from list.
Related Issues (20)
- USD balance and bitfinex/Kraken HOT 1
- Request Bitmex HOT 2
- HitBTC request HOT 2
- Binance error -1022 HOT 2
- Kucoin API update HOT 4
- Binance API isn't pulling all rates HOT 8
- Missing File | Page 404 HOT 2
- ReferenceError: jsSHA is not defined HOT 1
- Error 403 binance API HOT 6
- Coinmarketcap API change of endpoint URI + API Key HOT 2
- NUM! everywhere. [HELP] HOT 1
- BITFINEX "apikey: invalid"
- The number of rows in the range must be at least 1
- coinMarketCap api error HOT 4
- Binance Error 401 - fapi request HOT 2
- https://api.binance.com returned code 400. "msg":"Signature for this request is not valid."
- Kucoin API request fail (code 401) HOT 3
- Google Sheets no longer has Tools / Script editor function
- API Bitvavo
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from list.