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 need help to write a SC simple alert formula, please
I have the “Horizontal Grid” Study (it’s one of the User Contributed Studies that comes with SC) installed in some of my charts.
This Study plots up to forty horizontal lines on a chart (SG1 to SG40), depending on the user settings.
I would like to set a Simple Alert in this Study to alert me when the last price enters the vicinity of any of the Study horizontal lines (i.e. plus or minus 2 ticks), coming from below or from above.
I have been trying to write the formula for this alert but I really can’t figure out how to do it.
Is there one of the several brilliant traders / programmers in futures.io (formerly BMT) willing to write this alert formula for me, please?
It is a little difficult to write against so many subgraphs (very long formula). It would be easier to just write the formula on its own with same parameters as horizontal grid such as:
=MOD(C+.5, 10)<=1
This would give an alert if within two ticks of every 10 even points on ES for example.
Thank you for the clarification, it will help a lot if in the future I need to make any change.
That's exactly what I need. I would never figure that out by myself. Thank you very much.
Just to have the complete information, would you please tell me what is the "MOD" in that formula?
Another question: I need some more help to set one more simple alert, on a VWAP Study. I don't want to bother nor to ask too much from you, but do you think you could write the formula for me?
By all means, if you can't or don't have the time to do it please just say no. I will completely understand.
MOD is same as it is used in Excel - the modulo or remainder of the first number divided by the second. It is in the SC documentation under spreadsheet functions.
I can try to help if it is something I'm familiar with.
I am sorry for this late reply, that's because I live in Europe and went to bed. And that is also the reason that my English may not be the best sometimes.
Thank you for the explanation about the MOD, it makes it much clearer for me now.
Unfortunately, I have never learned how to work with spreadsheets, whether Excel or SC. Sometimes I manage to use Excel spreadsheets (in a user perspective) but I don't have a clue how to configure them. And I guess I am too old to start learning it now. Nevertheless, I toke a look at the page of SC spreadsheet functions and it has a lot of interesting information.
Regarding the other alert I need:
It is to be set in the VwapBands Study Alert.
I would like to set this alert with the following three conditions:
1- Alert when the price approaches the vicinity of the Vwap (SG1) within 3 ticks, coming from above or from below;
2- Alert when the price approaches the vicinity of the Vwsd2 Upper (SG4) within 3 ticks, coming from bellow;
3- Alert when the price approaches the vicinity of the Vwsd2 Lower (SG5) within 3 ticks, coming from above;
I also would like it to be possible for me to change the range of the 3 ticks vicinity, when needed.
If possible, I would prefer to have it set as a Simple Alert formula because I don't use spreadsheets due my lack of knowledge.
If somehow you find it is easier to set it separated in 2 or 3 studies I wouldn't mind having it that way.
Now, if you find it is too much work or for any other reason you can't do it, please just tell. No worries.
I am already very grateful to you for writing the other simple alert formula for me.
My suggestion would be to first add the "Bands/Envelope" study and make a fixed offset of 3 ticks based on the main graph 'last' price. Assume this is study ID2 and VWAP is ID1.