For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
iwasaki avatar image
32 ●0 ●2 ●3

Doubt about calculation of "TR.WACCBeta.value" in get_data()

I have a doubt about some values that I got when I run the code below:

ek.get_data('5411.T', fields=["TR.WACCBeta.date","TR.WACCBeta.value"], parameters={'SDate':'2020-03-01', 'EDate':'2020-03-31', 'Frq':'D'})[0]

I found seemingly unreasonable abrupt change in values on 2020-03-15 and 2020-03-16:

5411.T 2020-03-14T00:00:00Z 1.732474

5411.T 2020-03-15T00:00:00Z 1.253408

5411.T 2020-03-16T00:00:00Z 1.161265

5411.T 2020-03-17T00:00:00Z 1.711114

5411.T 2020-03-18T00:00:00Z 1.742852

5411.T 2020-03-19T00:00:00Z 1.798471

I understand that this beta is calculated with the order of preference: 5Y monthly, 3Y weekly, 2Y weekly, 180D daily, 90D daily, and I suspect that it has something to do with these settings of duration and frequency. The thing is that 5411.T has long track record and I'm sure that 5Y monthly data has been always available at least recently. Could somebody look into this sudden level shift followed by come-back on the original track? Thank you!

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvote
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @iwasakI

First of all, I can confirm that the coding you provided is valid and it retrieves the same data on Eikon Excel.


This forum is not the best place to ask about content questions. For an authoritative answer to any content questions, the best resource is the Refinitiv Content Helpdesk.

This forum is dedicated to things specific to the use of Eikon APIs.

The moderators here do not have deep expertise in every type of content available through Eikon.

The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application or by calling the Helpdesk number in your country.

Or at https://my.refinitiv.com/


ahs.png (107.4 KiB)
icon clock
10 |1500

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

Click below to post an Idea Post Idea