How to connect Crypto Excel to CoinBase Pro.
If you want to connect Crypto Excel to CoinBase Pro follow the simple steps in this guide.
There are 2 main functions families to connect Excel to CoinBase Pro: 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 CoinBase Pro. Just enter =st_watch_book(“coinbase”,”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.
What you need to connect Crypto Excel to CoinBase Pro.
- CoinBase Pro account and credentials.
- Crypto Excel Add in.
- Email ( the same you use for CoinBase-Pro) account and credentials.
- Your Mobile phone for 2FA authentication.
- 5 minutes.
Steps to connect Crypto Excel to CoinBase Pro.
1. Log in to your CoinBase-Pro desktop account.
2. Hover over your Avatar in the upper right corner and in the drop down menu click on API .
3. CoinBase Pro allows you to have more than one portfolio. Select the relevant portfolio. 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)
CoinBase Pro uses Passphrase as an extra security measure. Save the Passphrase, You will need it later to use st_authenticate function. You will never be able to retrieve it again.
4. Verify your account using your email and Google Authenticator or SMS depending on your security settings.
5. Copy and past API Key. API secret and Passphrase onto Crypto Excel connection form and click connect.
Remember you will not be able to see your API secret again for security reasons
Autenticate your Exchange.
Now that you have your credential you can authenticate CoinBase 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(“CoinBase”, “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.