Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Software to Calculate/Chart correlation from streaming data?
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
Can you help answer these questions from other members on NexusFi?
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.
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.
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.