I use XLQ in Excel with SIP and find it very helpful. I currently dump many fields from SIP to a text file and use Visual Basic and C++ to create filters similar to what you are considering. The XLQ site says it has a COM interface that will work with C++, C#, and VB. I have not used it yet, but it would speed things up if I did. I recommend checking that out as XLQ has a free trial period. If you can get XLQ working as a COM interface, the possibilities of what you can do with the data are bounded by your time and imagination. If I get time and get the COM interface working with C++ or VB I will let you know. I think I tried it about a year ago but couldn't figure it out - mostly because I didn't have the time. As I remember, I think I got it working in VB but could figure out how to add a COM reference to VC++ - mostly ignorance on my part.Andy
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Ra