Cancelled

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$

Skills: Software Architecture, Testing / QA, Windows Desktop

See more: vba retrieve data from website, macro vba oracle database retrieve data, vba scrape data website excel, 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

About the Employer:
( 11 reviews ) Paris, France

Project ID: #12244599

Awarded to:

kylehurt92

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 More

$72 USD in 2 days
(2 Reviews)
0.6

7 freelancers are bidding on average $98 for this job

$155 USD in 3 days
(4 Reviews)
4.1
sonarkaushik

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. More

$144 USD in 3 days
(11 Reviews)
4.3
sergioeliot3

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. More

$80 USD in 3 days
(13 Reviews)
4.4
AntonBliznetc

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 More

$80 USD in 2 days
(8 Reviews)
2.3
fastwriter24

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, S More

$80 USD in 3 days
(0 Reviews)
0.0
jannesvw8

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 in 3 days
(0 Reviews)
0.0