List of trades so far:
Code:
select opendatime as open, closedatime as close, lot, pips(ticket) as p, pl + rollover as pl from closedtrade where magic = 40 order by open
database result:
row(1):Array ( [open] => 2009-12-16 15:00:00 [close] => 2009-12-16 15:32:00 [lot] => 4.25 [p] => 4.0 [pl] => 277.56 )
row(2):Array ( [open] => 2009-12-16 15:00:00 [close] => 2009-12-16 15:32:00 [lot] => 3.69 [p] => 4.0 [pl] => 240.98 )
row(3):Array ( [open] => 2009-12-16 15:01:00 [close] => 2009-12-16 15:32:00 [lot] => 3.2 [p] => 4.0 [pl] => 208.99 )
row(4):Array ( [open] => 2009-12-16 16:21:00 [close] => 2009-12-16 16:50:00 [lot] => 4.54 [p] => 4.0 [pl] => 296.69 )
row(5):Array ( [open] => 2009-12-16 16:21:00 [close] => 2009-12-16 16:50:00 [lot] => 3.94 [p] => 4.0 [pl] => 257.48 )
row(6):Array ( [open] => 2009-12-16 16:45:00 [close] => 2009-12-16 16:50:00 [lot] => 3.35 [p] => 4.0 [pl] => 218.92 )
row(7):Array ( [open] => 2009-12-21 20:11:00 [close] => 2009-12-21 20:12:00 [lot] => 5.1 [p] => 4.0 [pl] => 327.23 )
row(8):Array ( [open] => 2009-12-21 20:11:00 [close] => 2009-12-21 20:12:00 [lot] => 4.41 [p] => 4.0 [pl] => 282.96 )
row(9):Array ( [open] => 2009-12-21 20:11:00 [close] => 2009-12-21 20:12:00 [lot] => 3.84 [p] => 4.0 [pl] => 246.39 )
row(10):Array ( [open] => 2009-12-22 21:34:00 [close] => 2009-12-23 09:29:00 [lot] => 5.58 [p] => -22.0 [pl] => -1951.91 )
row(11):Array ( [open] => 2009-12-22 21:35:00 [close] => 2009-12-23 09:29:00 [lot] => 4.84 [p] => -22.0 [pl] => -1693.04 )
row(12):Array ( [open] => 2009-12-22 21:35:00 [close] => 2009-12-23 09:29:00 [lot] => 4.19 [p] => -22.0 [pl] => -1465.79 )
row(13):Array ( [open] => 2009-12-29 20:28:00 [close] => 2009-12-29 22:22:00 [lot] => 3.46 [p] => 4.0 [pl] => 220.15 )
row(14):Array ( [open] => 2009-12-29 20:28:00 [close] => 2009-12-29 22:29:00 [lot] => 3.02 [p] => 4.0 [pl] => 192.15 )
row(15):Array ( [open] => 2009-12-29 20:28:00 [close] => 2009-12-29 22:29:00 [lot] => 2.62 [p] => 4.0 [pl] => 166.7 )
row(16):Array ( [open] => 2010-01-11 20:57:00 [close] => 2010-01-11 21:23:00 [lot] => 4.01 [p] => 4.0 [pl] => 258.36 )
row(17):Array ( [open] => 2010-01-11 20:57:00 [close] => 2010-01-11 21:23:00 [lot] => 3.48 [p] => 4.0 [pl] => 224.22 )
row(18):Array ( [open] => 2010-01-11 20:57:00 [close] => 2010-01-11 21:15:00 [lot] => 3.02 [p] => 4.0 [pl] => 194.57 )
row(19):Array ( [open] => 2010-01-12 20:18:00 [close] => 2010-01-12 21:02:00 [lot] => 4.42 [p] => 4.0 [pl] => 285.97 )
row(20):Array ( [open] => 2010-01-12 20:18:00 [close] => 2010-01-13 00:28:00 [lot] => 3.85 [p] => 4.0 [pl] => 251.42 )
row(21):Array ( [open] => 2010-01-12 20:43:00 [close] => 2010-01-12 20:50:00 [lot] => 3.24 [p] => 4.0 [pl] => 209.52 )
row(22):Array ( [open] => 2010-01-12 21:41:00 [close] => 2010-01-13 00:28:00 [lot] => 4.11 [p] => 4.0 [pl] => 268.39 )
row(23):Array ( [open] => 2010-01-12 21:41:00 [close] => 2010-01-13 00:28:00 [lot] => 3.56 [p] => 4.0 [pl] => 232.49 )
row(24):Array ( [open] => 2010-01-25 15:08:00 [close] => 2010-01-25 16:34:00 [lot] => 2.85 [p] => 4.0 [pl] => 185.22 )
row(25):Array ( [open] => 2010-01-25 15:08:00 [close] => 2010-01-25 16:34:00 [lot] => 2.5 [p] => 4.0 [pl] => 162.48 )
row(26):Array ( [open] => 2010-01-25 15:08:00 [close] => 2010-01-25 16:34:00 [lot] => 2.2 [p] => 4.0 [pl] => 142.98 )
row(27):Array ( [open] => 2010-01-27 15:22:00 [close] => 2010-01-27 15:36:00 [lot] => 3.76 [p] => 4.0 [pl] => 243.11 )
row(28):Array ( [open] => 2010-01-27 15:22:00 [close] => 2010-01-27 15:24:00 [lot] => 3.25 [p] => 4.0 [pl] => 209.96 )
row(29):Array ( [open] => 2010-01-27 15:22:00 [close] => 2010-01-27 15:24:00 [lot] => 2.85 [p] => 4.0 [pl] => 184.11 )
row(30):Array ( [open] => 2010-02-03 16:56:00 [close] => 2010-02-03 17:01:00 [lot] => 4.66 [p] => 4.0 [pl] => 296.35 )
row(31):Array ( [open] => 2010-02-03 16:56:00 [close] => 2010-02-03 17:01:00 [lot] => 4.04 [p] => 4.0 [pl] => 256.91 )
row(32):Array ( [open] => 2010-02-03 16:56:00 [close] => 2010-02-03 17:01:00 [lot] => 3.49 [p] => 4.0 [pl] => 221.94 )
row(33):Array ( [open] => 2010-02-04 15:52:00 [close] => 2010-02-04 16:08:00 [lot] => 4.91 [p] => 4.0 [pl] => 309.51 )
row(34):Array ( [open] => 2010-02-04 15:52:00 [close] => 2010-02-04 16:08:00 [lot] => 4.28 [p] => 4.0 [pl] => 269.79 )
row(35):Array ( [open] => 2010-02-04 15:52:00 [close] => 2010-02-04 16:08:00 [lot] => 3.75 [p] => 4.0 [pl] => 236.39 )
35 trades so far, 32 winners and 3 losers.
Pips so far:
Code:
select total(pips(ticket)) as p from closedtrade where magic = 40
database result:
row(1):Array ( [p] => 62.0 )
PL so far:
Code:
select total(pl + rollover) as tot from closedtrade where magic = 40
database result:
row(1):Array ( [tot] => 2469.15 )
After running The Channel Scalper for 7 complete weeks on a demo account, it has proven itself to be profitable. If this EA makes it to March 16 while still being profitable, I will be adding it to my live account (at a reduced risk).
Rick