[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] historic screen



PureBytes Links

Trading Reference Links


> is there a way to do a historic screen.
> 
> i.e. looking at 500 stocks and find out which stocks ever had a 10% 
> rise in one day?

Yes. How you code this will depend on how you define "a 10%  rise in one day".

C>Ref(C,-1)*1.1;  may be one definition.

C>O*1.1; may be another.

Supposing you use the first definition then Column A could look like this.

{Column A}
Cum(C>Ref(C,-1)*1.1);

and the filter could look like this;

{Filter}
colA>0;

Next set the Explorer to span the required number of periods, and run it across your database. 

Then create the indicator below and use it to locate each event on individual securities.

{Ten Percent Rise}
C>Ref(C,-1)*1.1;


Kind regards

Roy Larsen
www.metastocktips.co.nz
Free formulas and MS links




 



------------------------ Yahoo! Groups Sponsor --------------------~--> 
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/BefplB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/