|
PureBytes Links
Trading Reference Links
|
Hi mmbbrr79
Please try this:
lookback:=100;
EMA:=Mov(C,50,E);
DaysAbove:=Sum(If(C>EMA,1,0),lookback);
DaysBelow:=Sum(If(C>EMA,1,0),lookback);
Ratio:=DaysAbove/DaysBelow;
I'm not sure if it will work for the past 100 days
I hope it works!
(In my machine I've problems using Sum() function)
Cheers,
pablo
Ps: if DayBelow is cero then Ratio is not possible to calculate.
m> Hello,
m> I'm attempting to write a simple formula that counts the number of
m> days that the close has been above or below its 50 EMA, for the past
m> 100 days. I'd then like to take these numbers and compute the ratio
m> of days spent above/days spent below the 50 EMA.
m> Any suggestions?
m> Thanks,
m> M
m> Yahoo! Groups Links
Pablo Bozzolo
---
Contact info:
Movil: 221 5384617
E-mail: italoarg76@xxxxxxxx
MSN: italoarg76@xxxxxxxxxxx
ICQ: 77207033
------------------------ Yahoo! Groups Sponsor --------------------~-->
You can search right from your browser? It's easy and it's free. See how.
http://us.click.yahoo.com/_7bhrC/NGxNAA/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/
|