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

Re: Formula help



PureBytes Links

Trading Reference Links

To find these stocks ... in the explorer

cola=ref(c>mov(c,200,s),-90){90 days ago the close was > 200ma of the close}
colb=c<mov(c,200,s)             {now the close is < 200ma of the close}
filter=when(cola and colb)     {both cond1 and cond2 must be true}

Regards ... Martin

Heidi Stubner wrote:

> I'm rewording my last request for help because I'm starting to think that
> what I was looking for was impossible to create a formula for.
>
> I'm looking to do a filter to find the stocks which were above their 200
> day moving average 90 days ago and now are below their 200 day moving
> average.  I would like to use this to find stocks which are using the 200
> day m.a. as a resistance level once the price falls below it.  Any
> suggestions would be greatly appreciated.
>
> Heidi