logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
billsingh  
#1 Posted : Saturday, January 20, 2007 5:33:27 PM(UTC)
billsingh

Rank: Member

Groups: Registered, Registered Users
Joined: 1/21/2007(UTC)
Posts: 21

I want to scan the stock based on 2 days RSI (not 14 days) if the RSI is below 10 also if RSI above 90. What will be the formula ??

Thanks in advance

Bill

wblam  
#2 Posted : Sunday, January 21, 2007 4:44:18 AM(UTC)
wblam

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79

The formula should be: (RSI(C,2)<10) OR (RSI(C,2)>90).

But in explorer, RSI for 2 or 3 days alway get error. It seem that in the smallest no. of days to be used must be 4.

billsingh  
#3 Posted : Sunday, January 21, 2007 10:29:45 AM(UTC)
billsingh

Rank: Member

Groups: Registered, Registered Users
Joined: 1/21/2007(UTC)
Posts: 21

Thanks Wblam, I will keep in mind. I want to add this scan with RMO. Lets see what happens.
billsingh  
#4 Posted : Sunday, January 21, 2007 11:14:34 AM(UTC)
billsingh

Rank: Member

Groups: Registered, Registered Users
Joined: 1/21/2007(UTC)
Posts: 21

I read this article http://www.tradingmarkets.com/.site/stocks/commentary/editorial/2-Period-RSI.cfm
They say 2day RSI Produte beter result then 14 day.

So I ran the following.

a:=(Fml("Rahul Mohindar Osc (RMO)") > 0) AND

(Fml("SwingTrd 2")>0) AND

(Fml("SwingTrd 2")>Fml("SwingTrd 3")) AND
(RSI(C,2)<10);

a=1 AND Ref(a,-1)=0

and Found following matches that return 1.

AAPL
CRAY
GIGA
RADS
VOCS

I am going to watch those stocks in next few days and see what happens.

Is my formula right ???

Thanks

Bill

billsingh  
#5 Posted : Sunday, January 21, 2007 11:26:40 AM(UTC)
billsingh

Rank: Member

Groups: Registered, Registered Users
Joined: 1/21/2007(UTC)
Posts: 21

WBLIM you are right. 2 day RSI does not work, please ignore my last post. Here are the results of 4day RSI (just RSI)

Security Name RSI Ticker Symbol Location
FASTENAL ORD 1.0000 FAST
Forgent Networks, Inc. 1.0000 FORG
GARMIN ORD 1.0000 GRMN
SANDISK ORD 1.0000 SNDK
WHOLE FOODS ORD 1.0000 WFMI
YAHOO ORD 1.0000 YHOO

Lets see what happens to those stocks in next few day.

*PP  
#6 Posted : Sunday, January 21, 2007 2:18:36 PM(UTC)
*PP

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 4/1/2006(UTC)
Posts: 135
Location: Romania

billsingh wrote:

WBLIM you are right. 2 day RSI does not work, please ignore....

Lets see what happens to those stocks in next few day.

Everything is so magic, right? ;)

wblam  
#7 Posted : Sunday, January 21, 2007 11:22:11 PM(UTC)
wblam

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79

Hi Bill, I found a solution, create a custom indicator for 2 days RSI, call it RSI2. The formula is as follow:

U:=If(C>Ref(C,-1),C-Ref(C,-1),0)+If(Ref(C,-1)>Ref(C,-2),Ref(C,-1)-Ref(C,-2),0);
D:=If(C<Ref(C,-1),Ref(C,-1)-C,0)+If(Ref(C,-1)<Ref(C,-2),Ref(C,-2)-Ref(C,-1),0);
u/(u+d)*100;

Then in explorer, Filer tab:

Fml("RSI2")<10 OR Fml("RSI2")>90

BTW, does RMO trading system help you make money so far? I do not have ver 10 yet.

uasish  
#8 Posted : Monday, January 22, 2007 9:46:07 AM(UTC)
uasish

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 8/13/2005(UTC)
Posts: 170

Thanks: 7 times

Wblam,

As in the book " Technical Analysis A to Z " by Steven B Achelis the calculation for RSI = 100 - ( 100 / (1 + U/D)),where U = Avg upward price change & D = Avg downward price change,hence your code needs a modification at last line.

Asish

wblam  
#9 Posted : Monday, January 22, 2007 10:37:16 AM(UTC)
wblam

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79

uasish wrote:

Wblam,

As in the book " Technical Analysis A to Z " by Steven B Achelis the calculation for RSI = 100 - ( 100 / (1 + U/D)),where U = Avg upward price change & D = Avg downward price change,hence your code needs a modification at last line.

Asish

Hi Asish,

My formula is correct. The definition of the variables U and D in my formula are different from the book. In the book, U = Avg upward price change , but in my formula, U = Total upward price change. Similarly for D.

OK let me change my variables from U to A and D to V.

Now, U=A/2 and D=V/2, and

RSI = 100 - ( 100 / (1 + U/D))

=A/(A+V)*100.

billsingh  
#10 Posted : Monday, January 22, 2007 5:18:46 PM(UTC)
billsingh

Rank: Member

Groups: Registered, Registered Users
Joined: 1/21/2007(UTC)
Posts: 21

Wblam,
Thanks for that formula, Yes I have metastock 10. Actually just strat looking into technicals. Please let me know if you want to test anything on metastock 10.

Regards

Bill

wblam  
#11 Posted : Monday, January 22, 2007 8:32:19 PM(UTC)
wblam

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79

billsingh wrote:

Wblam,
Thanks for that formula, Yes I have metastock 10. Actually just strat looking into technicals. Please let me know if you want to test anything on metastock 10.

Regards

Bill

Hi Bill,

I have ver 9 and thinking whether want to upgrade to ver 10. As I know, ver 10 not much new thing compare to ver 9 except a new trading system RMO system which claimed is a very successful system and help many people made a lot of money. I like to know your opinon on that system.

Spaceant  
#12 Posted : Tuesday, January 23, 2007 2:15:28 AM(UTC)
Spaceant

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers
Joined: 8/16/2005(UTC)
Posts: 182

wblam wrote:

U:=If(C>Ref(C,-1),C-Ref(C,-1),0)+If(Ref(C,-1)>Ref(C,-2),Ref(C,-1)-Ref(C,-2),0);
D:=If(C<Ref(C,-1),Ref(C,-1)-C,0)+If(Ref(C,-1)<Ref(C,-2),Ref(C,-2)-Ref(C,-1),0);
u/(u+d)*100;

It doesn't seem right with the above formula. When the above code plotted on a local index, it shows 100 and 0 for some periods.

I also plot RSI(2) on another inner box, the above code doesn't in-line with RSI(2)...... seems not right to me or ....?

Sa

uasish  
#13 Posted : Tuesday, January 23, 2007 6:16:19 AM(UTC)
uasish

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 8/13/2005(UTC)
Posts: 170

Thanks: 7 times

Wblam,

If you have a particular objective of getting total upward price change then it is ok,but the link you provided where the RSI - 2 periods success rate for very short time frame is very encouraging,as per their findings & the basic concept of this leading indicator lies in it's avg of up/dn .However this 2 period time frame will mostly mis match with the chart & exploration values in MS .However i am using Jose's following code ( with little tweaking for my purpose) since long.It may be of some use,the following is his original :

.........................................8.................................................................

{ Smoothed RSI indicator v1.1 }
{ Internal sine-weighted smoothing }
{ Automatic historically-valid RSI peak/trough
boundaries}
{ Boundary crossover signals: +1=Long, -1=Short}
{ ©Copyright 2004 Jose Silva }
{ http://www.metastocktools.com }

{ user input }
pds:=1/Input("RSI periods",1,2520,10);
plot:=Input("plot: [1]-RSI, [2]-Long/Short signals",1,2,1);

{ RSI up/down average components }
x:=If(C>Ref(C,-1),C-Ref(C,-1),0);
y:=If(C<Ref(C,-1),Ref(C,-1)-C,0);
up:=PREV*(1-pds)+x*pds;
dw:=PREV*(1-pds)+y*pds;

{ sine-weighted internal smoothing }
s1:=Sin(30)*up;
s2:=Sin(60)*Ref(up,-1);
s3:=Sin(90)*Ref(up,-2);
s4:=Sin(60)*Ref(up,-3);
s5:=Sin(30)*Ref(up,-4);
up:=(s1+s2+s3+s4+s5)/(Sin(30)*2+Sin(60)*2
+Sin(90));
S1:=Sin(30)*dw;
S2:=Sin(60)*Ref(dw,-1);
S3:=Sin(90)*Ref(dw,-2);
S4:=Sin(60)*Ref(dw,-3);
S5:=Sin(30)*Ref(dw,-4);
dw:=(s1+s2+s3+s4+s5)/(Sin(30)*2+Sin(60)*2
+Sin(90));

{ RSI indicator }
dw:=If(dw=0,.000001,dw);
RS:=100-100/(1+up/dw);

{ automatic RSI peak/trough boundaries }
pk:=Ref(RS,-1)>Ref(RS,-2) AND Ref(RS,-1)>RS
AND Alert(Ref(C,-1)>Ref(C,-2)
AND Ref(C,-1)>C,2) {AND Ref(RS,-1)>50};
pkVal:=ValueWhen(1,pk,Ref(RS,-1));
pkAvg:=Cum(pkVal)/Cum(pkVal>-1);

tr:=Ref(RS,-1)<Ref(RS,-2) AND Ref(RS,-1)<RS
AND Alert(Ref(C,-1)<Ref(C,-2)
AND Ref(C,-1)<C,2) {AND Ref(RS,-1)<50};
trVal:=ValueWhen(1,tr,Ref(RS,-1));
trAvg:=Cum(trVal)/Cum(trVal>-1);

{ RSI peak/trough boundary cross signals }
up:=Cross(trAvg,RS);
dw:=Cross(RS,pkAvg);
signals:=up-dw;

{ alternative RSI peak/trough signals }
{up:=Ref(RS,-1)<Ref(RS,-2) AND Ref(RS,-1)<RS
AND Ref(RS,-1)<trAvg;
dw:=Ref(RS,-1)>Ref(RS,-2) AND Ref(RS,-1)>RS
AND Ref(RS,-1)>pkAvg;
signals:=up-dw;}

{ plot }
If(plot=1,pkAvg,0);
If(plot=1,trAvg,0);
If(plot=1,RS,signals)

..........................................................8......................................

Asish

wblam  
#14 Posted : Tuesday, January 23, 2007 11:08:57 AM(UTC)
wblam

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79

Spaceant wrote:
wblam wrote:

U:=If(C>Ref(C,-1),C-Ref(C,-1),0)+If(Ref(C,-1)>Ref(C,-2),Ref(C,-1)-Ref(C,-2),0);
D:=If(C<Ref(C,-1),Ref(C,-1)-C,0)+If(Ref(C,-1)<Ref(C,-2),Ref(C,-2)-Ref(C,-1),0);
u/(u+d)*100;

It doesn't seem right with the above formula. When the above code plotted on a local index, it shows 100 and 0 for some periods.

I also plot RSI(2) on another inner box, the above code doesn't in-line with RSI(2)...... seems not right to me or ....?

Sa

I found out the reason. MetaStock uses Wilder's smoothing average. My formula is equivalent to using simple average.

You may try this:

A:=If(C>Ref(C,-1),C-Ref(C,-1),0);
B:=If(C<Ref(C,-1),Ref(C,-1)-C,0);
u:=Wilders(A,2);
d:=Wilders(B,2);
u/(u+d)*100;

It should be looked the same now.

wblam  
#15 Posted : Tuesday, January 23, 2007 11:22:30 AM(UTC)
wblam

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79

uasish wrote:

Wblam,

If you have a particular objective of getting total upward price change then it is ok .....

Mathematically, if simple average is used,

U=A/n and D=B/n

then U/D = A/B.

uasish wrote:

... the link you provided ...

The link is not provided by me, is by Bill.

billsingh  
#16 Posted : Tuesday, January 23, 2007 11:54:37 AM(UTC)
billsingh

Rank: Member

Groups: Registered, Registered Users
Joined: 1/21/2007(UTC)
Posts: 21

Wblam,
I recommend upgrade and yes I know few people who have 10 consective winning trade using RMO what is what made me buy Metastock ver 10. For this year in Jan it made me over 20k with one trade and I am in the second trade with 5k up using RMO.

Go get it tiger, it is worth the money you pay for upgrade.

Regards

Bill

wabbit  
#17 Posted : Saturday, February 24, 2007 5:51:30 PM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Bill and All,

You don't NEED to upgrade to MS10 to get the RMO as it is exactly the same as the Rainbow Oscillator that was included with previous versions of MS (as early as MS7).

There are other good reasons to upgrade to MS10, besides the RMO.


wabbit [:D]


wblam  
#18 Posted : Saturday, February 24, 2007 11:50:24 PM(UTC)
wblam

Rank: Advanced Member

Groups: Registered, Registered Users
Joined: 11/25/2006(UTC)
Posts: 79

Hi Wabbit,

Thank you for the information. I found the Rainbow Oscilator indicator. However it is not documented in the manual of ver. 9.1.

Can you teach us how to create a template like the one in ver. 10?

Thanks.

Lam

wabbit  
#19 Posted : Tuesday, February 27, 2007 6:35:08 AM(UTC)
wabbit

Rank: Advanced Member

Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia

Was thanked: 16 time(s) in 16 post(s)
Quote:
Can you teach us how to create a template like the one in ver. 10?


I will do so in due course and post it under a new thread.... stay tuned.


wabbit [:D]


Users browsing this topic
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.