Data Import Program using API Calls

Closed Posted Jun 26, 2009 Paid on delivery
Closed Paid on delivery

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!

.NET Excel SQL

Project ID: #458363

About the project

24 proposals Remote project Active Aug 25, 2009

24 freelancers are bidding on average $176 for this job

ambar

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

$225 USD in 7 days
(46 Reviews)
7.3
schandraram

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

$250 USD in 15 days
(80 Reviews)
6.3
SigmaVisual

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

$150 USD in 3 days
(33 Reviews)
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 days
(26 Reviews)
5.0
VLADNOVA

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

$215 USD in 3 days
(9 Reviews)
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 More

$250 USD in 25 days
(7 Reviews)
4.5
gvyshnya

Please see more details in PM.

$200 USD in 10 days
(9 Reviews)
4.1
matiur

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

$200 USD in 5 days
(5 Reviews)
4.1
Yurilad

I can help you.

$140 USD in 7 days
(7 Reviews)
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 days
(6 Reviews)
2.4
guruplus

Hi Please refer my pmb Regards

$180 USD in 7 days
(1 Review)
1.9
haribagra

Hi, I am a Microsoft Certificated Professional worknig for No 1 MNC and our Clint is Microsoft. I have 4.5 years of experience in IT Industry. I can deliver the code/application Quality and ZERO defects.

$200 USD in 7 days
(0 Reviews)
0.0
aspiresc

Please check PM for details

$250 USD in 15 days
(0 Reviews)
0.0
geekonweb

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

$150 USD in 7 days
(0 Reviews)
0.0
helenalice

please check pmb

$200 USD in 0 days
(0 Reviews)
0.0
synerecis

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

$250 USD in 14 days
(0 Reviews)
3.0
jaymin009

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

$100 USD in 10 days
(0 Reviews)
0.0
Hsofttech

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

$120 USD in 3 days
(0 Reviews)
0.0
benylkwok

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

$100 USD in 7 days
(0 Reviews)
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 days
(0 Reviews)
0.0