Support Board

Date/Time: Mon, 25 Nov 2024 21:49:50 +0000

Post From: Daily Loss Limit in Spreadsheet Auto Trading

[2013-06-18 01:53:33] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
I don't think J51-J50 will necessarily produce a consecutive losing trades value. 1) Try this for counting consecutive losing trades: -Add the Trading: Losing Trades study -Add the Trading: Winning Trades study -Put this in cell O3: =IF(AA3>AA4,TRUE,IF(OR(AC3>AC4,INT(A3)>INT(A4)),FALSE,O4)) This will repeat TRUE until there is a winning trade, or until the date changes -Put this in cell P3: =IF(AND(O3,O4=FALSE),1,IF(AND(O3,AA3>AA4),P4+1,IF(AND(O3,O4),P4,0))) This will increment the consecutive losing trade count, and reset to zero if there is a winning trade, or the date changes. The formulas assume the Trading: Losing Trades study is in column AA and the Trading: Winning Trades study is in column AC; edit as needed. 2) To disable autotrading at a daily max loss value, I would use J45 instead of J11.