How to connect CryptoExcel to Huobi.
If you want to connect Huobi with Excel using CryptoExcel Add-in, this guide will walk you through everything you need. In just a few minutes, you’ll be able to stream real-time data or manage your portfolio and orders directly from Excel.
Huobi is an well known exchange amongst traders for a wide range of supported cryptocurrencies, spot and derivatives trading options, a P2P marketplace for fiat-crypto exchange, staking and yield generation
CryptoExcel is a Python-based Excel add-in that allows you to pull real-time crypto data from 100+ exchanges, including Kraken, directly into Excel.
Public vs Private Functions. Huobi Integration
When connecting Crypto Excel to Huobi, you can use two main families of functions:
1. Public Functions (No Account Needed)
Public functions do not require any registration or authentication and you can use them as soon as the Add-in is installed.
You can access in real time:
Order books
Live trades
Historical trades
Candlestick (OHLCV) data
Funding rates and more
Example: to stream the BTC/USDT book from Huobi into Excel, simply enter:
=ST_WATCH_BOOK("huobi","BTC/USDT")2. Private Functions (Authentication Required)
Private functions allow you to perform authenticated operations such as:
Viewing account balances
Tracking open positions
Sending and cancelling orders
Coin transfers
To use private functions, you’ll need to authenticate using your Huobi APIs credentials. This requires creating an API key, secret, directly from your Huobi account.
=ST_INSTANTIATE("huobi","nickname","api_key","api_secret")
Keep reading to discover how to get Huobi API key and API secret
What you need to connect CryptoExcel to Huobi
- Huobi account and credentials.
- Crypto Excel Add in.
- Your mobile phone for 2FA (Google Authenticator or SMS)
- 5 minutes
Steps to connect Crypto Excel to Huobi
If you want to connect Crypto Excel to Huobi follow the simple steps in this guide.
There are 2 main functions families to connect Excel to Huobi : 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 Huobi 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 Huobi . Just enter =st_watch_book(“huobi“,”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 Huobi.
Steps to connect Crypto Excel to Huobi.
Step 1. Log in to Huobi
- Log in to your Huobi account as you normally do
Step 2. Open API Management
- Hover over your Name in the upper right corner and in the drop-down menu and click on security and then API Management.
Step 3. Configure API Permissions
Turn on the required permission (Red arrows) and write the API name ( Crypto Excel in the example but you can use any name you like) and finally click create.
Verify your account using your email and Google Authenticator or SMS depending on your security settings.
Step 5. Copy API Key & Secret
Copy an past API Key and API secret in a safe place.
Remember you will not be able to see your API secret again for security reason.
Autenticate Huobi in Excel
Now that you have your credential you can authenticate Huobi and start using Crypto Excel private function.
As an example, if you want to authenticate your Huobi 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(“Huobi”, “joe”, “abcd”, “123”)
if the response is Joe is authenticated you can start using the private function.
Try =st_balance(“joe”).
Next Steps
By following these steps, you’ve successfully connected Excel to Huobi. Now You can:
Monitor live order books
Track balances across multiple exchanges
Automate trades directly from Excel
Build a complete crypto portfolio tracker
Explore our Academy and Docs to learn more about private functions and advanced automation.
Read our related tutorials: