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 cannot believe what a difference it makes trading with ProphetX!" - Comment from Bruce in Los Angeles
"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
"Everything is working great with the API. I love it." - Comment from Calvin
"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 just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email
"I was on the phone with a friend who uses CQG and right after the Fed announcement, CQG was as much as 30 seconds behind DTN.IQ. Some quotes were off by as much as 15-18 cents. Your feed never missed a beat." - Comment from Roger
"Interactive Brokers tick data was inconsistent, so I have switched to using DTN exclusively. It is great to no longer have to worry about my datafeed all day long." - Comment from Philippe
"Thanks for the great product and support. During this week of high volume trading, my QuoteTracker + IQ Feed setup never missed a beat. Also, thanks for your swiftness in responding to data issues. I was on ******* for a few years before I made the switch over early this year, and wish I had done it a long time ago." - Comment from Ken
"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
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
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 19650 total posts (0.07%) in 2,980 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 July 13, 2020 9:20 PM CFBB v1.2.0 0 ms.
© AderSoftware 2002-2003