NexusFi: Find Your Edge


Home Menu

 





Software to Calculate/Chart correlation from streaming data?


Discussion in Platforms and Indicators

Updated
      Top Posters
    1. looks_one maxplanck with 2 posts (0 thanks)
    2. looks_two cory with 1 posts (1 thanks)
    3. looks_3 Quick Summary with 1 posts (0 thanks)
    4. looks_4 Big Mike with 1 posts (1 thanks)
      Best Posters
    1. looks_one Big Mike with 1 thanks per post
    2. looks_two Zondor with 1 thanks per post
    3. looks_3 cory with 1 thanks per post
    4. looks_4 Lornz with 1 thanks per post
    1. trending_up 4,876 views
    2. thumb_up 4 thanks given
    3. group 4 followers
    1. forum 6 posts
    2. attach_file 0 attachments




 
Search this Thread

Software to Calculate/Chart correlation from streaming data?

  #1 (permalink)
maxplanck
Chicago IL
 
Posts: 19 since Sep 2011
Thanks Given: 12
Thanks Received: 4

I'm looking for software and a data feed that will allow me to calculate and chart the price correlation between two securities.

Currently I use Interactive Brokers, but I cannot do this w/ their Trader Workstation.

I'd like to do this w/ as high frequency data as is possible on a solo day trader's budget.

Generally, I'm trying to find the best combination of broker, data feed, software and API that provides fast execution, fast data, can calculate and display charts of price correlations, and will allow me to write my own algorithms for processing streaming data and charting these custom algorithms' output.

I'd like to be able to get very detailed w/ custom algorithms.. For example, I'd like to experiment w/ custom algorithms to calculate probabilities from streaming data along w/ historical data, using both price and volume as inputs.

I'm hoping to find the best, most full featured system(s) now, so that I don't spend my time learning a system that I will outgrow, then have to learn an entirely different system in order to progress further.

Thanks, any info is much appreciated

-Max

PS- I mainly trade the major ETFs: SPY, EEM, GLD, TLT, commodity ETFs, and eur.usd

Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
Cheap historycal L1 data for stocks
Stocks and ETFs
Trade idea based off three indicators.
Traders Hideout
How to apply profiles
Traders Hideout
ZombieSqueeze
Platforms and Indicators
 
  #3 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,465 since Jun 2009
Thanks Given: 33,242
Thanks Received: 101,665


You can do this with Sierra Chart, NinjaTrader, or MultiCharts platforms. All of them support popular brokerages for execution and/or data, like Rithmic, Zen Fire, TradingTechnologies, CQG, etc. You will find different FCM's and IB's that provide those services, just look through the Brokers section of nexusfi.com (formerly BMT).

You can use broker data or get a premium data feed like DTN IQFeed. Discussions as to why etc can be found on the forum.

As for the actual tool to compute the correlation, there are several already written for NinjaTrader on the forum to get you started, but you can write them for whatever platform just as easily, if they aren't already built-in.

With regards to an API, you can get the DTN IQFeed API if you want to do your own calculations outside of the major trading platform. You can also pull their data into Excel directly with their DDE. Other options include using Matlab to do the number crunching, and then send the order execution to the platform. Some platforms have API's for Matlab directly, such as CQG.

Mike



Join the free Markets Chat beta: one platform, all the trade rooms!

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #4 (permalink)
 
cory's Avatar
 cory 
virginia
 
Experience: Intermediate
Platform: ninja
Trading: NQ
Posts: 6,098 since Jun 2009
Thanks Given: 877
Thanks Received: 8,090

seem fast is of top priority, pick serrachart.

Reply With Quote
Thanked by:
  #5 (permalink)
 
Zondor's Avatar
 Zondor 
Portland Oregon, United States
 
Experience: Beginner
Platform: NinjatraderŽ
Broker: CQG, Kinetick
Trading: Gameplay KlownbineŽ Trading of Globex
Posts: 1,333 since Jul 2009
Thanks Given: 1,246
Thanks Received: 2,731

Links and Downloads Manager - [AUTOLINK]NinjaTrader[/AUTOLINK] Support Forum

To find it in the downloads section arrange the indicators by title in ascending order. This one should then show up on the second page. It's called Correltation.


Quoting 
Description
Plots the Correlation coefficient of two instruments (NT7 only)

The first instrument is the primary chart data series. The secondary instrument is specified by the parameter "Symbol2". The secondary instrument does not need to be plotted on the chart, but if it is, then "Symbol2" may be left blank and if will default to the second instrument displayed on the chart.

The "CorrelationType" parameter may be set as follows:
"Pearson": Pearson's Product-Moment Correlation (most common) (default)
"Rank": Correlation of the rank order of the data, also known as "Spearman"
"Residual": Correlation of the residuals (residual = error term = distance from a linear regression line through the data)
"PctChange": Correlation of the bar-to-bar percentage change

References:
Pearson:
https://en.wikipedia.org/wiki/Pearson...on_coefficient
Rank:
https://en.wikipedia.org/wiki/Spearman's_rank_correlation_coefficient

Exported using NT version 7.0.1000.3


Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #6 (permalink)
 
Lornz's Avatar
 Lornz 
Oslo, Norway
 
Experience: Advanced
Platform: CQG, Excel
Trading: CL
Posts: 1,193 since Apr 2010


maxplanck View Post
I'm looking for software and a data feed that will allow me to calculate and chart the price correlation between two securities.

Currently I use Interactive Brokers, but I cannot do this w/ their Trader Workstation.

I'd like to do this w/ as high frequency data as is possible on a solo day trader's budget.

Generally, I'm trying to find the best combination of broker, data feed, software and API that provides fast execution, fast data, can calculate and display charts of price correlations, and will allow me to write my own algorithms for processing streaming data and charting these custom algorithms' output.

I'd like to be able to get very detailed w/ custom algorithms.. For example, I'd like to experiment w/ custom algorithms to calculate probabilities from streaming data along w/ historical data, using both price and volume as inputs.

I'm hoping to find the best, most full featured system(s) now, so that I don't spend my time learning a system that I will outgrow, then have to learn an entirely different system in order to progress further.

Thanks, any info is much appreciated

-Max

PS- I mainly trade the major ETFs: SPY, EEM, GLD, TLT, commodity ETFs, and eur.usd

I don't know what your budget is, but you could check out RTS RTD Tango. It also has full connectivity to MATLAB.

Visit my NexusFi Trade Journal Reply With Quote
  #7 (permalink)
maxplanck
Chicago IL
 
Posts: 19 since Sep 2011
Thanks Given: 12
Thanks Received: 4

Thanks

Usually, w/ software there is one application for a given purpose that is least buggy, while still being very full featured. Is there any setup that you would particularly recommend?

I'm deep into the technical side of things, but you know how it is, you need a good system that runs reliably without problems, keeps technical issues out of your way, but allows you to configure things at a detailed level when you need to..

For example, I am a very technical person, but still I cannot stand to use Windows b/c it has so many errors and problems. I can fix a Windows PC, no problem and make it do anything, but having to fight the machine in order to make it work properly robs you of your time. I have to use Mac, it just works without me needing to go to war w/ it. (I realize that I will probably have to use Windows to run the trading software, this is just an example of a broader issue.)

I'm using IB's TWS now, from my perspective it is very buggy and lacking in features, although it's the best among the free software provided by brokerages that I've tried.

Reply With Quote




Last Updated on November 10, 2011


© 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