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.


Taidot: .NET, Excel, SQL

Näytä lisää: 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, 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

Tietoa työnantajasta:
( 1 arvostelu ) Chicago, United States

Projektin tunnus: #458363

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


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

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

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

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

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

150 $ USD 3 päivässä
(33 arvostelua)

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)

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

215 $ USD 3 päivässä
(9 arvostelua)

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)

Please see more details in PM.

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

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

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

I can help you.

140 $ USD 7 päivässä
(7 arvostelua)

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)

Hi Please refer my pmb Regards

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

sir I can do this task easily.

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

I have a few questions, please see private message.

250 $ USD 7 päivässä
(0 arvostelua)

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)

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

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

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

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

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

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

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

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

please check pmb

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

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)