anyone have a preference for an excel addon to pull RT data in? I know there are a couple out there, just wanted to see which one is better.. thanks...
I am using http://www.qmatix.com/XLQ.htm A couple of quirks, but doing its job. I am running big Excel spreadsheets with it with real time data from IQFEED and it's working ok.
thanks it looks interesting, and much cheaper then the XL excel analyzer.... what quirks do you have that you mentioned in your posting?
Sometimes data freezes for single tickers. I run spreadsheets with dozens of up to over 100 different tickers. Sometimes the bid + ask of certain random tickers would be zero. This is not an IQFeed problem because the feed in displays the respective ticker correctly in other software. This happens pretty rarely and is solved by simply closing excel, closing XLQ and reloading both. Annoying, but easy to work around it.
Just wanted to let you know that XLQ released version 4.0 last week. According to the developer, version 4.0 "has some major speed improvements, providing unprecedented flexibility to iqfeed in excel". He created a great video showing the speed of IQFeed data in Excel using XQL (no sound): http://www.qmatix.com/Videos/XLQUsingIQFeedSP500/XLQUsingIQFeedSP500.html. The video shows a basic IQFeed subscription streaming the SP500 components in real time to Excel as well as examples of streaming T&S and historical data.