Hello- I am looking for a template or basic excel sheet that will be used for trading through Interactive Brokers. I have looked into a few vendors that supply this type of stuff but I thought someone with experience may be able to point me in the right direction. I am decent with excel and have used IB for maybe 20 years. Now I just want to combine to two. I want to just start with the basics. Things like just bringing a quote into excel. Showing the bid/ask and some basic trading. Limit orders and stop orders. I guess if there was a template or a somewhat affordable/simple API I could purchase to get me started. If I had something basic so I could see their formulas just to get me rolling. Thanks Jim
IB supply a sample excel file that can be modified. It is contained in the ib API download. https://interactivebrokers.github.io/tws-api/dde_realtime_tutorial.html
However, the big issue I had with this - unless they have made changes - is that IB does not provide daily open prices for the spreadsheet.
Jimc, Are you using IB charts? the reason for my question is planning to use IB Data for Sierra Charts and using IB API to automate system. I am working on trying to develop a scanning system of various equities and once have the established results to my parameters, refining the choices as to get into days and down to minutes. I need minutes due to the large stop losses with $100 + stocks involved with my program.