Click here to Login




Correlation of market indicators

Updated on 2010-05-11





In the previous post, which can be found here How to create a market timing system, we started to introduce a technique to create a market timing system using several market and composite indicators. We began by assembling market indicators and creating composite indicators using the composite plug-in, and then we used the rules analyzer to simulate various strategies. Finally, we picked the most profitable rules, the ones that may have a predictive power.

The first part was easy, the second won't be as easy, but it won't be very difficult either.

There is something important we need to consider; even if the rules we have gathered use different formulas, they may be highly correlated. In the next paragraph, we will calculate the correlation between the trading indicators and dismiss some of those with high correlation.

Create a new list of rules and add a new time series for each market indicator.
Example: for the number of stocks closing above their 10-bars moving average, you should create the following rule/time series:
GetSeries("_SMA10", close, LastData)

Click on "Mass Rules" to create several trading rules from the previously added time series. Your formulas should appear on the left panel. Under the "Masks" formula editor, type the following formula
correl(mask, mask1, 30) > 0.7
Then click on "Create Rules".

"Correl" is a QuantShare function that calculates the correlation between two vectors. The third parameter specifies the period to use in the calculation; in this example, the value is set to 30. The first and second parameters contain predefined variables that instruct the trading software to update these values with the rules that are specified in the left panel - the one you created.
The idea is to detect how many times or the number of bars where the correlation between two market indicators is higher than 70%. If the rule is true during a high number of bars, then we dismiss the indicator that have less predictive power, according to the simulations we did previously - in the older post.

To start the simulation process, click on "Analyze the list". There are not a lot of things that need to be changed. Make sure that your index ticker symbol is selected and then go the Outputs control. Uncheck all outputs, select the "N-Bar stop" and set the number of bars to zero.
When the report is complete, sort the table by the "Positions" Column; the higher the "Positions" value is, the more correlated the two time series are.
The "Positions" value represents the number of bars where the 30-bar correlation between the two time series is higher than 70%.

Note:
- Make sure that the indicators' first bar starts before the "Start Date" defined in the Analyzer Settings form.
- we could have created a metric to determine whether to accept or reject a time series depending on its correlation with other indicators.

You finally come up with a list of profitable and non-highly correlated market indicators. We will now combine these rules and that is what the next post will be about.











no comments (Log in)

QuantShare Blog
QuantShare
Search Posts




QuantShare
Recent Posts

Create Graphs using the Grid Tool
Posted 1461 days ago

Profile Graphs
Posted 1566 days ago

QuantShare
Previous Posts

Correlation of market indicators
Posted 5320 days ago

Backtesting Process
Posted 5334 days ago

Trading software new features
Posted 5340 days ago

Optimization of a trading system
Posted 5355 days ago

Short Index - Part 2
Posted 5390 days ago

Short Index - Part 1
Posted 5397 days ago


More Posts

Back







QuantShare
Product
QuantShare
Features
Create an account
Affiliate Program
Support
Contact Us
Trading Forum
How-to Lessons
Manual
Company
About Us
Privacy
Terms of Use

Copyright © 2024 QuantShare.com
Social Media
Follow us on Facebook
Twitter Follow us on Twitter
Google+
Follow us on Google+
RSS Trading Items



Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.