02-15-2018, 12:07 AM
(This post was last modified: 02-16-2018, 05:11 AM by susitronix.)
Gekko will create one db (database) file for every exchange.
I had two Binance files from different computers.
The simplest way (thanks to TommieHansen) to MERGE these files is by using a tool:
SQliteStudio or phpLiteAdmin
(This tutorial is ONLY for SQliteStudio)
Download here:
https://sqlitestudio.pl/index.rvt
(click download on top of page, feel free to donate)
Only unpack the zip file and move to C/programs/ or User/Desktop. No Installation necessary
(Use Freeware 7zip)
http://download.cnet.com/7-Zip/3000-2250...45185.html
Double click >>> SQliteStudio.exe
Add the first database:
Menu >>> Database >>> [add Database]
In the popup window >>> click the small folder Icon
Choose /.../.../Gekko_Stable/History/YOUR FIRST .db FILE // (example: binance_01.db)
Add the second database:
Menu >>> Database >>> [add Database]
In the popup window >>> click the small folder Icon
Choose /YOUR SECOND .db FILE
On the left, double click your two .db files
Now you see your PAIRS:
candles_BTC/ETH
You can drag and drop [candles_BTC/ETH] like so:
>>> RightClickHold source file and move to the other Database >>>drop.
>>> choose COPY or MOVE
>>> repeat until your finished
Save the file, is not necessary since SQliteStudio establish a direct connection to the Database.
This allows us to edit/modify our .db WHILE it is in use by Gekko or other Clients.
>>> click/select on the .db file (binance_01)
>>>Menu >>> Database >>> [Disconnect from the Database]. (or click Icon)
Now your new .db is saved.
>>> No need to restart Gekko. ONLY click [Scan available data]
thanks to TommieHansen
I try askMikes Hint for Tip:
BTC 392hHafnMmHS8JWT6yDjdsX6mtEhQvTAq8
ETH 0x01d1897cE56347D936B9d8aceb422D8D2C958401
I had two Binance files from different computers.
The simplest way (thanks to TommieHansen) to MERGE these files is by using a tool:
SQliteStudio or phpLiteAdmin
(This tutorial is ONLY for SQliteStudio)
Download here:
https://sqlitestudio.pl/index.rvt
(click download on top of page, feel free to donate)
Only unpack the zip file and move to C/programs/ or User/Desktop. No Installation necessary
(Use Freeware 7zip)
http://download.cnet.com/7-Zip/3000-2250...45185.html
Double click >>> SQliteStudio.exe
Add the first database:
Menu >>> Database >>> [add Database]
In the popup window >>> click the small folder Icon
Choose /.../.../Gekko_Stable/History/YOUR FIRST .db FILE // (example: binance_01.db)
Add the second database:
Menu >>> Database >>> [add Database]
In the popup window >>> click the small folder Icon
Choose /YOUR SECOND .db FILE
On the left, double click your two .db files
Now you see your PAIRS:
candles_BTC/ETH
You can drag and drop [candles_BTC/ETH] like so:
>>> RightClickHold source file and move to the other Database >>>drop.
>>> choose COPY or MOVE
>>> repeat until your finished
Save the file, is not necessary since SQliteStudio establish a direct connection to the Database.
This allows us to edit/modify our .db WHILE it is in use by Gekko or other Clients.
>>> click/select on the .db file (binance_01)
>>>Menu >>> Database >>> [Disconnect from the Database]. (or click Icon)
Now your new .db is saved.
>>> No need to restart Gekko. ONLY click [Scan available data]
thanks to TommieHansen
I try askMikes Hint for Tip:
BTC 392hHafnMmHS8JWT6yDjdsX6mtEhQvTAq8
ETH 0x01d1897cE56347D936B9d8aceb422D8D2C958401