RamtaJogi— Hacking Life for Money and Fame.

RamtaJogi header image 1

Co-Relation Calculator

Basic Idea: Everyone knows that any stock follows the overall market it trades in. A stock trading on NYSE will follow Dow Jones Industrial Average more or less. But do you know how closely a stock follows a particular index? Does it follow 100% of the times (Index is down 10 times, stock is down 10 times) or it follows index only 60% of the time (Index is down 10 times, stock is down only 6 times) ? JV has been wondering about this answer and I created this tool to produce the answer based on historical data.

Program Details:

Current Version: 1.3

Last Version Update: October 30, 2008

Download link: Co-Relation Calculator.zip

Size: 32 Kb.

Requirements: .NET Framework 2.0 must be installed [You can download .NET Framework by clicking here.]. Windows Only.

Screen shots:

Co-relation Calculator v1.3

Co-relation Calculator v1.3

24 Comments

24 responses so far ↓

  • 1 bluecollartrader // Oct 19, 2008 at 8:00 pm

    Outstanding, RamtaJogi! I have downloaded this clculator and hope to use it frequently.
    Bravo. I have also book-marked your site for future reference.
    Thank you.

  • 2 RJ // Oct 19, 2008 at 8:29 pm

    Thank you bluecollartrader! Do let me know if you have any suggestions or if the tool has helped you.

  • 3 YngvaiMalmsteve // Oct 20, 2008 at 6:15 pm

    RJ, this calculator is awesome. It also verifies my strategy of looking at the indices like XLF when playing financials.

  • 4 bcecil // Oct 22, 2008 at 11:47 am

    Outstanding thanks a lot. Bookmarked you!!!

  • 5 bcecil // Oct 22, 2008 at 11:53 am

    “I will add a feature where you can paste multiple tickers and it will calculate odds of success for your short on green or red market day.”

    Will this new program be posted here when you get more time? Also can the sort be by highest red – red match percentages or if not too much trouble let us sort columns?

  • 6 RJ // Oct 22, 2008 at 3:06 pm

    Thank you bcecil for your comments.

    Yes, as I update the program, I will update this page. You will always find the latest version of the program on this page.

    And yes, your idea is good. I will sort the output by highest percentage.

    Thanks,
    RJ.

  • 7 Jeepee // Oct 25, 2008 at 7:35 am

    Hi RamtaJogi, Johnny

    Just downloadeded the calculator. Great stuff!

  • 8 novalis // Oct 29, 2008 at 9:16 pm

    What a great little tool. Thanks for the programming! See you in the room…

  • 9 RJ // Oct 31, 2008 at 12:02 am

    Thank you JeePee and novalis. I hope the tool can help you make some money!

  • 10 pavtrader // Nov 10, 2008 at 12:36 am

    Nice tool!!!

    Pav

  • 11 RJ // Nov 14, 2008 at 8:59 pm

    Thank you pavtrader for your comment. I hope the tool helps you make money.

    RJ

  • 12 Patriot // Nov 15, 2008 at 1:03 am

    RJ – I caught a few snippets of your chat with Laura at Investors Live tonight and saw your website posted there. As a tool collector I can really appreciate your software; the layout – intuitive, simple; the speed of execution – superfast; and the corelation idea – innovative.

    After installing I had fun loading the ultra ETF’s; longs and shorts . The results are surprising. For example, SKF will drop much faster when DJI is green than it will rise when the DJI is red – this explains why so many folks have gotten chopped up during the bear rally’s. I look forward to playing with more ideas / tickers.

    How do you capture and calculate the data so fast – never mind, trade secret I’m sure. Have you any familiarity with Harmonic Analysis? I’ve been using a trial version with extraordinary results – though it’s limited to Yahoo daily data dumps. Still it locates numerous bull and bear patterns using fibonacci calculations. Check it out sometime. I’d lay odds you could build a better tool.

    Thanks for building a cool tool

  • 13 RJ // Nov 15, 2008 at 1:40 am

    Patriot,

    Thank you for your your very nice comment. One of my interest is in UI (User Interface) and I am very glad that you were able to notice the effort I put in. You made my day! :)

    As indicated on the program itself, idea for such calculation was not mine, it was Johny’s idea. As a programmer, I could see value in his idea and implemented it. And there are no trade secrets. When you enter your tickers, I download prices from Yahoo! Finance and do the calculation. The speed is the magic of the powerful computers and super fast internet connectivity.

    And no, I am not familiar with Harmonic Analysis. I could only find one software called O-Matrix which uses Harmoni Analysis. Could you give me link to the software you are using?

    RJ

  • 14 Patriot // Nov 15, 2008 at 4:35 pm

    RJ,

    You deserve every kudo. I’ve been playing with the software tonight and keep discovering why some stocks (ETF’s) trade better than others. SRS is the leader so far, it moves green like no other when the DJI is red, and perhaps that explains why its price is higher than the other ETF’s.

    Here’s the link, they offer a 60-day trial but I warn you the installation and use is kluged big time. The only reason I use it are because the results are very strong for forecasting market direction.

    http://harmonicanalyzer.com/

  • 15 Patriot // Nov 15, 2008 at 4:37 pm

    RJ,

    Your blow by blow stock blog is terrific, great reading and thoughtful analysis. What are you thoughts on OPTR now? The market sold off heavy while OPTR just kept rising. I’m not sure if you follow RSI but the negative diversity of RSI to OPTR on Friday is noteworthy, meaning there was nothing supporting the rising price; looks prime for short IMHO.

    Quick Note regarding Co-Relation – it would be great to have the ability to enter a bucket of stocks, i.e., short and UltraShort ETF’s to correlate with the Dow and have results shown by a pull down of ranking variables. Either way, what other plans do you have for the Tool?

  • 16 Tortexal // Nov 16, 2008 at 11:17 pm

    RJ this is the coolest thing ever

  • 17 RJ // Nov 17, 2008 at 1:28 am

    Thanks Patriot for the kind words.

    And Tortexal, I thought you would already be using the tool. Anyway, I hope you can use this tool now to help you make some money.

    RJ

  • 18 Patriot // Nov 29, 2008 at 5:55 pm

    RJ – How are the innovations coming? We haven’t heard from you in a while. That said do you know what ticker to use for the Dow Jones Real Estate Index? I’ve used the following with no success [pulling co relation data from the tool]:

    ^DJUSRE
    ^DJUSRI

    I’d like to analyze the relationship between SRS (UltraShort ETF) and the RE Index.

    thx in advance,

    Patriot

  • 19 Jim // Jan 23, 2009 at 11:18 am

    Seems like the zip file is gone? Anybody have a copy?

  • 20 SteveO // Jan 23, 2009 at 12:20 pm

    I’ve been trying do download the calc, but I go to the 404 page instead. Can you help. When I right click, save as, it still doesn’t work.

    It sounds like a great tool

  • 21 RJ // Jan 23, 2009 at 1:55 pm

    Jim and SteveO,

    I updated my server software and file got removed. I have put it back. You should be able to download it now.

    RJ

  • 22 JL // Jan 28, 2009 at 11:42 pm

    Great tool, can I get the source?

  • 23 Adam // Feb 13, 2009 at 12:37 am

    RJ, im getting errors if i try to use less than 26-27 days of data. it says erroring when trying to devide by zero. That a yahoo thing or can you fix that?

  • 24 geoff // Mar 21, 2009 at 10:05 pm

    Hi,

    Thanks for creating this tool.

    However, I’ve been having some difficulty with it.

    Since I was manually calculating correlations in MS Excel before finding your tool, I have a fairly large repository of relationships that I routinely check. Unfortunately, given identical timeframes and data inputs, I couldn’t get values from the Calculator to correspond to the values I had.

    Problematic examples include wherever negative correlations existed (a number of our exchange-traded debt issues, preferreds, and currency ETFs routinely move against the market): I could never get a negative representation of *any* movement. Other examples were merely off – ranging from a few hundredths (SPY v TSM) to many tenths (SPY v DBA v MJF v HAP v XCJ). Further, while the problems were quite visible among ETF/equity/debt comparisons, I found that ETF/ETF comparisons were plagued, as well: SPY v VWO v VTI v SKF v SDS values are quite off, as are others.

    I was concerned that I might not be looking at what I need to in order to garner the most from your software. However, even after deconstructing what I’ve been using and rebuilding it I’m able to come much closer to the data presented in disclosure forms (long term) and via trend analysis (short term) than I’m able to glean from the Calculator.

    I really appreciate the attempt – thanks so much for trying. But I believe these issues need to be addressed.

    For reference, here are some test examples that failed:

    SPY v XCJ: r^2=.019 from 1/30/08-3/20/09.
    Values the calc yields: .5333/.4667/.5948/.4052

    SPY v BIL (BIL is an ultra short treasury tracker with, at times, and breathtakingly high negative correlation): r^-.90 from 1/30/08-3/20/09.
    Values the calc yields: .4444/.5556/.5686/.4314

    This tool would save me so much time – if you would look into my examples. What do you think? Thanks for your help…

    Best,
    Geoff

Leave a Comment