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

[amibroker] Re: to HERMAN: N100 Correlation table



PureBytes Links

Trading Reference Links

The code works without errors for me, But i do not
see any correlation table or heat map. I get a
ticker column and a name column. What am I missing
nand





--- In amibroker@xxxxxxxxxxxxxxx, "Rik Rasmussen" <hrasmussen@xxxx> 
wrote:
> Thanks folks,
> 
> This code is very handy for me.
> 
> I use methods of Charles Richards to time Mutual Funds. The method 
uses
> funds that correlate to the Russelll 2000.
> 
> I have set code to use a particular watchlist of funds in a 401k 
account,
> and sort result on RUT column.
> 
> Rik Rasmussen
> 
> 
> 
> 
> -----Original Message-----
> From: Stephane Carrasset [mailto:nenapacwanfr@x...]
> Sent: Friday, November 28, 2003 4:29 AM
> To: amibroker@xxxxxxxxxxxxxxx
> Subject: [amibroker] Re: to HERMAN: N100 Correlation table
> 
> 
> Hermann, Dimitri and All,
> 
> That's a wonderfull code to loops tickers against tickers with a
> specified WL.
> I have played with all the piece of codes you have given and
> came with this code for everybody
> 
> // Exploration WATCHLIST relative Correlation table
> 
> 
> list = GetCategorySymbols( categoryWatchlist, 1 );//WL 1
> TickerList="";
> Count=0;
> for( i = 0; ( sym = StrExtract( list, i ) ) != ""; i++ )
> {
> TickerList=TickerList + sym + ",";
> Count++;
> }
> 
> Filter=1;
> 
> AddTextColumn(Name(),"Ticker",1.0);
> AddTextColumn(FullName(),"FullName");
> SetOption("NoDefaultColumns",1);
> 
> C1 = ROC(C,1);
> 
> for(i=0;i<Count;i++)
> {
> Ticker = StrExtract( TickerList, i );
> C2 = ROC(Foreign(Ticker,"C"),1);
> Corr = Correlation(C1, C2, 8 );
> Color = IIf(Corr>0.7,8,4); // Add colors to make a heat map
> AddColumn(Corr,Ticker,1.3,1,Color);
> }


------------------------ 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.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/GHeqlB/TM
---------------------------------------------------------------------~->

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 http://docs.yahoo.com/info/terms/