I need help to write a SC simple alert formula, please - Sierra Chart | futures io social day trading
futures io futures trading


I need help to write a SC simple alert formula, please
Updated: Views / Replies:1,521 / 10
Created: by Rui S Attachments:0

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 90,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors – all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you don’t need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

Reply
 
Thread Tools Search this Thread
 

I need help to write a SC simple alert formula, please

  #1 (permalink)
Elite Member
Lisbon, Portugal
 
Futures Experience: Intermediate
Platform: SC, NT
Broker/Data: IB
Favorite Futures: Futures
 
Rui S's Avatar
 
Posts: 124 since May 2012
Thanks: 140 given, 49 received

I need help to write a SC simple alert formula, please

Hello,

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?

I would really appreciate this favor.

Thanks.

Reply With Quote
The following user says Thank You to Rui S for this post:
 
  #2 (permalink)
Elite Member
San Jose, CA
 
Futures Experience: Intermediate
Platform: Sierra Chart
Broker/Data: IB/IQFeed
Favorite Futures: Futures
 
Posts: 110 since Jan 2011
Thanks: 54 given, 89 received

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.

Reply With Quote
The following 4 users say Thank You to Jolew for this post:
 
  #3 (permalink)
Elite Member
Lisbon, Portugal
 
Futures Experience: Intermediate
Platform: SC, NT
Broker/Data: IB
Favorite Futures: Futures
 
Rui S's Avatar
 
Posts: 124 since May 2012
Thanks: 140 given, 49 received


@Jolew

Thank you for your reply.

The formula you posted works very well on ES. It will serve my needs perfectly.

However, I can't figure out how to set it to work with Euro Futures, which is the instrument I am currently trading.

I have the Grid spacing set to 0.00125 (12.5 ticks).

So, I am inserting the formula as this: =MOD(C+.00025,0.00125)<=1

And it doesn't work. I first thought that it could be because of the half tick so in order to test I made some more attempts like


=MOD(C+.0002,0.00125)<=1


=MOD(C+.0002,.0012)<=1


and some others but couldn't put it to work in any way.

What am I doing wrong?

Thanks.

Reply With Quote
The following user says Thank You to Rui S for this post:
 
  #4 (permalink)
Elite Member
San Jose, CA
 
Futures Experience: Intermediate
Platform: Sierra Chart
Broker/Data: IB/IQFeed
Favorite Futures: Futures
 
Posts: 110 since Jan 2011
Thanks: 54 given, 89 received

I guess the generalized formula would be:

=MOD(C+x, s)<=2*x

where x is the trigger distance to the grid lines (2 ticks in your case)
and s is the spacing between grid lines

So should be

=MOD(C+.0002,.00125)<=.0004

Reply With Quote
The following 2 users say Thank You to Jolew for this post:
 
  #5 (permalink)
Elite Member
Lisbon, Portugal
 
Futures Experience: Intermediate
Platform: SC, NT
Broker/Data: IB
Favorite Futures: Futures
 
Rui S's Avatar
 
Posts: 124 since May 2012
Thanks: 140 given, 49 received

@Jolew

Brilliant.

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.

Thank you very much.

Reply With Quote
The following user says Thank You to Rui S for this post:
 
  #6 (permalink)
Elite Member
San Jose, CA
 
Futures Experience: Intermediate
Platform: Sierra Chart
Broker/Data: IB/IQFeed
Favorite Futures: Futures
 
Posts: 110 since Jan 2011
Thanks: 54 given, 89 received

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.

Reply With Quote
The following user says Thank You to Jolew for this post:
 
  #7 (permalink)
Elite Member
Lisbon, Portugal
 
Futures Experience: Intermediate
Platform: SC, NT
Broker/Data: IB
Favorite Futures: Futures
 
Rui S's Avatar
 
Posts: 124 since May 2012
Thanks: 140 given, 49 received


Jolew View Post
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.

Thank you very much.


Last edited by Rui S; October 11th, 2013 at 07:48 AM.
Reply With Quote
The following user says Thank You to Rui S for this post:
 
  #8 (permalink)
Elite Member
San Jose, CA
 
Futures Experience: Intermediate
Platform: Sierra Chart
Broker/Data: IB/IQFeed
Favorite Futures: Futures
 
Posts: 110 since Jan 2011
Thanks: 54 given, 89 received

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.


Rui S View Post
1- Alert when the price approaches the vicinity of the Vwap (SG1) within 3 ticks, coming from above or from below;

=OR(CROSSFROMBELOW(ID2.SG1,ID1.SG1),CROSSFROMABOVE(ID2.SG2,ID1.SG1))


Rui S View Post
2- Alert when the price approaches the vicinity of the Vwsd2 Upper (SG4) within 3 ticks, coming from bellow;

=CROSSFROMBELOW(ID2.SG1,ID1.SG4)


Rui S View Post
3- Alert when the price approaches the vicinity of the Vwsd2 Lower (SG5) within 3 ticks, coming from above;

=CROSSFROMABOVE(ID2.SG2,ID1.SG5)

You can hide the bands study so it doesn't appear on the chart.


Last edited by Jolew; October 14th, 2013 at 12:03 AM. Reason: Add detail
Reply With Quote
The following 2 users say Thank You to Jolew for this post:
 
  #9 (permalink)
Trading for Profit
new york
 
Futures Experience: Intermediate
Platform: X Trader, Sierra Charts, Multicharts
Broker/Data: AMP/TT, Vision/Rithmic, AMP/CQG
Favorite Futures: CL, NG, gold
 
Posts: 355 since Mar 2012
Thanks: 665 given, 569 received


Jolew View Post
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.



=OR(CROSSFROMBELOW(ID2.SG1,ID1.SG1),CROSSFROMABOVE(ID2.SG2,ID1.SG1))



=CROSSFROMBELOW(ID2.SG1,ID1.SG4)



=CROSSFROMABOVE(ID2.SG2,ID1.SG5)

Hi

Would I be able to use that for an alert when the stoch slow D crosses above the 30 line or below the 70 line ?

sorry to jump in on your thread !

thank you
shane

Reply With Quote
The following user says Thank You to shanemcdonald28 for this post:
 
  #10 (permalink)
Elite Member
San Jose, CA
 
Futures Experience: Intermediate
Platform: Sierra Chart
Broker/Data: IB/IQFeed
Favorite Futures: Futures
 
Posts: 110 since Jan 2011
Thanks: 54 given, 89 received



shanemcdonald28 View Post
Would I be able to use that for an alert when the stoch slow D crosses above the 30 line or below the 70 line ?

It sounds like you want something like this.

=OR(CROSSFROMBELOW(SG2,SG4),CROSSFROMABOVE(SG2,SG3))

Reply With Quote
The following 2 users say Thank You to Jolew for this post:

Reply



futures io > > > > I need help to write a SC simple alert formula, please

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

Linda Bradford Raschke: Reading The Tape

Elite only

Adam Grimes: TBA

Elite only

NinjaTrader: TBA

January

Ran Aroussi: TBA

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula 1 JohnnyAustin Off-Topic 73 April 15th, 2015 08:08 PM
Wanted: Simple Volume alert with sound only DrE6 NinjaTrader 32 July 16th, 2014 12:17 AM
PriceVolumeRank Formula Edit artifice82 ThinkOrSwim Programming 0 August 22nd, 2013 07:45 PM
Cannot use decimal in RSI formula sqadri NinjaTrader Programming 3 October 22nd, 2011 10:01 AM
HELP with understanding this FORMULA plz.... mdsvtr Currency Futures 1 February 11th, 2011 10:11 PM


All times are GMT -4. The time now is 09:39 AM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts
Page generated 2017-12-11 in 0.14 seconds with 19 queries on phoenix via your IP 54.226.227.175