Custom Stock Indices; Python/Excel/R; stats - Stocks and ETFs Trading | futures trading

Go Back

> Futures Trading, News, Charts and Platforms > Traders Hideout > Stocks and ETFs Trading

Custom Stock Indices; Python/Excel/R; stats
Started:March 23rd, 2015 (08:24 PM) by burton1995 Views / Replies:334 / 1
Last Reply:March 23rd, 2015 (08:24 PM) Attachments:0

Welcome to

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike

Thread Tools Search this Thread

Custom Stock Indices; Python/Excel/R; stats

Old March 23rd, 2015, 08:24 PM   #1 (permalink)
Trading Apprentice
Kansas City, KS
Futures Experience: Beginner
Platform: MB Trading
Favorite Futures: equity, and commodity
Posts: 4 since Jan 2013
Thanks: 0 given, 0 received

Custom Stock Indices; Python/Excel/R; stats

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

Old March 23rd, 2015, 08:24 PM   #2 (permalink)
Quick Summary
Quick Summary Post

Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.


Reply > Futures Trading, News, Charts and Platforms > Traders Hideout > Stocks and ETFs Trading > Custom Stock Indices; Python/Excel/R; stats

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

NinjaTrader 8: Programming Profitable Trading Edges w/Scott Hodson

Elite only

Anthony Drager: Executing on Intermarket Correlations & Order Flow, Part 2

Elite only

Adam Grimes: Five critically important keys to professional trading

Elite only

Machine Learning Concepts w/FIO member NJAMC

Elite only

MarketDelta Cloud Platform: Announcing new mobile features

Dec 1

NinjaTrader 8: Features and Enhancements

Dec 6

Similar Threads
Thread Thread Starter Forum Replies Last Post
How-to have custom stats show up in MultiCharts optimization report? JHall65 MultiCharts 5 May 10th, 2014 04:09 PM
Why I'm Still Skeptical On Key Stock Indices Quick Summary News and Current Events 0 November 14th, 2013 11:30 AM
Excel Help with calculating averages with custom input RM99 Psychology and Money Management 15 July 31st, 2012 04:23 PM
Stock scanner on their server with my custom scripts dimkdimk Stocks and ETFs Trading 8 June 3rd, 2012 12:13 PM
US Stock Indices: ES, NQ and YM ("intermarket analysis") ikeaboy Index Futures Trading 3 December 17th, 2010 01:38 PM

All times are GMT -4. The time now is 09:25 AM.

Copyright © 2016 by 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.
no new posts

Page generated 2016-10-26 in 0.06 seconds with 19 queries on phoenix via your IP