Enter Trades via API from Excel to Interactivebrokers and Tradier

Status: Pending
Prize: $108
Entries Received: 2
Winner: sakhawat2

Winner

Contest Brief

Good Day
Instead of placing my trades in Interactivebrokers (https://www.interactivebrokers.com) or Tradier (https://tradier.com/), 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

Recommended Skills

Winner

Post a Contest Like This

Top entries from this contest

nursat Bangladesh

0

Public Clarification Board

Dashingdev
- 5 years ago
Just saw this. I have been a big fan of the Tradier API. I will try this
- 5 years ago
tukabwanausi
- 5 years ago
#increaseprize #increaseprize
- 5 years ago
Contest Holder
- 5 years ago
#extended
- 5 years ago
Contest Holder
- 5 years ago
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.
- 5 years ago
1. sakhawat2
  - 5 years ago
  Unfortunately, the contest deadline has passed. We cannot submit an entry anymore.
  - 5 years ago
sakhawat2
- 5 years ago
#extended
- 5 years ago
ilkecokay
- 5 years ago
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 )
- 5 years ago
1. Contest Holder
  - 5 years ago
  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.
  - 5 years ago
2. ilkecokay
  - 5 years ago
  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.
  - 5 years ago
sakhawat2
- 5 years ago
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.
- 5 years ago