Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
"DTN feed was the only feed that consistently matched Bloomberg feed for BID/ASK data verification work these past years......DTN feed is a must for my supply & demand based trading using Cumulative Delta" - Comment from Public Forum Post
"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum
"Boy, probably spent a thousand hours trying to get ******* API to work right. And now two hours to have something running with IQFeed. Hmmm, guess I was pretty stupid to fight rather than switch all this time. And have gotten more customer service from you guys already than total from them… in five years." - Comment from Jim
"Interactive Brokers tick data was inconsistent, so I have switched to using DTN exclusively. It is great to no longer have to worry about my datafeed all day long." - Comment from Philippe
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"This is an excellent value, the system is generous (allowing for 500 stocks) and stable (and really is tick-by-tick), and the support is fantastic." - Comment from Shirin via Email
"I have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim
"Very impressed with the quality of your feed - ******* is a real donkey in comparison." - Comment from A.C. via Email
Home  Search  Register  Login  Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Product Support »DTNIQ Client Software Wish List »using IQFEED in Excel
Author Topic: using IQFEED in Excel (3 messages, Page 1 of 1)

TLikins
-Interested User-
Posts: 32
Joined: Jul 11, 2005

Howdy


Posted: Nov 20, 2005 07:36 PM          Msg. 1 of 3
I was wondering if there are any examples available showing how to use the various external
libraries like DTNHistoryLookup or DTNNewsLookup in Visual Basic for Application ?

Thanks for your help!

DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1746
Joined: May 3, 2004

DTN IQFeed/DTN.IQ/DTN NxCore


Posted: Nov 20, 2005 07:42 PM          Msg. 2 of 3
We don't have any examples of using IQFeed in VBA. I don't have any experience with VBA, but if there is an ability to send and receive from a TCP socket, it should be possible. The key is that you would need to manually launch IQFeed (you could do this with IQLink Launcher), then talk to the socket to send and receive messages. Maybe someone else has done this and could provide information.

On the flip side, our ProphetX product line does allow the retrieval of historical data via DDE, but there isn't a retail API avialable at this time. I know there is at least one commercial app that wrote to IQFeed to pull historical data, but I can't recall the name right now.

Jay Froscheiser
DTN - Trading Markets

meder
-Interested User-
Posts: 1
Joined: Jan 17, 2008


Posted: Jan 17, 2008 11:28 PM          Msg. 3 of 3
www.quotelink.net run by Antonio is a great resource for Excel based analysis using IQFeed. He's up at all hours and quickly responds to emails.
 

 

Time: Wed February 1, 2023 12:05 AM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003