question

Upvotes
Accepted
1 1 1 1

Multiple Fund Income Dividends Duplocated over sequential days

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"},
rdp-apirefinitiv-data-platformfunds
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
Accepted
1k 2 2 1

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

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
18.1k 21 12 21

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?

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

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

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.

Hi @nick.winkley

I believe that you are using Refinitiv Data Platform API.

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

Upvotes
1k 2 2 1

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



fund-div-screen.png (210.8 KiB)
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.