Support Board

Date/Time: Wed, 29 May 2024 01:19:42 +0000

Post From: Time in force in combination with spreadsheet for trading

[2020-10-29 00:17:10] Link To Thread - Link To Post [Go To First Post]
FTDK - Posts: 13
Turns out it was fairly easy to do after all. I formulated it like this on my 1 minute chart spreadsheet: =OR(IF(AND($J$9=0, $J$93<A3), 1, 0), IF(AND($J$9=0, $J$94+5<E3), 1, 0), IF(AND($J$9=0, $J$94-5>E3), 1, 0)) $J$9 is the position average price so the order will only be canceled if this field is 0. Meaning if there is no open position. This will work for me since i only allow 1 trade at a time. $J$93 is the last working entry order date-time, so the order will be canceled when this field gets smaller than the opening time of the next new candle. Meaning the order will be there for maximum till the end of the candle that triggered it. $J94 is the last working entry order price, so the buy order will be canceled if the last price is 5 points higher than the buy limit price and the sell order will be canceled if the last price is 5 points lower than the sell limit price. ---- A completely different question but i think i already know the answer to this one: Is it possible to run the spreadsheet for trading on an ES chart but trigger the actual orders in MES (micro es futures)? Date Time Of Last Edit: 2020-10-29 00:18:16