Hi I figured the most computer savvy forum members would be in here... I have several hundred excel files: 2011-05-01.xls 2011-05-02.xls 2011-05-03.xls etc... Each file contains three columns, relating to one particular futures contract. [Time | Price | Volume] On average I guess there are around 50,000 rows of data in each file. Each file contains data for a particular day, and I have named each file as such. My question is this: *How can I create range bars? I understand the concept behind range bars, but while I am fairly Excel proficient, I am incapable of repackaging my raw data in such a way to create these range bars. Perhaps it is in fact impossible with Excel. I would very much appreciate some advice, if anyone is in a position to give it. Some secondary questions: *I would rather pile all of the data in to one large file. I did attempt to merge them all in to a Microsoft Access database, but the loading times were extreme and I encountered numerous crashes, and hit a brick wall with it. What would you do if you had 200 .xls files that you wished to analyze? *If Excel is not the appropriate software for working with this data, what alternatives exist? Thanks in advance.