Hi everyone

I would like to find certain correlation patterns in data so i will try to explain exactly what I am lookin for.

Suppose your data looks like this:

Price1 Price2

26,29 24,03
26,39 24,47
26,53 24,75
26,15 25,20
26,25 25,29
25,86 25,20
25,71 25,29
25,39 25,00
25,60 24,84
25,42 24,56
25,49 24,04
25,53 23,82
25,55 23,88
25,71 23,54
25,81 23,25
25,33 23,36
25,57 23,43
25,93 23,74
26,12 23,78
26,07 24,14
26,19 23,95
26,16 23,95

Now i would like to know if you can program excel to find for example when if price 2 went up when price 1 went up or the other way around. Also if price1 in first 5 days went up, did price 2 went up?

I really hope somone can help me
Thanks in advance