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 victor.koyama · Jun 09, 2020 at 02:55 PM · apipython api eikonget_data

Get History Beta - Get_Data Function

Hello,

I'm trying to retrieve the history for the 180D, 90D and BetaWklyAdj2Y indicadors from the TR.WACCBeta function. Currently, I've been able to set the date interval and frequency for the query. However, I have no idea how I can select the different indicators mentioned above. So far, I managed to build the following statment:


ek.get_data(stock_list,'TR.WACCBeta',{'SDate':'2020-05-22', 'EDate':'2020-05-29', 'FRQ':'D'})[0]


How can I adapt the function above to retrive the data desired?

Obs: I've tried to use the 'TR.BetaDaily180D','TR.BetaWklyAdj2Y','TR.BetaDaily90D' functions. However, they are not allowed to retrive data historically.

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.

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by zoya.farberov · Jun 09, 2020 at 04:34 PM

Hello @victor.koyama,

I use Data Item Browser to confirm what content fields are available for the instrument, and what parameters are supported.

Within Eikon desktop I run Data Item Browser and examined, for IBM.N TR.WACCBeta field:

It allows for various time intervals in the parameters, for example, quarterly

ek.get_data('IBM.N',['TR.WACCBeta'],{'SDate':0,'EDate':-4,'Frq':'FQ'}

Resulting in

(  Instrument      Beta
 0      IBM.N  1.295649
 1      IBM.N  1.336528
 2      IBM.N  1.325593
 3      IBM.N  1.251175
 4      IBM.N  1.232000, None)

The other fields that you mention, 'TR.BetaDaily180D','TR.BetaWklyAdj2Y','TR.BetaDaily90D' do not support the same parametrization, so you can only retrieve only single, current value

So I think what you see is consistent with what is currently supported?




dib1.gif (205.0 KiB)
dib2.gif (139.8 KiB)
Comment

People who like this

0 Show 2 · 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
victor.koyama · Jun 09, 2020 at 04:50 PM 0
Share
Hello, zoya


As I was reading the TR.WACCBeta descripton, I noticed it stated that "...various look back periods can be used to calculate it. In order of preference, Beta 5y monthly, Beta 3Y weekly,..., Beta 180D, Beta90D are used in the calcularion.". I wonder if there's a way for me to choose which methodology should be considered in the calculation.

Is that possible?

Thanks for the help!

avatar image
REFINITIV
Alex Putkov. ♦♦ victor.koyama · Jun 09, 2020 at 09:17 PM 0
Share

I'm afraid not. This field is calculated by Refinitiv for use in Starmine valuation models. More specifically it is used to calculate the cost of shareholder equity according to CAPM (Capital Asset Pricing Model), which in turn is used to calculate WACC (Weighted Average Cost of Capital). Starmine uses the methodology for Beta calculation in the order of preference stated in TR.WACCBeta field description: if 5Y monthly Beta can be calculated, then 5Y monthly Beta is used. If for any reason (e.g. not enough price history for the stock) 5Y monthly Beta cannot be calculated, then we attempt to calculate and use 3Y weekly Beta, and so on.

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 >
11 People are following this question.

Related Questions

Python API retrieve stock fundamental data specificly to include OriginalAnnouncementDate

Time Series of Analytics / Python

Get Data API for Corporate action doesn't return Stock Dividend Event.

EIKON API PYTHON AUTOMATION

Retrieve fund dividend type via Python Eikon 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