Originally Posted by
;
Ok, I just did another test in Excel and I'm not receiving the exact same value as you're for the Longest Line.
I exported 60 minute period information from Metatrader into csv, opened the file in excel, chosen from 2008.05.01 into 2008.05.12 such as, applied the manner function on the period and got 1.5403
Again, the manner 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 initial 4 to the 8th of this month, and the rest of two on the 9th of this month.
I applied the manner function on the close prices for every 60 minute period.
What's? What am I translating incorrect?
1.5462 only has two occurrences up to now, on the 9th of this month.