question

Upvotes
Accepted
49 3 6 12

Does RDP Fund API provide a capability to retrieve time series daily TNA data?

Does RDP Fund API provide a capability to retrieve time series daily TNA data?

I confirmed that I can retrieve daily NAV via the API as follows but couldn't find out the way to retrieve TNA daily data..

REQUEST

import requests

url = "https://api.refinitiv.com/data/funds/v1/assets?symbols=LP62005984&properties=names[filter:Name],prices[filter:NAV%3Bcurrency:JPY%3Bstart:2022-12-01%3Bend:2022-12-09]&language=Japanese"

payload={}
headers = {
  'Authorization': 'Bearer YOUR_TOKEN'
}

response = requests.request("GET", url, headers=headers, data=payload)

print(response.text)

RESPONSE

{
    "assets": [
        {
            "id": "LP62005984",
            "names": [
                {
                    "code": "NAME",
                    "type": {
                        "id": "29",
                        "name": "Name"
                    },
                    "values": [
                        {
                            "value": "セゾン 資産形成の達人F"
                        }
                    ]
                }
            ],
            "prices": [
                {
                    "code": "NAV",
                    "type": {
                        "id": "761",
                        "code": "NAV",
                        "name": "NAV"
                    },
                    "values": [
                        {
                            "date": "2022-12-09",
                            "currency": "JPY",
                            "priceCode": "Nav",
                            "value": 31297.0,
                            "isEstimate": false
                        },
                        {
                            "date": "2022-12-08",
                            "currency": "JPY",
                            "priceCode": "Nav",
                            "value": 31306.0,
                            "isEstimate": false
                        },
                        {
                            "date": "2022-12-07",
                            "currency": "JPY",
                            "priceCode": "Nav",
                            "value": 31636.0,
                            "isEstimate": false
                        },
                        {
                            "date": "2022-12-06",
                            "currency": "JPY",
                            "priceCode": "Nav",
                            "value": 31797.0,
                            "isEstimate": false
                        },
                        {
                            "date": "2022-12-05",
                            "currency": "JPY",
                            "priceCode": "Nav",
                            "value": 31664.0,
                            "isEstimate": false
                        },
                        {
                            "date": "2022-12-02",
                            "currency": "JPY",
                            "priceCode": "Nav",
                            "value": 31713.0,
                            "isEstimate": false
                        },
                        {
                            "date": "2022-12-01",
                            "currency": "JPY",
                            "priceCode": "Nav",
                            "value": 31564.0,
                            "isEstimate": false
                        }
                    ]
                }
            ]
        }
    ],
    "totalRecords": 1,
    "fromIndex": 0,
    "toIndex": 0,
    "pageNumber": 0
}
rdp-api#contentfundslipper
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 @hiroko.yamaguchi1 ,

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 on the left side of the appropriate reply? This will guide all community members who have a similar question.

Thanks,
AHS

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

Thanks,
AHS

Upvotes
Accepted
1.6k 3 2 3

@hiroko.yamaguchi1 , Currently the RDP Funds API only provides monthly data frequency for AUM/TNA data. I heard there is plan to include the Daily TNA in next year (2023).

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
14.2k 30 5 10

Hi @hiroko.yamaguchi1 ,

Have you had a chance to look at the API documentation in /data/funds/v1/assets > Reference yet?

1671182899868.png

Could you please try the query mentioned in the document and please let me know if it works?

1671183080130.png


1671182899868.png (175.6 KiB)
1671183080130.png (39.1 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.