Why are there sometimes duplicate elements in the response when requesting a mutual fund distrib...

daverudd
daverudd Newcomer
in TRKD

...ution?

(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&quot; xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;

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

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

Tagged:

Best Answer

Answers

Categories