question

Upvotes
Accepted
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 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
41 0 0 0

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 5.0 MiB each and 10.0 MiB total.

Upvotes
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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea