Crypto Binance data import in Excel and generate ROI of selected coins
Budget: €30 – €250 EUR
I need a Excel master that has knowledge of history- and live data input from Binance.
The objective is to make an Excel file which shows me the coin which has the highest ROI in a certain timeperiod. During that timeperiod the Excel file show trades to be made to follow the highest ROI coin. Let's say in a timeframe from 01-01-2020 till 31-12-2020 the Excel file can show me the coin which has the highest ROI during that timeperiod in USDT value based on daily closing prices extracted from Binance. The coins to be possible selected are ALL USDT paired coins on Binance.
The Excel file show me the trades which I had to make if I would like to follow the coin with the highest ROI from the start date. In other words: say that COIN1 has the highest ROI for the first 4 weeks and will taken over by COIN2 for 16 weeks followed by COIN3 for 2 weeks followed by COIN1 for the remaining of that period. Than the Excel file show me the trades started with COIN1->COIN2->COIN3->COIN1 followed by the endvalue in USDT. ROI is always from from the start beginning date. Like in the example above 01-01-2020 and the end value will show on 31-12-2020 in USDT value (coin is still in COIN1 because COIN1 has the highest ROI from the beginning point) I would like to backtest this in Excel. The input cells for the user only need to be which timeperiod (start and end date) and which coins (varies to some coins and max ALL USDT pairs on Binance) and USDT start balance value. All input cell are marked in blue in the example excel file attached.
Backtest results will show the trades that are made within timeperiod and dates. ROI TRACKER cumulative and endvalue in USDT.
It is very important that the excel file is connected or hooked onto Binance for future reference, so even in future I can always use this file without any import of any data. May be there is a Binance data Google sheet, to be honest I do not know.
I uploaded and Excel file with only 3 coins and 23 days of data, just to show you the basics of the idea.
Feel feel free to use improvements if you would like to. This can be a simple one sheet excel file which is connected to Binance.
Every time I will invest in Crypto I can follow this sheet and react (trade) accordingly. Also it will be used for backtest purposes.
kind regards
The objective is to make an Excel file which shows me the coin which has the highest ROI in a certain timeperiod. During that timeperiod the Excel file show trades to be made to follow the highest ROI coin. Let's say in a timeframe from 01-01-2020 till 31-12-2020 the Excel file can show me the coin which has the highest ROI during that timeperiod in USDT value based on daily closing prices extracted from Binance. The coins to be possible selected are ALL USDT paired coins on Binance.
The Excel file show me the trades which I had to make if I would like to follow the coin with the highest ROI from the start date. In other words: say that COIN1 has the highest ROI for the first 4 weeks and will taken over by COIN2 for 16 weeks followed by COIN3 for 2 weeks followed by COIN1 for the remaining of that period. Than the Excel file show me the trades started with COIN1->COIN2->COIN3->COIN1 followed by the endvalue in USDT. ROI is always from from the start beginning date. Like in the example above 01-01-2020 and the end value will show on 31-12-2020 in USDT value (coin is still in COIN1 because COIN1 has the highest ROI from the beginning point) I would like to backtest this in Excel. The input cells for the user only need to be which timeperiod (start and end date) and which coins (varies to some coins and max ALL USDT pairs on Binance) and USDT start balance value. All input cell are marked in blue in the example excel file attached.
Backtest results will show the trades that are made within timeperiod and dates. ROI TRACKER cumulative and endvalue in USDT.
It is very important that the excel file is connected or hooked onto Binance for future reference, so even in future I can always use this file without any import of any data. May be there is a Binance data Google sheet, to be honest I do not know.
I uploaded and Excel file with only 3 coins and 23 days of data, just to show you the basics of the idea.
Feel feel free to use improvements if you would like to. This can be a simple one sheet excel file which is connected to Binance.
Every time I will invest in Crypto I can follow this sheet and react (trade) accordingly. Also it will be used for backtest purposes.
kind regards