We have a table of financial data hosting time series of stock prices. The table is currently in an Excel sheet the size of which (20Mo) makes it difficult to manipulate.
Task1- Select a relevant data base tool to host this table considering the following :
- Free / open source tool,
- That can be easily interrogated from Excel
- That could also be used later-on to power a web based tool
- Reasonnably user friendly
Deliverable : a one page doc describing the tool and justifying it's appropriateness in light of the above requirements ;
Task 2- Provide help to set up the database and include the table in it.
Deliverable : Live help + one page user guide
Task 3- Build a UDF VBA Excel function to retrieve data from the DB into excel.
Excel function would be :
GetPrices(StockCode ; startdate ;enddate)
The budget for this is 80$ broken down into 3 milestones :
Task 1 : 20$
Task 2 : 20$
Task 3 : 40$