> ## Documentation Index > Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt > Use this file to discover all available pages before exploring further. # Request an Excel export of a VaR portfolio PnL series. > Accepts the export request asynchronously and returns a `Requested` notification. This acknowledges the request only; it does not confirm that a workbook is complete or promise delivery, idempotency, cancellation, or retention behavior. ## OpenAPI ````yaml /risk-and-pricing/atoti-risk-services/apis-endpoints/openapi/openapi.mintlify.json post /api/VarReportQuery/ExportPnLSeriesToExcel openapi: 3.0.4 info: title: Derivitec Api 1.0 version: '1.0' servers: - url: https://api.riskportal.activeviam.com security: - oauth2: [] - apikey: [] tags: - name: AdminUser - name: AtotiReport - name: AtotiSession - name: BloombergOAuth - name: Bond - name: BondYieldCurvePage - name: BookAccess - name: Books - name: Commodity - name: Counterparties - name: Currencies - name: Equity - name: EquityDividend - name: EquityPage - name: FeatureFlag - name: Fx - name: FxPage - name: GroupAccess - name: Home - name: LegacyPosition - name: MarketData - name: MarketDataProvider - name: MarketDataProviderAccess - name: Meta - name: Notification - name: Organisation - name: PnLReport - name: PortfolioAccess - name: Portfolios - name: Position - name: PositionFilter - name: PricingEnvironment - name: PricingEnvironmentAccess - name: RateAsset - name: RateAssetPage - name: Report - name: ReportDefinition - name: ReportHistoryLauncherQuery - name: ReportLauncher - name: ReportQuery - name: ReportQueryViewUser - name: ReportRestriction - name: ReportView - name: RiskReport - name: Tradable - name: TradeBooking - name: User - name: VarReport - name: VarReportQuery - name: YieldCurvePage paths: /api/VarReportQuery/ExportPnLSeriesToExcel: post: tags: - VarReportQuery summary: Request an Excel export of a VaR portfolio PnL series. description: >- Accepts the export request asynchronously and returns a `Requested` notification. This acknowledges the request only; it does not confirm that a workbook is complete or promise delivery, idempotency, cancellation, or retention behavior. operationId: ExportPnLSeriesToExcel requestBody: description: >- The body containing the opaque `ReportId`, optional VaR selection fields, required non-empty `RequestId`, and optional `TimeSeriesGroupByPropertyList`. No fixed list of grouping values is declared. content: application/json-patch+json: schema: $ref: >- #/components/schemas/ApiVarReportQueryExportPnLSeriesToExcelRequest application/json: schema: $ref: >- #/components/schemas/ApiVarReportQueryExportPnLSeriesToExcelRequest text/json: schema: $ref: >- #/components/schemas/ApiVarReportQueryExportPnLSeriesToExcelRequest application/*+json: schema: $ref: >- #/components/schemas/ApiVarReportQueryExportPnLSeriesToExcelRequest responses: '200': description: >- Returns a notification acknowledging that the PnL-series export was requested. content: application/json: schema: $ref: >- #/components/schemas/ApiVarReportQueryExportPnLSeriesToExcelResponse '400': description: BadRequest '401': description: Unauthorized '403': description: Forbidden security: - oauth2: [] - apikey: [] components: schemas: ApiVarReportQueryExportPnLSeriesToExcelRequest: required: - $type type: object properties: confidence_level: type: number description: >- Optional VaR confidence-level override expressed as a decimal fraction; null retains the report's configured level. format: double nullable: true example: 0.99 row_query: $ref: '#/components/schemas/FilterBase' weighting_var_definition: $ref: '#/components/schemas/WeightingVarDefinition' row_restriction_filter: $ref: '#/components/schemas/FilterBase' full_report_filter: $ref: '#/components/schemas/MultiFilter' report_configuration: $ref: '#/components/schemas/VarReportConfiguration' report_id: type: string description: >- Opaque identifier of the report run to retrieve or query. The value must not be null or empty. nullable: true portfolio_type: enum: - derivitec - enfusion - orchestrade - liquidity_book - maia - fund_studio - not_set type: string description: >- Portfolio category used to resolve the requested portfolio. It may be omitted when the portfolio name resolves unambiguously. nullable: true request_id: type: string description: >- Non-empty caller-supplied identifier used to correlate the export notification. nullable: true example: export-request-1 time_series_group_by_property_list: type: array items: type: string description: Position property names used to group the exported P&L series. nullable: true $type: type: string enum: - >- Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryExportPnLSeriesToExcelRequest, Derivitec.Web.Core additionalProperties: false description: Starts an XLSX export of a report's historical P&L series. ApiVarReportQueryExportPnLSeriesToExcelResponse: required: - $type type: object additionalProperties: false description: >- Acknowledges the P&L-series export request and exposes its notification state. properties: is_success: type: boolean description: >- Whether the operation completed successfully. The default is `true`; error outcomes set it to `false`. example: true error_messages: type: array items: type: string description: >- Messages explaining operation-level failures. The collection is empty by default. nullable: true notification: $ref: '#/components/schemas/Notification' $type: type: string enum: - >- Derivitec.Web.Core.VarReportQuery.ApiVarReportQueryExportPnLSeriesToExcelResponse, Derivitec.Web.Core FilterBase: description: Base selection criterion for a named report-data field. discriminator: propertyName: $type mapping: Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core: '#/components/schemas/FilterMintlifyShape' Derivitec.Web.Core.Filters.FilterBase, Derivitec.Web.Core: '#/components/schemas/FilterBaseMintlifyShape' Derivitec.Web.Core.Filters.MultiFilter, Derivitec.Web.Core: '#/components/schemas/MultiFilter' Derivitec.Web.Core.Filters.StringFilter, Derivitec.Web.Core: '#/components/schemas/StringFilter' oneOf: - $ref: '#/components/schemas/FilterMintlifyShape' - $ref: '#/components/schemas/FilterBaseMintlifyShape' - $ref: '#/components/schemas/MultiFilter' - $ref: '#/components/schemas/StringFilter' WeightingVarDefinition: required: - $type type: object properties: active: type: boolean description: Whether the VaR weighting configuration is enabled. window_length: type: integer description: Window-length value; no unit is established here. format: int32 decay_period: type: integer description: Decay-period value; no unit is established here. format: int32 scheme: enum: - exponentially_weighted - filtered_historical type: string description: Weighting scheme selected for the historical VaR configuration. $type: type: string enum: - >- Derivitec.Web.Core.Reports.WeightingVarDefinition, Derivitec.Web.Core additionalProperties: false description: Configuration used to select VaR weighting behaviour. MultiFilter: required: - $type type: object properties: field: type: string description: Name of the report-data field evaluated by this criterion. nullable: true operator: enum: - not_set - and - or type: string description: Logical rule used to combine the child criteria. conditions: type: array items: $ref: '#/components/schemas/FilterBase' description: >- Child criteria evaluated by the selected logical operator; nested groups are permitted. nullable: true $type: type: string enum: - Derivitec.Web.Core.Filters.MultiFilter, Derivitec.Web.Core additionalProperties: false description: >- Nested filter group that combines child criteria with a logical operator. VarReportConfiguration: required: - $type type: object properties: name: type: string description: Display name for this report-query or export configuration. nullable: true example: Default row_query: $ref: '#/components/schemas/FilterBase' confidence_level: type: number description: >- Optional VaR confidence-level override expressed as a decimal fraction; null retains the report's configured level. format: double nullable: true example: 0.99 weighting_var_definition: $ref: '#/components/schemas/WeightingVarDefinition' $type: type: string enum: - Derivitec.Web.Core.VarReportConfiguration, Derivitec.Web.Core additionalProperties: false description: >- Optional named overrides used when querying or exporting a historical VaR report. Notification: description: User-facing record of a request's notification lifecycle and read state. discriminator: propertyName: $type mapping: Derivitec.Web.Core.Notifications.ExportPivotToExcelNotification, Derivitec.Web.Core: '#/components/schemas/ExportPivotToExcelNotification' Derivitec.Web.Core.Notifications.ExportReportErrorsToExcelNotification, Derivitec.Web.Core: '#/components/schemas/ExportReportErrorsToExcelNotification' Derivitec.Web.Core.Notifications.ExportReportToExcelNotification, Derivitec.Web.Core: '#/components/schemas/ExportReportToExcelNotification' Derivitec.Web.Core.Notifications.Notification, Derivitec.Web.Core: '#/components/schemas/NotificationMintlifyShape' Derivitec.Web.Core.Notifications.VarReportQueryExportErrorsNotification, Derivitec.Web.Core: '#/components/schemas/VarReportQueryExportErrorsNotification' Derivitec.Web.Core.Notifications.VarReportQueryExportPnLSeriesToExcelNotification, Derivitec.Web.Core: >- #/components/schemas/VarReportQueryExportPnLSeriesToExcelNotification oneOf: - $ref: '#/components/schemas/ExportPivotToExcelNotification' - $ref: '#/components/schemas/ExportReportErrorsToExcelNotification' - $ref: '#/components/schemas/ExportReportToExcelNotification' - $ref: '#/components/schemas/NotificationMintlifyShape' - $ref: '#/components/schemas/VarReportQueryExportErrorsNotification' - $ref: >- #/components/schemas/VarReportQueryExportPnLSeriesToExcelNotification FilterMintlifyShape: required: - $type type: object properties: field: type: string description: Name of the report-data field evaluated by this criterion. nullable: true type: type: string nullable: true $type: type: string enum: - Derivitec.Web.Core.Filters.Filter, Derivitec.Web.Core additionalProperties: false FilterBaseMintlifyShape: required: - $type type: object properties: field: type: string description: Name of the report-data field evaluated by this criterion. nullable: true $type: type: string enum: - Derivitec.Web.Core.Filters.FilterBase, Derivitec.Web.Core additionalProperties: false description: Base selection criterion for a named report-data field. StringFilter: required: - $type type: object properties: field: type: string description: Name of the report-data field evaluated by this criterion. nullable: true type: type: string nullable: true filter: type: string nullable: true $type: type: string enum: - Derivitec.Web.Core.Filters.StringFilter, Derivitec.Web.Core additionalProperties: false ExportPivotToExcelNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true $type: type: string enum: - >- Derivitec.Web.Core.Notifications.ExportPivotToExcelNotification, Derivitec.Web.Core additionalProperties: false ExportReportErrorsToExcelNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true $type: type: string enum: - >- Derivitec.Web.Core.Notifications.ExportReportErrorsToExcelNotification, Derivitec.Web.Core additionalProperties: false ExportReportToExcelNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true $type: type: string enum: - >- Derivitec.Web.Core.Notifications.ExportReportToExcelNotification, Derivitec.Web.Core additionalProperties: false NotificationMintlifyShape: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true $type: type: string enum: - Derivitec.Web.Core.Notifications.Notification, Derivitec.Web.Core additionalProperties: false description: User-facing record of a request's notification lifecycle and read state. VarReportQueryExportErrorsNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true $type: type: string enum: - >- Derivitec.Web.Core.Notifications.VarReportQueryExportErrorsNotification, Derivitec.Web.Core additionalProperties: false VarReportQueryExportPnLSeriesToExcelNotification: required: - $type type: object properties: title: type: string description: User-facing title of the notification. nullable: true user_id: type: string description: Opaque identifier of the user to whom the notification belongs. nullable: true organisation_id: type: string description: >- Opaque identifier of the organisation scope associated with the notification. nullable: true request_id: type: string description: >- Opaque identifier that associates the notification with the originating request. nullable: true is_marked_as_read: type: boolean description: Whether the current user has marked this notification as read. timestamp: type: string description: >- Date and time recorded for the notification; the contract does not declare a time zone interpretation. format: date-time status: enum: - none - requested - processing - completed - failed - download_ready type: string description: Current lifecycle state of the notification-producing request. status_message: type: string description: >- User-facing detail accompanying the current notification status; it may be null when no detail is supplied. nullable: true report_id: type: string nullable: true report_configuration: $ref: '#/components/schemas/VarReportConfiguration' $type: type: string enum: - >- Derivitec.Web.Core.Notifications.VarReportQueryExportPnLSeriesToExcelNotification, Derivitec.Web.Core additionalProperties: false securitySchemes: oauth2: type: oauth2 description: >- OAuth2 access-token requested from AWS Cognito and provided as a Auth Bearer header flows: implicit: authorizationUrl: https://auth.riskportal.derivitec.com/oauth2/authorize scopes: {} apikey: type: apiKey description: API-Key requested via the site and provided as a header name: x-api-key in: header ````