How can I get quotes into excel? I would prefer realtime. I don't need streaming, but if I can get a realtime quote and have it refresh every minute or so that would be great. I hear you can with IB, but what about live charts or other services?
First, make up your mind. Do you want quotes for excel only, and if so how *many*? Do you need charting? Or do you want/need both?
IQFeed has a DDE server built in. The DDE Server is eneabled for any subscription level of IQFeed. Thus, your best priced option from us would be to buy IQFeed for QuoteTracker, which is $20 + exchange fees for RT equities and delayed futures and delayed futures and equity options. You can then stream the data directly into Excel. With this subscription level you will also be able to use the QuoteTracker software interface which will give you charting if you need it. You can sign up for this subscription level at www.iqfeed.net/quotetracker.