Find Jobs
Hire Freelancers

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

$250-750 USD

Terminado
Publicado hace más de 5 años

$250-750 USD

Pagado a la entrega
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
ID del proyecto: 18199744

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 Markets projects. In your specific case, it is clear that you need an integration from Excel to your IB terminal. For this, you can have an Excel Add-In to perform all the tasks related to Excel and communicate directly to your IB terminal through the IB-API for Excel. This API from IB allows you to connect directly from Excel to the IB platform without any third-party software and/or framework and from there you can download Quotes, place Trades, modify Trades (SL/TP), manage Pending Orders and much more for all markets, Forex, Futures, Stocks and Options. In your case, it seems to be only for Futures and Stocks. Sending an email to an external recipient is also relatively simple, there is no need to use MS_Outlook, all this can be done from inside Excel itself. All you would need is the SMTP (Outgoing Email Server) configuration details of the Sender email and all the recipient addresses to send any email you need. Well, I think that is all by now. If you have any question just let me know. Regards, Eng. John P.
$700 USD en 10 días
5,0 (5 comentarios)
5,1
5,1
9 freelancers están ofertando un promedio de $377 USD por este trabajo
Avatar del usuario
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 en 10 días
5,0 (44 comentarios)
5,1
5,1
Avatar del usuario
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 Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
$307 USD en 10 días
4,7 (34 comentarios)
4,6
4,6
Avatar del usuario
"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 working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$250 USD en 5 días
5,0 (18 comentarios)
4,2
4,2
Avatar del usuario
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. Best Regards.
$555 USD en 10 días
5,0 (1 comentario)
3,0
3,0
Avatar del usuario
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 have checked your project and I am sure that I can do the job for you. Lets discuss rest details over chat. Thanks Regards Xpert P
$250 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello, This looks interesting to me. I am good in Excel Macro and VBA. I am professional. Regards, Sindhu
$277 USD en 4 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Chicago, United States
5,0
4
Forma de pago verificada
Miembro desde nov 18, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.