Issue with balance sheet info time stamp and private/public status

Fernando E.

Hi,

I'm accessing Eikon data through the API via R. In particular, I'm downloading balace sheet/income/cash flow data for a large set of corporates. I have two issues:

1) I'm using "TR.ISPeriodEndDate"/"TR.BSPeriodEndDate"/"TR.CFPeriodEndDate" to match the data to its time stamp, but in several occasions all three dates are missing while there is actual BS data and I can check on screen which year it refers to. Are there alternatives codes that could be of use?

2) I have noticed that many of the companies which deliver all NAs for balance sheet data are, not surprisingly, private. But there are also private companies which do report data. Is there any TR.(...) variable that flags whether a company is public or private?

Thanks!

jason.ramchandani01

Hi @Fernando E. - thanks for your question.

1) So assume you have a IS field such as TR.Revenue you can toggle the output for that field from the default which will be value to a host of other output types. Please see the parameter tab in the Data Item Browser (type DIB into Eikon Search).

At the bottom you can toggle output and that gives you the option for more output types. As you change them you can see the field call in the bottom right change for each output type. eg you can request ' TR.Revenue(Period=FY0).calcdate', 'TR.Revenue(Period=FY0).periodenddate' and 'TR.Revenue(Period=FY0)' to get the dates (of which there are a few you can try them all and see which one gives you what you want) and the actual value itself.

2) If you type in 'private' into the Data Item Browser there are many fields there - each with a description - so one of those might be of help. You can also put a private company RIC into the instrument section of the DIB and then see what the values come out for each field. You may then be able to use one of them.

I hope this can help.