Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
19 3 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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvote
Accepted
39.4k 77 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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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