How to filter ownership data using the Eikon Formula Builder?

Hello,

I am using the following formula to extract ownership data in Excel:
=@RDP.Data(A2:A1000;"TR.InvestorFullName;TR.InvestorType;TR.InvInvmtOrientation;TR.PctOfSharesOutHeld;TR.OwnTrnverRating;TR.InvestorTotalAssets";"SDate=#1 CH=Fd RH=IN";E4;$D$1)

However, as I am trying to analyze a large number of companies over multiple years, the loading process takes very long. I am only interested in shareholders that hold at least 5% of the regarding firm (TR.PctOfSharesOutHeld >= 5). Is it possible to include such a filter within my formula?

Thanks a lot for any help!

Find more posts tagged with

eikon

excel

workspace

formula-builder

#content

Accepted answers

Jirapongse

@Tobias.Schueler

Thank you for reaching out to us.

Typically, you can check all available parameters on the Formula Builder.

I couldn't find the filter parameter for the value of TR.PctOfSharesOutHeld. However, please contact the helpdesk team via MyAccount to confirm this.

All comments

Jirapongse

@Tobias.Schueler

Thank you for reaching out to us.

Typically, you can check all available parameters on the Formula Builder.

I couldn't find the filter parameter for the value of TR.PctOfSharesOutHeld. However, please contact the helpdesk team via MyAccount to confirm this.

EXPLORE OUR SITES