Encerrado

Data Import Program using API Calls

Help is needed to create a program to retrieve historical and "real-time" trading data using API calls to a locally-run trading program, save data in MS Access or MS SQL Server 2000, and present data on Excel. Codes shall be written in VBA (within MS Access and/or Excel) or .Net.

The documentation for API and sample codes is available at [url removed, login to view];ib_entity=llc. The trading program is available at [url removed, login to view];ib_entity=llc. We will provide test user account.

The concerned financial product XYZ has the following attributes:

(1) Time-Dimension (X-axis):

XYZ and its derivatives (see below) are traded daily on the futures market. The prices need to be charted along this time dimension (X-axis);

(2) ExpirationDate-Dimension (Y-axis)

XYZ exists and traded in multiple forms in terms of “expiration date”. You can treat each one of them as independent product.

a. XYZ for delivery now (“spot price”);

b. XYZ future contract for delivery in 30 days;

c. XYZ future contract for delivery in 60 days;

d. XYZ future contract for delivery on a specific date, that is M-month from now (M=1~7);

e. Spreads of XYZ futures (yes, the spreads are traded as separate products on the market).

(3) Price-Dimension (Z-axis)

XYZ and its derivatives above have the following price information for a time segment (1 minute, 5 minutes, or a day, etc.)

a. Ask Price (the highest price a buy is willing to pay)

b. Bid Price (the lowest price a seller is willing to sell)

c. Last Price (the last actual transaction price in a time segment)

d. High Price (the highest traded price in a time segment)

e. Low Price (the lowest traded price in a time segment)

The System Requirements:

(1) Retrieve historical 1-minutes data for XYZ and its derivatives using API,

(2) Save and update data on MS Access (preferred) or MS SQL Server 2000.

(3) Present data in Excel for M-days with N-minutes data; (M=1~90 days, and N=1 minute~1 day)

The purpose of this data import program is to enable a user to create 2D and 3D charts on Excel to view the trading data for research.

Thanks!

Habilidades: .NET, Excel, SQL

Ver mais: excel data import calls, x-axis, sample system using php, sample of delivery contract, sample delivery contract, program 3d, price for vba for excel, os independent, ms access excel vba, future of market research, en save, dimension data, data forms in excel, contract in excel, contract excel, buy codes, access vba.net, 3d program, create auto import program using excel, import data excel sql porgram, import data using data contracts, net excel import api, trading program excel, sql 2008, programme using api

Acerca do Empregador:
( 1 comentário ) Chicago, United States

ID do Projeto: #458363

24 freelancers estão ofertando em média $176 para este trabalho

ambar

Dear Sir/Madam, Please check my private message. Thanks Shome.

$225 USD in 7 dias
(46 Comentários)
7.3
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

$250 USD in 15 dias
(80 Comentários)
6.3
SigmaVisual

We can help in your project, please check PMB to see our related experience.

$150 USD in 3 dias
(33 Comentários)
6.1
nmppatel

I am a VBA expert. I have very good experience with VBA Excel. I have completed many projects in VBA skill on GAF. I also have experience with .Net. I will provide quick & professional service.

$225 USD in 4 dias
(26 Comentários)
5.0
VLADNOVA

I have such experience. Will be glad to get it done for you. Respectfully. Vlad

$215 USD in 3 dias
(9 Comentários)
4.8
priyadarshinitec

Hi We are a team of expert coders with more than 7 years of coding experience in Microsoft technologies (Dot Net 1.1 & 2.0), PHP/MySQL, Web services, AJAX, XML, CSS, HTML, DHTML etc. We analyzed your requirements and w Mais

$250 USD in 25 dias
(7 Comentários)
4.5
gvyshnya

Please see more details in PM.

$200 USD in 10 dias
(9 Comentários)
4.1
matiur

Hi, I'm interested to work on this. Thanks, Matiiur

$200 USD in 5 dias
(5 Comentários)
4.1
Yurilad

I can help you.

$140 USD in 7 dias
(7 Comentários)
4.0
YankoNik

Hello I'm a Microsoft certificated professional with 10 years c/c++ windows programing. I can develop application with professional quality.

$250 USD in 20 dias
(6 Comentários)
2.4
guruplus

Hi Please refer my pmb Regards

$180 USD in 7 dias
(1 Comentário)
1.9
umair16

sir I can do this task easily.

$30 USD in 10 dias
(0 Comentários)
0.0
shaub

I have a few questions, please see private message.

$250 USD in 7 dias
(0 Comentários)
0.0
tken22

Ignore download of the data to MS Access and store only in Excel. Save time and speed up the reporting.

$95 USD in 3 dias
(0 Comentários)
0.0
benylkwok

I interested in your project. I can deliver it within 7 days.

$100 USD in 7 dias
(0 Comentários)
0.0
Hsofttech

Hi, We are ready for this job. Thanks Hsofttech Team

$120 USD in 3 dias
(0 Comentários)
0.0
synerecis

Please check PMB for bid details. regards, -Kshitij.

$250 USD in 14 dias
(0 Comentários)
3.0
jaymin009

Hi, I have such experience and really looking forward for your work.

$100 USD in 10 dias
(0 Comentários)
0.0
helenalice

please check pmb

$200 USD in 0 dias
(0 Comentários)
0.0
geekonweb

Hi .. I have over 8 years of working experience with Microsoft Technologies. Can do your job easily.

$150 USD in 7 dias
(0 Comentários)
0.0