Select DataBase tool+set-up assistance+Excel VBA retrieve data function

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$

Habilidades: Arquitectura de software, Verificación / QA, Windows Desktop

Ver más: vba retrieve data from website, macro vba oracle database retrieve data, vba scrape data website excel, excel, database administration, database development, node.js, vba conditional data lookup excel, vba as400 connection string retrieve data excel, retrieve data internet excel macros, retrieve data headers excel sheet dataset, retrieve data outlook excel, vba retrieve data email, retrieve data database excel vba, vba html data convert excel, vba import data project excel, perl script retrieve data excel

Información del empleador:
( 11 comentarios ) Paris, France

Nº del proyecto: #12244599

Adjudicado a:


Hi, I would do this over a period of 2 days and as an experienced system admin for 6 years, I have dealt with different database tools and types. I would suggest with you wanting to go web based that we should use M Más

$72 USD en 2 días
(2 comentarios)

6 freelancers están ofertando el promedio de $101 para este trabajo


Bonjour! Je suis connaisseur des bases de donnés, il n'importe quelle (MySql, MsSQl, ...), donc je peux faire qu'Excel, il fait une connection avec eux. Je peut aussi préparer pour vous votre VBA code réquis. Más

$80 USD en 3 días
(28 comentarios)
$155 USD en 3 días
(4 comentarios)

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. Más

$144 USD en 3 días
(11 comentarios)

Hi, I am interested in your project. Need more info about 1) you need for coding web site? or for fast used like excel over internat? I use Delphi & SQL for Account, CRM, ERP task form 1996 year. I have exp on ERP Más

$80 USD en 2 días
(12 comentarios)

Hi, I have a lot of experience with excel and I would like to set up your database. Please contact me. Kind regards, Jannes Van Wonterghem

$77 USD en 3 días
(0 comentarios)