Excel quotes

[dagve]

I am interested in importing real time quotes into an excel spreadsheet. Can anyone recommend some data vendors that offer this at a reasonable price?

 

[Fletch]

quote.com has a product call qlink... not sure I'd really say they have good service... but it usually works.

fletch

 

[WarEagle]

Quote.com offers their QFeed for free when you subscribe to QCharts (about $80/month). They have a DDE link called QLink that allows you to pull the QFeed quotes into Excel. Its very easy to use.

If you want more info, the link is:

http://finance.lycos.com/home/qcharts/qlink.asp?option=qlink

Kirk

Edit: Oops, Fletch beat me to it...I'm a slow typer

 

[dagve]

thanks for the help guys

 

[dvegadvol]

If you use Redi, Reuters, Bloomberg, AT-Financial they all have dde links. Other services could have them, but I use the above. Yahoo's server will give you 200 days of OHLC on any stock or index for free. Check their finance site too. For Redi and the others, call their data / trading platform support for more info.

Cheers

 

[sallyboy]

If you use RealTick, you can use the included program called Talnet to import realtime data.

 

[gordo]

devegadal:

How do you use the dde links in Reuters to export data into excel? Thanks.

 

[dvegadvol]

Gordo:

I'm using reuters dealing 3000. In this product you call a dde link with the following command line in the cell you want to display the data in:

=reuter|idn!'msft,prim act 1, last'

But if you have reuters running , search help for dde and follow the instructions listed, it's a really painless procedure. Reuters collects all the data for you, so there's no need to write the data to a separate database. Simply call up a tabular (or time and sales) window in Reuters, copy the data and paste it into your spreadsheet. If you want to record the data in a database real-time, you'll need a macro to do it. Let me know if you need help.

Cheers