NexusFi: Find Your Edge


Home Menu

 





Custom Stock Indices; Python/Excel/R; stats


Discussion in Stocks and ETFs

Updated
    1. trending_up 1,216 views
    2. thumb_up 0 thanks given
    3. group 1 followers
    1. forum 1 posts
    2. attach_file 0 attachments




 
Search this Thread

Custom Stock Indices; Python/Excel/R; stats

  #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.

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
ZombieSqueeze
Platforms and Indicators
Request for MACD with option to use different MAs for fa …
NinjaTrader
NexusFi Journal Challenge - April 2024
Feedback and Announcements
My NT8 Volume Profile Split by Asian/Euro/Open
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Retail Trading As An Industry
58 thanks
Battlestations: Show us your trading desks!
55 thanks
NexusFi site changelog and issues/problem reporting
48 thanks
What percentage per day is possible? [Poll]
31 thanks
GFIs1 1 DAX trade per day journal
29 thanks






Last Updated on March 23, 2015


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts