Processing
Collecting data for Collecting data for GOOG,MSFT,YHOO,F,T,A,CRM,JPM,M

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.

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.

To create correlation table or cloud specify valid comma-separated symbols and hit Build It button.

Please note, the New York Stock Exchange (NYSE) and American Stock Exchange (AMEX) have recently merged. Although Macroaxis has implemented solutions to handle this transition gracefully, you may still find some securities that may not be fully transferred from one exchange to another.

Help

Correlation Analysis

View All Portfolios

More Actions
- Select Assests
- Optimize Portfolio
- Suggest Portfolio
- Backtest Watchlist
- Analyze Correlations
- View Transactions
- Check Volatilities
- Import Equities
- Search Equities

Investment horizon:

30 Days Login to change

Generate output as Table Cloud

Specify valid comma-separated symbols | Check world markets correlations | Check portfolio equities correlations

Build Correlation

	GOOG	MSFT	YHOO	F	T	A	CRM	JPM	MRK	XOM
GOOG		0.23	0.4	0.43	0.12	0.73	-0.1	0.27	0.02	0.47
MSFT	0.23		0.08	0.17	-0.31	0.03	-0.28	0.21	-0.13	0.31
YHOO	0.4	0.08		0.28	0.22	0.62	-0.3	0.42	0.21	0.34
F	0.43	0.17	0.28		0.2	0.38	-0.05	0.49	0.3	0.64
T	0.12	-0.31	0.22	0.2		0.22	0.04	0.1	0.2	0.12
A	0.73	0.03	0.62	0.38	0.22		0.12	0.45	0.08	0.31
CRM	-0.1	-0.28	-0.3	-0.05	0.04	0.12		-0.24	0.13	-0.07
JPM	0.27	0.21	0.42	0.49	0.1	0.45	-0.24		0.16	0.47
MRK	0.02	-0.13	0.21	0.3	0.2	0.08	0.13	0.16		0.29
XOM	0.47	0.31	0.34	0.64	0.12	0.31	-0.07	0.47	0.29

Click cells to compare fundamentals

Compare Fundamentals

Check Volatility

Backtest As Portfolio

Evaluating the first 10 symbols. Please upgrade your account to plot more symbols

Correlation Matchups

High positive correlations

A	+ 0.73	GOOG
XOM	+ 0.64	F
A	+ 0.62	YHOO
JPM	+ 0.49	F
XOM	+ 0.47	GOOG
XOM	+ 0.47	JPM
JPM	+ 0.45	A
F	+ 0.43	GOOG

Insignificant Correlation

CRM	- 0.05	F
XOM	- 0.07	CRM
CRM	- 0.1	GOOG
MRK	- 0.13	MSFT

MRK	+ 0.02	GOOG
A	+ 0.03	MSFT
CRM	+ 0.04	T
MRK	+ 0.08	A

High negative correlations

T	- 0.31	MSFT
CRM	- 0.3	YHOO
CRM	- 0.28	MSFT
JPM	- 0.24	CRM
MRK	- 0.13	MSFT
CRM	- 0.1	GOOG
XOM	- 0.07	CRM
CRM	- 0.05	F

Weakest Diversification

Strongest Diversification

Weakest Diversification

Assets performance indicators

	Mean Deviation	Jensen Alpha	Sortino Ratio	Treynor Ratio	Semi Deviation	Information Ratio	Expected Shortfall	Potential Upside	Value At Risk	Maximum Drawdown
GOOG	0.94	0.21	0.37	0.49	0.00	0.24	(1.33)	2.20	(0.95)	4.56	Backtest
MSFT	1.14	0.49	0.41	0.91	0.00	0.29	(1.55)	3.60	(1.15)	5.09	Backtest
YHOO	1.46	(0.01)	0.15	0.32	1.23	0.15	(1.74)	2.76	(2.06)	6.36	Backtest
F	1.13	0.16	0.39	0.41	0.00	0.29	(1.53)	3.01	(0.71)	4.70	Backtest
T	0.85	(0.37)	(0.19)	(0.13)	2.24	(0.32)	(0.63)	1.16	(1.32)	6.20	Backtest
A	1.01	(0.06)	0.04	0.28	1.15	0.04	(1.20)	2.16	(1.51)	5.40	Backtest
CRM	0.93	0.63	0.52	16.03	0.00	0.28	(1.42)	2.36	(0.48)	2.84	Backtest
JPM	0.95	0.11	0.13	0.42	0.47	0.14	(1.11)	1.99	(1.45)	3.77	Backtest
MRK	0.92	(0.42)	(0.34)	(0.20)	1.66	(0.42)	(0.80)	1.11	(1.71)	4.27	Backtest
XOM	0.73	(0.18)	(0.09)	0.18	0.72	(0.11)	(0.81)	1.37	(1.52)	3.04	Backtest

About correlation table

About correlation cloud

Correlation Analysis

Correlation Matchups

High positive correlations

Insignificant Correlation

High negative correlations

Weakest Diversification

Strongest Diversification

Weakest Diversification

Assets performance indicators

Thanks for checking out Macroaxis