Discussions
»
Product and Service Development
»
Formula Assistance
»
Formula for 20 SMA Above 50 SMA For The Last 10 Weeks
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 3/27/2006(UTC)
Posts: 41
Location: Singapore
|
I'm seeking a formula that can scan stocks with the 20 days simple moving average above the 50 days simple moving for the last 10 weeks. i.e. 20 SMA never crosses down the 50 SMA during the past10 weeks.
e.g. 20MA Above 50MA For The Last 10 Weeks.
Appreciate if anyone has it or helps in providing codes for.
Have a great day ahead!
- Roy
|
|
|
|
|
|
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)
|
A:=if (Sum(Mov(C,20,S)>Mov(C,50,S),50)>49,1,if (Sum(Mov(C,20,S)<Mov(C,50,S),50)>49,-1,0));
A
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 3/27/2006(UTC)
Posts: 41
Location: Singapore
|
Hi Henry,
Thank you with much appreciation.
The above formula is intended for Swing Trading in scanning for stocks that has a nice continuous up trending or continuous down trending within the last 10 weeks (number of weeks can varies by individual).
e.g. From 10 weeks to 20 weeks (100 days)
A:=if(Sum(Mov(C,20,S)>Mov(C,50,S),100)>99,1,if(Sum(Mov(C,20,S)<Mov(C,50,S),100)>99,-1,0));
Addition criteria includes Stochastic crosses OR pattern recognition using Bullish/Bearish Engulfing, Morning/Evening Doji Star in searching for trend reversal.
Any comment/s from members are welcome regarding the above idea.
Thank you once again to Hendry!
- Roy
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
Formula Assistance
»
Formula for 20 SMA Above 50 SMA For The Last 10 Weeks
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.
