Enter Trades via API from Excel to Interactivebrokers and Tradier

Résumé de concours

Good Day
Instead of placing my trades in Interactivebrokers ([login to view URL]) or Tradier ([login to view URL]), I would prefer to enter them in an Excel Spreadsheet and send them to the respective broker. I would then confirm and submit the trade in the broker backend. In case I need to delete or adjust the trades, I would do this in the broker backend itself.
As I trade mainly multilegs options positions, I would enter the specifics for each leg in the Excel Sheet and would then like to submit via 1 button to either Interactivebrokers or Tradier. Have attached on example how I would like it to have in Excel and then in Tradier backend, if this is even possible. The same transfer would apply for Interactivebrokers.

Please let me know if there are any questions or suggestions.
Thank you and kind regards

Have now also added the InteractiveBrokers screenshot. Unfortunately, I can not give access to the websites. My suggestions is that I will test the program and give feedback what is working or not and the program needs to be update. This procedure might take several iterations.

Hello sir, i have a question about this project. Do you just want this project to copy excel data, and write them into corresponding form in a web site? If that is all, no API needed actually. Excel's own library is enough to detect the website, and pass excel values into the form. Then you can submit the form or edit it etc in your Internet Explorer. (Excel gives default support to only IE )

il y a 5 mois

Titulaire du concours

il y a 5 mois

Thanks for raising this good point. You are actually right that for Tradier as well as for InteractiveBrokers the data can be entered on a website. From my point of view, this would be the simplest way and enough for my needs.

Hello sir. As i have interest in this project and want to aid you through, i am having difficulty navigating around web sites you mentioned, and creating accounts. Do you plan on helping the freelancer you choose, finding the form pages you need, also sharing your account info to grant easy access and prevent needless effort, if only it is appropriate since these sites are finance related? Thanks.

If you are willing to guide, i'm eager to aid you, hovewer it seems like getting a valid account and navigating to forms you mentioned will take more time than preparing VBA script, especially for someone who is not related to financial business.

Hello!
As Baris Ilke C has mentioned, Excel alone can be used to obtain what you're trying to achieve, without using API.
I can code a project that will take your input and fill in the forms in the respective websites, which would allow you to review/edit/submit them manually afterward. The default support would be for IE, but I believe I can get it working on all browsers.
If that is what you seek, please provide a picture of "interactive brokers" as well as the "tradier" one provided.