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)

"Previously I was using *******. IQFeed is WAY more economical, and for my charting needs is just as good, if not better." - Comment from Public Forum Post

"I will tell others who want to go into trading that DTN ProphetX is an invaluable tool, I don't think anyone can trade without it..." - Comment from Luther

"You are much better than lawyers or the phone company because you answer the phone when I call! I just love your customer service." - Comment from Isreal

"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

"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom

"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen

"It’s so nice to be working with real professionals!" - Comment from Len

"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

"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 have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim

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.