Đã Đóng

INTERACTIVE BROKERS TWS DDE API ORDERING IN EXCEL

this is for ordering through the interactive brokers system.

currently they offer an excel file called “[login to view URL]” which offers samples of order that can be routed through their system

i am trying to setup another “page” in that workbook (which can be downloaded off the internet but i've included as an attachment) where i can easily enter combination order…as in all three are executed at once at a certain price.

Example

1) Buy AAPL 1000 shares

2) Buy AAPL 10 x 150 sept put contracts

3) Sell AAPL 10 x 150 sept call contracts

all executed together AT ONCE AS A GROUP ORDER at 151.5 LIMIT ORDER, not three separate orders submitted at individual prices

i want to be able to execute the above by just entering the basic information

Buy AAPL 1000 shares

—>symbol: AAPL

—>shares: 1000

Buy AAPL 10 x 150 sept put contracts

—>symbol: AAPL

—>contracts: 10

—>buy/sell: buy

—>strike price: 150

—>type: put

Sell AAPL 10 x 150 sept call contracts

—>symbol: AAPL

—>contracts: 10

—>buy/sell: sell

—>strike price: 150

—>type: call

all executed together at 151.5 LIMIT ORDER

—>limit order price: 151.5

i want it as another page in the [login to view URL] workbook so i can easily link to cells from other spreadsheets and files to the individual boxes. example, the “symbol: AAPL” can be linked to another file so that it can automatically populate “AAPL”. i think it needs to have a quick way of obtaining the proper ID for the options contracts to execute and i'm unsure of the formats required to execute trades. might need to open a paper trading account to test it out.

i've included the [login to view URL] file for reference.

Kĩ năng: Excel, Investment Management

Về khách hàng:
( 0 nhận xét ) Pasadena, United States

ID dự án: #33694320

12 freelancer chào giá trung bình$342 cho công việc này

(126 Nhận xét)
6.8
AccountantArman

Sir, I am Accounting, Finance, Excel VBA Macro Advanced Level Expert having Experience of over 10 years. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant Thêm

$300 USD trong 1 ngày
(162 Nhận xét)
6.5
(33 Nhận xét)
6.4
(2 Nhận xét)
3.6
(1 Nhận xét)
2.4
wilfrednjorog

Hi! I am professional writer with the vast skills and qualifications necessary for this job. I have experience in Excel and Investment Management. I am confident that I can produce high-quality work that meets your s Thêm

$250 USD trong 3 ngày
(0 Nhận xét)
0.0
rashidamjad

Hi there, How are you? I can work with your project skills Excel and Investment Management. Upon reading your description file I am sure we can definitely pull it off once provided with detailed file of your requiremen Thêm

$650 USD trong 15 ngày
(0 Nhận xét)
0.0
Finewelth7

I Will work in the Excel is the best, I can't Understand What are you need in the details. Thanks & Regards

$400 USD trong 7 ngày
(0 Nhận xét)
0.0
rudrayadav470

Hello sir i am rudra yadav i have 3 years experience in excel and i know excel very well and i can do it too i hope you will give me work for excel you will not give any complaint chance thank you

$325 USD trong 7 ngày
(0 Nhận xét)
0.0
emiliesc

After careful review of your project outline, I am confident that I can provide a holistic solution for the project. I have performed many similar tasks in my current position and I am excited about the opportunity to Thêm

$375 USD trong 7 ngày
(0 Nhận xét)
0.0
bowwy78

Hi, I am familiar with in investment management (forex, indices, crypto, stocks) market with more than 10 years of professional experience.

$250 USD trong 7 ngày
(0 Nhận xét)
0.0
ranjeetsingh77

Hello sir I am Ranjeet Singh i am perfect data entry and Excel and ms word pad kya main aapka kaam kar sakta hu main aapka kaam time par can I do better

$325 USD trong 7 ngày
(0 Nhận xét)
0.0