Find Jobs
Hire Freelancers

Develop VBA Excel DDE Trading Bot with API to TWS InteractiveBrokers

$250-750 AUD

Completed
Posted almost 2 years ago

$250-750 AUD

Paid on delivery
I need a VBA Excel DDE Trading Bot with API to TWS InteractiveBrokers. Refer to: [login to view URL] (Note I need "Full API functionality") This bot trades on Earnings. The instructions to be manually entered / input into the bot each week will be the Ticker, Earnings Date, Option Expiration Date, Entry Date (period), Option Type: Straddle / Strangle, Quantity, Entry RV, Stop Loss & Profit Taker %. RV = Relative Value. This is the calculation of the ATM (At The Money) Strike Option Price for the Straddle or Strangle as a percentage of the Stock price. Entry Date = e.g. 3 days before Earnings Date up to 1 day before Earnings Date. Bot functionality - During the Entry Date (period of time), the bot needs to take the Ticker and every second find the nearest ATM option price at the Options Expiry Date for the straddle and strangle. It then needs to calculate the RV as a percentage of the current stock price. If the current RV is at or lower than the Entry RV, then enter a limit order for the quantity (as a combo) specified at the RV Entry option price via InteractiveBrokers TWS API. Once entered, it should not try and enter again. Once confirmed as executed, the bot should every second look to exit the trade at a Stop Loss % order and multiple stepped Profit Taker %s (e.g. sell 20% at 5% profit, sell 50% at 10% profit, sell 20% at 15% profit, sell 10% at 20% profit). Furthermore, 2 hours before Earnings Date (i.e. 2hrs before previous day's market close), 'market order sell' any residual open positions. It should be able to do this for multiple Tickers. Example: We would manually input the below: Ticker = C (Citigroup Inc.) Earnings Date = 14 July 2022 Option Expiration Date = 15 July 2022 Entry Date = 3 days to 1 day (i.e. 12 July to 14 July) Option Type = Straddle Quantity = 10 Entry RV = 4.1% Stop Loss = 4% Profit Taker = sell 20% at 5% profit, sell 50% at 10% profit, sell 20% at 15% profit, sell 10% at 20% profit The Bot would do the following every second (when within the Entry Date range): Pull (from IB TWS) Current Stock Price = $46.19 Determine Nearest strike = 46 Pull (from IB TWS) Current Option Price for the Straddle = $2.08 Calculate the RV = 4.5% Evaluate if RV =/< Entry RV = No Loop and try again. Eventually the following may occur: Pull (from IB TWS) Current Stock Price = $47.9 Determine Nearest strike = 48 Pull (from IB TWS) Current Option Price for the Straddle = $1.96 Calculate the RV = 4.1% Evaluate if RV =/< Entry RV = Yes Enter limit order of 10 Straddles (combo) for $1.96 Note: This would look like ($48 Call @ 15 July 2022 and $48 Put @ 15 July 2022) in a combo at the price of $1.96 x qty of 10. Continue to scan for each condition, noting that each can only be executed once. Stop Loss = $1.88 for qty remaining Profit Taker = $2.06 for qty 2 $2.16 for qty 5 $2.25 for qty 2 $2.35 for qty 1 Finally, 2hrs before market close the day before Earnings, close any residual qty positions. Please provide a proposal - quote, timeframe etc to complete this, as well as your experience with VBA, IB TWS and development of trading bots. Note: Minor tweaks and adjustments may be made during the development process to further refine the bot. Thanks
Project ID: 34106243

About the project

26 proposals
Remote project
Active 2 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I'm a senior Python & ML developer and owner & founder of Dedeoglu Dev Company. Kindly send me a message to get in touch with me, Thanks, Yusuf.
$500 AUD in 7 days
4.9 (5 reviews)
3.9
3.9
26 freelancers are bidding on average $578 AUD for this job
User Avatar
Hey! I am professional VBA programmer with skills including Visual Basic, Trading, API, Data Science and Excel. I am Database/VBA/SQL Developer Master of Computer Science with 25+ years experience. Database Development: Backend & Frontend, SQL, query profiling, VBA. MS Access, SQL Server, MySQL, PostgreSQL. Developing and supporting DB for Finance/Accountancy, DM, CRM, ERP, ETL etc. MS Office automation: Access/Exce/Word/Outlook. Macros, VBA, API integration. Google Docs automation. System administration tools for Linux using bash, ruby. Data syncing, encryption, automation. The key focus is to deliver time-saving, user friendly and easy to use applications. Please contact me to discuss more regarding this project. Thanks
$750 AUD in 1 day
4.9 (67 reviews)
6.4
6.4
User Avatar
Hi there, ★★★ Excel / VBA / Macros / Automation Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to build a VBA Excel DDE Trading Bot with API to TWS InteractiveBrokers.. I provide complete ranges of solution for your Excel, Custom Formulas / Functions, Pivot Table, Dashboards, VBA and Macros Automation need. I can also provide similar past Excel work example before being hired. Services we offer: ✔️ Custom Formulas ✔️ VBA Macros Automation ✔️ Vlookup / Hlookup ✔️ Countif / Countifs ✔️ Converting CSV files in to specific format. ✔️ Export & import of Excel files in to specific excel file ✔️ Visual Basic User Forms, for user interface designing and dashboards ✔️ Interactive Pivot Tables and Graphs. ✔️ Converting Excel to PDF or CSV ✔️ Complete Dynamic VBA Macros Dashboards ✔️ Removing Duplicates from the File ✔️ Data Entry with automated process I'll be glad to discuss project before start so let's chat. Thanks for your consideration. Best Regards, TechPlus Team
$1,500 AUD in 7 days
4.9 (13 reviews)
5.6
5.6
User Avatar
Hi there myself yesu I am a vba developer I can do this you can contact me on this for further discussion thanks
$500 AUD in 7 days
4.9 (37 reviews)
4.9
4.9
User Avatar
Dear Client I am very interested in your project With 15 years of experience in website development, I am absolutely sure I am the right person for this project. I have worked on the similar project as yours over the years. You can simply take a look at my portfolio to know more about me. You will be fully satisfied with my work. Now, I hope to learn and discuss more detail. May I know your best time to discuss? Best Regards.
$900 AUD in 7 days
5.0 (2 reviews)
4.0
4.0
User Avatar
Hey! I am confident that I am the perfect candidate for this job, hence I would like to submit my proposal for your consideration. I have rich experience in Trading, Visual Basic, API, Data Science and Excel. In the two years I've been freelancing, I have written countless projects related to yours. I am confident that I can produce high-quality work for you. My rates are very reasonable, and I am available to start immediately. If you would like to see some of my previous work, I can provide you with a portfolio of my writing samples. I'm sure that you will be impressed with the quality of my work, and I look forward to hearing from you soon. Thank you for your time Wilfred
$250 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
FAB consultancy services We are leading Software services Company Based in India. We have super experienced web programmers and mobile application developers who have successfully completed various huge projects and has proven our skill in many opportunity. Our Vision: Client Satisfaction, Quality Work, Long term relation! Tech Expertise: * Unix and shell scripting --5 Years * Python developement --5 Years * .Net Core - 5+ Years * .Net ( MVC, Web and Desktop Apps , C#, VB) - 14 Years * ReactJs, Angular, TypeScript, Node JS, AngularJS, JQuery, Ajax - 6+ Years * Azure, AWS, Devops. - 3+ Years * Design, Bootstrap 3/4/5, HTML, CSS, jQuery - 4 Years * Apache Cordova, IONIC, Angular - 4 Years * Mobile (Android, iOS App(iPhone, iPad) , PhoneGap, iOnic) - 6 Years * Database (Oracle,MS SQL, MySQL,MongoDB) - 14 Years STRENGTHS: * Daily Communication * Daily & Weekly work / progress update report * Privacy & Data Security * Agile Development Methodology * DEDICATED FULLTIME TEAM * Flexible MODEL (Fixed + Hourly) * Many more... -More Flexible Every field of technology and trends I would appreciate your response , will talk about requirements and bid during chat-bot.
$500 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir , I have gone through your requirements .In BID AMOUNT I can Develop job portal Website for you. I am a Senior Developer specialized in Website development having an experience of more than 5+ years. i will be available 24/7 for chat and any call so please message me here. Waiting for your positive reply Thanks & Regards Shweta S
$500 AUD in 12 days
0.0 (0 reviews)
0.0
0.0
User Avatar
How are you Already have gone through your requirements in detail. Develop VBA Excel DDE Trading Bot with API to TWS InteractiveBrokers I am a web expert having great experience in API, Visual Basic, Trading, Data Science and Excel. I will provide you the result as per your requirements where you can easily manage the content and functionality easily. we can discuss project budget and requirement And I am confident to provide an innovative result with my skills and dedication. Please feel free to contact me so that we can discuss the further project and your needs in detail
$500 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
VB/ Excel / IB /API Integration ================================================================================================
$750 AUD in 2 days
0.0 (1 review)
0.0
0.0
User Avatar
I can do your work honestly i am hard worker i complete your project safely.I done your project without mistakes
$500 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
As a Senior Full Stack engineer, I have vast experience of + 9 years, so I have built 30 more small and big project with Javascript Frameworks like React, Vue, Angular, MEAN Stack, TypeScript, TailwindCSS, Next, Nuxt and Node JS. And also I am familiar with Backend side using PHP, Python Django, Flask and Java. As a software engineer, I must be familiar with different services and tools, for the version controlling systems, I am familiar with GitHub, Bitbucket, Gitlab, SVN repositories and also Microsoft Team Services. For the Ticket Management Tools, I am familiar with Jira, Trello, Active Collab, Asana and you know there are many other services that we can use for the TMS purpose. One of the most important things for the developers is Testing. I am comfortable with Unit Testing, e2e Testing of course Automatic or the manual. I can support more than 85 % of code coverage for the codebase and cover the entire flow with e2e testing cases. Regarding my availability, I can commit more than 40~50 hours per week and I can commit at the weekend if needed. I am an individual freelancer and I am flexible at working hours. I can be online any time zone and I will make more than 4~5 hours of overlapping time with you or other developers so we can keep communication clearly without any issues. That’s the brief information about me. Please let me know if you have any questions and I will be happy for trying to answer all of your technical or non-technical questions. Thanks very much.
$500 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, Hope you are doing great. Firstly about the Develop VBA Excel DDE Trading Bot with API to TWS InteractiveBrokers that i have a great experience in it. I am very confident to pull it off once awarded. I am a Full stack developer with a team of experienced developers, together we have 5+ years of experience in Trading, Data Science, Excel, Visual Basic and API Hi there, I am Rashid. I can work with your project skills Trading, Data Science, Excel, Visual Basic and API, I aim to establish a long term working relationship with my clients. Please let me know what is needed to secure the bid! Thanks for your consideration. Rashid Amjad.
$700 AUD in 20 days
0.0 (0 reviews)
2.9
2.9
User Avatar
Do you want proof i can do the job before you buy ? Hey there, you want results and I am here to give them :) you probably get 100s of people messaging you right now with some generic message saying they can do the job and when you hire them they can't or charge more :( it's a sad fact of freelancer. Why am I different, for one I can do this job, I am scraping Amazon and eBay. I have Facebook bots, I have drop shipping bots. I even have a email and telephone spider that's been working for quite some time now and all of this has been built by me. I have built PDF scrapers and i am not beyond doing some manual VA work :D I also bid on the work not the time. So what this means is, you pay me to build the system but for how ever long it's running I'm not going to charge you as well I'm not doing anything :) this is why my bid hopefully is cheaper then most :) and lastly i want you to see i can do this job, how do i do this. Well i do the job, i show you a little preview and if you are happy you hire me, i Finnish the task and get paid :D its a win win for everyone. Thank you for taking the time to read my bid and I hope to hear from you :)
$500 AUD in 7 days
5.0 (1 review)
0.0
0.0
User Avatar
hi i am shivam. i am from delhi. i am a good typist. i am a data entry operator. my typing speed is 55-60 word per minute. if you will give me project then i will completed. thankyou
$500 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I CAN COMPLETE YOUR PROJECT EASILY Hello, I am programmer with enough experiences on C#/.NET for 10+ years. C#/.NET is nice programming language and I am majoring on it for long years so I have confident to complete your project by C#/.NET. I can work by full time for your project and trying to satisfy the requirements. I am designing the project from scratch and structure it well. I am following the project's design process exactly, and if any error is found, fix it within 24 hours and provide maintenance free of charge for a month./ Client's idea + Programmer's good coding is the perfect result, this is my idea. I want to keep long-term relationship for customer so I want to give the nice result. If you want the perfect result, please contact with me.
$500 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have over 9 years of experience in the bpo industry. I possess a strong work ethic and I am ambitious. I have excellent writing skills and the ability to find innovative solutions and ideas. I am a quick learner. I am a people person. I love working in a team and on my own. I thrive in a competitive environment. I am highly flexible & I can adapt to the demands of a highly competitive and demanding industry. The objective is to obtain a challenging position in a reputed organization, an organization that recognizes dedication, devotion, and achievements with ample opportunities for advancement in my skills and experience.
$500 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, my name is yam and i have the perfect solution for you for the crypto trading space! This bot is fully automated and he buys and sells based on his algorithm so it trades for you while you're sleeping. In the last 3 month the bot did a total of 117%. I have 3 years of crypto and stock trading experience and 4 years of experience in software development in startups i worked in. Before 8 months i started freelancing and now i'm helping people to make their idea or dream come true! If you have an idea or a dream related to crypto and you don't know how to develop it, you came into the right place! I can develop any crypto/stock market related software you would like, i'm more than happy to listen to your idea! I have developed over 40 bots relating to crypto just in the last couple of months for my clients to help them generate money and bring ideas to life in the crypto market. If you're interested in any bot/crypto software that you want me to develop for you, feel free to send me a message :)
$500 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
✅I am very interested in your project.✅ ❤️Hello.❤️ I have read your project description and I am ready for your project. I have full time and I will provide great satisfaction to you. Let discuss on chat in details. Thank you. ❤️Albert❤️
$320 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, nice to meet you. I am happy to bid on your project. I have read your job description carefully and I am interested in this project. I have more than 7 years of solid knowledge and practical experience in this field. I can also start working right now and deliver good results on time. Please contact me for more details. Best regards, Eric Lesca. - Metatrader 4&5 - Pine Script - NinjaTrader - ThinkScript - Ctrader - API Based Trading Bot - Conversion from one trading language to another.
$500 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Brisbane, Australia
4.8
26
Payment method verified
Member since Mar 6, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.