|
PureBytes Links
Trading Reference Links
|
Thanks Dusant, that was indeed the problem. I don't know why he had
it written like that in the article. I've got it setup in Excel now.
Now to do it MS is the next step.
Thanks,
Harold
--- In equismetastock@xxxxxxxxxxxxxxx, Dusant <cooldush@xxxx> wrote:
>
> Harold,
>
> Have just dropped in from the blue and have not been following this
thread.
>
> However, the Col C and Col D are missing the average() and stddev()
functions of Excel.
>
> Maybe that could solve the issue.
>
> Dusant
>
> ----- Original Message -----
> From: hcour
> To: equismetastock@xxxx
> Sent: Friday, November 04, 2005 2:07 PM
> Subject: [EquisMetaStock Group] Re: Futures Mag Indicator - Std
Dev in Volatility Oscillator Formula?
>
>
> 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
>
>
>
>
>
> SPONSORED LINKS
> Business finance course
Business finance online course Business finance
schools Business finance small software
Small business finance source
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "equismetastock" on the web.
>
> To unsubscribe from this group, send an email to:
> equismetastock-unsubscribe@xxxxxxxxxxxxxxx
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
> ---------------------------------
>
>
>
>
> ---------------------------------
> Enjoy this Diwali with Y! India Click here
>
------------------------ 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/
|