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)

"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

"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

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

"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

"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

"Very impressed with the quality of your feed - ******* is a real donkey in comparison." - Comment from A.C. via Email

"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

"And by the way, have to say this. I love the IQFeed software. It's rock solid and it has a really nice API." - Comment from Thomas via RT Chat

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

"You have an excellent product !!!!!!" - Comment from Arely

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.