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)

"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"Everything is working great with the API. I love it." - Comment from Calvin
"I've been using IQFeed 4 in a multi-threaded situation for the last week or two on 2600 symbols or so with 100 simultaneous daily charts, and I have had 100% responsiveness." - Comment from Scott
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
"I cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"I just wanted to tell you what a fine job you have been doing. While *******, from what I hear, has been down and out, off and on, IQ feed has held like a champ this week." - Comment from Shirin
"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum
"I ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"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
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 19160 total posts (0.07%) in 2,616 days (0.01 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 July 15, 2019 2:55 PM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003