SPECIAL BINANCE TROUBLESHOOT FEATURE

Enter 'debug' as the third attribute and turn the 6h cache off. This will show a pop-up with detailed information on what's received !!

Example: For a normal spot account, just enter 'debug' in the Third Attribute field.

For margin or futures, just add 'debug'. Example: 'futures usdt account debug'. or 'vanilla account debug'

Binance known issue and workaround

Watch a step by step Video (version 1.5g)

ISSUE: No Balance in the sheet or only sometimes? or Binance error 418 or Way too many requests; IP banned until

CAUSE: It's not your machine that is making the connection with Binance, but the Google Cloud. The nodes in the Google Cloud share a large pool of IP addresses that make the connection to the Binance server. Sometimes, it gets too busy and Binance temporary blocks a Google Cloud IP address.

Every time the script runs, your session receives a new IP address from the Google Pool. It is one of the Google IP addresses that is blocked.

When the script is running from a Trigger this issue does not occur, so there is definitely a difference running from a trigger or by pressing the button in the sheet. With the workaround below the sheets gets updated from a Trigger when you open it and your balances are cached for 10 min (time in sheet). You can press the update button to update the prices / values.

WORKAROUND: Make sure a startup Trigger is active (CtrXL and BotMon) - see video

1. Set your Triggers in CONFIG. Log Frequency must be smaller than 6 hours

2. Make sure TTL is 21600 and Skipzero is ON

3. Turn caching OFF for Binance

4. Exit the sheet (refresh the url) a few times until it successfully made a connection with Binance

5. When Triggers are set the sheet will auto update in the background.

It is not configured todo live update to Binance but if it fails, it will do a failover to the cache. Don't worry, only asset and number of assets are cached. Not the current value.

See the CtrXL doc on how caching works

BotMon specific

1.) Binance connectivity issues - Resulting in no market data.

It's not your machine that is making the connection with Binance, but the Google Cloud. The nodes in the Google Cloud share a large pool of IP addresses that make the connection to the Binance server. Sometimes, it gets too busy and Binance temporary blocks a Google Cloud IP address.
Every time the script runs, your session receives a new IP address from the Google Pool. It is one of the Google IP addresses that is blocked.

When the script is running from a Trigger this issue does not occur, so there is definitely a difference running from a trigger or by pressing the button in the sheet. With the workaround below the sheets gets updated from a Trigger when you open it and your balances are cached for 10 min (time in sheet). You can press the update button to update the prices / values.

Work around: make sure the script is run from a Trigger and let it run for a couple of days

2.) Binance - Trades are not updated

The Binance API does not have a function to request all recent trades so one has to specify the trading pair to request last trades. (example BTC-USDT). Since there are many possible combinations and this will be extremely slow BotMon auto detects changes to the balance. It compares the balances in the spreadsheet with the balances on the API and requests pairs based on the difference. When the balance sheet is empty it requests all possible combinations *(slow)

If you miss trades:

1.) clear the balance sheet so it will be forced to loop through all pairs (slow) - you can just clear the values in balance column E

BotMon reads the Balance!C6:E sheet so it can compare balance as described earlier. You can clear this range are parts of it.

2.) manual delete some trades, starting at row 6 - https://youtu.be/TCWXX15WLps?t=19

BotMon reads the date in cell Trades!C6 and will add only add newer trades

Bit2C

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: API Reference

Available parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange.

debug - Pops up a dialog box with the raw output received from the exchange.

Bitfinex

Supported: [ ✔ ] Cointrexer [ ? ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference - Error codes

BotMon has known glitches on Bitfinex that where reported dec 2020.
The collector is still using the v1 Bitfinex API that needs a refresh to v2.
If the data is not sorted when you run it for the first time, you can manually sort the range on date.

CtrXL and Rex are using API v2

bitFlyer

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference - playground

Nothing special

BitForex

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

ReX is only tested with Balances!! Other Private commands with payload are not tested / implemented and require some additional code.

BitMart

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

Create API key:

Create your API keys on https://www.bitmart.com/api/en (don't use the Old API page)

CtrXL specific:

Third Attribute = BitMart memo

Spot

Current CtrXL collector version is based on Spot Balance. Let me know if you need more and we need to enhance the collector.

Test mode

To test you can use 'demo' as third attribute. This ignores the API and returns some sample data.

BitMEX

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference - Explorer

CtrXL specific:

On BitMEX you are trading derivatives contracts, not the underlying asset. The realised PNL of all trades is in XBT terms and all deposits/withdrawals to/from BitMEX are also made in XBT. Therefore your wallet balance is always only in XBT / BTC

To see your positions you can use our ReX tool.

Available parameters that can be used as third attribute:

testnet - For use with testnet environment (you need specific keys for testnet)

debug - Pops up a dialog box with the raw output received from the exchange.

ReX specific:

The API allows to fetch a max of 500 entries, so if you have more you need multiple queries.

Bitpanda

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

Bitpanda only uses an API key to authenticate to the API. There is no secret !

IMPORTANT: Paste your API key in both the API key and API secret field in CONFIG. Both fields need a key !

Demo or Test data:

Enter API key in both key and secret field in CONFIG

Enter 'demo' as the third attribute

This will populate some demo data (BTC and ETH) and skip the exchange API.

Errors or Issues:

See generic troubleshoot section

Error 429 - Rate Limit

The API is limited to x requests per x. Not sure what these values are on Bitpanda.

Solution: Wait until you press update or turn caching on in CONFIG

Error: Value type mismatch. Expected: object, Actual: boolean

a.) Turn off caching in CONFIG until everything works for you

b.) Enter your API key in both API key and API secret fields in CONFIG

c.) Please check Debug log so we can see what's received and/or if there is any error

Howto Debug: https://sites.google.com/site/moosyresearch/projects/cryptos/doc/exchanges#TOC-Howto-DEBUG

Bitpanda GE

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

Paste your API key in both the API key and the API secret field in CONFIG. Both fields need a key !

Demo data

The collector has some Demo data built in.

You can use 'demo' in the Third Attribute field and it will inject some sample data.

Bitsane

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Think it doesn't exist anymore but our connector does ;-)

Bitso

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

Nothing special, just pop-in your api key+secret in CONFIG

Demo or Test data:

Enter API key in both key and secret field in CONFIG

Enter 'demo' as the third attribute, this will populate some demo data and skip the exchange API.

Bitstamp

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

Apart from key and secret, the userid is required for authentication.

Bitstamp requires a third attribute for authentication, use the USERID as Third Attribute in CONFIG

Bittrex

Supported: [ ✔ ] Cointrexer [ ✔ ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

Additional troubleshoot switch:

You can enter 'debug' in the third attribute field. This will output the raw api data in a pop-up.

Bitvavo

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

see Bitvavo specific CtrXL video

Additional troubleshoot switch:

You can enter 'debug' in the third attribute field. This will output the raw api data in a pop-up.

BKEX

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

Nothing special

Bybit

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

CtrXL specific:
Spot account supported (/spot/v3/private/account )

Available parameters that can be used as third attribute:

testnet - For use with Bybit testnet (sandbox) environment (you need an account and specific keys for testnet)

debug - Pops up a dialog box with the raw output received from the exchange.

demo - pushed some demo data

BtcTurk

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

See this BtcTurk specific config video

Nothing special, just pop-in your read-only API credentials and your balance is fetched.

As third attribite you can use 'demo'. This will ignore the API and push some demo data (TRY and BTC) from the collector to CtrXL.

CEX.IO

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

1.) Create your API key on CEX.IO - see this howto article

2.) Find your CEX userID - see this howto article

In CtrXL enter your

API key + API secret + userid

(Third Attribute = CEX.IO Userid)

Changelly

Supported: [ X ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

#Todo: Please contact us and help us create a connector

CoinAll

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

Additional attribute = CoinAll Passphrase

You can use 'demo' as additional attribute to ignore to exchange a populate some demo data.

Coinbase

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

API settings for Coinbase: we only require wallet:accounts:read as far as I know

multiple accounts in your wallet:

If you have multiple accounts, you can specify an account id as the Third attribute. We default to account 0.

The account is a number, see the debug log for more details.

Issues:

You can enter 'debug' in the third attribute field in CONFIG. This will display a popup with the data it receives from Coinbase.

In addition you can look at the debug log, this shows even more data.

Known limitation:

Max. 100 different coins in a single balance.

Let me know if we need to extend this. (pagination)

Coinbase Pro (GDAX)

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage ,- API Reference

Coinbase Pro requires a third attribute for authentication.

Please enter your Coinbase Passphrase as the Third Attribute

Issues:

You can enter 'debug' in the third attribute (after your passphrase). This will display a popup with the data it receives from Coinbase.

In addition you can look at the debug log, this shows even more data.

CoinDCX

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

See this CoinDCX specific CtrXL video

Nothing special, pop-in api key/secret in CONFIG and go

Third attribute can be

'demo' to populate some demo data.

CoinEx

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage

Nothing special, pop-in api key/secret in CONFIG and go

Third attribute can be

'demo' to populate some demo data.

'debug' to output the received data

Coinmama

Supported: [ X ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

#Todo: There is currently no API available for Private data!

Coinone

Supported: [ X ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

#Todo: We can create a collector for you if you are willing to help. We can not create accounts and have balance on all exchanges. Please contact moosy.

Coinsbit

Supported: [ X ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

#Todo: When API becomes available!

Crex24

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

Crypto.com

Supported: [ X ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

#Help: We love to create a collector but we can not create an account (and do the passport verification) for every single exchange. Are you interested in a collector and are willing to help us, please contact moosylog@gmail.com .

See our Github page as well for more info

Cryptopia

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links:

Unknown cryptocurrencies

Cryptopia has coins that are not available on Coinmarketcap. These may not be handled correctly.

Cryptopia Key Permissions

Only 'Read Info' is required

'Enable Withdrawal' and 'Allow unsafe withdraw' not required

Click image to enlarge

BotMon specific:

CSV

If your date is in dd/mm/yy format, set the CONFIG!D36 switch to ON

Currency.com

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

Nothing special

Currency.com API is supported in both ReX and Cointrexer.

Pop-in api key and secret.

If you have issues, recreate keys and/or see details in debug.log

Delta Exchange

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

See this simple Delta Exchange howto video

ReX (limited support - no arguments are supported in the collector) - see quick video

API key/secret:

Nothing special

Available parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange.

debug - Pops up a dialog box with the raw output received from the exchange.

Deribit

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

The Deribit Collector for CtrXL is very flexible and let you determine what data you want to see in your sheet.
See below the configuration options and some best practices.

CtrXL specific:

Deribit API will fetch the BTC and the ETH value as available by the api (account api)

You can configure the collector by using the 'Third Attribute' field in config.

Available options:

• sessionFunding

• equity TIP!!

• balance (default)

• availableFunds

• maintenanceMargin

• deltaTotal

• marginBalance

Best practice, user feedback:

#TIP 1: To be honest with you, I think logging equity instead of balance on Deribit makes more sense.

Balance does not include this sessions open P/L (which is settled once a day at 8am UTC), so when you log intraday, you get the crypto balances from 8am valued at the current market prices....which completly busts any mark to market valuation for that account.

I'm logging equity for Deribit and now my MtM account value is on point : )

#TIP 2: You can see all values for your account using DEBUG (script editor, ctrl + enter)

#TIP 3: You can create a second or third entry for your Deribit account (other label/name) in CONFIG to collect multiple attributes ( if that brings any value )

feedback: moosylog@gmail.com

DeversiFi

Supported: [ X ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference or Diversifi copper (looks like there are 2)

Let me know if we need an integration

ERC20

Supported: [ ✔ ] Cointrexer [ ] BotMon [ ] ReX

Links:

An ERC20 token is a blockchain-based asset. As of October 2019, more than 200,000 different ERC20 compatible tokens exist on Ethereum's main network.

Unfortunately it is technically not possible to automatically get a list of ALL your ERC20 tokens and their balance from the Ethereum blockchain.
In addition, symbols that represent a token are not unique so the only way to address a token is by ETH address and Token address.

The Cointrexer "EtherscanTokens" Collector allows you to manual admister your tokens and fetches the balance for you. See below.

There are several other APIs where we potentially can pull data from, but they all provide a subset and not ALL available tokens:

Possible other sources: tokengateway.io / tokenbalance.com / bitquery.io / or export with deltabalances

Etherscan

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Etherscan is a Block Explorer and Analytics Platform for Ethereum, a decentralized smart contracts platform.

We have two different Etherscan collectors.
1.) Etherscan (ETH) - a total value on all assets (legacy collector)
2.) EtherscanTokens (ETS) - let you administer tokens and symbols (recommended) . See the Howto video

2.) EtherscanTokens (ETS)

*new* EtherscanTokens - let you administer a list of tokens and their Coinmarketcap symbol. CtrXL will fetch the balance.

Howto video

CONFIG

api = etherscan api key,

secret = eth address,

third attrib = optional, a sheetname

Etherscan does not return a decimal separator in the amount.
If you leave the decimal field empty,, the default decimal divide value is 18.
Common values are 6, 8, 18

1.) Traditional Totals Etherscan collector

API Key = Your Etherscan API key.

Secret = your ETH address

Third Attribute can be 'debug'. This will popup a dialogue box with the output it receives.

Third Attribute can be 'erc20'. This will make symbol ERC20 and leave the number as is.

Specific Token Balance

step1:

API Key = Your Etherscan API key.

Secret = your ETH address

Third Attribute = Token contract address

step2:

Open CMC_Mapping tab

Create an ENTRY to map the token to a Coinmarketcap symbol

ETH -> Token contract address -> Coinmarketcap Symbol

eToro

Supported: [ ] Cointrexer [ ] BotMon [ ] ReX

Links: Webpage - API Reference

eToroX

Supported: [ X ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

March 14, 2020. Although the eTorox team has been very cooperative we only have very limited support for the eTorox API.

Users first manually need to convert their API key from pkcs#8 to pkcs#1 for this to work in Google Apps Script. Very, very user unfriendly.

eToroX is a digital asset platform, secure, and regulated, which seeks to empower people with blockchain technology. According to Yoni Assia, CEO, and Founder of eToro, “We believe blockchain technology will revolutionize finance and we will see the greatest transfer of wealth over onto the blockchain.”

Limited support because this is NOT very user friendly and the eToroX API authentication is really a pain. See this video of ReX with eTorox in action.

1.) The PEM formatted pkcs #8 private key needs tobe converted to pkcs #1. (read howto)

Line breaks need tobe replaced by \n

example of converted key that can be copied into the sheet:

-----BEGIN PRIVATE KEY-----\nMIICdgIBBANBgkqhkiG9\n2394ddf0ufas\nWwDj2cehQwg==\n-----END PRIVATE KEY-----\n

2.) When you create an API key you will get an url for the API. This is a personal url.

Enter the API url as the third attribute (ThirdAttrib) in CONFIG

FTX

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

Some users experiences "Not logged in message" error messages.
Solution:
- try recreate your api key and do not share with other apps
- set (startup) Trigger - See the Binance section in this doc (let the script run from a Trigger)

Available CtrXL parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange.

debug - Pops up a dialog box with the raw output received from the exchange.

string - subaccount name. You can create separate entries in CONFIG if you like.

ReX

third attribute can be subaccount name

Gate.IO

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links:

Spot account is supported using /api/v4/spot/accounts

Available CtrXL parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange.

debug - Pops up a dialog box with the raw output received from the exchange.

margin debug - displays data but need to finish

Gemini

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links:

CtrXL: Third Attribite can be 'debug' or 'sandbox'

ReX: payload is not tested. Contact me if you have an issue with payload and we will fix it.

Gopax

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links:

Gopax is a fast, reliable and user-oriented cryptocurrency exchange by Streami Inc. Gopax is a South Korean cryptocurrency exchange.

Korean or International server

The Exchange Collector will default connect the Korean API server on https://api.gopax.co.kr.

If you have an account on the international https://api.gopax.com server, enter 'com' as Third Attribute in CONFIG.

API key/secret:

Nothing special

Available parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange.

debug - Pops up a dialog box with the raw output received from the exchange.

com - set the url to gopax.com server (default gopax.co.kr)

CMC Mapping

You can hide/remove unknown currencies '?' by mapping them to the correct Coinmarketcap symbol or hide them by mapping them to '***' in [CMC Mapping]

South Korean Won (KRW) is not supported and will show as '?'

You can extend the sheet and create your own calculations based on GoogleFinance("CURRENCY:USDKRW")

Issues

Check Debug Log and make sure the Dust Filter is turned off in CONFIG.

HitBTC

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links:

Nothing special, just popin key and secret in config

Huobi

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

CtrXL specific:

If you have multiple accounts, you can enter your accound ID as an additional option in the third attribute field in CONFIG.

You can find you account id:

- on Huobi.com

- in the CtrXL Logfile, look for:

[18-12-14 22:47:03:006 PST] Huobi accounts:

[18-12-14 22:47:03:007 PST] {data=[{subtype=, id=5126125, state=working, type=spot}],

Issues: No Balance // Keys are correct:

Set Triggers, exit the sheet and start again. The sheet now updates from the startup Trigger.

Please try the Binance workaround that is described here. (set ttl in config)

Old text

Every time you activate the script; your session is assigned to a node in the Google Cloud and you get an IP address.

It looks like Huobi validates the IP address and blocks many Google IP addresses.

Many times you do a request you don't get a response. If does not work; just run again and again.

IDEX

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ x ] ReX

Links: Webpage - API Reference

Oct 10 2020, Collector Updated to IDEX 2 - thanks Bernd for your help !

CtrXL specific:

Define a new Exchange in CONFIG:

1. Create an IDEX exchange in CONFIG and give it a unique name

2. Enter your IDEX API key and API secret

3. Third Attribute (required)

a. Leave empty will show a dialogue with your assigned wallet addresses

b. your wallet address - you can create multiple IDEX sources f you have multiple wallets

c. demo - this populates some demo data (USDT and ETH) and will skip the exchange API.

4. Make sure '6h Cache' checkbox in Column O is turned OFF until everything works for you,

Issues: Error 500 or timeout :

Some user reported a very specific issue with IDEX.

When you press the update button it takes a long time and eventually times out with 'Error 500 -Server Error"

This does no occur when the sheet is updated from a startup/timed Trigger. The work around is the following:

- set Triggers in CONFIG, exit the sheet and go back in. The sheet now auto. updates from a startup Trigger.

- set 6h cache to ON in CONFIG for IDEX

- you can lower the cache value to for example 10 minutes by adding "ttl 600" in config to an empty row (eg 22) (see the config tab in the CrXL doc)

Technical background on the issue can be found here

Troubleshoot:

1. Make sure you have a valid wallet address as third attribute in CONFIG. Leave third attribute blank to see your assigned wallets.

The wallet address is the IDEX wallet address and not your "normal" wallet address. Contact me if you have any questions

2. Timeout / Server Error / HTTP error 500. Work around: set Triggers and turn on the 6h cache.

3. Make sure the CtrXL Dust Filter is turned off in CONFIG. You can turn it back on when everything works.

4. Make sure '6h Cache' checkbox in CONFIG | Column O is turned OFF until everything works for you,

5. Check Debug Log

6. Contact Moosy for assistance

Note: (based on IDEX 1)

Only pairs which are supported in the given region will be returned. If no region is provided, pairs from the Global region will be returned.

At this point the collector does not specify a region. Let me know if this causes issues. (more)

Indodax

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links:

Demo data

The collector has some Demo data built in.

You can use 'demo' in the Third Attribute field and it will inject some sample data.

Make sure Dust Filter in CONFIG is OFF

CMC Mapping

You can hide/remove unknown currencies '?' by mapping them to the correct Coinmarketcap symbol or hide them by mapping them to '***' in [CMC Mapping]

Indian Rupee (IDR) is not supported and will show as '?'

Issues

Check Debug Log and make sure the Dust Filter is turned off in CONFIG.

Kraken

Supported: [ ✔ ] Cointrexer [ ✔ ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference - Futures

CtrXL specific:

Futures balances and/or Spot - you can create multiple entries

In CONFIG:

Spot - create a unique label, example 'My_KRK_Spot' and pop-in your key/secret.

Futures - create a unique label, example 'My_KRK_Futures' and pop-in your key/secret. Add 'futures' as third attribute.

If you have an issue, look at the Debug log and/or try ReX.

Log into your Kraken account and visit your Settings page. Click on the Generate New Key button to create a new API key.

Make sure that the API key only has the Query Funds permission, and provide the API key a description.

Click on the Generate Key button. Below you can see some screenshots of the process.

Once you have logged in you will need to click on the drop-down menu near your account name in the upper- right corner. Please select Settings in the drop down menu.

Once the Settings page comes up you will see a menu banner along the top of the page. Please click on the API option.

On the next page you will click the Generate New Key button.

Only select the Query Funds checkbox.

The sheets don't do anything specific with margin wallet on Kraken

Contrexer specific:

Query Closed Order & Trades must be switched on as well if you want Mr. Robot to retrieve a price for you. (2.7.4 and higher)

Once your Kraken.com API Key as been generated you can enter the API Key and Private Key in the Cointrexer Configuration Tab.

Kucoin

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links:

Kucoin requires a third attribute for API authentication:

The Third Attribute in the CONFIG tab should be your Kucoin 'Passphrase'

You must create an API key via the KuCoin website. Upon creating a key you will have 3 pieces of information which you must remember:

* Key

* Secret

* Passphrase

The Key and Secret will be randomly generated and provided by KuCoin. The passphrase is filled in when you create the API.

IMPORTANT!! User feedback: the Passphrase should contain letters and numbers for the API to work.

1.) If you have issues, recreate API key and make sure Passphrase contains letters and numbers

2.) Make sure the API does not have IP restrictions ! (No Limit)

3.) Still issues, look at the DEBUG log

Liquid

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links:

Required:

Token and User secret

The token is a short number

User secret is long string

Special action:

in config copy the long string (user secret) in both key and secret field

copy the short number, the token in the third attribute

The third attribute can also be 'demo' to generate some sample data.

You can use CMC Mapping to tweak and map the currencies to Coinmarketcap.

You can also also hide/remove unknown currencies by mapping it in [CMC_Mapping] to ***

LUNO

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference

CtrXL supports API 1.0 -> https://www.luno.com/en/developers/api

You can use CMC Mapping to tweak and map the currencies.

You can also also hide/remove unknown currencies by mapping it in [CMC_Mapping] to ***

The collector has some Demo data built in.

You can use 'demo' in the Third Attribute field and it will inject some sample data.

Mercadobitcoin

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Only Cointrxer is tested

You can use debug as third attribute

MEXC Global

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Only Cointrxer is tested. MEXC API version 3

You can use 'debug' and or 'demo' as third attribute

MXC

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

Note: Looks like all MXC commands are Private Requests and require an API key.

Namebase

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

You can generate a key from https://www.namebase.io/pro.

Third attrubite can be 'debug'

ReX Buider has two sample commands

n.exchange

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Reference

#Todo: Please let me know if we need to develop a collector?

Nominex

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ? ] ReX

Links: Webpage - API Reference

API key/secret:

Nothing special

Available parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange.

debug - Pops up a dialog box with the raw output received from the exchange.

Nomics

API v1 does not allow private requests (nov 2020)

https://nomics.com/docs/#section/Authentication

OKX

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: https://www.okx.com/docs-v5/en/#rest-api-authentication

IMPORTANT:

OKX API key:
IP restriction should be turned off
Google Cloud uses many different IP addresses

Enter api key + secret+ passphrase

Make sure you use OKX passphrase as the Third Attribute

You can enter 'debug ' after your passphrase to show debug info.
'demo' to populate some demo data

OKCoin

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links:

The OKCoin Passphrase is required as Addition Authentication Attribute (Third Attribute) in CONFIG

Third Attrib = Passphrase

Pariby

Paribu is recent exchange from Turkey opened in 2017. They don't have api yet

#Todo: Please let me know if his changes and we need to develop an integration

URL:

Webpage

API Search

Phemex

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API

CtrXL specific:

See this Phemex specific video -> https://youtu.be/t7mTA6wPQWw

You can use the following settings in the third attribute field in config.

"spot" (default) = your spot wallet from

"swap" = your swap wallet/balance from /accounts/accountPositions

"debug" = shows a popup with raw data it receives from the api

"btc" or "usd" (default is btc)

Feedback is very welcome

Poloniex

Supported: [ ✔ ] Cointrexer [ ✔ ] BotMon [ ? ] ReX

Links:

Once logged in click on the wrench icon / drop down menu in the upper right and click on API Keys

If you have not used API keys before you need to ENABLE the option:

Once inside the API Keys page click on "Create New Key"

You will be redirected to your new API page with your created API.

Because we only need read access, uncheck the boxes "trading and withdrawals"

Poloniex Key Permissions

Only 'Read Info' is required

'Unrestricted' is required to allow access from the Google cloud

Poloniex not working for you?

1.) Please try to recreate your API key on Poloniex and don;t share the keys with other apps!

2.) If this doesn't work.

Check the DEBUG Log to see what error you get.

https://sites.google.com/site/moosyresearch/projects/cryptos/doc/exchanges#TOC-Howto-DEBUG

Received some reports about 'nonce error' - you can see this wik DEBUG.

This can be resolved by recreating your API keys on Poloniex, see:

https://sites.google.com/site/moosyresearch/projects/cryptos/doc/exchanges#TOC-Error-Messages

Margin Wallets

Not supported in the current release.

BotMon specific:

Deposits and Withdrawls Not supported in the current release.

CSV : If your date is in dd/mm/yy format, set the CONFIG!D36 switch to ON

Orders: Recent orders only gives us one day of data so make sure Triggers are turned on to collect all your trades.

Probit

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Search

API key/secret:

Nothing special

Available parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange.

debug - Pops up a dialog box with the raw output received from the exchange.

SimpleFX

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links: Webpage - API Search

API key/secret:

Make sure you use the correct keys for key and secret:

Some SimpleFX users mix then up

example:

apikey = ef21e0c733c951a8b14e2d1cfacx1743

apisecret = c1d23238-072c-1129-815d-153c34d12871

The secret is longer and has - in there !!!

Available parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange. (ctrxl only)

debug - Pops up a dialog box with the raw output received from the exchange.

Upbit

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ X ] ReX

Links: Webpage - API Reference Authenticate - API Reference

Howto configure Video specially for Upbit -> https://youtu.be/JlHClLc0-rg

Upbit Indonesia or Singapore

By default the collector uses the Upbit Singapore instance.

To use the Indonesia instance, please add 'id' in lowercase as the third attribute.

Demo data

Third attribute can be 'demo' to populate some demo data. This will not use the Upbit API.

'id' (Indonesia) and 'demo' can not be combined in the third attribute field

Vinex Network

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ? ] ReX

Links: Webpage - API

API key/secret:

Nothing special

Available parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange.

debug - Pops up a dialog box with the raw output received from the exchange.

Yobit

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ? ] ReX

Links:

See quick howto Configure CtrXL video for Yobit

API key/secret:

Nothing special

Available parameters that can be used as third attribute:

demo - generates some sample data and will not connect to the exchange.

debug - Pops up a dialog box with the raw output received from the exchange.

Note:

Feedback on Yobit integration is very welcome

We collect from https://yobit.net/en/api/ GetInfo -> (funds_incl_orders)

ZeroHash

Supported: [ ✔ ] Cointrexer [ X ] BotMon [ ✔ ] ReX

Links:

API key/secret:

required passphrase as third attribute

Available parameters that can be used as third attribute:

passphrase - required as additional attribute

debug - Pops up a dialog box with the raw output received from the exchange.

Note:

Not fully tested