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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
eric.jian avatar image
19 ●1 ●1 ●5

Can I change the row header with the 'Rh' parameter using the Eikon Data API?

I would like to use the Eikon Data API to replicate the data pull of this excel formula

=TR(FLWS.OQ,"TR.InvestorFullName;TR.InvestorType;TR.InvAddrCountry;TR.InvInvestmentStyleCode;TR.PctOfSharesOutHeld;#1(Sdate=-1CQ);#1(Sdate=-1CQ).date;#1(Sdate=-2CQ);#1(Sdate=-2CQ).date;#1(S"&"date=-3CQ);#1(Sdate=-3CQ).date;#1(Sdate=-4CQ);#1(Sdate=-4CQ).date;#1(Sdate=-5CQ);#1(Sdate=-5CQ).date;#1(Sdate=-6CQ);#1(Sdate=-6CQ).date;#1(Sdate=-7CQ);#1(Sdate=-7CQ).date;#1(Sdate=-8CQ);#1(Sdate=-8CQ).date","CH=Fd RH=investorID NULL=-",,"TR.SharesHeld")

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
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

RH parameter cannot be used with Eikon Data APIs. What one should understand here is that in your request the fields TR.InvestorFullName, TR.InvestorType etc are also dependent on the value of SDate parameter, just as the field TR.SharesHeld is. The list of investors returned may not be the same depending on the value of SDate. Even if the table is aligned on investorID, as =TR function does when you add RH:investorID, the result is still not perfect. You'll get the best result if you retrieve the list of investors separately for each quarter and then combine the tables as you see fit. I suggest you use the following request and repeat it for each quarter:

ek.get_data("FLWS.OQ",["TR.InvestorFullName.investorID",
                       "TR.InvestorFullName","TR.InvestorType",
                       "TR.InvAddrCountry","TR.InvInvestmentStyleCode",
                       "TR.PctOfSharesOutHeld",
                       "TR.SharesHeld","TR.SharesHeld.date"],
            {'Sdate':'-1CQ'})
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