|
PureBytes Links
Trading Reference Links
|
Hello,
Sorry, 2nd column was not correct. Attached is corrected
sheet:
<TABLE cellSpacing=0
cellPadding=0 width=512 border=0 x:str>
<TD
width=64 height=17>
<TD
width=64>
<TD
width=64>Wilders
<TD
width=64>
<TD
width=64>Wilders
<TD
width=64>
<TD
width=128 colSpan=2>AMA10/11
<TD
height=17>
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num>10
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num>11
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num>10
<TD
align=right x:num>11
<TD
height=17>Data
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="00.1" x:fmla="=1/C2"><FONT face="Arial CE"
size=2>0,1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="9.0909090909090912E-2" x:fmla="=1/E2"><FONT
face="Arial CE" size=2>0,090909
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="00.1" x:fmla="=1/G2"><FONT face="Arial CE"
size=2>0,1
<TD
align=right x:num="9.0909090909090912E-2" x:fmla="=1/H2"><FONT
face="Arial CE" size=2>0,090909
<TD
align=right height=17 x:num>1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num x:fmla="=A4">1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num x:fmla="=C4">1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num x:fmla="=E4">1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>2
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.1" x:fmla="=$C$3*A5+(1-$C$3)*C4"><FONT
face="Arial CE" size=2>1,1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.0818181818181818" x:fmla="=$E$3*A5+(1-$C$3)*E4"><FONT
face="Arial CE" size=2>1,081818
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.1" x:fmla="=$G$3*A5+(1-$G$3)*G4"><FONT
face="Arial CE" size=2>1,1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>3
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.29" x:fmla="=$C$3*A6+(1-$C$3)*C5"><FONT
face="Arial CE" size=2>1,29
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.2463636363636363" x:fmla="=$E$3*A6+(1-$C$3)*E5"><FONT
face="Arial CE" size=2>1,246364
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.2727272727272727" x:fmla="=$H$3*A6+(1-$H$3)*G5"><FONT
face="Arial CE" size=2>1,272727
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>4
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.5609999999999999" x:fmla="=$C$3*A7+(1-$C$3)*C6"><FONT
face="Arial CE" size=2>1,561
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.4853636363636364" x:fmla="=$E$3*A7+(1-$C$3)*E6"><FONT
face="Arial CE" size=2>1,485364
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.5454545454545454" x:fmla="=$G$3*A7+(1-$G$3)*G6"><FONT
face="Arial CE" size=2>1,545455
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.5049000000000001" x:fmla="=$C$3*A8+(1-$C$3)*C7"><FONT
face="Arial CE" size=2>1,5049
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.4277363636363636" x:fmla="=$E$3*A8+(1-$C$3)*E7"><FONT
face="Arial CE" size=2>1,427736
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.4958677685950412" x:fmla="=$H$3*A8+(1-$H$3)*G7"><FONT
face="Arial CE" size=2>1,495868
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>4
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.75441" x:fmla="=$C$3*A9+(1-$C$3)*C8"><FONT
face="Arial CE" size=2>1,75441
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.6485990909090908" x:fmla="=$E$3*A9+(1-$C$3)*E8"><FONT
face="Arial CE" size=2>1,648599
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.7462809917355373" x:fmla="=$G$3*A9+(1-$G$3)*G8"><FONT
face="Arial CE" size=2>1,746281
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>5
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.0789689999999998"
x:fmla="=$C$3*A10+(1-$C$3)*C9"><FONT face="Arial CE"
size=2>2,078969
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.9382846363636363"
x:fmla="=$E$3*A10+(1-$C$3)*E9"><FONT face="Arial CE"
size=2>1,938285
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.0420736288504884"
x:fmla="=$H$3*A10+(1-$H$3)*G9"><FONT face="Arial CE"
size=2>2,042074
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>3
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.1710720999999999"
x:fmla="=$C$3*A11+(1-$C$3)*C10"><FONT face="Arial CE"
size=2>2,171072
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.0171834454545454"
x:fmla="=$E$3*A11+(1-$C$3)*E10"><FONT face="Arial CE"
size=2>2,017183
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.1378662659654397"
x:fmla="=$G$3*A11+(1-$G$3)*G10"><FONT face="Arial CE"
size=2>2,137866
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.05396489" x:fmla="=$C$3*A12+(1-$C$3)*C11"><FONT
face="Arial CE" size=2>2,053965
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.9063741918181818"
x:fmla="=$E$3*A12+(1-$C$3)*E11"><FONT face="Arial CE"
size=2>1,906374
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.0344238781503998"
x:fmla="=$H$3*A12+(1-$H$3)*G11"><FONT face="Arial CE"
size=2>2,034424
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>3
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.1485684010000003"
x:fmla="=$C$3*A13+(1-$C$3)*C12"><FONT face="Arial CE"
size=2>2,148568
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="1.9884640453636364"
x:fmla="=$E$3*A13+(1-$C$3)*E12"><FONT face="Arial CE"
size=2>1,988464
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.1309814903353601"
x:fmla="=$G$3*A13+(1-$G$3)*G12"><FONT face="Arial CE"
size=2>2,130981
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>4
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.3337115609000003"
x:fmla="=$C$3*A14+(1-$C$3)*C13"><FONT face="Arial CE"
size=2>2,333712
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.1532540044636366"
x:fmla="=$E$3*A14+(1-$C$3)*E13"><FONT face="Arial CE"
size=2>2,153254
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.3008922639412366"
x:fmla="=$H$3*A14+(1-$H$3)*G13"><FONT face="Arial CE"
size=2>2,300892
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>3
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.4003404048100005"
x:fmla="=$C$3*A15+(1-$C$3)*C14"><FONT face="Arial CE"
size=2>2,40034
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.2106558767445454"
x:fmla="=$E$3*A15+(1-$C$3)*E14"><FONT face="Arial CE"
size=2>2,210656
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.3708030375471134"
x:fmla="=$G$3*A15+(1-$G$3)*G14"><FONT face="Arial CE"
size=2>2,370803
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>1
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.2603063643290007"
x:fmla="=$C$3*A16+(1-$C$3)*C15"><FONT face="Arial CE"
size=2>2,260306
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.080499379979182"
x:fmla="=$E$3*A16+(1-$C$3)*E15"><FONT face="Arial CE"
size=2>2,080499
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.2461845795882849"
x:fmla="=$H$3*A16+(1-$H$3)*G15"><FONT face="Arial CE"
size=2>2,246185
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>4
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.4342757278961007"
x:fmla="=$C$3*A17+(1-$C$3)*C16"><FONT face="Arial CE"
size=2>2,434276
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.2360858056176274"
x:fmla="=$E$3*A17+(1-$C$3)*E16"><FONT face="Arial CE"
size=2>2,236086
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.4215661216294562"
x:fmla="=$G$3*A17+(1-$G$3)*G16"><FONT face="Arial CE"
size=2>2,421566
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>3
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.4908481551064909"
x:fmla="=$C$3*A18+(1-$C$3)*C17"><FONT face="Arial CE"
size=2>2,490848
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.2852044977831376"
x:fmla="=$E$3*A18+(1-$C$3)*E17"><FONT face="Arial CE"
size=2>2,285204
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.4741510196631422"
x:fmla="=$H$3*A18+(1-$H$3)*G17"><FONT face="Arial CE"
size=2>2,474151
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>3
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.5417633395958417"
x:fmla="=$C$3*A19+(1-$C$3)*C18"><FONT face="Arial CE"
size=2>2,541763
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.3294113207320963"
x:fmla="=$E$3*A19+(1-$C$3)*E18"><FONT face="Arial CE"
size=2>2,329411
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.5267359176968283"
x:fmla="=$G$3*A19+(1-$G$3)*G18"><FONT face="Arial CE"
size=2>2,526736
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right height=17 x:num>5
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.7875870056362575"
x:fmla="=$C$3*A20+(1-$C$3)*C19"><FONT face="Arial CE"
size=2>2,787587
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.5510156432043414"
x:fmla="=$E$3*A20+(1-$C$3)*E19"><FONT face="Arial CE"
size=2>2,551016
<TD
><FONT
face="Arial CE" size=2>
<TD
align=right x:num="2.7515781069971164"
x:fmla="=$H$3*A20+(1-$H$3)*G19"><FONT face="Arial CE"
size=2>2,751578
<TD
>
Best regards,Tomasz Janeczkoamibroker.com
----- Original Message -----
From: "Tomasz Janeczko" <<A
href="">amibroker@xxxxxx<FONT
size=2>>
To: <<A
href=""><FONT
size=2>amibroker@xxxxxxxxxxxxxxx>
Sent: Wednesday, October 15, 2003 2:30 PM
Subject: Re: [amibroker] Re: MA, DEMA and TEMA can take array
parameters, but EMA can't?
> Dimitris,> >
Please take Excel and take a look at the following:> > 1st column
is 10period Wilders> 2nd column is 11 period wilders> 3rd column
is AMA equivalent that uses 10 periods for odd bars and 11 periods for even
bars.> > Wilders
Wilders AMA10/11 > 10
11 10 11 > Data
0,1 0,090909 0,1 0,090909 >
1 1 1 1 >
2 1,1 1,01 1,1
> 3 1,29 1,038
1,272727 > 4 1,561
1,0903 1,545455 >
1 1,5049 1,13176 1,495868 >
4 1,75441 1,194025
1,746281 > 5
2,078969 1,282519 2,042074 >
3 2,171072 1,371375
2,137866 > 1
2,053965 1,439634 2,034424 >
3 2,148568 1,510527
2,130981 > 4
2,333712 1,592846 2,300892 >
3 2,40034 1,673595
2,370803 > 1
2,260306 1,732266 2,246185 >
4 2,434276 1,802467
2,421566 > 3
2,490848 1,871305 2,474151 >
3 2,541763 1,938351
2,526736 > 5
2,787587 2,023275 2,751578 > > Hope this
helps.> > Best regards,> Tomasz Janeczko>
amibroker.com> ----- Original Message ----- > From: "DIMITRIS
TSOKAKIS" <<FONT
size=2>TSOKAKIS@xxxxxxxxx>> To: <<A
href=""><FONT
size=2>amibroker@xxxxxxxxxxxxxxx>> Sent:
Wednesday, October 15, 2003 2:20 PM> Subject: [amibroker] Re: MA, DEMA
and TEMA can take array parameters, but EMA can't?> > >
> The same question for EMA/AMA equivalent.> > The AMA(C,a) will
not touch AMA(C,10) when a is variable and a=10.> > I do not think we
may speak for equivalence...> > > >
x1=10;Plot(EMA(C,x1),"EMA10",1,1);> >
x2=20;Plot(EMA(C,x2),"EMA20",1,1);> >
a1=2/(x1+1);Plot(AMA(C,a1),"AMA10",4,8);> >
a2=2/(x2+1);Plot(AMA(C,a2),"AMA20",4,8);> > x=10+Cum(1)%11;>
> a=2/(x+1);> > Plot(AMA(C,a),"AMA",7,1);> > >
> Dimitris Tsokakis> > --- In <A
href=""><FONT
size=2>amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko"
<amibroker@x<FONT
size=2>...> > > wrote:> > > Dave,> > >
> > > For variable period exponential smoothing simply use
AMA:> > > > > > EMA( array, period_variable ) =
>>> AMA( array, 2 / ( > > period_variable+1) );>
> > > > > <A
href=""><FONT
size=2>http://www.amibroker.com/guide/afl/afl_view.php?name=AMA<FONT
size=2>> > > > > > > > > Best
regards,> > > Tomasz Janeczko> > >
amibroker.com> > > ----- Original Message ----- > > >
From: "Dave Merrill" <<FONT
size=2>dmerrill@x...>> > > To:
<<FONT
size=2>amibroker@xxxxxxxxxxxxxxx>> > >
Sent: Tuesday, October 14, 2003 2:39 PM> > > Subject: [amibroker]
MA, DEMA and TEMA can take array parameters, > > but EMA
can't?> > > > > > > > > > it appears
that you can pass an array, not just a single scalar > > value,
as> > > > the range parameter to the built in MA, DEMA and TEMA
functions, > > but you> > > > can't for EMA. am I
right about this, or is there some other > > problem in my>
> > > code?> > > > > > > > if that is
true, it's too bad, and I hope this ability will be > > added in
the> > > > future, hopefully soon. it's been said before that it
would nice > > to use> > > > dynamic (array)
parameters with all built in indicators, and > > that's> >
> > definitely true, but EMA is a basic building block that I'd think
> > personally> > > > was even more important to
have.> > > > > > > > thanks,> > >
> > > > > dave> > > > > > > >
> > > > > > > > Send BUG REPORTS to <A
href="">bugs@x...> >
> > Send SUGGESTIONS to <FONT
size=2>suggest@x...> > > >
-----------------------------------------> > > > Post
AmiQuote-related messages ONLY to: <A
href=""><FONT
size=2>amiquote@xxxxxxxxxxxxxxx > > > >
(Web page: <A
href=""><FONT
size=2>http://groups.yahoo.com/group/amiquote/messages/<FONT
size=2>)> > > >
--------------------------------------------> > > > Check group
FAQ at: > > <A
href=""><FONT
size=2>http://groups.yahoo.com/group/amibroker/files/groupfaq.html<FONT
size=2> > > > > > > > > Your use of Yahoo!
Groups is subject to > > <A
href=""><FONT
size=2>http://docs.yahoo.com/info/terms/ > >
> > > > > > > > > >> > >
> > > > > Send BUG REPORTS to <A
href=""><FONT
size=2>bugs@xxxxxxxxxxxxx> > Send SUGGESTIONS
to <FONT
size=2>suggest@xxxxxxxxxxxxx> >
-----------------------------------------> > Post AmiQuote-related
messages ONLY to: <FONT
size=2>amiquote@xxxxxxxxxxxxxxx > > (Web page:
<FONT
size=2>http://groups.yahoo.com/group/amiquote/messages/<FONT
size=2>)> > --------------------------------------------> >
Check group FAQ at: <A
href=""><FONT
size=2>http://groups.yahoo.com/group/amibroker/files/groupfaq.html<FONT
size=2> > > > > Your use of Yahoo! Groups is subject to
<FONT
size=2>http://docs.yahoo.com/info/terms/ > >
> > > > > ------------------------ Yahoo! Groups
Sponsor ---------------------~-->> Buy Ink Cartridges or Refill Kits
for your HP, Epson, Canon or Lexmark> Printer at MyInks.com. Free s/h on
orders $50 or more to the US & Canada.> <A
href=""><FONT
size=2>http://www.c1tracking.com/l.asp?cid=5511>
<FONT
size=2>http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM<FONT
size=2>>
---------------------------------------------------------------------~->>
> Send BUG REPORTS to <FONT
size=2>bugs@xxxxxxxxxxxxx> Send SUGGESTIONS to
<FONT
size=2>suggest@xxxxxxxxxxxxx>
-----------------------------------------> Post AmiQuote-related messages
ONLY to: <FONT
size=2>amiquote@xxxxxxxxxxxxxxx > (Web page:
<FONT
size=2>http://groups.yahoo.com/group/amiquote/messages/<FONT
size=2>)> --------------------------------------------> Check
group FAQ at: <A
href=""><FONT
size=2>http://groups.yahoo.com/group/amibroker/files/groupfaq.html<FONT
size=2> > > Your use of Yahoo! Groups is subject to <A
href=""><FONT
size=2>http://docs.yahoo.com/info/terms/ >
>
Yahoo! Groups Sponsor
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Attachment:
Test.xls
Attachment:
Description: "Description: MS-Excel spreadsheet"
|