Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
hello sir
could u please help me in creating an explorer.
i want the rsi indicator in explorer
which can tell me that which shares are above 70 or below 30 rsi
please create one for me
till the time i read alll lessons.
thank u
navneet
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Happy-
ColA: RSI(C,14) :replace 14 with whatever periods you want
Filter: colA>70 OR colA<30
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 10/29/2004(UTC)
Posts: 1,394
Location: Glastonbury, CT
Was thanked: 2 time(s) in 2 post(s)
|
your version
ColA: RSI(C,14) :replace 14 with whatever periods you want
Filter: colA>70 OR colA<30
will show all of the candidates lumped into 1 list
ColA: If(RSI(14)>70,1,If(RSI(14)<30,-1,0))
Filter: ColA<>0
This way all overbought will show +1 all oversold will show-1
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Much better Henry... I thought of making 2 separate columns, but never flagging the differences into 1 column. Experience at work! :wink:
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers
Joined: 7/6/2005(UTC)
Posts: 5
|
A lot of MS Code can be simplified as in the following:
[code:1:56f50bff7d]If(RSI(14)>70,1,If(RSI(14)<30,-1,0));[/code:1:56f50bff7d]
can also be written as
[code:1:56f50bff7d](RSI(14)>70)-(RSI(14)<30);[/code:1:56f50bff7d]
Regards Victor
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
THANK TO ALL YOU PEOPLE WHO HAVE REPLIED MY MESSAGE TO HELP ME OUT.
BUT I THINK THERE IS SOME ERROR IN FORMULA
INSTEAD OF +1 AT 70 AND -1 AT 30
Col A: buy/sell If(RSI(14)>70,1,If(RSI(14)<30,-1,0))
Filter colA<>0
IT SHOULD HAVE BEEN
-1 AT 70 AND 1 AT 30
Col A: buy/sell If(RSI(14)>70,-1,If(RSI(14)<30,1,0))
I THINK SO, IF I AM MAKING A MISTAKE THEN PLEASE DO TELL ME.
AS -1 INDICATES SELL SIGNAL AND +1 INDICATES BUY SIGNAL NORMALLY.
WHATEVER IT IS THANKS FOR REPLYING AND HELPING ME OUT.
DO TELL ME IF I AM MISTAKEN IN ABOVE.
THANK YOU
NAVNEET/HAPPY
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 9/8/2004(UTC)
Posts: 2,266
Was thanked: 1 time(s) in 1 post(s)
|
Quote:AS -1 INDICATES SELL SIGNAL AND +1 INDICATES BUY SIGNAL NORMALLY.
If that's how you want the formula then you are correct ;)
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
CAN ANYONE PLEASE MAKE ONE EXPLORER FOR ME.
COL A FORMULA SHOULD BE
IF RSI OF 14 DAYS IS BELOW 30 ONE DAY BACK AND IS ABOVE 30 TODAY THEN BUY
IF RSI OF 14 DAYS IS ABOVE 70 A DAY BACK AND IS BELOW 70 TODAY THEN SELL
COL B SHOULD SHOW RSI 14 ONE DAY BACK
COL C SHOULD SHOW RSI 14 TODAY
COL D CLOSE PRICE
COL E VOLUME
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Hey Happy-
R U making any progress with the Formula Primer? A lot of these solutions can be found in the examples. Plus the syntax of the functions are all explained.
I have not tested this, but this may get you started:
[code:1:74d33a11d7]ColA if(ref(RSI(14),-1)<30 AND RSI(14)>30,1,if(ref(RSI(14),-1)>70 AND RSI(14)<70,-1,0))
ColB ref(RSI(14),-1)
ColC RSI(14)
ColD C
ColE V[/code:1:74d33a11d7]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 6/3/2005(UTC)
Posts: 64
Location: India
|
THANKS SIR FOR EARLY REPLY. THERE IS SOME PROBLEM IN THIS EXPLORER AS IT IS NT FUNCTIONING XACTLY.
AND ALSO LASTLY I WAS VERY BUSY FROM LONG SO COULDN'T GET TIME TO READ FORMULA PRIMER BUT GOOD NEWS IS THAT NOW I HAVE MADE SOME TIME AVAILABLE DAILY FOR STUDYING. AND I HAVE STARTED WITH FORMULA PRIMER. HOPE I WILL COMPLTE IT SOON. ANY PROBLEMS IF ARISE THEN I KNOW U PEOPLE ARE ALWAYS HERE TO HELP THANKS AS ALWAYS
NAVNEET
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/19/2005(UTC)
Posts: 2,995
Was thanked: 14 time(s) in 10 post(s)
|
Happy-
I responded while away from my own computer, so I could not test my submission. Sorry it bombed the first time, but I won't give up. There are plenty of resources available here on the forum to help you out. Could you please tell me what part of it isn't working for you and I'll try to get it working for you tomorrow.
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
