Select DataBase tool+set-up assistance+Excel VBA retrieve data function
This project was awarded to kylehurt92 for $72 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
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$
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online