|
|
Home
Search
Register
Login
Recent Posts
»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.
|
|
|