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)




"I just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email
"I am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
"I am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"There is no doubt that IQFeed is the best data provider. I am very satisfied with your services. And IQFeed is the only one that I would recommend to my friends. Now, most of them are using your product in China." - Comment from Zhezhe
"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
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - 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
"Excellent datafeed !!!" - Comment from Arely
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)

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: 1742
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: Sat February 17, 2018 9:06 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003