Does anyone know a software program that will import stock and futures quotes on to an excel platform? Thanks.
QCharts allows this (I think thru QFeed?). I have never done it - I use another fairly manual method that works very well for my needs. I have read that you can set up streaming quotes to be dumped into an Excel sheet live as they print. I'm sure others can provide better info.
QuoteTracker has an API that can be used for it: http://www.quotetracker.com http://www.quotetracker.com/help/qtserver.shtml IQFeed can be used through QuoteTracker or directly for Excel: http://www.quotetracker.com/iqfeed QuoteIn is also something you may want to look at: http://www.quotein.com
Thanks for the replies. I need to be able to import these prices live at the same time. I will check out those links. Is this a fairly simple process to setup? I don't have any experience with API.
For continuously updated stuff, you would probably be better off with IQFeed since they provide the datafeed and have the DDE Link. should be easy to setup. After signing up, you can just ask their support for instructions on getting the DDE Link to Excel. QuoteIn I think supports access to QuoteTracker, though it is not listed on the site right now. In which case you would be able to use any datafeed that QT supports for futures (IB for example) and it would be easier to setup for a beginner than our API
I use a DDE link from eSignal to run a worksheet for equities, I suppose it would work for futures too, but I don't subscribe to their futures feed. I also use Interactive Brokers' feed will to run an excel worksheet.
Yes it does. Simply use the futures symbol , for example ES #F instead of the stock symbol. Using the #F instead of a specific contract makes it easy at rollover time; you won't have to update a bunch of cell refs the morning of the change.
So are you saying that with IQFeed I can use that alone to import the stock and futures data on to excel? I would not need the quotetracker software?