Tamamlanmış

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

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

Beceriler: API, Excel, Visual Basic

Daha fazlasını gör: interactive brokers api download, interactive brokers automated trading software, interactive brokers historical data downloader, ib excel adapter, interactive brokers dde spreadsheet, interactive brokers excel api, interactive brokers excel rtd, interactive brokers excel trader, cut paste vba excel, vba excel action opening workbook, vba excel column label, vba excel delete column, view directory name files cells vba excel, odbc data vba excel, interface dll excel vba, excel 2013 vba find date, ms access sql server 2012 excel 2013 vba vba excel reports, ms access sql server 2012 excel 2013 vba vba excel reports,, excel 2013 power programming with vba, microsoft excel 2013 power programming with vba free

İşveren Hakkında:
( 0 değerlendirme ) Chicago, United States

Proje NO: #18199744

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 700%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(3 Değerlendirme)
3.5

Bu iş için 10 freelancer ortalamada $364 teklif veriyor

SBITServices

Hello , I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming and completed 400+ projects. I never ask for payments in front. You can re Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(381 Değerlendirme)
7.4
ilkecokay

Hello sir. I will need a lot more detail and i will ask lots of questions but if you want to work together please kindly message me. Thanks..

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(20 Değerlendirme)
4.3
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.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
3.9
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
3.9
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde307%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
3.7
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
MadhanMohanD

I have very good experience in VBA with excel, please check my blog (that is a sample of my work with excel). For the purpose of automation, data cleanups and reports i use VBA macros. [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
SindhuMRS

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

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0