Welcome to NexusFi: the best trading community on the planet, with over 200,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- discounts are available after registering.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
My current alert is this
=AND(ID33.SG1=1,ID47.SG1>-10,ID48.SG1>-12,CROSSFROMBELOW(ID2.SG1,ID5.SG1))
I am trying to replace the crossover with price closing above an up sloped moving average(which I can not figure out how to do), I have the coloring set based on slope but I am not sure how to access the slope to use it in an alert.
I found this code on sierra charts forums by @TomLib
=AND(C[-1]<ID5.SG1[-3],C>ID5.SG1[-2]) which from the looks of it is the first bar that closes above the moving average not including the slope this could work.
Trying to combine
=AND(C[-1]<ID5.SG1[-3],C>ID5.SG1[-2])
+
=AND(ID33.SG1=1,ID47.SG1>-10,ID48.SG1>-12)
can someone help me with this?
Can you help answer these questions from other members on NexusFi?
If there are never any flat segments, example #8 will always work.
If there are any single flat segments, use example #9.
If there are multiple sequential flat segments, an intermediate study with another formula is needed.
I think you'll want to keep the crossover so that you only get the alert once. Try this:
=AND(ID33.SG1=1,ID47.SG1>-10,ID48.SG1>-12,CROSSFROMBELOW(ID2.SG1,ID5.SG1) , ID5.SG1 > ID5.SG1[-1],ID5.SG1[-1] < ID5.SG1[-2])
This is from example #8, and only for an upsloped MA.
I have additional criteria in a spreadsheet that it checks for, my problem is that sometimes the other criteria is met but a cross over doesn't happen the second time because the moving averages are already in sync. So this is just the trigger for the spreadsheet. Is it possible to use your other code but only the first occurence of it? @TomGlib
For the short I would need to do the same thing. These are Tilson moving averages so I do not have issues with flat segments.
Short code that I also would like to get rid of the crossover as well.
=AND( ID47.SG1<10,ID34.SG1=1,CROSSFROMABOVE(ID2.SG1,ID5.SG1))
I have additional criteria in a spreadsheet that it checks for, my problem is that sometimes the other criteria is met but a cross over doesn't happen the second time because the moving averages are already in sync. So this is just the trigger for the spreadsheet. Is it possible to use your other code but only the first occurence of it? @TomGlib
For the short I would need to do the same thing. These are Tilson moving averages so I do not have issues with flat segments.
Short code that I also would like to get rid of the crossover as well.
=AND( ID47.SG1<10,ID34.SG1=1,CROSSFROMABOVE(ID2.SG1,ID5.SG1))
Persistent variables can also be created using the Spreadsheet Formula study, which is not a spreadsheet study, despite its name.
You've given formulas with ID2, ID5, ID33, ID34, ID47, ID48. It's difficult for me to offer specific advice.
If you want an alert when any one of several conditions goes TRUE when all the others are already TRUE, use a format like this:
=OR(AND(Condition1goesTRUE, Condition2isTRUE, Condition3isTRUE),AND(Condition1isTRUE, Condition2goesTRUE, Condition3isTRUE),AND(Condition1isTRUE, Condition2isTRUE, Condition3goesTRUE))
