Support Board
Date/Time: Wed, 27 Nov 2024 00:27:49 +0000
Post From: How to change trade twconfig based on ATR range values
| [2023-10-10 17:18:32] |
| Sawtooth - Posts: 4120 |
|
One question J112 - means row J column 112?
Columns are lettered, rows are numbered, so J112 is column J, row 112.I do not want autotrading, I just want to rotate through 3 or 4 twconfigs with different tick SL and TP, and these to be auto-selected when I open a trade based on the current ATR reading range at the moment I open my trade.
Try this: Add the Spreadsheet System for Trading study. - Give it a name in the Spreadsheet Name field. - Set the 'Number of Rows' to 10. - Click OK and OK. On the spreadsheet sheet: - Enter a formula like this in cell O3: =AND(ID1.SG1@3>=1,ID1.SG1@3<1.5) - Enter a formula like this in cell P3: =AND(ID1.SG1@3>=1.5,ID1.SG1@3<2.5) where ID1.SG1 is your ATR study; edit to your ATR's ID#.SG#. - Enter a formula like this in cell J112: =IF(O3=1,"88RR.twconfig",IF(P3=1,"1111RR.twconfig",0)) Edit to your names for each twconfig file. - Enter =1 in cell J28. Note: Do not enter any formulas in K3, L3, M3, N3. This will not autotrade, it will only choose your twconfig file. If the ATR goes above 2.5 or below 1, it will retain the previously chosen twconfig. Date Time Of Last Edit: 2023-10-10 17:21:03
|