I need two macros written to automate the loading of data into Excel. My data is in two different directory structures.
This is historical financial data.
In both cases, the user will have cells in the main excel sheet that will have the stock symbol, and quote date as entry fields. Both macros will locate the proper data and import it into excel. The only difference in the macros is that the file directory structure is different. In both cases, the file is in CSV format.
Case 1: There is one directory that has one file for each date. The file has over 170,000 rows of data in it (bigger than excel can handle). This macro needs to read in the data and pick out the only the data related to a particular stock symbol and place it into the excel spreadsheet. Each stock symbol has an average of 30 rows of data.
Case 2: There is one directory for each stock symbol. In the stock directories is one file per quote date. The macro simply needs to construct the proper file path to the data and import it.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Excel, VBA