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)




"It’s so nice to be working with real professionals!" - Comment from Len
"I am very pleased with the DTNIQ system for quotes and news." - Comment from Larry
"Thank God for your Data Feed as the only Zippers I see are on my pants (LOL), and no more 200 pip spikes to mess up charts." - Comment from Spiro via Email
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"I would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
"Excellent datafeed !!!" - Comment from Arely
"Version 4.0.0.2 has been working well for me and I appreciate that it is now a much tighter client to work with. I feel I can go to press with my own application and rely on a stable platform" - Comment from David in IA.
"I ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
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: Tue January 26, 2021 2:31 AM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003