Custom basket trading interface VBA/Excel 2013 to IB TWS API

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

Currently placing market orders through IB TWS BasketTrader with separate csv files for 6 segregated client accounts. Need to integrate the task to one Excel interface/worksheet. Column A contains the list of desired symbols separated by short and long. All intraday market orders with specific entry/exit times per account. US regular trading hours only 0930-1600 EST.

The intention is to toggle/click AUTO ALL before market open and have positions automatically scheduled to open at desired Entry Time(s) and closed at desired Exit Time(s). Toggle meaning like click to turn on, and click to turn off, like a button. The individual AUTO Cells should all turn on when AUTO ALL is toggled on, but also allow for turning on/off individually if desired. Also, CLOSE ALL will not function as an on/off toggle, but as a button that should instantly execute the closing of all positions in all accounts by manually clicking it. The individual CLOSE buttons will function the same way, but instantly execute the closing of all positions in selected client account/column. Ideally that would happen with the AUTO/AUTO ALL buttons in off positions to avoid conflict.

Upon, opening file, VBA/Excel needs to establish auto-login to all the client accounts. Also need Excel/VBA to send an email alert from my Comcast SMTP email account/login, to two other email addresses if any cell values in Open Positions (cell N15:S15) change between 0930-1600 EST, regardless of client account. I don't want to use MS Outlook.

The attached image is my prototype. Recommended improvements are appreciated.

Cell A2:A3- Short E-mini futures routed IB-GLOBEX

Cell A4:A15- Short equities routed IB-SMART

Cell A17:A36- Long equities routed IB-SMART

Column C- Desired quantities for the above

Column B,D,E- Irrelevant for this project/Informational

Column F-K- Segregated IB accounts (1-6) with desired symbol/quantity row marked X

Cell N3:S3- API socket port (informational)

Cell N5:S5- Account ID/Number (informational)

Cell N7:S7- Buying Power for each account from IB API

Cell N9:S9- Market Value (portfolio) for each account from IB API

Cell N11:S11- Open PNL (portfolio) for each account from IB API

Cell N13:S13- Realized PNL (portfolio) for each account from IB API

Cell N15:S15- Open Positions for each account from IB API

Cell N17:S17- Desired Entry times for each client account (input)

Cell N19:S19- Desired Exit times for each client account (input)

Cell N22:S22- Toggle (on/off)/AUTO basket for each account

Cell N24:S24- Button/CLOSE all positions for each account

Cell N27:O28- Toggle (on/off)/AUTO ALL baskets for ALL accounts

Cell R27:S28- Button/CLOSE ALL positions for ALL accounts

API Excel Visual Basic

Identifikační číslo projektu: #18199744

O projektu

9 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

wiredc5

Hi there, I read your project and it is interesting, in fact I have built several IB projects integrated with Excel similar to this one you posted. I am an IT engineer and I work exclusively with International Market Další

$700 USD za 10 dní
(5 recenzí)
5.1

9 Freelnceři na tento projekt zveřejňují nabídky v průměru $377

dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

$250 USD za 10 dní
(44 Recenzí)
5.1
akritisood94

I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main S Další

$307 USD za 10 dní
(34 Recenzí)
4.6
dataexplorer

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Další

$250 USD za 5 dní
(18 Recenzí)
4.2
goalscoreplayer

Hello, how are you? You have meet earlier with me. I have checked your project description carefully. I have full experience for IB, TWS I can satisfy your requirements in excel. I want to discuss project with you Další

$555 USD za 10 dní
(1 recenze)
3.0
sayanprogrammer2

HI I am Xpert P. I am senior Developer and I am Expert in API, Excel, Visual Basic. I have completed 200+ based projects in programming with 100% client satisfaction .I have Working experiences of more than 15 years. I Další

$250 USD za 7 dní
(0 Recenzí)
0.0
SindhuMRS

Hello, This looks interesting to me. I am good in Excel Macro and VBA. I am professional. Regards, Sindhu

$277 USD za 4 dní
(0 Recenzí)
0.0