IB Improvements (Part 3)
- Thread starter fleance
- Start date
What I need is RealTick's quote data on IB's TWS! Today, the quotes on IB's TWS for MSFT, INTC, and EBAY were again running 5 to 10 seconds behind my RealTick feed. At times the IB quotes on MSFT were stuck. Hitting the offer or bid with limit orders would not come close to getting a fill on IB's TWS because the market had by then already moved several levels. Having to look two monitors to the right of my TWS to get my quotes off of my RealTick quote screen is too far of a stretch. I need the correct quotes in the platform I am trading on and I want that to be IB's TWS.
As for me, all of the improvements IB has made in the TWS software are nice but are insignificant to having timely quotes. This quote problem has been going on for months when the volume picks up on heavily traded stocks like MSFT, INTC, CSCO and the like. IB surely knows their quotes are lagging but for some reasons (financial or other reasons) chooses to not correct the problem. IB needs to bite the bullet and do what ever it is they need to do to fix the problem.
Catoosa
As for me, all of the improvements IB has made in the TWS software are nice but are insignificant to having timely quotes. This quote problem has been going on for months when the volume picks up on heavily traded stocks like MSFT, INTC, CSCO and the like. IB surely knows their quotes are lagging but for some reasons (financial or other reasons) chooses to not correct the problem. IB needs to bite the bullet and do what ever it is they need to do to fix the problem.
Catoosa
I use a third party application to do that. I use it to grab my transaction histories from various brokers including IB. It has different reports and options for reviewing/searching through your trades and results but one of the features I like best (besides dealing with the different methods that brokers use to report trades) is that I copy any or all of the trade data to the clipboard and then put it into excel or whatever and do what I want with it. I have used it to grab trades from CyberTrader, RealTick/Instinet, InteractiveBrokers and Schwab accounts (although IB is my main trading account now). There are probably a few such tools out there. This one works well for me. I realize it's not a native solution and it's not free but for me it's a necessary tool given the various sources and number of trade records I deal with.
It's called TradeLog.
In the interest of those that might want to learn more about this tool type 'tradelog' into Google and go to the site by armencorp. I am a happy customer & user of the tool.
Another tool I've heard about and once tried is known as Gainskeeper. I am not as familiar with it's features but you may want to check it out as well if you think you need a tool to help import or manage your trade records.
- David I
If your asking about how to get completed trade information into excel then this is what I do. TradeLog can get completed trade information one of 5 ways from InteractiveBroker's e-mailed statements/web pages/log files. Pick you're favorite way. Specifics for InteractiveBroker users are in the TradeLog help guide:
http://www.armencomp.com/tradelog/import.shtml#IB
Once in TradeLog I then select one, several or all trades and control-c (or press the 'copy to clipboard' button) and then I go to my excel spreadsheet, select a cell and control-v (paste). Done!
- David I
I have been using TradeLog since last year, and it is by far the best program I have found for handling large numbers (100,000s) of trades from various brokers. I had over 100,000 trades from several different brokers (IB, CyberCorp, NDB, DLJ) and TradeLog handled them all. I did find a coupple bugs for the developer in is trade matching algorithm and Quicken Import, but he was very responsive in pinpointing the problem and fixing it.
When I first started I used CyberCorp's Quicken Format to import into Quicken, but Quicken is very slow and gets bogged down when imported 1000s of trades.
Once I bought TradeLog, everything became so much easier. The program is extremely optimized and was very snappy on my P3 850 Mhz even when loading 100,000 transactions.
If you have any questions about it I suggest you check out their website. See link above. I highly recommend it for traders and especially for IB users. The IB import works great, at least for stocks. 50,000 stock trades match up perfectly. I can't comment on handling of options/futures trades as I don't trade those.
Fleance
When I first started I used CyberCorp's Quicken Format to import into Quicken, but Quicken is very slow and gets bogged down when imported 1000s of trades.
Once I bought TradeLog, everything became so much easier. The program is extremely optimized and was very snappy on my P3 850 Mhz even when loading 100,000 transactions.
If you have any questions about it I suggest you check out their website. See link above. I highly recommend it for traders and especially for IB users. The IB import works great, at least for stocks. 50,000 stock trades match up perfectly. I can't comment on handling of options/futures trades as I don't trade those.
Fleance
I use a third party application to do that. I use it to grab my transaction histories from various brokers including IB. It has different reports and options for reviewing/searching through your trades and results but one of the features I like best (besides dealing with the different methods that brokers use to report trades) is that I copy any or all of the trade data to the clipboard and then put it into excel or whatever and do what I want with it. I have used it to grab trades from CyberTrader, RealTick/Instinet, InteractiveBrokers and Schwab accounts (although IB is my main trading account now). There are probably a few such tools out there. This one works well for me. I realize it's not a native solution and it's not free but for me it's a necessary tool given the various sources and number of trade records I deal with.
It's called TradeLog.
I was the one who suggested the searchable transaction history. As it turns out, I also use Tradelog. I don't download my transactions on a daily basis however, I use the monthly statements for that. Not everyone diligently downloads their trades on a daily basis (especially when they have multiple actively traded accounts to contend with). I would still love to see a searchable transaction history. It would make life much easier.
Tradelog by the way works better for some brokers than others. For IB it works well. For CSFB I've had tremendous mismatching problems this year. It would have almost been easier to enter trades manually with the time I had to put in sorting out the mismatching problems.
99
It's called TradeLog.
I was the one who suggested the searchable transaction history. As it turns out, I also use Tradelog. I don't download my transactions on a daily basis however, I use the monthly statements for that. Not everyone diligently downloads their trades on a daily basis (especially when they have multiple actively traded accounts to contend with). I would still love to see a searchable transaction history. It would make life much easier.
Tradelog by the way works better for some brokers than others. For IB it works well. For CSFB I've had tremendous mismatching problems this year. It would have almost been easier to enter trades manually with the time I had to put in sorting out the mismatching problems.
99