Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by luis_paulo_silva · Oct 04, 2018 at 09:08 AM · dividendadjusted-priceseod pricing

Dividend adjusted historical prices

From what i read in other posts historical prices are adjusted only for splits and not dividends. Is there any way to get dividend adjusted data?

Something like the 10,000 usd reinvested one can get using the eikon desktop app would be enough if EOD data is available.

This is a major problem for me. Is there any alternative?

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

6 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Oct 04, 2018 at 10:08 AM

I'm not sure I quite understand this part of the question: "Something like the 10,000 usd reinvested one can get using the eikon desktop app would be enough if EOD data is available". Perhaps what you're looking for is total return on a stock? If this is the case you can get total return from Eikon Data API using the field TR.TotalReturn. E.g. this will give the total return on Thomson Reuters stock between 01-JAN-17 and 01-JAN-18:

ek.get_data(['TRI.N'],['TR.TotalReturn'],{'SDate':'2017-01-01', 'EDate':'2018-01-01'})
You may also want to look at this thread.
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by Alex Putkov. · Oct 04, 2018 at 09:54 AM

The practice of what to consider a capital change event requiring stock price adjustment differs by market. E.g. in Brazil the market practice is to adjust stock price histories for dividends whereas in the US the practice is to exclude dividends from capital changes requiring adjustment of a stock price history. If the practice for the market you're interested in is to not adjust price history for dividends, you can always do the adjustment yourself: retrieve the price history, the dividend history and do the adjustment following the methodology of your choosing (e.g. subtract the dividend amount from the stock price).

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by luis_paulo_silva · Oct 04, 2018 at 10:36 AM

@Alex Putkov.

Thank you for the answer.

If the practice for the market you're interested in is to not adjust price history for dividends, you can always do the adjustment yourself

I figured as such but dividend adjusting the historical price of all stocks of the russel 2000 is somewhat troublesome. Even if i can hypothetically do that with one or two for loops i guess that is not what i was expecting from Eikon.

Even if the US Market uses only split adjusted data i see no reason for split-dividend adjusted data to not be available.

Split-Dividend adjusted data is essencial for backtesting and portfolio optimization and i'm somewhat puzzed this is not getting more attention (services like Quantopian seem to understand that).

In respect to the total return, what i meant was growth data would be enough for me, even if it was normalized to say, 10,000. The price per se is not necessary, as i normalize it to run the optimization.

Comment
839395901
matteo.avigni
sdittmar

People who like this

3 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Alex Putkov. ♦♦ · Oct 04, 2018 at 11:02 AM 1
Share

@luis_paulo_silva
Thank you very much for your feedback. Since it is about content available through Eikon and not about APIs, which is what this forum is dedicated to, I suggest you raise it with Refinitiv Helpdesk. You can reach the Helpdesk by either calling the Helpdesk number in your country or by using Contact Us capability in your Eikon application.

avatar image
Answer by luis_paulo_silva · Oct 04, 2018 at 04:47 PM

@Alex Putkov.

Again, thank you for the quick response. I will follow through with your recomendation and contact the help desk.

For future reference the API call I was making was:

SPY = ek.get_timeseries(["SPY"],
                        "Close",
                        start_date="2016-12-30",  
                        end_date="2017-12-31")

Which returns close data unadjusted for dividends/distributions.

P.S. - From what i gathered European ETF and mutual Funds are also dividend/distribution unadjusted.

Comment
839395901

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
REFINITIV
Answer by Wan Po.Lee · Oct 04, 2018 at 10:29 PM

@luis_paulo_silva For funds, including ETFs, you can get the performances of the fund and then derive its “adjusted historical prices). Because the performance provided by Lipper is by-default the total return that reflects dividends (reinvested on ex-div date) and other cooperate actions such as unit split/merge. However, for historical rolling performances, only weekly performances are available for 5-year period or shorter and only monthly performances for longer period.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
Answer by s.klein · Dec 04, 2018 at 09:28 AM

@luis_paulo_silva is not the only person interested in dividend adjusted data. Imho it is one of the major drawbacks of Eikon, and something that tradingview and stockcharts offers for free! You cannot properly utilize technical indicators on equities if your underlying data is not adjusted for cash dividends - a signal can be generated improperly simply by the underlying equity going 'ex-dividend'. The total return function does not give the OHLC prices, and having to pull all of the data and calculate on my own is burdensome and seems like reinventing the wheel.

Comment
sdittmar

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
13 People are following this question.

Related Questions

Retrieve dividend stock via Python Eikon API

cannot get unadjusted price from get_timeseries()

How can I get dividend data in certain condition using python API?

HOW to get adjustment factor "Sheet" by get data?

Forecast Dividends for Next 12 months using python API

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges