Does anyone have recommendations for good software that links with Excel? Bloomberg does but it's too expensive. ESQuotes does but it's not fast enough/flexible enough for me. I'd like to be able to grab historical data for calculating correlations as well as intra-day realtime data quickly.
Just an update on what I've found: Since I'd like a lot of flexibility in getting at the data in Excel, I'm thinking about getting an Interactive Brokers account and using this software 'XLQ' to get intraday backfill: http://www.qmatix.com/XLQ.htm Does anyone know how many days of intraday (1 minute? I'm not sure) backfill you can get with IB? - Caementarius
You should check out the new and improved free plug-in we've created for eSignal or QCharts users called QLink. It has a great toolbar inside of Excel that makes it easy to fill in spreadsheets with the snapshot, time & sales and/or historical bar data you need. You just need an eSignal or QCharts account to access the streaming, real-time data, and there's no additional fee for the QLink plug-in. There's even trials going on, so you can check it out risk-free.
Hey JayF... I'm a long time Qcharts/Qlink user. Is this a new version for use with QCharts? If so, how/where can I try it? Thanks, TNG
Hi TNG, The below link should take you to the most recent version of the QLink Beta. We're nearing the full release of the next version, about 1-2 weeks away. http://forum.esignalcentral.com/showthread.php?s=&threadid=22745
Thanks JayF. Is that Qlink version good with QCharts? When I try to install it, it says I need eSignal... Thanks, TNG
Yes, it does work with QCharts 6.0 (Beta), which uses the eSignal datafeed. Just download in that same QLink link, but one post down, you'll see a link to the QCharts 6.0 download page.
Do you need to have Q Charts 6.0 installed or E-SIgnal in order for the new Qlink to work? I had issues connecting despite the installation of both the new Q Charts and E-Signal. Alan
Alan, The new QLink requires an installation of either QCharts 6.0 or eSignal in order to download the data from the eSignal network. If you are experiencing difficulties installing the QLink program, please report this via the QCharts Beta Forum.