|
Kansas City, KS
Posts: 4 since Jan 2013
Thanks Given: 0
Thanks Received: 0
|
Hi there folks - I'm interested in making a two custom indices from IBD's top 200 and bottom 200 stocks using a geometric average. I would like to conduct volume to range analysis on the individual issues, correlations between stocks in the other index, build/monitor pairs trades. In the beginning I would only need EOD data. Can I just pick an arbitrary number such as 5,000 or do I have to get a baseline number from the issues themselves? I'm not interested in a Market Cap index and obviously the stocks are rotated through these lists on a fairly regular basis.
Eventually I would like to add swing trading futures and do some statistical testing such as CL above 20 sma, two down days and close in lower 25% of range, how often is the low of day(0) violated, etc.
Can this be done in Excel? Should it be? If either Python or R are the better tool, which one and why? Thanks very much and I look forward to your answers.
|
