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)




"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"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
"I had always used ******* but for the past 2 weeks have been trying DTN IQFeed. Customer support has been extraordinary. They call just to make sure your problem hasn't recurred." - Comment from Public Forum
"I would just like to say that IQFeed version 4 is running very well and I am very happy with its performance. I would also like to extend a big thanks for the fast and efficient help that I always receive. My questions and concerns are always addressed promptly. Way to go!" - Comment from Josh in CO.
"Thanks for all of your help. Great customer service deserves to be recognized which one the reasons I've been a customer of DTN for over 10 years!" - Comment from Stuart
"It’s so nice to be working with real professionals!" - Comment from Len
"Just a quick one to say I'm very impressed so far :) The documentation for developers is excellent and I've quickly managed to get an app written to do historical downloads. The system is very robust and pretty quick considering the extent of data that's available. The support guys have been very helpful too, in combination with the forums it's been plain sailing so far!" - Comment from Adam
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 »NEW IQFEED FORUMS »IQFeed API Questions »Get consistent historical daily data
Author Topic: Get consistent historical daily data (4 messages, Page 1 of 1)

913alerts
-Interested User-
Posts: 2
Joined: Sep 25, 2020


Posted: Sep 25, 2020 07:43 AM          Msg. 1 of 4
Hello,

I've been playing with your API the last couple of days and was hoping you could explain me what I'm doing wrong.

What I do:
HDX,AAPL,1460


What I expect:
1460 datapoints that have the same data (and yes an extra day when it has opened) whether I call it now, in a few hours or tomorrow.

What I get:
ALL data keeps on changing.
I've pasted one day (2020-05-28) below from my DB; it shows a constantly changing datetime with also a different OHLC for historical data that shouldn't change anymore?


240390837 AAPL DAILY 1590696693 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 20:11:33
240390836 AAPL DAILY 1590696692 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 20:11:32
240390835 AAPL DAILY 1590682292 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 16:11:32
240390834 AAPL DAILY 1590669994 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 12:46:34
240390833 AAPL DAILY 1590667893 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 12:11:33
240390832 AAPL DAILY 1590667892 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 12:11:32
240390831 AAPL DAILY 1590661699 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 10:28:19
240390830 AAPL DAILY 1590653493 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 08:11:33
240390829 AAPL DAILY 1590639093 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 04:11:33
240390828 AAPL DAILY 1590639092 79.19250000 80.86000000 78.90750000 79.56250000 iqfeed 0 2020-05-28 04:11:32
240390827 AAPL DAILY 1590624693 79.03500000 79.67750000 78.27250000 79.52750000 iqfeed 0 2020-05-28 00:11:33
240390826 AAPL DAILY 1590624692 79.03500000 79.67750000 78.27250000 79.52750000 iqfeed 0 2020-05-28 00:11:32


Would love to hear what I'm overlooking.
Edited by 913alerts on Sep 25, 2020 at 07:44 AM
Edited by 913alerts on Sep 25, 2020 at 07:44 AM

DTN_Gary_Stephen
-DTN Guru-
Posts: 396
Joined: Jul 3, 2019


Posted: Sep 28, 2020 07:14 AM          Msg. 2 of 4
HDX is a daily data command. It returns the last X number of days. HDX,AAPL,1460 would return the last 1,460 days, not different times within the same day.

Having said that, do you send this command multiple times within a day? What you may be collecting are partial datapoints for the current day. If you are specifying S,SET PROTOCOL 6.1 (which you should be doing, unless you have backwards compatibility reasons for doing otherwise), then the HDX command will include a partial datapoint for today. The HDX command doesn't return a time, so I'm guessing the timestamp in your DB is the time you sent the request.

Having said that, I'm not sure how you could get different results for 5-28, unless you were making these requests on 5-28.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

913alerts
-Interested User-
Posts: 2
Joined: Sep 25, 2020


Posted: Sep 28, 2020 02:24 PM          Msg. 3 of 4
> HDX is a daily data command. It returns the last X number of days. HDX,AAPL,1460 would return the last 1,460 days, not different times within the same day.
Okay we're on the same page

> S,SET PROTOCOL 6.1
Thank you, added now :)

> The HDX command doesn't return a time, so I'm guessing the timestamp in your DB is the time you sent the request.
I made a mistake on my end, thank you!

> Having said that, I'm not sure how you could get different results for 5-28, unless you were making these requests on 5-28.
Probably me changing the datestring into an unixtimestamp has to do with this, I'm gonna try some things and await if that solves it, thank you!

DTN_Gary_Stephen
-DTN Guru-
Posts: 396
Joined: Jul 3, 2019


Posted: Sep 28, 2020 02:25 PM          Msg. 4 of 4
Great! Let me know if you have any more questions about the DTN IQFeed API itself!

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist
 

 

Time: Mon May 20, 2024 12:39 PM CFBB v1.2.0 10 ms.
© AderSoftware 2002-2003