question

Upvotes
Accepted
nick.winkley avatar image
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.

wasin.w avatar image   wasin.w

Hello @nick.winkley

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

4 Answers

· Write an Answer
Upvotes
Accepted
bob.lee avatar image
1.5k ●3 ●2 ●3

@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
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●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
nick.winkley avatar image
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.

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
bob.lee avatar image
1.5k ●3 ●2 ●3

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.