Moosy Research is the leader in Google Sheets based cryptocurrency sheets. Our mission is to build and support the best cryptocurrency spreadsheets that help investors to manage their assets. If you are looking for a cool sheet, have a look at Cointrexer, BotMon and ReX.
To access your private data on an exchange, API authentication is required. Allmost all exchanges provide API authentication based on a public/private key pair and a cryptographic signature such as Secure Hash Algorithms (SHA) combined with hash-based message authentication code (HMAC) to gain access to private data. The challenge however is that all exchanges do their authentication slidely different and use different attributes in the http header for the authentication and/or signing of the request. Moosy Research created 50+ exchange specific collectors to authenticate and todo these private requests for our own cyptosheets. A selection of our collectors is open source and published below.
Howto use these code examples:
-
Scroll down and copy one of the .gs files into your Google Apps Script ide
-
Pop-in your API keys and select run from the menu
-
The result can be viewed from the Apps Script built-in Logger
-
Disable the V8 runtime if you have any issues with this code !!!
Please ★ Star on the top of this page if you like this page and you want to motivate me to publish more.
To explore these lovely APIs from Google Sheets you can use our ReX Tools. ReX Explorer is a Sheet and Script that allows you to see the request and the response data. ReX Explorer is great for educational purposes; the script log will show details on complete HTTP/REST request and response. To view the log from Google Sheets select: Tools, Script Editor, View, Logs. ReX Builder is tool for you to create your own cryptosheet.
Enjoy,
Moosy
Your donation is highly appreciated => ETH 0x4a15c8a7aeb99ae02c0a4fae53a34ae34aa9b438
| Exchange | Id | OSS | CtrXL | ReXB | API | Signature |
|---|---|---|---|---|---|---|
| Bibox | BBX | cointrexer | ✓ | HMACMD5 | ||
| Binance | BIN | binance.gs | ✓ | ✓ | v3 | HMACSHA256HEX |
| Bit2C | B2C | cointrexer | ✓ | HMACSHA512B64 | ||
| BitGo | xxx | not possible | v2 | impossible / IP chk | ||
| Bitfinex | BFX | bitfinex.gs | ✓ | ✓ | v2 | HMACSHA384HEX |
| Bitflyer | FLY | bitflyer.gs | ✓ | v1 | HMACSHA256HEX | |
| Bitforex | FOR | cointrexer & rex | ✓ | ✓ | HMACSHA256HEX | |
| Bitget | todo | v1 | HMACSHA256B64 | |||
| Bitmart | MRT | bitmart.gs | ✓ | ✓ | v1 | HMACSHA256HEX |
| Bitmex | BMX | bitmex.gs | ✓ | ✓ | v1 | HMACSHA256HEX |
| Bitpanda | PAN | cointrexer | ✓ | |||
| Bitpanda GE | PGE | cointrexer | ✓ | |||
| Bitsane | BSN | cointrexer | ✓ | HMACSHA384HEX | ||
| Bittrex | BTX | bittrex.gs | ✓ | ✓ | v3 | HMACSHA512HEX |
| Bitso | BSO | cointrexer | ✓ | HMACSHA256HEX | ||
| ByteTrade | todo | v2 | HMACSHA256HEX | |||
| BKex | KEX | cointrexer & rex | ✓ | ✓ | HMACSHA256HEX | |
| Bitstamp | BTS | cointrexer | ✓ | HMACSHA256HEX | ||
| Bitvavo | VAV | cointrexer | ✓ | HMACSHA256HEX | ||
| Bitmax | todo | v1 | HMACSHA256B64 | |||
| Bitz | todo | v2 | HMACSHA256B64 | |||
| BtcTurk | BTK | cointrexer | ✓ | HMACSHA256B64enc | ||
| BTSE | todo | v3 | HMACSHA384HEX | |||
| Bybit | BYB | bybit.gs | ✓ | ✓ | v1 | HMACSHA256HEX |
| Cex.io | CEX | cointrexer | ✓ | |||
| Coinall | ALL | cointrexer | ✓ | |||
| Coinbase | CNB | coinbase.gs | ✓ | v2 | HMACSHA256HEX | |
| Coinbase Pro | GD | cointrexer & rex | ✓ | ✓ | ||
| CoinDCX | DCX | cointrexer | ✓ | |||
| CoinEx | CNX | cointrexer | ✓ | |||
| CoinONE | todo | v2 | HMACSHA512HEX | |||
| Coinsbit | todo | v1 | HMACSHA512 | |||
| CoinTiger | todo | v2 | HMACSHA512HEX | |||
| Crex24 | C24 | cointrexer | ✓ | HMACSHA256B64 | ||
| Crypto_com | todo | v2 | HMACSHA256HEX | |||
| Crypto APIs | CRA | cryptoapis.gs | ✓ | v1 | none | |
| Currency com | CUR | cointrexer & rex | ✓ | ✓ | ||
| DCX | DCX | cointrexer | ✓ | HMACSHA256HEX | ||
| Delta-Exchange | DEL | delta_exchange.gs | ✓ | ✓ | v2 | HMACSHA256HEX |
| Deribit | DRB | cointrexer & rex | ✓ | ✓ | Barrier Token | |
| DeversiFi | Todo | v1 | ? | |||
| eToro | TOR | rex | ✓ | ? | not sure latest version | |
| eToroX | TOX | rex | ✓ | v2 | not sure latest version | |
| Forex | bitforex? is it the same | . | ||||
| FTX | FTX | cointrexer & rex | ✓ | ✓ | ||
| Gate.io | GAT | cointrexer | ✓ | |||
| Gemini | GEM | gemini.gs | ✓ | ✓ | v1 | HMACSHA384HEX |
| Globitex | . | todo | v? | HMACSHA512HEX | ||
| BitBTC | HIT | cointrexer | ✓ | |||
| Hotbit | todo | ? | ? | |||
| Huobi Pro | HUB | huobi.gs | v1 | HMACSHA256B64 | ||
| Idex | IDX | idex.gs | ✓ | v2 | HMACSHA256HEX | |
| Indodax | IND | cointrexer | ✓ | |||
| Kraken | KRK | kraken.gs | ✓ | ✓ | v1 | HMACSHA512++ |
| Kucoin | KUC | cointrexer | ✓ | |||
| Liquid | Liq | cointrexer | ✓ | |||
| Luno | LUN | cointrexer | ✓ | none | ||
| Mercadobitcoin | MCD | cointrexer | ✓ | HMACSHA512HEX | ||
| MXC | MXC | cointrexer & rex | ✓ | ✓ | HMACSHA256HEX | |
| MEXC Global | MEX | mex.gs | ✓ | HMACSHA256HEX | ||
| Namebase | NMB | cointrexer | ✓ | ✓ | ||
| Nicehash | NCH | nicehash.gs | HMACSHA256HEX | |||
| Nominex | NOM | cointrexer | ✓ | |||
| Okex | OKX | okex.gs | ✓ | ✓ | v3 | HMACSHA256B64 |
| OkCoin | OKC | cointrexer & rex | ✓ | ✓ | v3 | HMACSHA256B64 |
| OANDA | OAN | oanda.gs | ✓ | ✓ (-) | v2 | Barrier Token |
| Gopax | PAX | cointrexer | ✓ | |||
| Paribu | todo | ?? | ||||
| Phemex | PMX | cointrexer & rex | ✓ | ✓ | ||
| Poloniex | POL | poloniex.gs | ✓ | v1 | HMACSHA512HEX | |
| Probit | PRB | cointrexer & rex | ✓ | ✓ | ||
| SimpleFX | SMP | cointrexer & rex | ✓ | ✓ | Barrier Token | |
| Redot | is it possible? | v1 | Fin FIX API | |||
| Ukex | todo | v? | HMACSHA512??? | |||
| Upbit | UPB | cointrexer | ✓ | |||
| Vinex Network | VNX | cointrexer | ✓ | |||
| VccExchange | todo | v3 | HMACSHA256HEX | |||
| Yobit | YBT | cointrexer | ✓ | |||
| Zerohash | ZHS | cointrexer & rex | ✓ | ✓ | v1 | HMACSHA256B64 |
feedback or requests: moosylog@gmail.com
If you don't tell me, how can I know?
hmac sha cryptos cryptocurrency cryptocurrencies exchange sign sigature signing private request authentication authenticate google sheets google script javascript gas Google Sheets automatic creation with Google Apps Script (GAS) for managing a cryptocurrency tracking spreadsheet Google Sheets script editor code for managing a cryptocurrency tracking spreadsheet
Moosy Research: Cool Cryptocurrency Sheets Because nothing is as flexible and easy to work with as a spreadsheet!