question

Upvotes
Accepted
nick.winkley avatar image
1 ●0 ●0 ●0

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

4 Answers

Upvotes
Accepted
b.lee avatar image
707 ●2 ●1 ●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 5.0 MiB each and 10.0 MiB total.

Upvotes
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

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

Upvotes
nick.winkley avatar image
1 ●0 ●0 ●0

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

chavalit-jintamalit avatar image chavalit-jintamalit

Hi @nick.winkley

I believe that you are using Refinitiv Data Platform API.

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

Upvotes
b.lee avatar image
707 ●2 ●1 ●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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea