Ok, I just did another test in Excel and I'm not getting the same value as you are for the Longest Line.
I exported 60 minute interval data from Metatrader to csv, opened the file in excel, selected from 2008.05.01 to 2008.05.12 including, applied the mode function on the interval and got 1.5403
Again, "the mode is the value that occurs the most frequently in a data set".
So in my test, 1.5403 is the most common value at which eurousd traded throughout this month, with 6 occurrences, the first 4 on the 8th of the month, and the rest of 2 on the 9th of the month.
I applied the mode function on the close prices for each 60 minute interval.
What gives? What am I interpreting wrong?
1.5462 only has 2 occurrences so far, on the 9th of the month.
I exported 60 minute interval data from Metatrader to csv, opened the file in excel, selected from 2008.05.01 to 2008.05.12 including, applied the mode function on the interval and got 1.5403
Again, "the mode is the value that occurs the most frequently in a data set".
So in my test, 1.5403 is the most common value at which eurousd traded throughout this month, with 6 occurrences, the first 4 on the 8th of the month, and the rest of 2 on the 9th of the month.
I applied the mode function on the close prices for each 60 minute interval.
What gives? What am I interpreting wrong?
1.5462 only has 2 occurrences so far, on the 9th of the month.