This project helps me manage my cryptocurrency transactions a little more efficiently.
It's really an unpretentious tool but if it can help others....
After entering my history since 2017 (big job !), I can now enter my transactions as they happen which greatly simplifies monitoring.
In addition to this project, my other crypto-updater project will be necessary to obtain the latest crypto prices using the coingecko APIs. These are the only internet access.
In addition, no data such as the address of your wallets is entered. On the other hand, you have the possibility when creating a transaction to provide the transaction identifier and thus have the possibility of accessing it via the appropriate blockchain.
Associated with the crypto-updater project, crypto-dashboard allows:
- manage the platforms/wallets to use,
- enter transactions as they occur, view them, delete or modify them,
- to have a multi-platform/portfolio,
- to see the evolution of cryptos (at 5mn, 1h, 1 day et 1 week),
- define alerts,
- to monitor cryptos that you have not yet purchased.
- to access token charts and possibly explorers.
I started to look at automatic feeding via the APIs of the main platforms but it's not won:
- Coinbase is the most "open" and all transactions can be found there but no swagger. Crypto receiving transactions are commonly found with the 'send' type. This doesn't sound very serious. Coinbase indicates that they have reviewed all of this but in reality we are not clear.* Binance provides a set of APIs as considerable as Coinbase except that the public API for trades (swap in particular) is not made available
- Bitpanda after various "tinkering" turns out to be usable
- Coinhouse / eToro and the whole "clique" of its kind hide behind their public image and only offer paltry APIs (when they exist). They would still have to start by providing the hash of the transactions! To use it, all you need is a machine with docker installed.
But as a young retiree after 46 years in computer sciences, including 20 years in IT, I have to keep busy :)
As a user of the Binance platform, among others, I have implemented the possibility of entering almost automatically all trades made with the *USDT and *BNB pairs.
The project use
- API coingecko
- API geckoterminal
- API binance
- Graph library of TradingView
To install it, go to https://www.docker.com/products/docker-desktop/ and choose the version for macOS. Click on the .dmg file to install Docker.
Refer to the official guide. Here for Ubuntu, run the following commands in a shell:
sudo apt-get update
sudo apt-get install ca-certificates curl
sudo install -m 0755 -d /etc/apt/keyrings
sudo curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc
sudo chmod a+r /etc/apt/keyrings/docker.asc
echo \
"deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu \
$(. /etc/os-release && echo "$VERSION_CODENAME") stable" | \
sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
sudo apt-get update
sudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin docker-compose
This is the simplest installation.
The documentation is in the overview of docker image labarrem/crypto-dashboard-ui
The first thing to do is to choose the base directory for the installation. Let's call it CRYPTO_HOME.
In a terminal, enter the following commands:
CRYPTO_HOME=<directory that was chosen>
mkdir -p $CRYPTO_HOME/dashboard
mkdir -p $CRYPTO_HOME/dashboard/icons
mkdir -p $CRYPTO_HOME/dashboard/mongodb
mkdir -p $CRYPTO_HOME/dashboard/config
In <CRYPTO_HOME>/dashboard/config create a file named default.json with the following content (content visible in this project in demo/default.json):
{
"language": "fr",
"timezone": "Europe/Paris",
"fiat_currency" : "EUR",
"fiat_symbol": "€",
"decimal_separator": ",",
"coingecko_currency" : "eur",
"mongodb_uri" : "mongodb://mongo:27017/?serverSelectionTimeoutMS=3000&directConnection=true",
"mongodb_database": "crypto",
"server_port" : 8080,
"refresh_in_seconds" : 120,
"coingecko_coins_url": "https://api.coingecko.com/api/v3/coins/list",
"coingecko_quotation_url": "https://api.coingecko.com/api/v3/simple/price",
"coingecko_chart_api": "https://api.coingecko.com/api/v3/coins/TOKEN/market_chart?vs_currency=CURRENCY&days=DAYS",
"geckoterminal_networks_url": "https://api.geckoterminal.com/api/v2/networks?page=",
"geckoterminal_quotation_url": "https://api.geckoterminal.com/api/v2/simple/networks/NETWORK/token_price/",
"notification_ntfy_url": "https://ntfy.sh",
"notification_ntfy_topic": ".......",
"chain_explorers": [
{
"name": "Binance BSC",
"url": "https://bscscan.com/tx/"
},
{
"name": "Bitcoin",
"url": "https://blockstream.info/tx/"
},
{
"name": "Cosmos",
"url": "https://www.mintscan.io/cosmos/tx/"
},
{
"name": "Ethereum",
"url": "https://etherscan.io/tx/"
},
{
"name": "Optimism",
"url": "https://optimistic.etherscan.io/tx/"
},
{
"name": "Polygon",
"url": "https://polygonscan.com/tx/"
},
{
"name": "Solana",
"url": "https://solscan.io/tx/"
},
{
"name": "XRP",
"url": "https://bithomp.com/explorer/"
}
],
"platforms_api": {
"binance": {
"api_key": "<BINANCE_API-KEY>",
"secret_key": "<BINANCE_SECRET-KEY>",
"withdraw_list_url": "https://api.binance.com/sapi/v1/capital/withdraw/history",
"payments_list_url": "https://api.binance.com/sapi/v1/fiat/payments",
"dribblet_url": "https://api.binance.com/sapi/v1/asset/dribblet",
"convert_url": "https://api.binance.com/sapi/v1/convert/tradeFlow",
"trades_histo_url": "https://api.binance.com/api/v3/myTrades"
},
"coinbase": {
"api_key": "<COINBASE_API_KEY>",
"secret_key": "<COINBASE_PRIVATE_KEY",
"host": "api.coinbase.com",
"accounts_path": "/v2/accounts"
},
"bitpanda": {
"api_key": "<BITPANDA_API_KEY>",
"base_url": "https://api.bitpanda.com/v1"
}
}
}
Refer to the description of the values in the Manual installation chapter below for dashboard and updater.
Here the configurations are common.
You create (or copy from this Github project) the docker-compose-images.yml file:
services:
dashboard:
image: labarrem/crypto-dashboard-ui:stable
ports:
- "8080:8080"
depends_on:
- mongo
volumes:
- <CRYPTO_HOME>/dashboard/icons:/home/node/app/public/images/icons
- <CRYPTO_HOME>/dashboard/config:/home/node/app/config
restart: unless-stopped
updater:
image: labarrem/crypto-dashboard-data:stable
depends_on:
- mongo
volumes:
- <CRYPTO_HOME>/dashboard/config:/home/node/app/config
restart: unless-stopped
mongo:
image: mongo:4.4
volumes:
- <CRYPTO_HOME>/dashboard/mongodb:/data/db
ports:
- "27017:27017"
restart: unless-stopped
by replacing all the strings '<CRYPTO_HOME>' with the chosen directory (value of CRYPTO_HOME) above.
Note: the dashboard service listen port depends on the information coded in this docker-compose-images.yml file but also in the default.json configuration file. The port indicated in docker-compose-images.yml is 8080:8080. This indicates that you will be able to connect on the server via port 8080 (first 8080 before ':') at http://localhost:8080. The second 8080 (after the ':') must match the port specified in the default.json file. You can only change the port number before the ':' character.
To launch, submit the following command and access the dashboard by http://localhost:8080
docker compose -f ./docker-compose-images.yml up -d
The docker and docker-compose commands should now be available.
Perform the following commands in the shell (or the Utilities/Terminal app for MacOS) to retrieve both crypto-dashboard and crypto-updater projects from Github repositories. Create a directory to receive the archives. For example /Users/me/crypto for MacOS and /home/me/crypto for Linux. In the following we refer to this directory by <CRYPTO_HOME>.
mkdir <CRYPTO_HOME>
cd <CRYPTO_HOME>
git clone https://github.com/mlabarre/crypto-dashboard.git
git clone https://github.com/mlabarre/crypto-updater.git
You should now see two directories crypto-dashboard and crypto-updater It is now necessary to modify two config files:
Edit the <CRYPTO_HOME>/crypto-dashboard/config/default.json file and modify it according to your environment
{
"language": "fr",
"timezone": "Europe/Paris",
"fiat_currency" : "EUR",
"fiat_symbol": "€",
"decimal_separator": ",",
"mongodb_uri" : "mongodb://mongo:27017/?serverSelectionTimeoutMS=3000&directConnection=true",
"mongodb_database": "crypto",
"server_port" : 8080,
"refresh_in_seconds" : 300,
"coingecko_chart_api": "https://api.coingecko.com/api/v3/coins/TOKEN/market_chart?vs_currency=CURRENCY&days=DAYS",
"geckoterminal_networks_url": "https://api.geckoterminal.com/api/v2/networks?page=",
"chain_explorers": [
{
"name": "Binance BSC",
"url": "https://bscscan.com/tx/"
},
{
"name": "Bitcoin",
"url": "https://blockstream.info/tx/"
},
{
"name": "Cosmos",
"url": "https://www.mintscan.io/cosmos/tx/"
},
{
"name": "Ethereum",
"url": "https://etherscan.io/tx/"
},
{
"name": "Optimism",
"url": "https://optimistic.etherscan.io/tx/"
},
{
"name": "Polygon",
"url": "https://polygonscan.com/tx/"
},
{
"name": "Solana",
"url": "https://solscan.io/tx/"
},
{
"name": "XRP",
"url": "https://bithomp.com/explorer/"
}
],
"platforms_api": {
"binance": {
"api_key": "<BINANCE_API-KEY>",
"secret_key": "<BINANCE_SECRET-KEY>",
"withdraw_list_url": "https://api.binance.com/sapi/v1/capital/withdraw/history",
"payments_list_url": "https://api.binance.com/sapi/v1/fiat/payments",
"dribblet_url": "https://api.binance.com/sapi/v1/asset/dribblet",
"convert_url": "https://api.binance.com/sapi/v1/convert/tradeFlow",
"trades_histo_url": "https://api.binance.com/api/v3/myTrades"
},
"coinbase": {
"api_key": "<COINBASE_API_KEY>",
"secret_key": "<COINBASE_PRIVATE_KEY",
"host": "api.coinbase.com",
"accounts_path": "/v2/accounts"
},
"bitpanda": {
"api_key": "<BITPANDA_API_KEY>",
"base_url": "https://api.bitpanda.com/v1"
}
}
}
| variable | Description |
|---|---|
| language | Language used: fr (French) or en (English) only. |
| timezone | Time zone (ie Europe/Paris). |
| fiat_currency | This is the Fiat currency (here EUR) with which you buy your cryptos. This can be EUR, USD, GBP, etc. |
| fiat_symbol | Currency of symbol above. This can be €, $, £, etc... |
| decimal_separator | Decimal separator character |
| mongodb_uri | This is the connection URL to the mongodb server. Don't change anything. |
| mongodb_database | Name you want to give to the mongo database. Here it is crypto. |
| server_port | Node server listening port. Here 8080. |
| refresh_in_seconds | The portfolio and dashboard views are displayed with a refresh. Here the latter will be every 5 minutes |
| coingecko_chart_api | API for graphs. Do not modify. |
| geckoterminal_networks_url | URL to get networks from geckoterminal. Don't change anything. |
| chain_explorers | URLs of major blockchain explorers. You can add more. |
| platforms_api | For experimentation. Automatic retrieving of binance trades requires the binance block with correct values |
Edit the <CRYPTO_HOME>/crypto-updater/config/default.json file and modify it according to your environment
{
"language": "fr",
"fiat_currency" : "EUR",
"coingecko_currency" : "eur",
"mongodb_uri" : "mongodb://mongo:27017/?serverSelectionTimeoutMS=3000&directConnection=true",
"mongodb_database": "crypto",
"coingecko_coins_uri": "https://api.coingecko.com/api/v3/coins/list",
"coingecko_quotation_uri": "https://api.coingecko.com/api/v3/simple/price",
"geckoterminal_quotation_url": "https://api.geckoterminal.com/api/v2/simple/networks/NETWORK/token_price/",
"notification_ntfy_url": "https://ntfy.sh",
"notification_ntfy_topic": "KdiLd90OOODO"
}
| variable | Description |
|---|---|
| language | Language used: fr (French) or en (English) only. |
| fiat_currency | This is the Fiat currency (here EUR) with which you buy your cryptos. This can be EUR, USD, GBP, etc. |
| coingecko_currency | Currency relative to the previous variable. It must be recognized by coingecko: eur, usd, gbp, etc. |
| mongodb_uri | This is the connection URL to the mongodb server. Don't change anything. |
| mongodb_database | Name you gave in the crypto-dashboard default.json file above. |
| coingecko_coins_uri | API to get the list of all cryptos (called once a day) |
| coingecko_quotation_uri | API to obtain the quotations of the cryptos used (called once every 5 minutes) |
| geckoterminal_quotation_url | URL to access crypto prices from geckoterminal. Don't change anything. |
| notification_ntfy_url | ntfy.sh URL for notifications. Don't change anything. |
| notification_ntfy_topic | Key/topic that you declared in the NTFY application (see Alertes section below). |
You need to specify where wallets icons reside.
You must create the local directory where icons will be stored.
mkdir <CRYPTO_HOME>/dashboard/icons
You then need to edit the docker-compose.yml file. It should look like this:
version: "3"
services:
dashboard:
image: crypto-dashboard
build: .
ports:
- "8080:8080"
depends_on:
- mongo
volumes:
- /datas/dashboard/icons:/home/node/app/public/images/icons
updater:
image: crypto-updater
build: ../crypto-updater
depends_on:
- mongo
mongo:
image: mongo:4.4
volumes:
- /datas/dashboard/mongodb:/data/db
ports:
- "27017:27017"
You must replace:
volumes:
- /datas/dashboard/icons:/home/node/app/public/images/icons
by
volumes:
- <CRYPTO_HOME>/dashboard/icons:/home/node/app/public/images/icons
always replacing <CRYPTO_HOME> by the chosen path, of course.
Note: the dashboard service listen port depends on the information coded in this docker-compose.yml file but also in the default.json configuration file. The port indicated in docker-compose.yml is 8080:8080. This indicates that you will be able to connect on the server via port 8080 (first 8080 before ':') at http://localhost:8080. The second 8080 (after the ':') must match the port specified in the default.json file. You can only change the port number before the ':' character.
To initialize the folder with the icons supplied in project crypto-dashboard enter the following command :
cp <CRYPTO_HOME>/crypto-dashboard/public/images/icons/* <CRYPTO_HOME>/dashboard/icons
replacing <CRYPTO_HOME> by the chosen path.
You now need to specify where the MongoDB database named in the previous two files should be located.
For example, we could design <CRYPTO_HOME>/mongodb to put the database in the directory you created above.
mkdir <CRYPTO_HOME>/dashboard/mongodb
You then need to edit the docker-compose.yml file. It should look like this:
version: "3"
services:
dashboard:
image: crypto-dashboard
build: .
ports:
- "8080:8080"
depends_on:
- mongo
volumes:
- /datas/dashboard/icons:/home/node/app/public/images/icons
updater:
image: crypto-updater
build: ../crypto-updater
depends_on:
- mongo
mongo:
image: mongo
volumes:
- /datas/dashboard/mongodb:/data/db
ports:
- "27017:27017"
You must replace:
volumes:
- /datas/dashboard/mongodb:/data/db
by
volumes:
- <CRYPTO_HOME>/dashboard/mongodb:/data/db
always replacing <CRYPTO_HOME> by the chosen path.
Docker will build the images for crypto-dashboard and crypto-updater. It will also download the mongoDB image (I put version 4.4 here because version 5 can cause problems with some processors).
cd <CRYPTO_HOME>/crypto-dashboard
sudo docker compose up -d
With MACOS, if the docker compose command fails, try without sudo.
It is possible to define alerts on the Evolution and survey views.
Notifications are sent to any device where the application open-source ntfy is installed (Android, IOS, desktop). The necessary settings were discussed above, in the default.json configuration file of crypto-updater.
If your installed host is myhost, the dashboard is accessible from the URL : http://myhost:8080
Start by adding the missing wallets if necessary using the wallets tab. Then, using the Cryptos tab, select the cryptos you have. Then all you have to do is enter your past transactions.
If you encounter any problems or need some questions you can send me a quick email to michel.labarre@gmail.com. I will do my best to answer you.
The screens below in clear mode. A dark mode is selectable.
