Quote from gummy:
Aha! Afraid to guess, eh?
My guess was way off!
Thanks to all who participated.
For the answer, check out:
http://www.gummy-stuff.org/perfect-correlation.htm#QUESTION
Quote from gummy:
Aha! Afraid to guess, eh?
My guess was way off!
Thanks to all who participated.
For the answer, check out:
http://www.gummy-stuff.org/perfect-correlation.htm#QUESTION
Quote from gummy:
And if they both have a positive change. Can the correlation be -1?
You'll have noticed that the question explicitly refers to the "correlation between returns".
) you chose the conditional variance of y to be zero. Your choice of b and mean(x) ensures a probable positive return for both stocks over the full time period.Actually, I invented ten random x- returns (a la NORMINV(), in Excel).... you chose the conditional variance of y to be zero.
Quote from gummy:
Actually, I invented ten random x- returns (a la NORMINV(), in Excel).
Then I generated the y-returns via:
y = ax + b (with your choice of "a" and "b").
The spreadsheet is available, to play with![]()
Many think (me included, until recently!) that (for example) Investopedia's explanation is okay, namely:
"Perfect positive correlation (a correlation co-efficient of +1) implies that as one security moves, either up or down, the other security will move in lockstep, in the same direction.".

That is why I mentioned CoIntegration which is a better estimate of co-movement of securities than correlation.Quote from gummy:
...
My purpose was to illustrate that it's possible for securities to go up and down together ... yet a correlation of -1.
Indeed, it's possible to go in opposite directions yet have a correlation = +1.
...
I tend to agree.... looking for any type of correlations between 2 stocks or two instruments is meaningless- be it spearman or pearson.
)Quote from gummy:
I tend to agree.![]()
However, if the returns of stock Y are uniquely determined by the returns of stock X as, for example, when
(y-returns) = (x-returns)^3
it's difficult to understand a statement that says they have a low correlation.
It's even more confusing (to me, at least) to see two stocks whose prices move up together
... and then find that their correlation is -100%.
Mamma mia!
(That's why I'd prefer Spearman to Pearson)