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)

"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark

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

"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

"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

"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

"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 am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George

"I ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob

"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 was with ******* for 4 years at $230 a month, this is a huge savings for me, GOD BLESS YOU PEOPLE," - Comment from T.S. via Email

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.