Custom Stock Indices; Python/Excel/R; stats

Discussion in Stocks and ETFs

Updated March 23, 2015

1,743 views
0 thanks given
1 followers

Search this Thread

R; stats

burton1995 · 2015-03-23T20:24:19-04:00

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.

March 23rd, 2015, 08:24 PM	#1 (permalink)
burton1995 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.