It looks like you're new here. If you want to get involved, click one of these buttons!
.Net API client
.Net / VBA / Excel (3rd party)
Algorithms and Strategies
Mobile and Desktop apps
Market data (WebSockets)
In this Discussion
Is historical data Dividend adjusted?
Data given in historical API is dividend adjusted?
We usually adjust data during the weekend. Can you name the instrument you are looking at?
I am not sure that Kite chart data is Dividend adjusted or not. (I verified that it is split-bonus adjusted).
Take example of COLPAL.
Latest Ex-Dividend date for this stock was 18-12-2017. 400% dividend was announced.
As per theory (
dividend amount should be deducted from stock price.
I checked kite chart data, it's not adjusted this dividend.
15-12-2018 close price: 1,072.40
18-12-2018 close price: 1,078.85
For dividends, the price adjusts itself on the markets. No normalisation required on our part. For splits/bonuses, since more stocks are created, the adjustment is required.
I have one doubt reg bonus adjustment in kite data.
I can see there some price mismatch beetween Kite data and NSE EOD data.
For example TCS share:
For 17-June-2009, NSE EOD OHLC is (392.00 395.00 375.00 379.15)
Kite daily OHLC is (385.98 388.94 369.24 372.94)
TCS company issued 1:1 bonus twice, first on 28-July-2006 and second on 16-June-2009. No other bonus/split till date. (please correct me if I am missing anything here)
So, all price data after 16-June-2019 should be match on Kite chart data and NSE EOD data. isn't it?
Could you please explain why there is price difference?
Please let me know if I am missing any adjustment here.
Hmmm... We'll have the data team check this.
.A any update?
.A You said above:
>For dividends, the price adjusts itself on the markets. No normalisation required on our part. For >splits/bonuses, since more stocks are created, the adjustment is required.
That is a misleading statement. Its actually incorrect to not apply correction for dividends on historical data. If the purpose is just to make charts across days, then not adjusting dividends isn't noticeable because dividends are usually a tiny fraction of stock price.
But lets say one is developing a strategy based on price. Lets say the rule is, whenever next day open price falls say 3% below previous day's close, then you buy and sell vice versa. Suppose current day is ex-Dividend date and dividend was 3%. The stock price will fall by 3% even in absence of any news or sentiment change in the market. Not adjusting for this dividend, will make us buy the stock, and even if the mean-reversion works on average, this day we won't make any money most likely.
So, all historical data, from yesterday into the past must be adjusted for all corporate actions before we build any trading strategy on price and volume.
We don't do the historical data adjustment for dividends. We will forward your concern to the data team.