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)

"Everything is working amazing now. I'm already impressed with the true-tick feed of IQFeed and it's ability to support my 480 symbol layout." - Comment from Tyler via Email
"Thanks for all of your help. Great customer service deserves to be recognized which one the reasons I've been a customer of DTN for over 10 years!" - Comment from Stuart
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"Everything is working great with the API. I love it." - Comment from Calvin
"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
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"You are either overstaffed or people just don't have problems with your feed because customer support always answers the phone quickly." - Comment from Jay via Email
"I was on the phone with a friend who uses CQG and right after the Fed announcement, CQG was as much as 30 seconds behind DTN.IQ. Some quotes were off by as much as 15-18 cents. Your feed never missed a beat." - Comment from Roger
"I had always used ******* but for the past 2 weeks have been trying DTN IQFeed. Customer support has been extraordinary. They call just to make sure your problem hasn't recurred." - Comment from Public Forum
"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat
Home  Search  Register  Login  Blogs Recent Posts

Information on Various DTN Products:
DTN IQFeed | DTN ProphetX | DTN Ag | NxCore
Follow DTN_IQFeed 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)

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


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!

-VP, Product Operations-
Posts: 1744
Joined: May 3, 2004


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

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

Posted: Jan 17, 2008 11:28 PM          Msg. 3 of 3 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: Fri March 23, 2018 2:05 AM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003