Support Board
Date/Time: Fri, 14 Mar 2025 09:56:44 +0000
[User Discussion] - HELP! SPREADSHEET FORMULA FOR SCALING IN ON REVERSALS
View Count: 626
| [2022-06-10 09:14:18] |
| User9890731 - Posts: 47 |
|
HI and thanks in advance, I would like someone to help with a formula that ''scales in'' by 1 contract each time the current open position triggers a reversal order that I already have on cell K3 and M3... current reversal entry formula ; K3:=ID0.SG4@3>ID3.SG2@3 M3:=ID0.SG4@3<ID3.SG2@3 THANKS Date Time Of Last Edit: 2022-06-10 09:18:49
|
| [2022-06-10 12:53:06] |
| Sawtooth - Posts: 4182 |
|
Maybe this would work for you: https://www.sawtoothtrade.com/example-2.html |
| [2022-06-10 13:55:16] |
| User9890731 - Posts: 47 |
|
Thanks Tomgilb, To be clear on what i actually need the spreadsheet to perform during the trade execution the following conditions must be met; 1) I need the 1st parent order to have a main target of say 100ticks, 2) when a reversal trade is executed, 2 contracts must be traded but the target for the parent position should remain 100tick while the 2nd position and every other subsequent position must have a consistent target say 20ticks every time ''scaling in '' occurs. so if 4 reversals occur, then out of the 4 open positions, 3 positions should have a target of 20ticks while the parent has a 100tick target. |
| [2022-06-10 14:52:23] |
| Sawtooth - Posts: 4182 |
|
if 4 reversals occur, then out of the 4 open positions, 3 positions should have a target of 20ticks while the parent has a 100tick target.
Try this:- Use J82/J83 to set an exit quantity for exits at 20 ticks. - Use L3/N3 to exit all but one lot at 20 ticks. - For the final 100 tick target exit, use J29. |
| [2022-06-10 16:18:21] |
| User9890731 - Posts: 47 |
|
HI TOM, Lastly, how could you edit the J26 (=IF(J8<>0,ABS(J8),((J52/H1)-INT(J52/H1))/H2+1) formula to only add lots/contracts provided non of the targets have been hit before a reversal has occurred. hence if a target is hit then it resets back to 1 contract. hence removing the limitation of ''assuming you're all in/out'' |
| [2022-06-10 21:20:27] |
| Sawtooth - Posts: 4182 |
|
how could you edit the J26 formula to only add lots/contracts provided non of the targets have been hit before a reversal has occurred. hence if a target is hit then it resets back to 1 contract.
Since this formula resets to 1 each time J52 increments to again be divisible by H1, I can't think of a way to reset to 1 with another condition in the middle of completing a divisibility by H1.I'm not saying it's not possible to do what you want, only that it's not something that has an easy answer. |
To post a message in this thread, you need to log in with your Sierra Chart account: