Closed

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
Employer working
Project Budget
$30 - $250 USD
Total Bids
8
Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online