Design and create an Excel spread sheet to be used as an API for Interactive Brokers

Completed Posted Dec 17, 2013 Paid on delivery
Completed Paid on delivery

Hello,

I'm looking for someone to work in excel and build/modify an API (example attached) that includes the information detailed below. It must have the functionality to display all current open positions automatically and include the following data/columns. The information to calculate this is currently pushed into the API anyway (API example is attached).

Ticker symbol (for example: AAPL) (standard macro from the attached example)

Description (for example: Apple) (standard macro from the attached example)

Expiry (for example: 2013/07/19) (standard macro from the attached example)

Contract type (for example: 640 Put) (standard macro from the attached example)

Position (for example = –1 (short one contract)) (standard macro from the attached example)

Average price (for example 0.32) (standard macro from the attached example)

Bid/Ask (for example: [url removed, login to view]) (standard macro from the attached example)

Spread of bid/ask (for example: 0.13 Cents) –> formula = ask price minus bid price = spread value. (non-standard macro needs coding)

Mid-price of spread -> formula = ask price plus bid price divided by 2 = mid-price. (non-standard macro needs coding)

P/L based on Mid price (formula for short positions = Average price minus current mid-price) (formula for long positions = Current mid-price minus Average price )

Credit received (formula = average price of credits minus average price of debits = total credit )

Current % of maximum profit (formula = current credit divided by total credit *100) current credit is calculated by using the Mid price of spread.

All the above columns need to group each asset separately and have a sub total P/L of each asset.

Please feel free to ask any questions

Excel

Project ID: #5237498

About the project

4 proposals Remote project Active Dec 19, 2013

Awarded to:

ksavin

Hello. I have the TWS installed and an IB account. I also have experience working with their API (a full-scale trading system in C# working through the IB Gateway). It should not be a problem to make your spreadsheet w More

$110 USD in 4 days
(4 Reviews)
2.6

4 freelancers are bidding on average $115 for this job

vbexcel

I can help. I am an Excel / VBA coder pro with over ten years experience in developing automated, Excel based applications. I have specific experience in modifying Interactive Brokers VBA code. I integrated their pl More

$110 USD in 3 days
(27 Reviews)
5.4
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$166 USD in 10 days
(23 Reviews)
4.9