Get Performance Report in Graphql

This query returns performance metrics for one or more portfolio registers.

GraphQL Query

query GetPerformanceReport {
  performance_report(
    input: {
      end_date: "2024-05-01"
      registers: ["CH-BND-20394857"]
    }
  ) {
    begin_nav
    end_nav
    grand_absolute_pl
    grand_cash_flow
    grand_cash_flow_weighted
    grand_cash_inflow
    grand_cash_outflow
    grand_nav
    grand_return
  }
}

Input Fields

end_date

end_date: "2024-05-01"

• Report end date
• Required field
• ISO date format

registers

registers: ["CH-BND-20394857"]

• List of portfolio register user codes
• At least one register is required
• Supports multiple registers

Output Fields

NAV Values

• begin_nav — NAV at period start
• end_nav — NAV at period end
• grand_nav — aggregated NAV

Cash Flow Metrics

• grand_cash_flow
• grand_cash_flow_weighted
• grand_cash_inflow
• grand_cash_outflow

Performance Metrics

• grand_absolute_pl — absolute profit or loss
• grand_return — total return

Python Code

import requests

url = "https://<domain_name>/<realm_code>/<space_code>/graphql/"

headers = {
    "Authorization": "Bearer <access_token>",
    "Content-Type": "application/json"
}

payload = {
    "query": """
    query GetPerformanceReport {
      performance_report(
        input: {
          end_date: "2024-05-01"
          registers: ["CH-BND-20394857"]
        }
      ) {
        begin_nav
        end_nav
        grand_absolute_pl
        grand_cash_flow
        grand_cash_flow_weighted
        grand_cash_inflow
        grand_cash_outflow
        grand_nav
        grand_return
      }
    }
    """
}

response = requests.post(url, json=payload, headers=headers)
print(response.json())

Notes

• This is a calculated report
• No pagination
• Uses input, not filters
• Default calculation method is applied if not provided
• Execution time depends on data volume