You are not tracking ramtajogi.
| Symbol | Sector | Return | Exposure | Trades | Last Trade | Status |
|---|---|---|---|---|---|---|
| ABK | Property and Casualty Insurance | 34.87% | n/a | 16 | 04-Nov-08 | Prior Holding |
13-Oct-08
Introducing Co-relation Calculator
Holding Rationale for ABK.
For quite some time now, JV has been looking for a way to relate a stock with an index. What he wants to know is how does stock A move corresponding to an index B? If index B is green for the day, does stock A also end up on green OR there is no relationship between the two? What he wanted was an indicator over 100 days in percentage which shows how many times stock A followed particular index. E.g. ABK and DJI. In last 100 trading days, how many times if DJI was green, ABK was green and if DJI was red, ABK was red? Intuition suggests that they a big company stock should follow DJI more or less but JV doesn’t like intuition and he wanted real hard numbers.
Now, I might suck at trading for now, I think I am good at programming and I decided to take up JV’s challenge and today in around 3 hours I created a program which lets you relate a stock with an index. Introducing ….drumrolls please….Co-relation Calculator! Here’s a screenshot:
Co-relation Calculator Start up
As I am currently long on ABK, when the program starts it loads ABK and DJI. It also loads 1st day of current year as From Date and Today’s date as To Date. When you click on ‘Get Co-relation Percentage’, program will download prices from Yahoo! Finance and decide for each day whether the tickers were GREEN or RED and whether those movement was same for both the tickers. Let’s try to see how ABK moved with DJI.
Co-relation Calculator - ABK / DJI
Interesting. From Jan 1st 2008, 36% of the time, ABK moved same as DJI. You can safely say that ABK doesn’t really follow DJI that much. Let’s compare ABK’s performance against XLF (Financial Sector Index).
Co-relation Calculator - ABK - XLF
Well, Looks like ABK follows XLF much more closely. Again, this is as per expectation. BTW, if you have any doubts about the calculation, you can click on ‘Details’ button and it will show you all the prices which program downloaded for calculating the co-relation. [You can also copy this data on clipboard and later paste in Excel for more analysis.]
Co-relation Calculator - Details
I would like to add that program is generic enough so that you can not only compare a stock with an index, but you can compare any two tickers. e.g. ABK and MBI [both are re-insurers]. Well, 48% of the time, they follow each other!
Similarly, GS/MER - 50%, BAC/WFC - 51.75% so on and so forth.
For stocks which are not related, MSFT/AIG - 40%, GOOG/PMI 39%.
Anyway, I am not very sure how useful this information is. Because if a stock follows a particular index ~50% of the times, it doesn’t give me any additional information for my trading. It is useful for scenarios where you find stocks which either follows index very closely OR doesn’t follow index at all. I could not find any combination where stock wasn’t following index. Please try this program and see if you find otherwise.
Program Highlights:
1. It is written in C#/WinForms/.NET Framework 2.0 If you are using Vista, you shouldn’t have any trouble running it. If you are using Windows XP, make sure you have .NET framework installed.
2. It downloads data from Yahoo Finance. Currently, URL for the Yahoo! Finance is hard coded in the program. So if Yahoo! Finance changes their URL or format, program will not work.
3. To download the program, click here. [It's a zip file containing an EXE. Don't worry, there are no viruses or anything.]
So JV, where is my reward? 
Happy Trading.
Status as of end of Oct 13th:
Positions traded for Gain: None
Positions traded for Loss: None
Open Positions: ABK (LONG 250 @ 3.68$)
Posted at 19:46 in Holding Rationales | Permalink | Top
Leaders Lagging. Wh...
The markets are trading slightly higher today as they await ...
StocksHaven
Palm Gets Slapped w...
On Thursday, Palm Inc (PALM) reported results for the quarte...
ockhamsrazor
Wholesale" guest?
Modern music research institute of Beijing, may you only Sho...
silent2506
LOW Watchlist idea
this is trading almost 40% below its 5-year high and just in...
jack65203
Categories
Holding Tags
Other Stock Tags
0 Comments on "Introducing Co-relation Calcul..."
You must be logged in to post a comment.
Top