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
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
Bu iş için 10 freelancer ortalamada $364 teklif veriyor
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
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..
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.
"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
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
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
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
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
Hello, This looks interesting to me. I am good in Excel Macro and VBA. I am professional. Regards, Sindhu