Downloading & Formating from Intrade

Final Project Write-up
I am currently working on an Honors thesis. This project will analyze the predictive accuracy of the contracts available on Intrade.com. These contracts are similar to betting in some ways, but are based on real world events rather than games of chance. The project requires huge amounts of data to be used in regression analysis.

The purpose of this VBA project is to assist me in the downloading, formatting, and compiling of data necessary for my Honors Thesis. I am doing a project that requires massive amounts of data, i.e. thousands of spreadsheets, that must be downloaded from the website Intrade.com. The data must be extracted, formatted, and compiled for use in Stata. As this would take me weeks to do manually, automating this task would save me a tremendous amount of work.

Note that the last four files are to be used to test the macro.

http://files.gove.net/shares/files/10f/dgarcia/Final_Write-up.pdf
http://files.gove.net/shares/files/10f/dgarcia/Project_Master_Macro.xlsm
http://files.gove.net/shares/files/10f/dgarcia/contract_6223_0.csv
http://files.gove.net/shares/files/10f/dgarcia/contract_6225_0.csv
http://files.gove.net/shares/files/10f/dgarcia/contract_6229_0.csv
http://files.gove.net/shares/files/10f/dgarcia/contract_652757_0.csv