I need an Excel spreadsheet application to analyze fairly large amounts of historic stock price data.
There are approximately 200 stock symbols covering approximately 500 days of data and 8-10 data points per symbol (open high low close Volume etc,) - I provide the data
I need macros or VBA code that can help answer questions like:
for stock symbol A, for the time period of April 1-5, what was the max value and min value, which occured first during that period; and a few more queries like this
I prefer not to use a database application for this because of my personal learning curve, I know how to use Excel
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Windows XP Professional and Office XP (Excel)