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)




"DTN has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton
"Everything is working great with the API. I love it." - Comment from Calvin
"IQ feed works very well, does not have all of the normal interruptions I have grown used to on *******" - Comment from Mark
"I use IQ Feed, Great stuff as far as data analysis information, storage and retrieval is concerned." - Comment from Public Forum
"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
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"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
"The service is great, I see a noticeable improvement in my volume profiles over [broker]'s data feed" - Comment from Larry
"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
"For anyone considering using DTN.IQ for a data feed, my experience with the quality of data and the tech support has been very positive." - Comment from Public Forum
Home  Search  Register  Login  Blogs Recent Posts

Information on Various DTN Products:
DTN IQFeed | DTN ProphetX | DTN Ag | NxCore
Follow DTN_IQFeed on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »IQFeed Developer »IQFeed Developer Support »Historical API Issue
Author Topic: Historical API Issue (7 messages, Page 1 of 1)

AlexK
-Interested User-
Posts: 12
Joined: Oct 2, 2017


Posted: Oct 2, 2017 08:32 AM          Msg. 1 of 7
Hello,

We're seeing a fairly significant issue with the HDT Historical API. Problem:

When we take Lead Hog (as an example), and run the API daily, we get a certain set of prices each day. In this example, on 7-24-17, Lean Hog is at price point $80.725 when we call the API each day in July. If we we wait and run the same HDT Historical API on say, October 1st, for the same day and commodity, we get a price of $66.975.

So, the same API yields different data, depending on when it's called. This is a huge problem for us and am wondering if there's a different API we should be calling historically, or if you see the same issue?

Thank you.

DTN_Tim Walter
-DTN Guru-
Posts: 1093
Joined: Apr 25, 2006


Posted: Oct 2, 2017 08:49 AM          Msg. 2 of 7
Good morning,

I believe this is related to the post below. If you look at the underlying contracts you will find the data has not changed. It is just on the continuous contracts where this will be seen, as the contracts being reported for certain dates will have changed completely.

Also, in case this is relevant, if you are using the @HE#C symbologies, those prices see adjustments at every contract expiration. If you want the prices to be unadjusted, be sure to just use @HE# instead.

Tim

http://forums.dtn.com/index.cfm?page=topic&topicID=4377

"Based on customer feedback, effective this evening we will be changing the roll users for @LE (Live Cattle), @HE (Lean Hogs) and @LB (Lumber) contracts to roll 2 weeks prior to expiration. This will provide continuation chart data that will more closely follow volume/OI on these contracts."

AlexK
-Interested User-
Posts: 12
Joined: Oct 2, 2017


Posted: Oct 2, 2017 09:10 AM          Msg. 3 of 7
We are using @xx#, NOT the adjusted continuous, and we are getting these different results based on WHEN the same API is run

AlexK
-Interested User-
Posts: 12
Joined: Oct 2, 2017


Posted: Oct 2, 2017 09:14 AM          Msg. 4 of 7
Thank you for the quick response.

We are not using #C, ever. We are always using the unadjusted # on our API calls. In the example I gave you for July, we get different data back depending on whether we call the API on a daily basis through July vs calling the API to provide that July data later on (August, Sept, Oct, whatever).

DTN_Tim Walter
-DTN Guru-
Posts: 1093
Joined: Apr 25, 2006


Posted: Oct 2, 2017 09:39 AM          Msg. 5 of 7
@HEQ17 has the open of 80.725 that you mentioned.

But, when we changed the roll dates on our end which govern the continuous contracts, it changed the emphasis from @HEQ17 to @HEV17

And if were to look, you would find that @HEV17 shows the open you mentioned at 66.975 for the date 7-24-2017.

It was the change of the roll dates that would have caused this. If you wanted to have a rolling contract that would not be subject to this type of change (albiet these changes are rare) you would have to build your continuous contracts from the underlying daily data.

Tim

AlexK
-Interested User-
Posts: 12
Joined: Oct 2, 2017


Posted: Oct 2, 2017 12:14 PM          Msg. 6 of 7
Thank you, again. So just to confirm: can you provide that continuous contract data in an API call historically or would I have to build that out myself in some manner?

DTN_Tim Walter
-DTN Guru-
Posts: 1093
Joined: Apr 25, 2006


Posted: Oct 2, 2017 12:21 PM          Msg. 7 of 7
If you want it to look like it was before, then yes, you would have to create that yourself. Though in my opinion, the data before was not using the most active contract, it was simply based on expiration. Therefore, I feel, that the new data is a better indication of where the market was comparatively to where we had it previously.

Tim
 

 

Time: Mon December 11, 2017 1:36 AM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003