Support Board

Date/Time: Fri, 19 Apr 2024 12:50:19 +0000

Post From: Daily Loss Limit in Spreadsheet Auto Trading

[2013-06-14 22:31:32] Link To Thread - Link To Post [Go To First Post]
vegasfoster - Posts: 444
J28 controls whether autotrading is enabled, J29 will flatten and cancel all open orders, J10 is your Open PL and J11 is your Closed PL. If the total of cells J10 and J11 are greater than your daily stop loss, then you want both J28 and J29 to equal true. The issue is when you flatten and cancel, if price moves in your favor before the orders fill, then you could be slightly under your daily loss again and autotrading will resume even though you don't want it to. So you may want to create positive slippage in your Open Profit/Loss in J10 so that when the final value transfers to the Closed Profit/Loss in J11, then J28 and J29 will stay false. Assuming you have a $500 daily stop and you estimate max $30 of positive slippage, then you would enter: In J28, =(J11 + if(J10<0, J10+30, 0)) < -500 In J29, =J28 Problem is your actual loss could be greater by the amount of the estimated positive slippage. Maybe someone else knows a better way. I can't think how to do 2 or 3 losing trades in a row using the spreadsheet. Again, maybe someone else knows.