Enter Trades via API from Excel to Interactivebrokers and Tradier

Status: Pending
Premie: $108
Mottatte bidrag: 2
Vinner: sakhawat2

Winner

Konkurransesammendrag

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

Anbefalte ferdigheter

Winner

Legg ut en lik konkurranse

Beste bidrag i denne konkurransen

nursat Bangladesh

0

Offentlig avklaringstavle

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