Multiple Fund Income Dividends Duplocated over sequential days

nick.winkley

lipperID: 68199066

This fund in an example of a fund which has over 1000 distributions for income in the last 5 years, you can see below many share the same value

{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-04-13","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-04-12","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0048327,"date":"2021-04-09","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-04-08","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-04-07","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-04-06","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-04-05","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0064436,"date":"2021-04-01","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-03-31","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-03-30","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-03-29","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0048327,"date":"2021-03-26","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-03-25","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-03-24","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-03-23","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0016109,"date":"2021-03-22","maxDate":"2021-04-13"},
{"code":"I","name":"Income Dividend","currency":"CAD","value":0.0048327,"date":"2021-03-19","maxDate":"2021-04-13"},

bob.lee

@nick.winkley, data team confirmed our data matches the daily dividend data they received from fund company.

chavalit-jintamalit

Hi @nick.winkley

What is the API you are using and what is your API call snippet code?

What is this output that you provided?

nick.winkley

hi @chavalit-jintamalit

The Eikon Data API

https://api.refinitiv.com/data/funds/v1/assets

This is the related properties section of the call, i suggest screening by the specific lipper id

    "properties": [
        {
            "name": "Distributions",
            "period": {
                "startDate": "2016-04-16",
                "endDate": "9999-01-01"
            }
        }
    ]

That output is just translated from the assets[].distributions[] array from the returned data

"distributions": [
                {
                    "code": "W",
                    "type": {
                        "id": "5371",
                        "name": "Aggregate Accrual"
                    },
                    "values": [
                        {
                            "currency": "USD",
                            "value": 0.0001615,
                            "date": "2016-04-29",
                            "maxDate": "2021-03-31",
                            "reinvestDate": "2016-04-29",
                            "distributionPrices": [
                                {
                                    "date": "2016-04-29",
                                    "currency": "USD",
                                    "priceCode": "Nav",
                                    "value": 1,
                                    "isEstimate": false
                                }
                            ],
                            "category": {
                                "id": "5705",
                                "code": "Income",
                                "name": "Income"
                            },
                            "taxation": {
                                "id": "763",
                                "code": "Gross",
                                "name": "Gross"
                            }
                        },
                        {
                            "currency": "USD",
                            "value": 0.0000085,
                            "date": "2021-03-31",
                            "maxDate": "2021-03-31",
                            "reinvestDate": "2021-03-31",
                            "distributionPrices": [
                                {
                                    "date": "2021-03-31",
                                    "currency": "USD",
                                    "priceCode": "Nav",
                                    "value": 1,
                                    "isEstimate": false
                                }
                            ],
                            "paymentPrices": [
                                {
                                    "date": "2021-03-31",
                                    "currency": "USD",
                                    "priceCode": "Nav",
                                    "value": 1,
                                    "isEstimate": false
                                }
                            ],
                            "reinvestPrices": [
                                {
                                    "date": "2021-03-31",
                                    "currency": "USD",
                                    "priceCode": "Nav",
                                    "value": 1,
                                    "isEstimate": false
                                }
                            ],
                            "category": {
                                "id": "5705",
                                "code": "Income",
                                "name": "Income"
                            },
                            "taxation": {
                                "id": "763",
                                "code": "Gross",
                                "name": "Gross"
                            }
                        }]

This is from a different fund as an example

chavalit-jintamalit

https://community.developers.refinitiv.com/discussion/comment/76847#Comment_76847

Hi @nick.winkley

I believe that you are using Refinitiv Data Platform API.

I moved your question to "Refinitiv Data Platform" forum.

bob.lee

@nick.winkley, The data seems matching Lipper's desktop service: Lipper IM (see below). If you know / think this is wrong data, please raise this to Lipper's data team via client support or directly if you know the contact.

To me, this repeated dividend does look strange. But I am not an expert on Canadian market, I will also check with data team to understand it better.