Find Jobs
Hire Freelancers

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

$250-750 USD

Đã hoàn thành
Đã đăng vào hơn 5 năm trước

$250-750 USD

Thanh toán khi bàn giao
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
Mã dự án: 18199744

Về dự án

9 đề xuất
Dự án từ xa
Hoạt động 5 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
Đã trao cho:
Avatar người dùng
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 trong 10 ngày
5,0 (5 nhận xét)
5,1
5,1
9 freelancer chào giá trung bình $377 USD cho công việc này
Avatar người dùng
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 trong 10 ngày
5,0 (44 nhận xét)
5,1
5,1
Avatar người dùng
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 trong 10 ngày
4,7 (34 nhận xét)
4,6
4,6
Avatar người dùng
"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 trong 5 ngày
5,0 (18 nhận xét)
4,2
4,2
Avatar người dùng
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 trong 10 ngày
5,0 (1 nhận xét)
3,0
3,0
Avatar người dùng
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 trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Hello, This looks interesting to me. I am good in Excel Macro and VBA. I am professional. Regards, Sindhu
$277 USD trong 4 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của UNITED STATES
Chicago, United States
5,0
4
Phương thức thanh toán đã xác thực
Thành viên từ thg 11 18, 2018

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.