| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/29/2005
Posts: 12
|
Hello,
I would like to write a formula for the following:
Today's closing price fell below the 10 day exponential moving average price for the 10 days ending yesterday.Please advise.
Thanks.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I am not sure I understand....
You want the close today to be below the 10-day ema yesterday?
Do you want the close yesterday to be above the 10ema of 2-days ago?
If so, this should work:
C<XAVGC10.1 AND C1>XAVGC10.2
- Craig
Here to Help!
|
|
Registered User
Joined: 11/29/2005
Posts: 12
|
Hello Craig,
Basically what I want is a formula that gives me a listing of stocks that dipped below the 10 ema for the first time today.
When I use the formula C<XAVGC10.1, I get a listing of all stocks that are currently below the 10 day ema.Many have been below the 10 day ema for several days.I am only interested in those that closed below the 10 ema line today. Hope this is clear.
Thanks.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
First time since?
I need how many days you want it above.
Here is an example to work from, you should have no trouble extending/shortening the time.
Under 10ema 1st time since 10 days
C<XAVGC10 AND C1>XAVGC10.1 AND C2>XAVGC10.2 AND C3>XAVGC10.3 AND C4>XAVGC10.4 AND C5>XAVGC10.5 AND C6>XAVGC10.6 AND C7>XAVGC10.7 AND C8>XAVGC10.8 AND C9>XAVGC10.9 AND C10>XAVGC10.10
- Craig
Here to Help!
|
|
|
Guest-1 |