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

$30-250 USD

Inställt

Publicerad

över sju år sedan

$30-250 USD

Betalning vid leverans

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$

Software Architecture

Testing / QA

Windows Desktop

Project ID: 12244599

Om projektet

5 anbud

Distansprojekt

Senaste aktivitet sju år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

5 frilansar lägger i genomsnitt anbud på $107 USD för detta uppdrag

@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. Laissez-moi savoir si je peux être d'aide. Sergio

$80 USD Om 3 dagar

4,8

(64 omdömen)

6,7

@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. with thanks and regards

$144 USD Om 3 dagar

4,9

(12 omdömen)

4,3

@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 & Account system include 1c: ERP and more. I am a full time programmer with 20 year exp in Russia. I have hi degree in information system in economics.

$80 USD Om 2 dagar