How can I collect intraday data from IB and export it as a file which can be read by other charting programs and do the playback? Any advice?
What package should I choose if what I want is just this one. It appears the payment is one-off, isn't it? Any more options?
Don't see a price for DataCenter. Do you know how much it costs? Thx. How far back and what kind of data can you transport from IB? I have MetaStock Pro that I want to get data into also. Thx.
Hi, you can collect IB data with excel too. A DDE connection is demonstrated by IB in their demo file 'TwsDde.xls' in your 'C:\Jts\Excel'-Folder. More stable than the old fashioned DDE is their activeX Control available for data import via Visual Basic. A ready made solution is offered by CyberXpert with its free IB-Excel-Adapter. All you have to to is to write a small VBA routine saving these data into a file and your collection is working. Solutions for collection and converting also may be be offered by freelancers listed here. Its even possible to chart IB data realtime with Excel Chart. Creating good looking realtime charts in Excel may need some programming time but it has the advantage that you can chart what you want to see and aren't limited to the offer of your chart provider. Martin PS re IB data quality see this thread.
I'm just looking to get data into MetaStock Pro 9 from IB so I can run some screens. I saw this software, MetaServer RT 3.2 for Interactive Brokers' TWS , from Tradersoft but not sure how well it works. http://www.traderssoft.com/mst/msrt/#tws Also there's this one, IB Loader, for historical data. http://www.traderssoft.com/ts/ibl/ Like I say, don't know how well they work.
Where can I get the "small VBA routine"? Or do I need to pay for freelance tools just for that? I don't know much about coding.
Too bad that they don't give the fully functional trial version. We have no way to test how reliable and efficiency the tools are.