Support Board
Date/Time: Thu, 06 Mar 2025 19:11:52 +0000
Post From: Multiple Spreadsheet System for Trading on the same instrument
| [2022-02-09 01:04:20] |
| Sawtooth - Posts: 4181 |
|
You will need to isolate which formula was used to enter. Try this: - Put each Longs formula in its own Formula Column (e.g. O3 and P3), and use this example in K3: =OR(O3,P3) - Use two more Formula Columns to count the bars since each of the two signals, using these examples: Q3: =IF(O3, 1, Q4 + 1) R3: =IF(P3, 1, R4 + 1) - When J8 > 0, the column with the greater count identifies the formula that was used, with a formula like this: =IF(AND($J$8>0,Q3>R3),offset1,IF(AND($J$8>0,R3>Q3),offset2,0)) - Use one instance of the TMS study for only Longs, referencing its own Formula Column. Replicate the above for the Short entries. |