Can you covert the below excel formula to Codebook query?C

avinash.sonde
avinash.sonde LSEG
edited June 4 in Refinitiv Data Platform Libraries

Can you covert the below excel formula to Codebook query?

=@RDP.Data("SYBA.DE","TR.FundHoldingName;TR.FundHoldingRIC;TR.FundLatestFilingDate;TR.FundNumberOfShares;TR.FundNumberOfSharesChanged;TR.FundPercentageOfFundAssets","EndNum=2000 CH=Fd RH=IN")

Tagged:

Answers

  • avinash.sonde
    avinash.sonde LSEG

    Can I please get an update on this?

  • nick.zincone
    nick.zincone admin

    Hi @avinash.sonde

    Try this:

    ld.get_data("SYBA.DE", 
    
            "TR.FundHoldingName;TR.FundHoldingRIC;TR.FundLatestFilingDate;TR.FundNumberOfShares;"
    
            "TR.FundNumberOfSharesChanged;TR.FundPercentageOfFundAssets",
    
            parameters={'EndNum': 2000})
    image.png
  • avinash.sonde
    avinash.sonde LSEG

    Hi @nick.zincone Thanks for the update, is there also a way to retrieve the data historically, for example on a monthly basis from 6 months ago up to today? If yes, can you give me the Codebook query for it?

  • nick.zincone
    nick.zincone admin
    edited June 3
    https://community.developers.refinitiv.com/discussion/comment/126113#Comment_126113

    Hi @avinash.sonde,

    I'm not sure if this data is available historically. I would suggest you involve a content specialist who can confirm. You can reach out to the desktop help team by accessing the "Get Help & Support" option from the help (?) menu. They may be able to assist if such a capability is available using the RDP.Data() or RDP.HistoricalPricing() functions. If so, there should be a way to convert via Python within CodeBook.

Categories