30 Days Moving Correlation Matrix

Build Matrix

Specify up to 15 valid comma-separated symbols having historical data

Generate output as Table Cloud

	XTMXL.MC	DIN.MC	RIO.MC	ELE.MC	DERM.MC	XPBR.MC	REN.MC	XBFR.MC
XTMXL.MC		-0.42	-0.14	0.31	0.57	0.4	0.62	0.29
DIN.MC	-0.42		0.15	0.19	-0.28	-0.17	-0.4	0.11
RIO.MC	-0.14	0.15		0.12	0.1	-0.09	-0.22	0.02
ELE.MC	0.31	0.19	0.12		0.48	0.74	0.44	0.56
DERM.MC	0.57	-0.28	0.1	0.48		0.76	0.65	0.45
XPBR.MC	0.4	-0.17	-0.09	0.74	0.76		0.73	0.61
REN.MC	0.62	-0.4	-0.22	0.44	0.65	0.73		0.28
XBFR.MC	0.29	0.11	0.02	0.56	0.45	0.61	0.28

Hover over cells for correlations between individual assets, or click to compare fundamentals

{ Risk / Return Back-testing }

Correlation Matchups

How to use this Correlation Matrix?

High positive correlations

XPBR	+ 0.76	DERM
XPBR	+ 0.74	ELE
REN	+ 0.73	XPBR
REN	+ 0.65	DERM
REN	+ 0.62	XTMXL
XBFR	+ 0.61	XPBR
DERM	+ 0.57	XTMXL
XBFR	+ 0.56	ELE
DERM	+ 0.48	ELE
XBFR	+ 0.45	DERM
REN	+ 0.44	ELE
XPBR	+ 0.4	XTMXL
ELE	+ 0.31	XTMXL
XBFR	+ 0.29	XTMXL

Recommended Pairs

XPBR	- 0.09	RIO
RIO	- 0.14	XTMXL
XPBR	- 0.17	DIN
REN	- 0.22	RIO
DERM	- 0.28	DIN

XBFR	+ 0.02	RIO
DERM	+ 0.1	RIO
XBFR	+ 0.11	DIN
ELE	+ 0.12	RIO
RIO	+ 0.15	DIN
ELE	+ 0.19	DIN
XBFR	+ 0.28	REN

High negative correlations

DIN	- 0.42	XTMXL
REN	- 0.4	DIN
DERM	- 0.28	DIN
REN	- 0.22	RIO
XPBR	- 0.17	DIN
RIO	- 0.14	XTMXL
XPBR	- 0.09	RIO

Why correlation coefficient is important?

An investor can reduce portfolio risk simply by holding instruments which are not perfectly correlated. In other words, investors can reduce their exposure to individual asset risk by holding a diversified portfolio of assets. Diversification will allow for the same portfolio return with reduced risk. If all the assets of a portfolio have a correlation of 1, i.e., perfect correlation, the portfolio volatility (standard deviation) will be equal to the weighted sum of the individual asset volatilities. Hence the portfolio variance will be equal to the square of the total weighted sum of the individual asset volatilities. If all the assets have a correlation of 0, i.e., perfectly uncorrelated, the portfolio variance is the sum of the individual asset weights squared times the individual asset variance (and volatility is the square root of this sum). If correlation is less than zero, i.e., the assets are inversely correlated, the portfolio variance and hence volatility will be less than if the correlation is 0. Learn more...

About correlation table

Correlation table is a two-dimensional matrix that shows correlation coefficient between pairs of securities. The cells in the table are color-coded to highlight significantly positive and negative relationships.

About correlation cloud

Correlation cloud is a flat representation of correlation coefficients between pairs of securities. The links in the cloud are color-coded to highlight significantly positive and negative relationships.

References

Modern Portfolio Theory From Wikipedia, the free encyclopedia Learn About Modern Portfolio Theory (MPT)
Markowitz, Harry M. (1952). Portfolio Selection, Journal of Finance, 7 (1)
Sharpe, William F. (1964). Capital asset prices: A theory of market equilibrium under conditions of risk, Journal of Finance, 19(3)
Lintner, J. (1965). The Valuation of Risk Assets and the Selection of Risky Investments in Stock Portfolios and Capital Budgets, The Review of Economics and Statistics, 47 (1), 13-39
Burmeister E and Wall KD., The arbitrage pricing theory and macroeconomic factor measures, The Financial Review, 21:1-20, 1986
Chen, N.F, and Ingersoll, E., Exact pricing in linear factor models with finitely many assets: A note, Journal of Finance June 1983
Fama, E. and French, K. (1992). The Cross-Section of Expected Stock Returns, Journal of Finance, June 1992, 427-466
Black, F., Jensen, M., and Scholes, M. The Capital Asset Pricing Model: Some Empirical Tests, in M. Jensen ed., Studies in the Theory of Capital Markets. (1972)
French, C. W. (2003). "The Treynor Capital Asset Pricing Model", Journal of Investment Management, 1 (2), 60-72
Lintner, J. (1965). The valuation of risk assets and the selection of risky investments in stock portfolios and capital budgets, Review of Economics and Statistics, 47 (1), 13-37
Markowitz, Harry M. (1999). The early history of portfolio theory: 1600-1960, Financial Analysts Journal, 55 (4)
Tobin, James (1958). Liquidity preference as behavior towards risk, The Review of Economic Studies, 25 Treynor, J. L. (1961). "Market Value, Time, and Risk." Unpublished manuscript.
Treynor, J. L. (1962). "Toward a Theory of Market Value of Risky Assets." Unpublished manuscript.

Other Resources

Robust Portfolio Optimization and Management by Frank J. Fabozzi, Petter N. Kolm, Dessislava Pachamanova, Sergio M. Focardi
Portfolio Optimization and Performance Analysis by Jean-Luc Prigent
Option Pricing and Portfolio Optimization by Ralf Korn, Elke Korn
Portfolio optimizations in incomplete financial markets by Walter Schachermayer
Bond Portfolio Optimization by Michael Puhle
An MCDM approach to portfolio optimization by M. Ehrgott, K. Klamroth, C. Schwehm

Efficient Frontier

14843 global portfolios

Optimize

Sharpe Ratios

				DERMOESTETICA		0.01
				MINERSA		0.00
				INVERFIATC		0.00
				UNION		0.00
				INMOB		0.12
				GRASVER		0.00
				JAZZTEL		0.34
				BRADESCO		0.04
				BTLMC		0.00
				CEMENTOS		0.28
				INVERFIATC		0.00
				VERTICE		0.22
				AYCO		0.00
				INVERPYME		0.00
				SOGECABLE		0.00
				13843601BC		0.00
				CIRCULO		0.00
				JOAQUIN		0.00
				BEFESA		0.22
				CINSA		0.00