These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 9, 2010

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 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 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.

No comments:

Post a Comment

Blog Archive