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 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
"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
"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"I noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
"Boy, probably spent a thousand hours trying to get ******* API to work right. And now two hours to have something running with IQFeed. Hmmm, guess I was pretty stupid to fight rather than switch all this time. And have gotten more customer service from you guys already than total from them… in five years." - Comment from Jim
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"I've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott
"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
Home  Search  Register  Login  Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets on Twitter
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.
 

 

Time: Thu February 22, 2024 12:54 PM CFBB v1.2.0 22 ms.
© AderSoftware 2002-2003