Importing quote data into Excel

Maverick74 · Jun 27, 2003

Does anyone know a software program that will import stock and futures quotes on to an excel platform? Thanks.

ktm · Jun 27, 2003

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.

j_medved · Jun 27, 2003

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

Maverick74 · Jun 27, 2003

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.

j_medved · Jun 27, 2003

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

Maverick74 · Jun 27, 2003

Does e-signal allow you to import both stock and futures quotes on to excel live?

j_medved · Jun 27, 2003

I think I saw something about them supporting DDE in the beta version of their product.

Eldredge · Jun 27, 2003

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.

Tech Analysis · Jun 27, 2003

Quote from Maverick74:

Does e-signal allow you to import both stock and futures quotes on to excel live?

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.

Maverick74 · Jun 29, 2003

Quote from j_medved:

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

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?