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

hiroko.yamaguchi1

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;currency:JPY;start:2022-12-01;end: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
}

bob.lee

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

raksina.samasiri

Hi @hiroko.yamaguchi1 ,

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

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