The title says it all. I trade futures options exclusively and wanted to see if anyone had insight into the quote speedsrobustness coming into the API. I'm using the Excel DDE right now just building a matrix I find useful for entering trades but I pull the trigger on TWS. What I've found is quite often my ES quote on TWS is different than the one showing on the API. When I close Excel and reopen it the quotes match. Anyone else experiencing this? Any insight as to how IB's quote speeds compare to third party providers or is that even worth looking into since I trade option spreads?
ES is supposed to update every 100 msec now in TWS. I imagine the FOPs update slower than that, probably every 300 msec. IB is not a real time feed like others, they aggregate the data and send it on schedule. It's good because it doesn't lag, bad because you don't get every tick.
What Matt said is true and good but if you want to stick with Excel you could try the ActiveX spreadsheet instead of DDE. Also, I remember there's a refresh rate setting for DDE. But for real money I'd still go with something else.