nursat
Bangladesh
Enter Trades via API from Excel to Interactivebrokers and Tradier
- 状态: Pending
- 奖金: $108
- 参赛作品已收到: 2
- 获胜者: sakhawat2
Winner
竞赛简介
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
您还可能感兴趣的技能
Winner
此竞赛的顶尖作品
公共说明面板
-
Dashingdev
- 5 年 之前
Just saw this. I have been a big fan of the Tradier API. I will try this
- 5 年 之前
-
tukabwanausi
- 5 年 之前
#increaseprize #increaseprize
- 5 年 之前
-
竞赛主办者 - 5 年 之前
#extended
- 5 年 之前
-
竞赛主办者 - 5 年 之前
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 年 之前
-
sakhawat2
- 5 年 之前
Unfortunately, the contest deadline has passed. We cannot submit an entry anymore.
- 5 年 之前
-
sakhawat2
- 5 年 之前
#extended
- 5 年 之前
-
ilkecokay
- 5 年 之前
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 年 之前
-
竞赛主办者 - 5 年 之前
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 年 之前
-
ilkecokay
- 5 年 之前
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 年 之前
-
sakhawat2
- 5 年 之前
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 年 之前
