Welcome to NexusFi: the best trading community on the planet, with over 150,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 -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
I currently have a color bar based alert setup that paints a bar using
=CROSSFROMBELOW(ID7.SG1, ID1.SG5)
I would like to add another condition in so the alert only paints the bar IF price exceeds the highs of the prior 3 bars before crossing back below CROSSFROMABOVE(ID7.SG1, ID1.SG5)
Any help would be appreciated.
Cheers
"Free markets work because they allow people to be lucky, thanks to aggressive trial and error, not by giving rewards or incentives for skill. The strategy is, then, to tinker as much as possible and try to collect as many Black Swan opportunities as you can"
Can you help answer these questions from other members on NexusFi?
If you want to 'store' the crossover event until/if price exceeds the previous 3 highs, you'll need to use a spreadsheet study, as this exceeds the capability of Simple Alerts.
If the crossover occurs concurrently with price exceeding the previous 3 highs, you could use this:
=AND(CROSSFROMBELOW(ID7.SG1, ID1.SG5),C>MAX(H[-1],H[-2],H[-3]))
Thanks Tom, I thought that might be the case. Occurring concurrently is still useful though, so really appreciate that.
Aside from what's provided on the SC website, is there any other good resources for learning how to use the spreadsheet studies? I'm not familiar with them at all.
"Free markets work because they allow people to be lucky, thanks to aggressive trial and error, not by giving rewards or incentives for skill. The strategy is, then, to tinker as much as possible and try to collect as many Black Swan opportunities as you can"
