Help charting my trades
#1
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,5886


The 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.
  Reply
#2
I would love to see it look something like the backtest charts do, like [Image: 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.
  Reply
#3
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.
  Reply


Forum Jump:


Users browsing this thread: