I want to measure the relationship between pairs of time series over different time periods. I've been looking into correlation of time series and it seems to me that there isn't much point in finding the correlation between pairs of time series due to a number of issues (such as potential trends etc.). Is finding the correlation between two time series pointless, or is it still a decent indicator for the relationship between how the two time series move?
I've tried looking into cross-correlation. However ,that seems to require the two time series to be stationary - the problem is that I have more than 80 different time series per year, so having to look over various plots to check for stationarity isn't realistic so I instead decided to just settle with correlation.
Here's what I did to find the correlation between pairs of time series: Each time series had two columns, a date and a number which showed the inventory for an item in a shop. Different time series were for different items in the shop. Many of the time series had varying lengths: one series will have 200 days in a year while another will only have 30. I first found the days the two time series had in common and I then grouped these values/days together (for example if both items had an inventory on 02/03/2016 then this would go into the new subset) and then found the correlation between the inventory of the two different items.
Is this method correct?
EDIT: I've just been reading more into correlation between time series and I was wondering if someone could check this for me. According to this topic: https://quant.stackexchange.com/questions/489/correlation-between-prices-or-returns it looks like it would be better for me to find the correlation between two time series if I instead look at the variation of the inventory of the items rather than looking at both the time series normally. Would that be better or would it still be bad idea for me to do?
2nd Edit: Alternatively, what if I tried to find the correlation of the cumulative sums for both the time series? Would that be okay to do instead?