「ESTIMATES IBES V1 > GET SUMMARIES」What are the key items in "Measures"?

gagaga_fugugu

Hello.

I have a question about the resulting data retrieved by "ESTIMATES IBES V1 > GET SUMMARIES" in RKD.

"Measures": {　　

　"Measure": [

　　{

　　　"Code": "SAL",

　　　"Name": "Revenue",

　　　"Abbreviation": "SAL",

　　　"IsPreferred": false,

　　　"ReportingBasis": "Consolidated",

　　　"ValueFormat": {　・・・　},

　　　"Section": "Income Statement",

　　　"PrecisionDetail": 2,

　　　"PrecisionSummary": 2,

　　　"Periods": {}

　　　　"Periods": [　・・・

We are trying to put the "Measures" data into the DB.

(The "ValueFormat":{} and "Periods":{} will be stored in another table related to this one, so they are not relevant here.

I used "Code" as a key item, but the SAL will be duplicated.

Which item should I set as the key item to store the Measures correctly in the DB?

Please let me know.

wasin.w

Hello @gagaga_fugugu

The RKD team has reviewed the request message and the question. The team suggests you use the SAL = REVENUE as the standard measure to get revenue estimates. The code SAL can be used in ADD MEASURE field as well however reporting basis and calculation basis fields need to kept blank while using SAL as a single code in ADD MEASURE.

The below information are details of business classification (TRBC).

wasin.w

Hello @gagaga_fugugu

Could you please confirm if you already receive the correct data from RKD, but you want to know if there a non-duplicate item in the Measures data array?

gagaga_fugugu

Thanks for the reply.

JSON is correctly received from RKD.

When I tried to import the Measures array, the "Code": "SAL" was duplicated, so I would like to know what I should set as the key item to prevent the same thing from happening.

wasin.w

Hello @gagaga_fugugu

Thank you for the information, this question seems to be the RKD data content question rather than the API how to use question.

I am contacting the RKD support team to verify the RKD content structure.

mohammad waseem

Hello gagaga_fugugu,

The measure code indicates the data items for which data needs to be retrieved. The code for revenue is 'SAL', the code for dividend per share is 'DPS' etc. They will appear in the response multiple times if you are trying to retrieve data for multiple periods. I have tried to prepare a table containing sample values for the headers below including CODE. Are you concerned that the same code SAL is appearing in in both CODE as well as Abbreviation columns ?

CODEAbbreviationNamePeriodValueSALSALRevenueFY11000SALSALRevenueFY21500SALSALRevenueFY31200

gagaga_fugugu

@wasin.waeosri

Hello

Thanks for the reply.

I am waiting for your answer.

gagaga_fugugu

Hello, @mohammad waseem

Thank you for your reply. And thank you for the sample.

I will store the "Periods" data, which is the data by fiscal period, in a separate table, so the data I will keep is the measure code data.

(Periods data will be used in conjunction with the current data.

When I requested the data with the following settings, two SALs appeared.

When I requested the data with the following settings, two SALs appeared. There are SAL and Pharma in the Abbreviation column, and I think I should use this as one of the key items, but I would like to know which item is necessary to avoid problems in the future.

-------------------------------------------

SYMBOL

・Type:Ric, Value:0867.HK

MEASURES

・Code:All, Segment Code: (Empty)

RELATIVE PERIODS

・Type: Annual, Number -1

・Type: Annual, Number 0

・Type: Annual, Number 1

・Type: Annual, Number 2

・Type: Annual, Number 3

・Type: Annual, Number 4

・Type: Annual, Number 5

・Type: Annual, Number 6

・Type: Interim, Number -2

・Type: Interim, Number -1

・Type: Interim, Number 0

・Type: Interim, Number 1

・Type: Interim, Number 1

・Type: Interim, Number 3

・Type: Interim, Number 4

Use Summary Options: Check

・Output Industry Code Type: Trbc

・Include Estimate Snapshots:

　…the following：No

gagaga_fugugu

@wasin.waeosri

Thanks for the reply.

I am waiting for your answer.

wasin.w

Hello @mohammad waseem

Could you please help the client regarding this follow-up question?

wasin.w

Hello @gagaga_fugugu

Could you please share the XML/JSON request message example so the RKD team can replicate the issue?

Please remove your credential from the file before post the file into this forum too.

mohammad waseem

@gagaga_fugugu

I tried the same company with same periods and measure code 'SAL' but do not see 'Pharmaceutical Sales' in the name. This company is a pharmaceutical company. The code 'SAL' is for Revenue and applicable to all the companies globally regardless of the industry they belong. You can use 'GetMeasures_1' API call to get the list of measures available for any company with corresponding name.

thanks,

Waseem

gagaga_fugugu

api_trkd_thomsonreuters_com_api_EstimatesIBES.txt@wasin.waeosri

Thanks for the reply.

I will send you the request JSON without the authentication related information.

Currently, I am thinking that there will be no problem if the following items are included in the key items, but is this too much?

Abbreviation

ReportingBasis

Section

If you can give me the correct answer, I would appreciate it.

I would appreciate it if you could give me an answer in a little hurry.

Thank you very much for your help.

Translated with www.DeepL.com/Translator (free version)

wasin.w

Hello,
Thank you for the file. I have passed it with the question to the RKD support team.

wasin.w

Hello @gagaga_fugugu

The RKD team has reviewed the request message and the question. The team suggests you use the SAL = REVENUE as the standard measure to get revenue estimates. The code SAL can be used in ADD MEASURE field as well however reporting basis and calculation basis fields need to kept blank while using SAL as a single code in ADD MEASURE.

The below information are details of business classification (TRBC).

SAL

Pharmaceutical Sales

Pharma

false

Consolidated