Crypto Excel » Explore Crypto Excel » How to connect Crypto Excel to BitMEX.
If you want to connect Crypto Excel to BitMEX follow the simple steps in this guide.
There are 2 main functions families to connect Excel to Bitmex: public and private.
The Public functions does not require any registration on the Exchange.
In practice you can access all the information you see on the Bitmex website in real time without logging in. These includes books, trades, trades history, candles history, founding rates ecc.
You can use all public functions immediately and without any need to open an account on Bitmex. Just enter =st_watch_book(“bitmex”,”BTC/USDT”) in a cell and Crypto Excel will do the rest.
The Private functions enables typical operations of the authenticated user: sending orders, balances, position, coin transfers ecc.
If you want to use the private functions you need to authenticate first. This can be easily done with the st_instantiate function but you need to know your API credentials.
1. Log in to your BitMEX desktop account.
2. click on API.
3.Click on API Key Management.
4. Write the API name ( Crypto Excel in the example but you can use any name you like). and select order in the Key Permission field, then click Create API Key.
5. Copy an past API Key and API secretin a safe place.
Remember you will not be able to see your API secret again for security reason.
Now that you have your credential you can authenticate BitMEX and start using Crypto Excel private function.
As an example, if you want to authenticate your account and give it the nickname of Joe, and your API key is abcd and your API secret is 12345; you can enter in a cell
= st_instantiate(“bitmex”, “joe”, “abcd”, “123”)
if the response is Joe is authenticated you can start using the private function.
Try st_balance(“joe”).
Read our academy for more private functions.