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)

"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
"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
"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
"I am very happy I changed. I love the product, but more so I am thrilled with Tech Support. You are knowledgeable, polite, pleasant and professional." - Comment from Pat
"I have been using IQFeed now for a few years in MultiCharts and I have zero complaints. Very, very rare to have any data hiccups or anything at all go wrong." - 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
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"Previously I was using *******. IQFeed is WAY more economical, and for my charting needs is just as good, if not better." - Comment from Public Forum Post
"I noticed that ******* quotes locked up shortly after the interest rate announcement yesterday while yours stayed stable." - Comment from Ron in Utah
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
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
Viewing User Profile for: Ryan
About Contact
Joined: May 17, 2012 09:00 AM
Last Post: Aug 10, 2016 11:00 PM
Last Visit: Aug 10, 2016 11:43 PM
Yahoo IM:
Post Statistics
Ryan has contributed to 14 posts out of 19450 total posts (0.07%) in 2,875 days (0.00 posts per day).

20 Most recent posts:
IQFeed Developer Support » IQFeed v5.2 - Request Watches Aug 10, 2016 11:00 PM (Total replies: 1)

1. In protocol 5.2, 'S,REQUEST WATCHES\r\n' no longer returns symbols under a "trades-only" watch. Please confirm.
2. If this is the case, what should my solution be to obtain the previous functionality?

IQFeed Developer Support » Streaming Interval Bars Aug 10, 2016 03:11 PM (Total replies: 3)

I will answer my own question. Port 9400.

I'm not sure why my local copy of IQFeed Developer Docs for 5.1 does not have this port listed but has the documentation for the Derivative / Streaming Interval bars. Frustrating.

As it is after hours now, it seems that I will need to test tomorrow.

IQFeed Developer Support » Tick trade side Aug 10, 2016 03:00 PM (Total replies: 6)

If you really want to re-construct buyers v sellers at the tick level, start here:

and then search for "Lee and Ready (1991) Algorithm" for more recent follow-up studies.

IQFeed Developer Support » Streaming Interval Bars Aug 10, 2016 02:41 PM (Total replies: 3)

Before I struggle with this any longer, I figured that I would solicit your feedback.

I am unable to receive streaming interval bars with my current code. I am able to connect and receive Level 1 streaming data with--in part--with the following message:

message = 'tSPY\r\n'

It is my understanding that I should be able to receive 1-minute streaming interval bars with:

message = 'BW,SPY,60\r\n'

To this message, I receive no response from the server. Is there a different port that I need to connect to? Or a different initialization message?

I'm still not sure as to the precise answer to my issue, but it appears to involve the use of socket.ReceiveAsync method. I've switched to a synchronous method and the historical retrieval is working well. But I'm not sure if it was the async method in general, or the logic within.

Thanks for your response, Steve.

I have been able to accomplish the majority of the functionality that I stated above. However, I seem to have received data out of order or duplicated. I've attached my log file.

"Add to hold" messages are from Level 1 connection. "Adding history" messages are from historical socket.

In summary, I find the following:


!ENDMSG! | Line 25
"data.segment.1" (14:31:23.285 - 14:31:23.288) | Ending Line 44
"data.segment.2" (14:31:23.289 - 14:31:47.099) | Ending Line 460
!ENDMSG! | Line 461
"data.segment.1" (14:31:23.285 - 14:31:23.288) | Ending Line 478
!ENDMSG! | Line 479


Nothing related to the historical socket after Line 479. I've requested the messages in descending order, so I assume the "data.segment.1" ending on Line 44 is the duplicate. Any idea about the 17 duplicated transactions in "data.segment.1"?

Much appreciated,

I'm looking to implement a "retrieve missing data on loss of connection" functionality. Before I went any further with debugging, I wanted to know if it was possible to simultaneously watch a Level1 stream and retrieve historical data (same account, same computer).


Data and Content Support » SPY Bid / Ask to Four Decimals Oct 27, 2014 10:01 AM (Total replies: 0)


Have you updated your methodology on how you record Bid / Ask? I download Historical TICK data for SPY on a daily basis and I've never seen the bid / ask not rounded to two decimal places until today.


Data and Content Support » Understanding Historical Tick Data Sep 24, 2014 11:57 AM (Total replies: 5)

I'm using HTD to request tick data on SPY. I've copied a continuous portion below:

2014-09-23 09:30:00,198.4300,100,4601873,198.4300,198.4300,4305,0,0,C
2014-09-23 09:30:00,198.4400,100,4601973,198.4300,198.4300,4306,0,0,C
2014-09-23 09:30:00,198.4100,333382,4935355,198.4200,198.4300,4318,0,0,C
2014-09-23 09:30:00,198.4300,500,4935855,198.4200,198.4300,4321,0,0,E
2014-09-23 09:30:00,198.4300,500,4936355,198.4200,198.4300,4322,0,0,E
2014-09-23 09:30:00,198.4300,500,4936855,198.4200,198.4300,4323,0,0,E
2014-09-23 09:30:00,198.4300,500,4937355,198.4200,198.4300,4324,0,0,E
2014-09-23 09:30:00,198.4400,100,4937484,198.4200,198.4300,4326,0,0,C
2014-09-23 09:30:00,198.4400,200,4937684,198.4200,198.4300,4327,0,0,C

1. TickID on line 2 is 4306 and on line 3 in 4318. However, the Last Size on line 3 equals the change in the Total Volume between lines 2 & 3. So is this an aggregation of trades? If so, how is it determined that those trades should be aggregated.

2. Between lines 7 & 8 TickID 4325 is missing and the volume is not accounted for. The Total Volume increased by 129 between lines 7 & 8, but the Last Size in line 8 is 100. TickID 4325 is not in the rest of that day's data.

a. I've seen terms "implied trade" / "non-last-qualifying" used elsewhere in this forum, but I'm not sure how/if "implied trade" applies to equities and I really can't find the term "non-last-qualifying" outside of iqfeed. If this is the reason for the unaccounted for volume above, can you direct to a more substantial definition of "non-last-qualifying" (an exchange generated document perhaps)?

b. If I was watching / recording SPY in real-time, would I find these 29 shares with a TickID of 4325?

Much appreciated,

Data and Content Support » SPY VWAP using Excel via IQLink DDE Jun 11, 2013 12:37 PM (Total replies: 6)


As of 1:22 PM ET, using formula "=IQLink|SPY!VWAP" I receive a reading of ~162.84. This appears to be off. I download tick data and manually calculated VWAP and it comes out closer 163.62.

I manually calculated using all trades made on 6/11/2013. Am I missing something? I haven't been using this function, but it appeared to be unrealistically low yesterday as well. Just glancing at some other securities, they appear to be fine.


Data and Content Support » SPY Tick Data 3/20/13 - 3/22/13 Apr 1, 2013 10:17 AM (Total replies: 3)

I was trying to access the data during market hours. I will try again after 4pm.

Is this a new-ish policy?

Data and Content Support » SPY Tick Data 3/20/13 - 3/22/13 Apr 1, 2013 10:06 AM (Total replies: 3)

I can't seem to download historical tick data for SPY for the following dates: 3/20/13, 3/21/13, 3/22/13 (via NinjaTrader). I was able to download tick data for subsequent dates and I've previously downloaded 3/19/13 and prior (so I'm not sure if the problem extends further back in time at this point).

However, I was able to download minute data for 3/20/13 - 3/22/13. I've never come across this situation before. Any help is appreciated.


Data and Content Support » Excel Freezes May 17, 2012 09:29 AM (Total replies: 2)

Thanks, Tim.

Chrome was the issue.


Data and Content Support » Excel Freezes May 17, 2012 09:07 AM (Total replies: 2)

Excel freezes everytime I enter a DDE formula. Let me correct that, it has worked on several occasions, but the significant majority of the time it freezes.


Time: Mon March 30, 2020 11:14 AM CFBB v1.2.0 47 ms.
© AderSoftware 2002-2003