|
PureBytes Links
Trading Reference Links
|
Thanks for the answer, but I had a couple of problem cause of my math
unknowing.
I find the date and value you told about, but how can I translate a date in
a number to have x0 and y0?
I tried to write the formula in excel but had the result "NAME#?"
What is r ?
Can we try with a simple example?
setted a line at initial and final value 1000, initial date 1/6/05 and final
24/6/05 it should result a angle of 0° if i'm not wrong, can you translate
this in an excel formula?
TIA
----- Original Message -----
From: "mgf_za_1999" <no_reply@xxxxxxxxxxxxxxx>
To: <equismetastock@xxxxxxxxxxxxxxx>
Sent: Saturday, June 25, 2005 4:04 PM
Subject: [EquisMetaStock Group] Re: trendline angle degree
> Hi there,
>
> To get the angle is not easy. If you look at the properties of a
> line, it gives you the start and end date and value, which you could
> use as (x0,y0) and (x1,y1) coordinates and from that calculate the
> angle in something like Excel. Using something like
>
> angle = asin(y/r) = asin(y/(sqrt(y^2+x^2))
>
> may do the trick.
>
> Regards
> MG Ferreira
> TsaTsa EOD Programmer and trading model builder
> http://www.ferra4models.com
> http://fun.ferra4models.com
>
>
> --- In equismetastock@xxxxxxxxxxxxxxx, "meta" <meta_stock@xxxx> wrote:
> > Hi,
> > I'm new at the group,
> > I need a little help
> > I need a program, a plug-in or a formula for metastock (or excel) tells
> > trendline angle degree, +/- as in figure
> > http://img151.echo.cx/img151/3320/noname0rf.gif
> > any help?
> > TIA
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
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/
|
