How to connect Crypto Excel to HitBTC.
If you want to connect Crypto Excel to HitBTC follow the simple steps in this guide.
There are 2 main functions families to connect Excel to HitBTC : public and private.
The Public function does not require any registration on the Exchange.
In practice you can access all the information you see on the CoinBase Pro 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 HitBTC. Just enter =st_watch_book(“hitbtc”,”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_authenticate function but you need to know your API credentials.
What you need to connect Crypto Excel to HitBTC.
Steps to connect Crypto Excel to CoinBase Pro.
1. Log in to your HitBTC desktop account.
2. Click on setting in the upper right corner, then API Keys and New API key
3. your API Key has been successfully created. You can copy and paste the API Key and Secret Key onto Crypto Excel connection form and click connect. Confirm you understand
Remember you will not be able to see your API secret again for security reasons.
4. API Key is ready but it does not have any access rights. Click on Order book/History/Trading balance and Place/Cancel orders.
5. Every time you add a new right to your newly created API you will be asked to verify your account using your email and Google Authenticator or SMS depending on your security settings.
Autenticate your Exchange.
Now that you have your credential you can authenticate HitBTC 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(“hitbtc”, “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.