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)

"The people at Nirvana have very nice things to say about your company and I can see why! Price and service is a potent combination." - Comment from Ed

"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

"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

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

"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

"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken

"My broker in Davenport suggested I give you a try as he uses your service and says its the best." - Comment from Bill via RT Chat

"I just wanted to let u know that your data feed/service is by far the best!!! Your unfiltered tick data is excellent for reading order flow and none of your competitors delivers this quality of data!" - Comment from Peter via Email

"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

"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - 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 »IQFeed/Excel interface; how to get last month's HLOC ?

Author	Topic: IQFeed/Excel interface; how to get last month's HLOC ? (7 messages, Page 1 of 1)
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Jan 20, 2020 01:39 PM Msg. 1 of 7 Hi - I currently use the IQFeed/Excel interface to stuff a spreadsheet. Works quite well. A cell might have something like the following in it, which will display the last trading price for MSFT: =IQLink\|msft!last Two questions, tho: * Pls point me to the list of available parms to use with this; can't find it. This used to be on the website somewhere, but it's been several years since I last saw it(I think). Or, maybe it was buried in some doc on using this interface. * I'm specifically interested in getting the previous day/week/month's High, Low, Open, Close values, so I can run 'em through some formulas. Any way to get this from the iQFeed interface, or do I -have- to use a 3rd party product like QCollector? I have a license for QC and know I can get this info there, but would rather not add an extra layer of software to the process, just to get some basic info.
DTN_Stephen -DTN Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Jan 20, 2020 01:44 PM Msg. 2 of 7 Thank you for your forum post. Please review this link, you will find this very helpful. You can find both formulas and DDE Fields you are looking for. https://help.dtniq.com/dde-link-overview/ Stephen Shockey Senior Customer Support Representative and Product Support Specialist DTN 800-779-7299 stephen.shockey@dtn.com
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Jan 20, 2020 01:55 PM Msg. 3 of 7 Thanks, that's the list. Now, what about retrieving last month's HLOC info? No parms in the list, so am I outa luck or what? Doesn't appear to be a way to specify timeframe.
DTN_Stephen -DTN Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Jan 20, 2020 02:03 PM Msg. 4 of 7 Correct DDE does not quote historical data. Stephen Shockey Senior Customer Support Representative and Product Support Specialist DTN 800-779-7299 stephen.shockey@dtn.com
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Jan 20, 2020 03:07 PM Msg. 5 of 7 Thanks.
DTN_Stephen -DTN Guru- Posts: 453 Joined: Aug 22, 2014	Posted: Jan 20, 2020 03:10 PM Msg. 6 of 7 Please keep in mind Q Collector does not use our DDE interface; in this case you would be replacing a layer with Q Collector. Stephen Shockey Senior Customer Support Representative and Product Support Specialist DTN 800-779-7299 stephen.shockey@dtn.com
AMA -DTN Evangelist- Posts: 183 Joined: Aug 1, 2007	Posted: Jan 20, 2020 03:30 PM Msg. 7 of 7 Yup, I was aware of that. Have several alternatives for what I need and will be scoping them out over the next few weeks.