How in Workspace get same result with IPA service as with Excel function RPD.DateCalcPeriod?

eugen_p
eugen_p Newcomer
edited September 1 in Refinitiv Data Platform Libraries

Hello,

how we can get the same result with Instrument Pricing Analytics Delivery Platform (IPA) as with the Excel function RDP.DateCalcPeriod?

In Excel we get the result 24.06.2025:

image.png

But in .NET application using IPA service we get nothing. We use the following JSON request:

image.png

Do you have the technical description for Instrument Pricing Analytics Delivery Platform with details about JSON requests?

Thank you in advance!

Tagged:

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @eugen_p

    Thank you for reaching out to us.

    I checked and found that the IPA doesn't provide the DateCalcDatePeriod endpoint.

    However, I found this one (/analytics/functions/v1/common/add-period).

    The Python code that uses the LSEG Data Library for Python looks like this.

    analytics_url = '/analytics/functions/v1/common/add-period'

request = {
  "universe": [
    {
      "dateMovingConvention": "NextBusinessDay",
      "calculationDate": "2025-06-17",
      "currencyCodes": [
        "EURARS"
      ],
      "period": "SN",
      "fields": [
        "StartDate",
        "EndDate"
      ]
    }
  ]
}

request_definition = ld.delivery.endpoint_request.Definition(
    method = ld.delivery.endpoint_request.RequestMethod.POST,
    url = analytics_url,
    body_parameters = request
)
response = request_definition.get_data()
response.data.raw

    It uses the endpoint interface of the LSEG Data Library for Python. The example is available on GitHub.

Categories