|
PureBytes Links
Trading Reference Links
|
Herman:
This is really neat. However, one warning. If you copy the spreadsheet and
paste it into Excel, Excel doesn't like the color coding. You'll see 3 squares
following each data entry in the correlation matrix table. If you eliminate the
color coding in the AddColumn line, you can get rid of this problem. Just an
observation.
Al V.
<BLOCKQUOTE
>
----- Original Message -----
<DIV
>From:
Herman vandenBergen
To: <A title=amibroker@xxxxxxxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Sent: Sunday, November 30, 2003 7:39
PM
Subject: RE: [amibroker] Re: to HERMAN:
N100 Correlation table
<SPAN
class=870083800-01122003>//This works fine:
<FONT
color=#ff0000>
Filter<FONT
color=#000000> = Status<FONT
color=#000000>("LastBarInTest"<FONT
face="Courier New">); list = <FONT
color=#0000ff>GetCategorySymbols( <FONT
color=#ff0000>categoryWatchlist,
0<FONT
color=#000000>); AddTextColumn<FONT
color=#000000>(Name<FONT
color=#000000>(),"Correlation"<FONT
color=#000000>,1.0<FONT
face="Courier New">); Ticker1= <FONT
color=#0000ff>Name<FONT
color=#000000>(); for<FONT
color=#000000>( Col=0;
(Ticker2=StrExtract(
List, Col))!= ""<FONT
face="Courier New">; Col++) { Var2 = <FONT
color=#0000ff>Foreign(Ticker2,<FONT
color=#ff00ff>"C");
Corr = Correlation(
C, Var2,
8<FONT
color=#000000>); Color = IIf<FONT
color=#000000>(Corr>0<FONT
color=#000000>, colorBrightGreen<FONT
color=#000000>, IIf<FONT
color=#000000>(Corr<0<FONT
color=#000000>, colorRed<FONT
color=#000000>,colorWhite<FONT
face="Courier New">)); Color = <FONT
color=#0000ff>IIf(Ticker1==Ticker2, <FONT
color=#ff00ff>1,
Color); AddColumn(
Corr, Ticker2, 1.3,
1,
Color);
<SPAN
class=870083800-01122003>}
<SPAN
class=870083800-01122003>
<FONT face=Tahoma
size=2>-----Original Message-----From: Steve Wiser
[mailto:slwiser@xxxxxxxxxxx]Sent: December 1, 2003 6:12
AMTo: amibroker@xxxxxxxxxxxxxxxSubject: Re:
[amibroker] Re: to HERMAN: N100 Correlation
tableHello AllSince upgrading to 4.5 beta
has anyone had any problems getting the Correlation table script?I
am now having problems with it. It seems to do nothing now. It
maybe some setting that I inadvertently set apart from the upgrade. I
just want to know it anyone else is having problems with this
script.Steve Send BUG REPORTS to
bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page:
<A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
Send BUG REPORTS to bugs@xxxxxxxxxxxxxSend SUGGESTIONS to
suggest@xxxxxxxxxxxxx-----------------------------------------Post
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)--------------------------------------------Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
<BLOCKQUOTE
><FONT
face="Courier New">---Outgoing mail is certified Virus
Free.Checked by AVG anti-virus system (<A
href="">http://www.grisoft.com).Version: 6.0.543
/ Virus Database: 337 - Release Date:
11/21/2003
Yahoo! Groups Sponsor
ADVERTISEMENT
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.
|