Macro Merge Data from Multiple Excel Workbooks --- Stock Data

[jonathonappleseed]

Hello,

I have downloaded a large quantity of NYSE data & would like to create a macro that allows me to compile summaries of a stock's history. The workbooks are separated by day, with each book listing the end of day data for every stock on the exchange (see below for exact format).

[TABLE="width: 448"]
<tbody>[TR]
[TD="width: 64"]Symbol[/TD]
[TD="width: 64"]Date[/TD]
[TD="width: 64"]Open[/TD]
[TD="width: 64"]High[/TD]
[TD="width: 64"]Low[/TD]
[TD="width: 64"]Close[/TD]
[TD="width: 64"]Volume[/TD]
[/TR]
</tbody>[/TABLE]

I need to create a summary for several specific stocks (preferably without having to open each file individually, search the symbol, & copy/paste the data into a summary). The format for the final summary workbook is:

[TABLE="width: 448"]
<tbody>[TR]
[TD="width: 64"]Date[/TD]
[TD="width: 64"]Open[/TD]
[TD="width: 64"]High[/TD]
[TD="width: 64"]Low[/TD]
[TD="width: 64"]Close[/TD]
[TD="width: 64"]Volume
[/TD]
[/TR]
</tbody>[/TABLE]

Any advice? Thank you!

 

[jonathonappleseed]

I found another data set that has this format. If anyone is interested, you can go to:

[url]http://www.google.com/finance/historical?output=csv&q={symbol}[/URL]

& download 1 year of stock data with the same format listed as above. Thanks anyway.