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

RE: [EquisMetaStock Group] formula help Mov() angle



PureBytes Links

Trading Reference Links

I'll try to explain this.
 
Let's say we need to measure the slope of a roof or the slope of a roadway.
We measure the run and the rise. The run is a horizontal distance that can
be any easily measured distance i.e. a few inches, feet or miles), the rise
is the vertical change in that distance.
Rise/run = slope. Both the rise and the run must be in the same units
(inches, feet, miles). If you then look up a table of tangents, or use a
hand calculator, or excel you can determine the angle in degrees
corresponding to this slope.
 
With a stock chart the rise (change in price) and the run (change in time)
are in different dimensions. This means that while the rate of change
(slope) will be the same regardless of the scales used, the angle of this
slope is meaningless because of the different dimensions for the rise and
run.
 
The rest of what you are doing is correct. Its a matter of correct
terminology.  It means that using the program to draw a line on your chart
at a given angle in degrees may give incorrect results, but using the the
program to draw a line at a given slope will give correct results. On the
other hand if the program converts angles to slope/rate of change then you
will get correct results.
 
Everything else you say is correct and I agree with it.
 
If you have any questions please write me directly.
 
Lionel

  _____  

From: equismetastock@xxxxxxxxxxxxxxx [mailto:equismetastock@xxxxxxxxxxxxxxx]
On Behalf Of stock market
Sent: Sunday, January 14, 2007 11:30 AM
To: equismetastock@xxxxxxxxxxxxxxx
Subject: Re: [EquisMetaStock Group] formula help Mov() angle



hi lionel,
thanks for the clarification and information. have taken a note of the same.
though i am not a maths expert and had writen to try it practically. thanks
for the exact answer.

but could not understand what you mean by saying

"In this situation, the "angle" in degrees is meaningless as price and time
are different measures, and the "angle" would depend on the scales used for
price and time."

the motive is to filter securities which are rising with the highest roc
angle. whether the same be applied to the intraday,daily or weekly charts.
it would give the same result. i.e filter the stocks having steepest moving
average.

comments appreciated.
regards
joshik

On 1/14/07, Lionel Issen <lissen@xxxxxxxxxx <mailto:lissen%40sbcglobal.net>
net> wrote:
>
> OOP
> OOPS! my error.
>
> A rate of change of 50% is equivalent to an angle of 26 degrees 34
> minutes.
>
> _____
>
> From: Lionel Issen [mailto:lissen@xxxxxxxxx.
<mailto:lissen%40sbcglobal.net> net <lissen%40sbcglobal.net>]
> Sent: Saturday, January 13, 2007 9:25 AM
> To: 'equismetastock@ <mailto:%27equismetastock%40yahoogroups.com>
yahoogroups.com <%27equismetastock%40yahoogroups.com>'
> Subject: RE: [EquisMetaStock Group] formula help Mov() angle
>
> Joshik:
>
> The rate of change is the tangent of the "angle". Hence an ROC of 100% is
> equivalent to an "angle" of 45 degrees, and a rate of change of 50% is
> equivalent to an "angle" of 30 degrees: just look up a table of tangents
> in
> a mathematics book.
>
> In this situation, the "angle" in degrees is meaningless as price and time
> are different measures, and the "angle" would depend on the scales used
> for
> price and time.
>
> I agree with the rest of your posting.
>
> Hope this helps
>
> Lionel
>
> _____
>
> From: equismetastock@ <mailto:equismetastock%40yahoogroups.com>
yahoogroups.com <equismetastock%40yahoogroups.com>[mailto:
> equismetastock@ <mailto:equismetastock%40yahoogroups.com> yahoogroups.com
<equismetastock%40yahoogroups.com>]
> On Behalf Of stock market
> Sent: Saturday, January 13, 2007 12:06 AM
> To: equismetastock@ <mailto:equismetastock%40yahoogroups.com>
yahoogroups.com <equismetastock%40yahoogroups.com>
> Subject: Re: [EquisMetaStock Group] formula help Mov() angle
>
> hi, phillip,
>
> you can find the Rate of change of the moving average. and then this rate
> of
> change would give you the angle at which the moving average is.
>
> ROC(mov(c,35,E),1,%)
>
> Use a higher ROC period to find the angle of more days. the above gives
> the
> angle of 1 day. MOV is a curve so it would give diff. angles for different
> days at any given point.
>
> i think that if the ROC is 100% then the angle would be 90 degree and if
> the
> ROC is 50% then angle should be 45 degree. try it practically and you can
> get the solution.
> joshik
>
> On 1/13/07, pennellp2000 <no_reply@xxxxxxxxxx
> <mailto:no_reply% <no_reply%25>40yahoogroups.com> s.com> wrote:
> >
> > Is there any way to put the angle of a moving average line in a
> > formula, eg Mov(35) has been rising at 45 degrees for 20 periods.
> >
> > Thanks in advance Phillip
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> 
>

[Non-text portions of this message have been removed]



 


[Non-text portions of this message have been removed]



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> 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/