mgraczyk
-Interested User-
Posts: 1
Joined: Jan 20, 2005
|
Posted: Jan 20, 2005 12:10 PM
Msg. 1 of 2
This is in re: DTN.IQ.
When you get the "Close" price using SnapQuote or use the "Close" field in Excel using DDE (eg, =IQLINK|MSFT!Close), the price given is actually the prior trading day's closing price adjusted for dividends if any. This "closing" price, however, is different than the "Close" price noted in the Time and Sales tool when it is configured to report daily prices.
For example today the symbol PMN went ex-dividend and the dividend amount was 0.0493. Snap Quote reports yesterday's closing price as $11.80 but Time and Sales reports yesterday's closing price as $11.85 (yesterday's actual closing price was $11.85, not $11.80).
DTN customer support just confirmed that the data feed (ie, the data provided in Snap Quote and via DDE) do indeed reflect the prior trading day's closing price adjusted for dividends (and that these data are what are reported by the exchanges as the prior day's closing price and are not adjusted by DTN).
DTN customer support further explained that the Time and Sales data reported are delivered by DTN servers based on historical data that are not adjusted for dividends (because these prices are written to the DTN database before the exhcanges deliver the adjusted prices).
So here is the question...
Is there a way to get via Snap Quote and DDE both the prior trading day's actual closing price and the closing price adjusted for dividends? I hope so, since this seems to me to be a fundamental requirement that every user of the DTN data feed should need.
|
DTN_Jay_Froscheiser
-VP, Product Operations-
Posts: 1746
Joined: May 3, 2004
DTN IQFeed/DTN.IQ/DTN NxCore
|
Posted: Jan 21, 2005 10:25 AM
Msg. 2 of 2
Unfortunately, there is no way to do this at this time. The live quote data (watch lists, snapquotes, etc) are going to carry the data sent by the exchange at the current time. So, if adjustments are made by the exchange to the data, the live data will reflect that. The time and sales currently records what was sent at the time the data was recorded. Thus, these corrections will not be reflected in the intraday data (it should get corrected on historical data - daily). We are looking into passing those corrections to the intraday data, but it doesn't sound like that would accomplish what you want either. If we do this, both T&S and live quote data will match, but you won't be able to get both sets of data.
Jay Froscheiser DTN Market Access, LLC.
|