How to connect Excel to your crypto Exchange.
In this article you will learn how to connect Excel to your crypto Exchange using Crypto Excel and your private API credentials.
Functions to connect Excel to your crypto Exchange.
There are 2 main functions families to connect Excel to your Crypto Exchange: 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 website in real time without logging in. These includes
- books,
- trades,
- trades
- history,
- candles history,
- founding rates.
You can use all public functions immediately and without any additional requirements. Just enter =st_watch_book(“binance”,”BTC/USD”) 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.
What is an API?
An application programming interface (API) is a computing interface that defines interactions between multiple software intermediaries ( Wikipedia ). It is a piece of code that enables data transmission between one software and another. In our case, between the Exchanges where you have your accounts and Excel.
Your API credentials consist of API Key, API Secret and, for some Exchanges, a secret password.
You can think of your API key as your Username, and your API Secret, also referred to as API Private Key, or Private Key or Secret Key, as your password.
When you use the st_instantiate function Crypto Excel transmits your credential to your Exchange for the authentication process.
How to get your credential from your crypto exchange.
Each Exchange has a specific procedure for creating APIs. Here you can find a general overview that will work in most scenarios. In case you need more help, please read the “how to connect Crypto Excel to” guide related to the Exchange you want to connect to.
Crypto Excel supports more then 100 crypto Exchanges therefore it would be impossible to write a guide for all of them. If you do not find a guide in our Academy for your specific Exchange google it or browse your exchange website.
- Sign in to your Exchange account.
- Click on your profile in the top right corner. It might be your username or the icon with a face.
- Click on Settings or, if you have it in your profile menu, API or API setting, or API access.
- Click on API or API setting or API access. Skip this point if you got there directly from the profile menu.
- Look for the “Add new API” or “new API key” or “generate new key” button. Some Exchanges will ask you to enter a name for your new API at this stage. You can enter ShieldTrade but it’s not compulsory because every name will work. It’s just a reminder for you.
- Configure the API setting.
6.1 Enter the API name if you have not done it before
6.2 Give the view balance/read and trade permission.
During the above process the Exchange will ask you to verify your identity, so keep your mobile and your email handy.
Google Authenticator is generally used for 2FA (two-factor authentication). Be ready to download and use it.
If you already have an API key you must set a new one to connect Crytpto Excel to your Exchange.
Api Permission
The API you are creating usually have 3 permissions.
Read/View balances.
This is required for Crypto Excel to use the st_balance function and import your crypto balance into Excel.
Trades.
If you want to use Crypto Excel automated trading functionality you have to select this option.
Transfer Money ( Not implemented ) .
Crypto Excel seamless integrate Excel with your crypto Exchange and it could also perform money transfer.
We decided not to implement this type of functions. If you you would like to have it contact us.
You do not need to give any money transfer permission to your API.
Some Exchanges like Kraken, offer advanced API key settings in which you can configure various rights.
As a general rule, we want all the permissions available except deposit and withdraw permissions.
Finish the API setting by clicking on Generate key or Save or Done. Some Exchanges will ask you to verify your identity by sending you an email or a code.
Some Exchanges will ask you to set a Passphrase as an extra layer of security.
After your API key, API secret and Passphrase are shown copy and past them in a secure location. For security reason you will not be able to recover them from the website.
Autenticate your Exchange.
Now that you have your credential you can authenticate your Exchange and start using Crypto Excel private function.
As an example, if you want to authenticate your account on okx and give it the nickname of Joe, and your API key is key and your API secret is 12345; you can enter in a cell
= st_Instantiate(“okx”, “joe”, “abcd”, “123”)
if the response is Joe is authenticated you can start using the private function.
Try st_balance(“joe”).
Conclusion.
In this article we discussed how to connect Excel to your crypto Exchange using Crypto Excel and your private API credentials.
This is a general guide which will work in most cases scenario. In our academy you can find some article about how to connect Excel to a specific Exchange. We suggest you to use the exchange website in case you need more information.
Crypto Excel is a desktop application. your credential will remain on your pc. No middle man, Max security.