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

Notification

Icon
Error

Options
Go to last post Go to first unread
Wilkoqpr  
#1 Posted : Friday, June 25, 2010 4:47:02 AM(UTC)
Wilkoqpr

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

Traetey  
#2 Posted : Friday, June 25, 2010 8:39:53 AM(UTC)
Traetey

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
v.trader  
#3 Posted : Friday, June 25, 2010 5:21:24 PM(UTC)
v.trader

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)
Wilkoqpr  
#4 Posted : Tuesday, June 29, 2010 10:07:45 AM(UTC)
Wilkoqpr

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)
Similar Topics
RMO Exploration to catch Buy/Sell signal - coding help needed (Formula Assistance)
by PTJim 5/31/2019 6:17:43 PM(UTC)
advice/help needed on explorer formula (Advanced Coding Techniques)
by dimpledbrain 3/30/2015 2:42:31 PM(UTC)
help needed to check EMA crossover formula (Formula Assistance)
by dimpledbrain 3/17/2015 3:42:51 PM(UTC)
System Tester - Sell based on buy price/candlestick values - Help needed (Advanced Coding Techniques)
by alvaro 8/21/2014 6:58:30 AM(UTC)
Help Needed (MetaStock)
by Nocash 5/30/2013 10:23:50 PM(UTC)
Help needed for custum indicator (Formula Assistance)
by NGOMSI 12/14/2012 5:22:33 PM(UTC)
help needed on simple formula (Formula Assistance)
by ralphharper1 12/8/2012 7:37:10 PM(UTC)
Help needed for Simple time indicator (Basic Coding Techniques)
by KenK 11/6/2012 10:02:24 AM(UTC)
Help needed with Simple Time Formula (Formula Assistance)
by KenK 11/6/2012 7:31:17 AM(UTC)
Rounding Bottom (Cup Pattern)Explorer Help Needed (Formula Assistance)
by Sahilsri 9/27/2012 3:59:34 AM(UTC)
Help needed for Metastock formula (MetaStock)
by mhireche 5/1/2012 8:03:50 AM(UTC)
Help needed - I have a problem with adding a "Day after" filter to a candle signal in the System Tester? (Formula Assistance)
by rasj 2/1/2012 9:36:01 PM(UTC)
Help Needed - Acceleration bands exploration (Formula Assistance)
by nick1334 11/14/2011 5:14:40 AM(UTC)
CCI Explorer - Help needed thanks (Formula Assistance)
by manageacc 4/5/2011 6:20:02 AM(UTC)
Help needed for indicator building (Formula Assistance)
by petros734 11/20/2010 8:52:05 AM(UTC)
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.