question

Upvotes
Accepted
1 0 0 3

If in request for ownership data

Hello,

I would like to request only some ownership data for BMW. So far my request is as follows:

=TR("BMWG.DE";"TR.PctOfSharesOutHeld;TR.InvestorFullName";"SDate=03/2011 CH=Fd RH=IN;calcdate NULL=.";B3)

This works fine. However, I download so many observations that are rather useless (ownership data which is 0 or 0.01). Thus, I would like to filter so that I only download observations with ownership of more than 0.01%. I found out that I can use the EndNum=500 for instance. Unfortunately, this does not ensure a 0.01% cutoff. Is there a way to use something like: if PctOfSharesOutHeld>0.01 in the request? Since I plan to download ownership data for several quarters and for thousands of companies this cutoff is important to me in order not to exceed the maximum allowed rows in Excel.

Best,

Lennart

eikoneikon-com-api
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
39.2k 75 11 27

I suggest you raise this question to Thomson Reuters Helpdesk by either calling the Helpdesk number in your country or by using Contact Us capability in Eikon application. A data specialist will be able to tell you of there are any filtering parameters you can utilize.

icon clock
10 |1500

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

Click below to post an Idea Post Idea