Rank: Newbie
Groups: Registered, Registered Users
Joined: 7/30/2007(UTC)
Posts: 2
|
hi guys, its my first time posting on this board. just a quick question, how can i write a formula which is some thing like this:
find stocks which Close weekly is bigger than MA10 weekly & MA10 weekly is bigger than MA50 with out changing exploration period from daily to weekly!
this is my current formula:
Mov(C,10,S) > Mov(C,50,S) AND C > Mov(C,50,S) AND MACD()> Mov(MACD(),9,EXPONENTIAL) AND Mov(V,20,S) > 100000 AND C>Ref(HHV(H,1),-25)
Scan colA.
Now this scan is for daily period, i need to add the weekly one to above formula.
thanks
|
|
|
|
|
|
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)
|
xman, Welcome to the Forum. There are a couple of ways to attack your problem, some easy, some not so easy... One way would be to consider that every week has about 5 trading days and assume that every stock trades every day each week (of course we know this isnt true, but it might be a suitable assumption at this point), then you could simply multiply all the time frames in your exploration by 5. Of course, you would have to rebuild the MACD function for the new time frames too! Another way would be to download Roy Larsen's weekly indicator on daily charts codes and include these in your computations. They can be downloaded free from his website : http://www.metastocktips.co.nz
|
|
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users
Joined: 7/30/2007(UTC)
Posts: 2
|
thanks for your help mate!
oh by the way i am from Melbourne ;)
|
|
|
|
|
|
| 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.
