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've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"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
"I started a trial a few weeks back before the market went wild. DTN.IQ didn’t miss anything and beat my other provider. I decided to stay with you because of the great service through all the volatility." - Comment from Mike
"And by the way, have to say this. I love the IQFeed software. It's rock solid and it has a really nice API." - Comment from Thomas via RT Chat
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
"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
"As a past ******* customer(and not a happy one), IQ Feed by DTN is a much better and cheaper product with great customer support. I have had no problems at all since switching over." - Comment from Public Forum
"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
"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"This is an excellent value, the system is generous (allowing for 500 stocks) and stable (and really is tick-by-tick), and the support is fantastic." - Comment from Shirin via Email
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 »Product Support »Data and Content Support »Trading data is inconsistent - Market Open vs Extended Trading
Author Topic: Trading data is inconsistent - Market Open vs Extended Trading (6 messages, Page 1 of 1)

sasha
-Interested User-
Posts: 54
Joined: Jul 21, 2004


Posted: Oct 22, 2004 08:02 AM          Msg. 1 of 6
I'm wondering why extended trading volume is included in the TotalVolume Level 1 data?

If the Market is closed, then the TotalVolume should not increment.

Because of this in my opinion the TotalVolume field provided by DTN is wrong or at least useless.

This means I really have to calculate my own TotalVolume value.


I'm using QQQ for this example.

Another problem is that History Tick requests return ticks with times up to 16:15 hours - which is not consistant with Market Open hours of 09:30 - 16:00 hours. Consequently, does TotalVolume in historical EOD summary data include Extended trading hours trades (while the MarketClose = true)?


I will ask if this can be more clearly separated. For example, it would be better to include a Level 1 extended trading "TotalVolume" field in addition to the existing extended trading "Last" field.

I think this would be of great benefit and save a lot of people re-calculating the correct TotalVolume value.

Edited by sasha on Oct 22, 2004 at 08:19 AM

DTN_MarketData
-DTN's Market Data Experts-
Posts: 738
Joined: Jul 15, 2004


Posted: Oct 25, 2004 03:26 PM          Msg. 2 of 6
The data you are seeing on QQQ is trading that is occurring on regional exchanges like Arca (Pacific), Chicago or other regionals. This information comes into us until 16:15 and is correctly being counted as part of TotalVolume on the day.

skunk
-DTN Evangelist-
Posts: 249
Joined: May 7, 2004


Posted: Oct 26, 2004 01:13 PM          Msg. 3 of 6
I believe that the official trading hours for the index tracking stocks is 8:30 a.m. - 3:15 p.m. Central Time (Chicago time). So iqfeed is doing the correct thing in my opinion.

sasha
-Interested User-
Posts: 54
Joined: Jul 21, 2004


Posted: Oct 27, 2004 08:56 PM          Msg. 4 of 6
Houston, we have a problem!

The NASDAQ Stock Market Trading Sessions
Regular Trading Hours from 9:30 a.m. to 4:00 p.m. eastern time
After Hours from 4:00 p.m. to 6:30 p.m. eastern time

http://www.nasdaq.com/about/schedule.stm

The QQQ ETF does not have a "special" open and close time. It is the same as every other listed equity on the Nasdaq.

DTN's own feeds adhere to this because every tick is MarketOpen=false before 09:30 and after 16:00 hours. DTN.IQ Level 2 app. changes to active color at 09:30 and inactive color at 16:00.

My broker's and every other broker's trading system is configured to indicate official market open and market closed that adhere to these times.

Now here it is from the Nasdaq...

Nasdaq Pre-Market Quotes end at 09:29 hours:
http://www.nasdaq.com/?selected=NASDAQ-100+PMI

Nasdaq Pre-Market Trade Report ends at 09:29 hours:
http://quotes.nasdaq.com/quote.dll?mode=frameset&page=afterhours&symbol=QQQ&symbol=&symbol=&symbol=&symbol=&symbol=&symbol=&symbol=&symbol=&symbol=&selected=QQQ&FormType=&kind=&Leap=&mkttype=PRE&sel=premarket&userinput=&x=15&y=9

So we have a problem here because how can anyone use the DTN TotalVolume to do some calculations that rely on the actual trading volume - not volume done pre-market or after hours?

VWAP is an obvious problem - anyone calculating VWAP will have an incorrect value. A few bps difference in VWAP is a BIG problem! This way when anyone starts trading at 9:30am they are competing with true the Market Open hours VWAP and not some wild pre-post market trades.

Another problem is inconsistant numbers between snap quotes and aggregated trade tick analysis!

This is a real big pain and such a little oversight by DTN and probably minor to fix.

An obvious fix is to add another field to identify Pre-Market Volume which would clean this up and improve the data quality a lot.

Can you resolve or address this in your next release please?

Otherwise I will have to unnecessarily clean this data in real-time. I don't even want to know the mess and hacking I'm going to start in with cleaning historical data!
Edited by sasha on Oct 27, 2004 at 08:57 PM

skunk
-DTN Evangelist-
Posts: 249
Joined: May 7, 2004


Posted: Oct 28, 2004 07:20 AM          Msg. 5 of 6
hmmmm

http://www.nasdaq.com/indexshares/about_funds.stm

"What are the trading hours for Exchange Traded Funds?
Exchange Traded Funds based on broad based indexes trade until 4:15 p.m., Eastern Time. Select Sector SPDR Funds trade until 4:00 p.m. Eastern Time. iShares Sector Funds trade until 4:15 p.m. Eastern Time. Exchange Traded Funds based on foreign stock indexes trade until 4:00 p.m., Eastern Time. HOLDRS, which are depository receipts, trade until 4:00 p.m., Eastern Time."

sasha
-Interested User-
Posts: 54
Joined: Jul 21, 2004


Posted: Oct 28, 2004 07:16 PM          Msg. 6 of 6
Ok, but what is the open time?

Can DTN confirm if their feed is consistant (field MarketOpen=true/false) across each different instrument - special case for QQQ, special case for SPDR, special case for equity, future, options, etc?

Can DTN confirm what the official open time for QQQ and other broad based Index tracking symbols are?

We really need a feature/fix regarding the problem of differentiating Pre-Market and After-Hours trade volume from actual Open Market volume.

Tomorrow I'll check the feed and will have some more information to present.

I'll see what value the MarketOpen field is before 09:30. If the field MarketOpen=false before 09:30 then there is clearly a problem with incrementing TotalVolume before market open.

What is a trading system supposed to think about these phantom trades?

Why do my tick data calculations not match the snap quote TotalVolume?

This results in much confusion about whether there is/isn't a problem with missing data and where and how deep it is buried.

If TotalVolume increments before market open than how do I explain to my trading system and a million others that I'm actually feeding it some wild pre-market trade or some other weird special broker crossing trade?

Another thing for me to find out when the TotalVolume field actually stops incrementing - if ever.

I'm sure I have a valid issue here and it should make sense to everyone wanting regular unleaded Open, High, Low, Close and TotalVolume. if you look at all trading systems that take Open/High/Low/Close/TotalVolume, they are designed for on market/market open trades. Open is just that - the first price when the market officially opens. TotalVolume includes trades done from that first price - when the market is open and not some wild pre-market broker special crossing, etc.
 

 

Time: Mon May 16, 2022 12:29 AM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003