This is a trading item or a component that was created using QuantShare by one of our members.
This item can be downloaded and used by QuantShare Trading Software.
Trading items are of different types. There are data downloaders, trading indicators, trading systems, watchlists, composites/indices...
You can use this item and hundreds of others for free by downloading QuantShare.
Top Reasons Why You Should Use QuantShare:
Works with US and international markets (stock, forex, options, futures, ETF...)
Offers you the tools that will help you become a profitable trader
Allows you to implement any trading ideas
Exchange items and ideas with other QuantShare users
Our support team is very responsive and will answer any of your questions
We will implement any features you suggest
Very low price and much more features than the majority of other trading software
The following Forex correlation trading item creates a correlation matrix between several currency pairs.
Correlation is a statistical measure of the relationship between two securities. It tells us whether two currency pairs are moving in the same, opposite or random direction.
Correlation values vary between -100% (Forex pairs move in the same direction) and 100% (Forex pairs move in the opposite direction).
The correlation is very high and it is colored in Green if its value is higher than 80%.
The correlation is very low and it is colored in Red if its value is lower than -60%.
This Forex correlation pivot table is based on the correlation of the last 30 trading days. Of course, you can update the formula and measure the correlation using another period (90 days for example) or in another time frame (example: hourly or 1-minute).
To update the formula, right click on the Forex/currency correlation table then select "Update Rows/Columns/Values".
In the "Values" panel, click on "Correl" then update the "Correl" function.
For example, to use a 90-day period, type:
Correl(perf(close, 1), perf(SYMBOL, 1), 30)*100
To change the default period, select the "Intraday" tab then choose "1h" time frame for example.
To modify the currency pairs list used in this Forex correlation matrix, select "Rows" and "Columns" fields then update the list of symbols. The current list includes the following currencies: AUDCAD, AUDJPY, EURCAD, EURCHF, EURUSD, USDCAD, USDCHF...
Here is the correlation table of 15 currency pairs in the foreign exchange market: