+- Gekko Forum (https://forum.gekko.wizb.it)
+-- Forum: Trading discussion (https://forum.gekko.wizb.it/forum-1.html)
+--- Forum: General Discussion (https://forum.gekko.wizb.it/forum-17.html)
+--- Thread: Help charting my trades (/thread-57917.html)
Help charting my trades - Henry151 - 05-13-2019
Hey there,
I've got this record of trades; it's a csv file,
date,time,buy_or_sell,btc_amount,price_in_usd
Code:
2019-02-16,23:21:19,BUY,0.25866,3618.07
2019-02-21,19:31:06,SELL,0.258402,3924.96
2019-02-22,07:21:02,BUY,0.257734,3930.67
2019-02-24,20:51:11,SELL,0.257476,3795.87
2019-02-26,05:12:16,BUY,0.256694,3804.09
2019-02-26,08:02:20,SELL,0.253688,3809.16
2019-02-27,14:11:20,BUY,0.256693,3802.46
2019-02-27,23:01:12,SELL,0.256436,3793.08
2019-02-28,16:41:16,BUY,0.254123,3823.35
2019-03-02,08:53:15,SELL,0.253869,3803.5
2019-03-04,04:21:12,BUY,0.254982,3782.31
2019-03-04,07:11:16,SELL,0.254727,3746.68
2019-03-04,10:41:00,BUY,0.258865,3683.5
2019-03-04,11:21:22,SELL,0.258606,3708.57
2019-03-06,00:42:14,BUY,0.2501,3831.03
2019-03-11,13:31:17,SELL,0.24985,3865.98
2019-03-12,01:11:13,BUY,0.252005,3829.98
2019-03-12,08:01:03,SELL,0.251753,3864.9
2019-03-13,10:21:19,BUY,0.252489,3848.44
2019-03-13,11:45:05,SELL,0.083982,3857.3
2019-03-15,06:51:18,BUY,0.250519,3881.62
2019-03-18,15:12:06,SELL,0.250268,3979.96
2019-03-20,01:11:11,BUY,0.249339,3990.92
2019-03-21,18:52:08,SELL,0.24909,3969.08
2019-03-24,18:31:06,BUY,0.247799,3986.12
2019-03-24,20:41:09,SELL,0.247551,3979.54
2019-03-25,12:21:11,BUY,0.247415,3977.05
2019-03-25,13:31:13,SELL,0.247168,3984.86
2019-03-25,18:41:19,BUY,0.250138,3933.78
2019-03-25,22:21:05,SELL,0.249888,3920
2019-03-26,07:31:16,BUY,0.250064,3914.24
2019-03-26,08:01:17,SELL,0.249814,3928.96
2019-03-28,00:22:12,BUY,0.243673,4023.9
2019-04-02,04:41:11,SELL,0.243429,4420.91
2019-04-03,04:52:24,BUY,0.219459,4828.78
2019-04-11,13:11:06,SELL,0.222397,5031.45
2019-04-12,01:32:04,BUY,0.22625,4941.63
2019-04-12,02:41:05,SELL,0.226024,4965
2019-04-13,11:02:08,BUY,0.223344,5018.41
2019-04-13,12:11:09,SELL,0.223121,5030.38
2019-04-14,04:01:10,BUY,0.222771,5034.16
2019-04-14,07:11:14,SELL,0.222548,5019.5
2019-04-15,07:51:07,BUY,0.217372,5134.24
2019-04-15,22:51:07,SELL,0.217154,5036.45
2019-04-17,12:21:17,BUY,0.21121,5171.43
2019-04-21,13:12:05,SELL,0.210999,5217.14
2019-04-23,16:21:12,BUY,0.199245,5520.86
2019-04-25,00:11:13,SELL,0.199046,5424.4
2019-04-25,22:01:02,BUY,0.200879,5369.53
2019-04-26,00:51:06,SELL,0.200678,5253.93
2019-04-26,16:11:07,BUY,0.201232,5232.79
2019-04-26,17:32:10,SELL,0.201031,5279.6
2019-04-28,19:01:16,BUY,0.199769,5308.34
2019-04-29,14:01:21,SELL,0.199569,5252.95
2019-05-01,08:32:20,BUY,0.196386,5333.32
2019-05-06,04:22:17,SELL,0.19619,5698
2019-05-07,14:21:03,BUY,0.189746,5886The trading happened on binance, with the btc-USDT pair.
I am struggling getting it into a nice visual representation, to help me understand how my bot has been doing, what circumstances it's doing the right things in and where it needs adjustment, etc.
Can someone help me get this data superimposed over a chart of the BTC price in a meaningful way? I would really, really appreciate it.
Thanks so much for any time spent helping me. And if anybody wants the parameters that I used for the gekko instance that made these trades, if you will help me get this data charted I will be totally happy to share my settings with you.
RE: Help charting my trades - Henry151 - 05-13-2019
I would love to see it look something like the backtest charts do, like
![[Image: X9KAmI8.png]](http://i.imgur.com/X9KAmI8.png)
... I feel like this should be super easy but it is really stumping me so if anyone can help me out with it i will be super grateful.
RE: Help charting my trades - Henry151 - 05-14-2019
I also just discovered this https://github.com/RJPGriffin/google-forms-gekko-plugin and would love to see if there's any way to retroactively put my trade data into that type of spreadsheet as well. Any help? Much appreciated.