Support Board
Date/Time: Thu, 13 Mar 2025 20:25:32 +0000
[User Discussion] - please verify(ocrrect) formula
View Count: 497
| [2022-06-03 16:03:57] |
| User427561 - Posts: 217 |
|
ikeep getting an error with the following formula: =and((crossfromabove(id1.sg1,id2.sg1)),((id7.sg1<id7.sg1[-1]))) can you please verify and tell me what is wrong with it? thank you the logic is as follows:"at the crossing from above of trendline id1 over trend line id2, while simultanrously stachastic fast id7 is below stochastic slow, the the condition is met or true." I tried my best at viewing my syntax but could not find anything wrong with it,and was hoping you can see what I dont. thank you. Date Time Of Last Edit: 2022-06-03 19:03:20
|
| [2022-06-03 19:08:20] |
| User427561 - Posts: 217 |
|
i have edited the original post with more clarifications. please revew. all I need is confirmation of my formula that its syntax is ok. brackets etc. i tied all I could to no avail and was hoping you could see in my syntax whatever i am missing thank you
|
| [2022-06-03 21:08:52] |
| Sawtooth - Posts: 4182 |
|
Your formula has no syntax errors, even though it has unnecessary parentheses. However, the Stochastic Slow is SG2, not SG1[-1] The [-1] refers to the previous bar. So try this formula: =and(crossfromabove(id1.sg1,id2.sg1),id7.sg1<id7.sg2) |
| [2022-06-03 21:10:16] |
| User427561 - Posts: 217 |
|
I know somebody replied to my original post, but somehow that reply was lost,but if i recall it was referred me to some Serra insructios. i vave since rvised my post with additional clarfications hoping it might help you understand the intent of my formula to achieve. and all I needed was a review of my syntax which was giving me an error after all I did to revise it but to no avail. as mentioned i revised my original post clarifying what I was intending to achieve and kindly ask you to see anything in my syntax that I was missing despite all I did to revise it . I would appreciate your reviewing my formula syntax for any error I may be overlooking, and thank you for your patience and cooperation in this matter. Date Time Of Last Edit: 2022-06-03 21:20:22
|
| [2022-06-03 23:35:29] |
| Sawtooth - Posts: 4182 |
|
Your formula from post #1... =and((crossfromabove(id1.sg1,id2.sg1)),((id7.sg1<id7.sg1[-1]))) ...has no syntax errors, assuming you are not using it on a spreadsheet. If you are using a spreadsheet study, the syntax is different: =and((crossfromabove(id1.sg1@3:id1.sg1@3,id2.sg1@3:id2.sg1@4)),((id7.sg1@3<id7.sg1@4))) However still, the Stochastic Slow is SG2, not SG1. SG1 is the Stochastic Fast. |
To post a message in this thread, you need to log in with your Sierra Chart account: