Correlation between first 4 hour candle and daily candle

How to find out the correlation between first 4 hour candle of the day and daily candle for the last ten years. eg if first 4 hour candle of Eur/Usd was red was the daily candle also red or was it green?

sometimes I really wonder about the education level here on ff. You just download 4 hour data into excel and make an analysis in excel. You make some "if" formulas and put the results into a pivot table to see if there is a correlation or not.
If you don't know how to do that, then go to microsoft and do some excel courses.