Forex Factory (https://www.forexfactory.com/forum.php)
-   Trading Discussion (https://www.forexfactory.com/forumdisplay.php?f=11)
-   -   Correlation between first 4 hour candle and daily candle (https://www.forexfactory.com/showthread.php?t=381509)

fffx Aug 29, 2012 1:19pm | Post# 1

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?

Custos Aug 29, 2012 1:50pm | Post# 2

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.


© Forex Factory