Can I used the Eikon Data API to pull data from a TR formula?

eric.jian
eric.jian
in Eikon Data APIs

TR formula is a template from the Single Security Current Investor Positions (Ownership).

=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")

Tagged:

Answers

  • Zhenya Kovalyov
    Zhenya Kovalyov

    @eric.jian, I am not sure you can change the row header with the 'Rh' parameter in the Data API, otherwise - yes. Replace #1 with TR.SharesHeld and put the fields in a list.

  • eric.jian
    eric.jian

    So if I do not have that "CH=Fd RH=investorID NULL=-", the data pulled is shifted and incorrect. Do you know if there is a workaround this? Thanks

Categories