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

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

Find more posts tagged with

python

codebook

#technology

Accepted answers

All comments

avinash.sonde

Can I please get an update on this?

nick.zincone

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})

avinash.sonde

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

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.

EXPLORE OUR SITES