DTN IQFeed, DTN.IQ, DTN ProphetX Support Forums

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 great ! Very impressive client. The news refreshes better and is more pertinent than the ******* feed I paid $ 100/month for. I Also like the charts a lot." - Comment from Leon

"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 has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton

"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.

"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 "bracket trade" all major news releases and I have not found one lag or glitch with DTN.IQ feed. I am very comfortable with their feed under all typical news conditions (Fed releases, employment numbers, etc)." - Comment from Public Forum

"IQ feed is brilliant. The support is mind-bending. What service!" - Comment from Public Forum Post

"For anyone considering using DTN.IQ for a data feed, my experience with the quality of data and the tech support has been very positive." - Comment from Public Forum

"You have an excellent feed. Very few spikes for Spot Forex." - Comment from Public Forum Post

"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

Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather

DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter

»Forums Index »Archive (2017 and earlier) »DTN.IQ Client Software Support »Excel code necessary to retrieve tick data, similar to Time & Sales

Author	Topic: Excel code necessary to retrieve tick data, similar to Time & Sales (6 messages, Page 1 of 1)
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Mar 15, 2011 05:49 PM Msg. 1 of 6 Hi - I'd like to retrieve some tick data directly into an Excel spreadsheet. Right now, I have to bring up a DTNIQ T&S window, retrieve the data then manually save it to disk in .csv format. After that, I can import it into Excel and do my thing. Is there an easy way to load xxxx tick elements directly into an Excel column, possibly using some kind of 'IQLink' statements similar to what I already use for other DTNIQ items in my sheet? I'm using Excel 2007.
DTN_Jay_Froscheiser -VP, Product Operations- Posts: 1746 Joined: May 3, 2004 DTN IQFeed/DTN.IQ/DTN NxCore	Posted: Mar 15, 2011 11:38 PM Msg. 2 of 6 There isnt anything native in DTN.IQ. We do have an excel addin (add-on) for prophetx that can do this. Or, with DTN.IQ/IQFeed, i would suggest looking at one of the third party apps such as XLQ OR QuoteIN. They both provide great tools for pulling in data other than the DDE streaming data we natively provide. Jay Froscheiser DTN
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Mar 16, 2011 11:38 AM Msg. 3 of 6 Thanks, Jay - I'll check out the 3rd party apps
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Mar 27, 2011 12:16 PM Msg. 4 of 6 Jay, could you post the name of the Prophetx add-on for Time & Sales/Excel ? Thanks.
DTN_Jay_Froscheiser -VP, Product Operations- Posts: 1746 Joined: May 3, 2004 DTN IQFeed/DTN.IQ/DTN NxCore	Posted: Mar 27, 2011 12:35 PM Msg. 5 of 6 The excel add-in for ProphetX is a premum service. Information is available here: http://www.telvent.com/en/business_areas/trading/solutions_overview/commodity_traders/add_on_solutions/loader.cfm?csModule=security/getfile&pageid=89404. The add-in software is part of the installation of ProphetX (it will ask if you want to install the add-in). There is also a built in ability to get data from ProphetX into excel using the tabular data app (without needing the premium service entitlement). Information is available in the full help documentation by going to the 'quotes' section, then the 'dde linking' subsection. Scroll down about half way to see instructions on dde for historical data. Jay Froscheiser DTN
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Mar 27, 2011 01:27 PM Msg. 6 of 6 Thanks for the quick response, Jay...I already have a ProphetX subscription, so will look into that more, time permitting.