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)

"I just wanted to let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate

"I am very pleased with the DTNIQ system for quotes and news." - Comment from Larry

"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles

"I'm satisfied with IQFeed. It's the most reliable and fastest quote feed I have ever used. Although I'm a resident in China, it's still very fast!" - Comment from Xiaofei

"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

"As a past ******* customer(and not a happy one), IQ Feed by DTN is a much better and cheaper product with great customer support. I have had no problems at all since switching over." - Comment from Public Forum

"I used to have *******, but they are way more money for the same thing. I have had no probs with data from DTN since switching over." - 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

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

"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan

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.