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)
Say if I want to find out the largest green candle over the last 30 green candles (ignore red candles), what would be the alert formula please? Thank you.
Best,
AJ
Can you help answer these questions from other members on NexusFi?
1. Add the Spreadsheet Formula study, Hide the study, set 'Draw Zero Values' to No, and put this formula in the Formula field:
=IF(C>O,H-L,0)
This returns the value of each green bar's range.
2. Add the Color Bar Based On Alert Condition study, and use a formula like this on the the Alerts tab:
=MAX(ID2.SG1[0:-30])=H-L
where the Spreadsheet Formula study is ID2. Edit the ID# as needed.
