Is it possible to retrieve all the holdings using a ticker in Reuters Excel add-in? For example for product
IE00BM67HT60, I used ticker TR.FundHoldingName but I could only retrieve top holdings for this ETF, and I also want to know the tickers which can retrieve all the currencies/counties. I used ticker TR.FundPercentageOfFundAssets but it could only retrieve part of the holdings.
You can specify StartNum and EndNum to get all the holdings.
=TR("IE00BM67HT60","TR.FundHoldingName;TR.FundPercentageOfFundAssets;TR.FundCountryOfDomicile;TR.FundHoldingRIC","StartNum=1 EndNum=1000 CH=Fd RH=IN",B2)