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.

Upvotes
Accepted
1.7k 3 3 4

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