Support Board
Date/Time: Sun, 24 Nov 2024 07:21:27 +0000
Spreadsheet Trading System
View Count: 191
| [2024-06-21 14:03:57] |
| User357489 - Posts: 72 |
|
Hi there, at present i have buy and sell conditions for auto entry based on 1 condition. i wanted to know if i were to use the =OR(AND... formula, i could have several different conditions, so if 1 or more occur at any given time, they trigger the trade. my current formula is =AND(ABS($J$8)=0, EA3<EA4, EH3<EH4, EJ3>EJ4, EK3>EK4, E3>C4, EH3>0, E3>C4,FL3>FL4, A3-INT(A3)>TIMEVALUE("01:30:00")) can i simply add to this list using commas as seperators, and would i just need to add =or(and...? Thanks |
| [2024-06-21 14:26:34] |
| John - SC Support - Posts: 36238 |
|
Yes, you can do what you are wanting. For example: =OR(AND(item1, item2, item3), AND(item4, item5, item6)) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-06-23 14:22:27] |
| User357489 - Posts: 72 |
|
Hi John Thanks, it's worked for the most part. As I was tweaking and testing in chart replay, I have noticed that some cell references changed? So when I wrote a condition let's say, EJ3>0 denoting ID15.SG1 >0, as I was watching the replay, I noticed it wasnt triggering in some places so checked and in this example, had gone to cell column EH instead. If I then remove say 1/3 of my conditions to test the remaining, it actually doesn't seem to then recognize the new buy/sell entry formula and feels like I have to start from scratch? Quite confusing, hoping you can shed light if similar things happened to others in past. Appreciate the help as always |
| [2024-06-23 14:30:41] |
| User357489 - Posts: 72 |
|
For further reference, here are the 3 individual conditions I want to combine into one buy/sell entry formula: 1) =AND(AO3>0, E3>C4, DY3>DY4, EJ3>EJ4, EK3>EK4, FL3>FL4, EH3>0 2)=AND(ABS($J$8)=0, EA3<EA4, EH3<EH4, EJ3>EJ4, EK3>EK4, E3>C4, EH3>0, E3>C4,FL3>FL4, A3-INT(A3)>TIMEVALUE("08:30:00 3) =OR(AND(ABS($J$8)=0,CROSSFROMBELOW(AJ3:AJ4,AK3:AK4),E3>=AI3,EA3>0, A3-INT(A3)>TIMEVALUE("08:30:00"))) Where $J$8 is the 'position quantity' cell. I asked chat gpt to combine all 3 using =OR(AND as you answered in a previous support ticket, yet I feel this is where I went wrong as I'm not totally confident writing the formulas 'solo: |
| [2024-06-24 17:01:07] |
| John - SC Support - Posts: 36238 |
|
We think what you are referencing is that the columns that hold the other study values will change as you add/remove studies. This is the case with the Spreadsheet Study and is why we recommend using the format specified at the following link to reference studies within a Spreadsheet: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: