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

eugen_p

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:

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

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

Thank you in advance!

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.