I worked on and off with sorting the data for the hourly candles for awhile and finally got that down. Thanks NTW and everyone else that wrote out the steps. Now that I have figured out the hourly stuff, I was wondering if you could explain a little more how to arrange the tick data in excel.
You mentioned that now that we knew how to arrange the hourly stats we should be able to organize the tick data. I looked all over online for examples of how people are using tick data to find out the PNR, but almost nothing comes up with anything remotely helpful in that area. I understand what the PNR is trying to do, but do not know how to go about it using the same logic that was used on the hourly examples.
Thanks
Vandal
P.S. gotta love that rick roll