Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 6/25/2010(UTC) Posts: 2
|
Hi I am a newbie so please dont laugh to much!
I am tying to create 3 ormula
1) current weeks closing price is higher then the highest price of the proceeding 12 weeks 2) closing price is above the current 40 week MA and the trend of that 40 week MA is upwards 3) Combined
Now Equis have been very helpfull and supplied the following
All these formulas assume you have set the exploration to use weekly data:
1) current weeks closing price is higher then the highest price of the proceeding 12 weeks
Filter formula:
C > Ref( HHV(H, 12), -1)
2) closing price is above the current 40 week MA and the trend of that 40 week MA is upwards
Filter formula:
C > Mov(C, 40, S) AND Roc(Mov(C, 40, S), 1, $)>0
3) combined Filter formula:
C > Ref( HHV(H, 12), -1) AND C > Mov(C, 40, S) AND Roc(Mov(C, 40, S), 1, $)>0
All good so far the problem I have is that when I set up a new exploration and add the formulare to the filter section and chande the data from daily to weekly in the options it then says it will take over 24hrs to run! Now am I doning somthing wrong here or is this just the reality of the search I want to run? All I need is to compare the the weekly closing price to see if it has closed higher then th e proceeding 12 weeks? and the 40 week MA is moving up ?
Please help !
Wilko
|
|
|
|
Rank: Member
Groups: Registered, Registered Users Joined: 3/22/2010(UTC) Posts: 16
|
Hello Wilko, I'm pretty sure you're running the exploration on online data; you should download prices to your harddisk first, then run the exploration on the local files (see here for more info: https://www.metastock.com/customer/support/kb/faq.aspx?fc=476). That should speed up things quite a bit; just to give you an idea: an exploration of +- 20.000 securities takes approx. 15-20 mins on my not-so-recent laptop. Hope this helps, Traetey
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 10/26/2009(UTC) Posts: 76 Location: Toronto, Canada
|
YESSS!!!! When I was new to this I also used online data..... Download data it would speed up things x100000 (literary)
|
|
|
|
Rank: Newbie
Groups: Registered, Registered Users, Subscribers Joined: 6/25/2010(UTC) Posts: 2
|
Thanks I think that has sorted it !
the downloader isnt that straight forward to use so I hope I have t ok!
The formular I have been given dont really work can anyone else offer assistance ?
Ta
Wilko
|
|
|
|
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.