question

Upvotes
Accepted
daverudd avatar image
1 ●1 ●1 ●0

Why are there sometimes duplicate elements in the response when requesting a mutual fund distribution?

(1) In order to get all the distributions for a mutual fund I assume we should call

LipperFundamentals_1Client.GetDistribution_1.

Is that true? If not, how can we obtain all the distributions for a fund?

(2) Calling LipperFundamentals_1Client.GetDistribution_1one sometimes gets

a response <DistributionList> that contains duplicate <DistributionItem>

elements for the same year and month.

Please see the attached file; it contains the distributions obtained via the

aforementioned service for the following fund:

ClearBridge Aggressive Fund A (lipper ID = 40001160)

How should one compute the total aggregate distribution for a certain year-month

if there are duplicates (as in the attached file)?

Is the presence (sometimes) of duplicates part of the normal return structure?


Here is the response fiie in question (lipper ID = 40001160) (some DistributionItems are omitted for brevity)

<?xml version="1.0" encoding="utf-16"?>

<DistributionResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">;

<DistributionResult xmlns="http://www.reuters.com/ns/2009/01/01/webservices/rkd/LipperFundamentals_1">;

<DistributionType>

<LipperId>40001160</LipperId>

<DistributionList>

<DistributionItem>

<DataDate>1984-09-28</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.13</DistributionValue>

<ReinvestmentDate>1984-09-30</ReinvestmentDate>

<PaymentDate>1984-09-28</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

*** items skipped for brevity ...


<DistributionItem>

<DataDate>2013-12-11</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>1.42488</DistributionValue>

<ReinvestmentDate>2013-12-11</ReinvestmentDate>

<PaymentDate>2013-12-11</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2013-12-11</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>1.42488</DistributionValue>

<ReinvestmentDate>2013-12-11</ReinvestmentDate>

<PaymentDate>2013-12-11</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2014-12-10</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>4.00347</DistributionValue>

<ReinvestmentDate>2014-12-10</ReinvestmentDate>

<PaymentDate>2014-12-10</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2014-12-10</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>4.00347</DistributionValue>

<ReinvestmentDate>2014-12-10</ReinvestmentDate>

<PaymentDate>2014-12-10</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2015-12-09</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>7.54549</DistributionValue>

<ReinvestmentDate>2015-12-09</ReinvestmentDate>

<PaymentDate>2015-12-09</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2015-12-09</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>7.54549</DistributionValue>

<ReinvestmentDate>2015-12-09</ReinvestmentDate>

<PaymentDate>2015-12-09</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2016-12-07</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>8.12886</DistributionValue>

<ReinvestmentDate>2016-12-07</ReinvestmentDate>

<PaymentDate>2016-12-07</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2016-12-07</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.17909</DistributionValue>

<ReinvestmentDate>2016-12-07</ReinvestmentDate>

<PaymentDate>2016-12-07</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2016-12-07</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.683417</DistributionValue>

<ReinvestmentDate>2016-12-07</ReinvestmentDate>

<PaymentDate>2016-12-07</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2016-12-07</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>8.991367</DistributionValue>

<ReinvestmentDate>2016-12-07</ReinvestmentDate>

<PaymentDate>2016-12-07</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2017-12-06</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>11.75209</DistributionValue>

<ReinvestmentDate>2017-12-06</ReinvestmentDate>

<PaymentDate>2017-12-06</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2017-12-06</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>11.75209</DistributionValue>

<ReinvestmentDate>2017-12-06</ReinvestmentDate>

<PaymentDate>2017-12-06</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2017-12-20</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.390312</DistributionValue>

<ReinvestmentDate>2017-12-20</ReinvestmentDate>

<PaymentDate>2017-12-20</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2017-12-20</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.390312</DistributionValue>

<ReinvestmentDate>2017-12-20</ReinvestmentDate>

<PaymentDate>2017-12-20</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2018-12-06</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.00198</DistributionValue>

<ReinvestmentDate>2018-12-06</ReinvestmentDate>

<PaymentDate>2018-12-06</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2018-12-06</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>29.84295</DistributionValue>

<ReinvestmentDate>2018-12-06</ReinvestmentDate>

<PaymentDate>2018-12-06</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2018-12-06</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>29.84493</DistributionValue>

<ReinvestmentDate>2018-12-06</ReinvestmentDate>

<PaymentDate>2018-12-06</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2018-12-19</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.398907</DistributionValue>

<ReinvestmentDate>2018-12-19</ReinvestmentDate>

<PaymentDate>2018-12-19</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2018-12-19</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.398907</DistributionValue>

<ReinvestmentDate>2018-12-19</ReinvestmentDate>

<PaymentDate>2018-12-19</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2019-12-05</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>21.42755</DistributionValue>

<ReinvestmentDate>2019-12-05</ReinvestmentDate>

<PaymentDate>2019-12-05</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2019-12-05</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>21.42755</DistributionValue>

<ReinvestmentDate>2019-12-05</ReinvestmentDate>

<PaymentDate>2019-12-05</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2019-12-18</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.833293</DistributionValue>

<ReinvestmentDate>2019-12-18</ReinvestmentDate>

<PaymentDate>2019-12-18</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

<DistributionItem>

<DataDate>2019-12-18</DataDate>

<CurrencyCode>USD</CurrencyCode>

<DistributionValue>0.833293</DistributionValue>

<ReinvestmentDate>2019-12-18</ReinvestmentDate>

<PaymentDate>2019-12-18</PaymentDate>

<MaxDate>2019-12-18</MaxDate>

<TaxOperation xsi:nil="true" />

<TaxableInterestIncome xsi:nil="true" />

<IncomeOperation>PAID</IncomeOperation>

</DistributionItem>

</DistributionList>

</DistributionType>

</DistributionResult>

rkd-apirkd
icon clock
10 |1500

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

Jirapongse avatar image   Jirapongse

@daverudd

Hi,

As your query is related to Refinitiv Knowledge Direct, I moved it to this TRKD group.

Kind regards,

AHS

wasin.w avatar image   wasin.w

<AHS>

Contact Onlinesolutions@refinitiv.com team to help the client.

wasin.w avatar image   wasin.w

<AHS>

RKD team is investigating the issue with the content team via a separate channel.

wasin.w avatar image   wasin.w

Hello @daverudd

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks,


AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


2 Answers

· Write an Answer
Upvotes
Accepted
muzammil.sharief1 avatar image
111 ●1 ●1 ●2

Hi Dave,

I am checking on it will respond back in sometime.

Thanks

Muzammil

icon clock
10 |1500

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

Upvotes
daverudd avatar image
1 ●1 ●1 ●0

Thank you. Yes, the question belongs in that group

icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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