# Contrasting effects on correlation between two variables with increase or change in dataset

I am trying to analyze two variables: Currency exchange rate and Stock price of a company. I am computing the correlation between them to determine whether the currency exchange rate has some effect on the stock price.

When I took the dataset for the year 2017-18, the correlation observed = 0.676.
For the year 2016-2017: -0.27.
And for the years 2013-2018: -0.412.

The correlation is almost inverted!

Now I have two questions:

1. Given the recent trend, is it safe to say that a growth in the exchange rate will positively effect the stock price (with > 0.5 probability)?
2. Is it because of the nature of the two variables i.e. the fact that the exchange rate is not the only factor determining the share price, that I am observing such contrasting results when the dataset size is increased/modified?

EDIT Including an image of the graph of the two variables as well(Orange: Exchange rate, White: Stock price):

• Since you only have two variables, do you want to plot and show it here? Jul 26, 2018 at 11:48
• @SmallChess Have included the graph as well. Jul 26, 2018 at 12:02
• @SmallChess Did it help? Jul 27, 2018 at 8:35

1. No. Whether an increase in exchange rate will have a positive effect on stock price is a causal question that cannot be answered from the data alone. Under the Pearlian framework of causal inference, it is possible to establish causation without an experimental intervention if you can control for all confounders, but for financial variables like this, that is very, very hard. If, on the other hand, you meant to ask whether the conditional probability of observing an increase in stock price given an increase in exchange rate is greater than 0.5 (an observational question), you can in principle get that from the data but will need something more sophisticated than linear correlation (see below).
2. Essentially, yes. However, there is also the possibility that there is simply low-frequency noise in the data that is independent of any variable you can measure.

Now, the larger issue may be that you are not using the right tools to analyze this kind of time series data, which is better modeled as a random process than random variable. You should look at the cross-correlation function to start. Also, if you want to establish "predictive causality" of exchange rate on stock price, you can look into Granger causality or transfer entropy. If you really want to quantify the probability of successful prediction, you will need to use a model that makes strong assumptions about the nature of the data-generating process.

However, the take-home message is that financial processes are very complex and difficult to predict. Even the predictions of top securities analysts on Wall Street often fail to do better than chance.

• Thanks for your answer. Let me go through the links you have posted and get back to you on it. It looks good. :) Jul 29, 2018 at 9:58