Get Price History Check

This query returns a price history check report on a given date.

GraphQL Query

query GetPriceHistoryCheck {
  price_history_check(
    input: {
      report_date: "2024-05-01"
      pricing_policy: "com.finmars.standard-pricing:standard"
    }
  ) {
    items {
      id
			type
      name
      position_size
      accounting_date
      transaction_currency_id
      transaction_currency_name
      transaction_currency_user_code
      settlement_currency_name
      settlement_currency_user_code
    }
  }
}

Input Highlights

Report Date

report_date: "2024-05-01"

• Snapshot date
• ISO date format
• Required field
  

PL First Date

pl_first_date: "2024-01-01"

• Snapshot date
• ISO date format
• Required field
• Basically its a "date from"

Report Currency

report_currency: "USD"

• Output currency
• Must exist in the system

Pricing Policy

pricing_policy: "com.finmars.standard-pricing:standard"

• Defines valuation rules
• Uses pricing engine configuration
• Required for valuation

Portfolios

portfolios: ["Commodity Portfolio"]

• List of portfolio user codes
• Supports multiple portfolios

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 GetPriceHistoryCheck {
  price_history_check(
    input: {
      report_date: "2024-05-01"
      pricing_policy: "com.finmars.standard-pricing:standard"
    }
  ) {
    items {
      id
			type
      name
      position_size
      accounting_date
      transaction_currency_id
      transaction_currency_name
      transaction_currency_user_code
      settlement_currency_name
      settlement_currency_user_code
    }
  }
}
    """
}

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

Notes

• This is not a list query.
• No pagination.
• Uses input instead of filters.
• Report queries execute calculations.