Support Board
Date/Time: Thu, 06 Mar 2025 19:18:35 +0000
Post From: Multiple Spreadsheet System for Trading on the same instrument
| [2022-02-08 22:27:50] |
| FTDK - Posts: 13 |
|
Alright, i am working on another potential solution but am now running into the next issue: I have created 1 spreadsheet with both trigger formulas in them using =OR(IF(AND(FORMULA1), 1, 0), IF(AND(FORMULA2), 1, 0) This does work to open the trades. If formula 1 is true it opens a trade and if formula 2 is true it opens a trade. Now my thinking was that i could combine my formula including if K4=1, so if the formula opened a trade the previous bar, then calculate the point offset for the attached orders that can be used by the trade management study. This does seem to work when i use the formulas separately, but once i combine them i get an incorrect number. For example: =IF(AND(K4=1, FORMULA1), Z3-D7, 0) - this formula does give a correct number =IF(AND(K4=1, FORMULA2), Z3-D7, 0) - this formula does give a correct number But once i combine them like i did with the 2 formulas to open a trade it goes wrong: =OR(IF(AND(K4=1, FORMULA1), Z3-D7, 0), IF(AND(K4=1, FORMULA2), Z3-D7, 0))) Now the formula still gives a result at the correct time, but instead of calculating the actual number, which is the Z3-D7 part, it only shows as 1 instead of the correct number. I suspect i am doing something wrong in combining the 2 formulas, but i have done it in the exact same way as i have done it for the formulas that trigger the trade, and they do work correctly. When i combine the 2 formulas like this example below i do get a correct number, however then it calculated the number every time K4=1 instead of when K4=1 and FORMULA1 or FORMULA2 are correct. =IF(OR(K4=1, AND(FORMULA1)), Z3-D7, IF(OR(K4=1, AND(FORMULA2)), Z3-D7, 0) Date Time Of Last Edit: 2022-02-08 22:41:49
|