Suljettu

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!

Taidot: .NET, Excel, SQL

Näytä lisää: excel data import calls, sample system using php, sample delivery contract, program 3d, os independent, future market research, en save, dimension data, contract excel, buy codes, 3d program, net excel import api, trading program excel, sql 2008, programme using api, import xyz excel, microsoft access 2003, net developer hourly rates, vba codes, p sql, p 3d, excel vba help, api contract

About the Employer:
( 1 review ) Chicago, United States

Projektin tunnus: #458363

24 freelanceria on tarjonnut keskimäärin 176 $ tähän työhön

ambar

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

225 $ USD 7 päivässä
(46 arvostelua)
7.3
schandraram

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

250 $ USD 15 päivässä
(80 arvostelua)
6.3
SigmaVisual

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

150 $ USD 3 päivässä
(33 arvostelua)
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 4 päivässä
(26 arvostelua)
5.0
VLADNOVA

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

215 $ USD 3 päivässä
(9 arvostelua)
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 Lisää

250 $ USD 25 päivässä
(7 arvostelua)
4.5
gvyshnya

Please see more details in PM.

200 $ USD 10 päivässä
(9 arvostelua)
4.1
matiur

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

200 $ USD 5 päivässä
(5 arvostelua)
4.1
Yurilad

I can help you.

140 $ USD 7 päivässä
(7 arvostelua)
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 20 päivässä
(6 arvostelua)
2.4
guruplus

Hi Please refer my pmb Regards

180 $ USD 7 päivässä
(1 arvostelu)
1.9
umair16

sir I can do this task easily.

30 $ USD 10 päivässä
(0 arvostelua)
0.0
shaub

I have a few questions, please see private message.

250 $ USD 7 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
0.0
benylkwok

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

100 $ USD 7 päivässä
(0 arvostelua)
0.0
Hsofttech

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

120 $ USD 3 päivässä
(0 arvostelua)
0.0
synerecis

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

250 $ USD 14 päivässä
(0 arvostelua)
3.0
jaymin009

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

100 $ USD 10 päivässä
(0 arvostelua)
0.0
helenalice

please check pmb

200 $ USD 0 päivässä
(0 arvostelua)
0.0
geekonweb

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

150 $ USD 7 päivässä
(0 arvostelua)
0.0