Support Board

Date/Time: Mon, 06 May 2024 18:09:09 +0000

Post From: Spreadsheet: Identifying Long / Short Winning / Losing trades

[2022-06-10 20:26:05] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3993
Suggestion: 1. Use Attached Orders and set J72/J74 to M. Don't use L3/N3 to set a stoploss price. 2. Set your initial target and stoploss offsets in J80/J81. These offsets from the entry price are in points, not ticks. 3. Add the Trade Management by Study study, referencing a spreadsheet Formula Column/subgraph that returns the calculated stoploss price. You can use two instances, and two Formula Columns, one for longs and one for shorts. This study will move the Attached Order stop to the calculated price. Attached Orders: Study Controlled Targets and Stops 4. Use a formula like this in J28, instead of your reference to the Time Range Highlight study: =AND(J8=0,OR(FRACTIME(J41)<TIMEVALUE("09:30:00"),FRACTIME>TIMEVALUE("16:00:00"))) This formula will disallow entries outside of its window, but allow exits after the end time. 5. If you use L3/N3 for any other exit condition, set 'Cancel All Working Orders On Exit' to Yes. Optional: you could instead use OR(...) and combine this formula with the one in J29. 6. Use J29 for a flatten time, like this: =FRACTIME(J41)>TIMEVALUE("16:14:00") The time here needs to be >= the end time in J28. Date Time Of Last Edit: 2022-06-10 22:35:57