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)




"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"With HUGE volume on AAPL and RIMM for 2 days, everyone in a trading room was whining about freezes, crashes and lag with *******, RealTick, TS and Cyber. InvestorRT with IQFeed was rock solid. I mean SOLID!" - Comment from Public IRC Chat
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"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
"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
"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
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"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
"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
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 »Product Support »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 Evangelist-
Posts: 226
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 Evangelist-
Posts: 226
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 Evangelist-
Posts: 226
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: Mon February 24, 2020 2:28 AM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003