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 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
"Everything is working great ! Very impressive client. The news refreshes better and is more pertinent than the ******* feed I paid $ 100/month for. I Also like the charts a lot." - Comment from Leon
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"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
"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
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"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
"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
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) »Data and Content Support »Historical candles were changed
Author Topic: Historical candles were changed (4 messages, Page 1 of 1)

tarasov
-Interested User-
Posts: 12
Joined: Oct 24, 2020


Posted: Oct 24, 2020 09:43 AM          Msg. 1 of 4
Hello.
I worked with API for the last week and I faced a situation I can't understand, I hope you can help me.

In the beginning of the last week (19.10.2020) I loaded 1-minutes bars for AAPL for period 2013-01-01 - 2020-10-16 with request HIT. I saved this data and after a couple of days (21.10.2020) I loaded the same data again, with the same request. I compared this data using pandas (datetime column in index, merge and calculating differences between corresponding columns) and saw that there are differences between old and new files.

I'm attaching a file with differences to the post, I hope you can look at this. Differences mostly in volume, but there are a few differences for prices too. Can you explain to me what data are correct, old one or new one and how is it possible, that so old data (2016 and 2018 years) was changed?

I tried to get a specific request from the package I use and I think it is
HIT,AAPL,60,20130101 000000,20201016 235959,"","","",True,1,100,s,True<CR><LF>

Time in file in GMT.



File Attached: diffs.txt (downloaded 890 times)

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


Posted: Oct 26, 2020 07:21 AM          Msg. 2 of 4
Tarasov,

Are you certain that both were identical HIT requests? Because different historical requests handle trades and volume differently.

Interval history (HI_) includes only Last Qualified and Form T trades, and the period volume will include only those trades, but total volume includes all trades.

Daily history (HD_) includes only last-qualified prices (not Form T), and the period volume will include only those trades, but total volume includes all trades.

However, the daily volume includes all trades in both cases. So if you're doing different types of requests, the total volume will appear different.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

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


Posted: Oct 26, 2020 01:41 PM          Msg. 3 of 4
Tarasov,

We are investigating something that might have caused the results you describe. I'll follow up on this thread when I have more info.

Sincerely,
Gary Stephen
DTN IQFeed Implementation Support Specialist

tarasov
-Interested User-
Posts: 12
Joined: Oct 24, 2020


Posted: Oct 28, 2020 04:14 AM          Msg. 4 of 4
I'm sure that both queries were HIT type, so it means that both of them were "Interval history" type, right?

Thank you, I will wait for results of your investigation.
 

 

Time: Fri April 19, 2024 6:03 AM CFBB v1.2.0 12 ms.
© AderSoftware 2002-2003