|
PureBytes Links
Trading Reference Links
|
Harold,
>From what you posted it looks like the calculations are (#1)the
moving average of the roc and (#2)the standard deviation of the roc.
If that is the case try this:
A:= roc(c,10,%);
B:= mov(A,10,S0;
X:= Stdev(A,10);
A;B;X;
Let me know how it works out.
Preston
--- In equismetastock@xxxxxxxxxxxxxxx, "hcour" <halcour@xxxx> wrote:
>
> Ah! Ok, I see it on the chart now.
>
> This is how it is setup in Excel in the article, see if this helps:
>
> Col A: Date
> Col B: Closing Price
>
> Starting w/the 10th row:
> Col C: [B(x):B(x+9)] - This is the avg.
> Col D: [B(x):B(x+9)] - The std dev.
>
> Starting w/the 11th row:
> Col E: B12-B11 - The price change.
> Col F: D12-D11 - The volatility.
>
> Is there an error in this, since Col C & Col D have the same
formula?
> If so, lemme know and I'll email the author and get the correct one.
> (I've already been in contact w/him and he's a very nice gent. He
> didn't have a MetaStock version of his code.)
>
> Thanks much,
> Harold
>
>
>
>
>
>
> --- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@xxxx>
wrote:
> >
> > Harold,
> >
> > Its there but the scale is so great for the std dev that you
can't
> > see the roc and the ma. Zoom in and you will see them or remove
the Z
> > variable ands plot it in another window.
> >
> > As far as the error, the minimum std dev is 2 which I should have
> > related.
> >
> > I still don't have my November edition of the mag so I'm shooting
in
> > the blind here. If you can send anything else from the article
maybe
> > it would help. Maybe the excel formula.
> >
> > Preston
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Try Online Currency Trading with GFT. Free 50K Demo. Trade
24 Hours. Commission-Free.
http://us.click.yahoo.com/RvFikB/9M2KAA/U1CZAA/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/
|