create_aggregate
Build a frequency-severity aggregate loss distribution using FFT, Panjer recursion, or Monte Carlo sampling. Optionally output an analytic object for direct mean and percentile queries without running simulations.
Instructions
ModelRisk: Build a frequency-severity aggregate using the chosen method — 'FFT' (Fast Fourier Transform) or 'Panjer' (Panjer recursion) for the fast analytic methods, or 'MC' for Monte Carlo. frequency_object_cell and severity_object_cell are references to distribution-object cells (built with VoseObject). FFT and Panjer support as_object=True, which writes the ...Object form whose mean and percentiles can be read directly with compute_distribution / get_tail_risk — the aggregate loss distribution WITHOUT running a simulation. Method-specific options: density (FFT), intervals / max_p (Panjer), min_limit / max_limit / distribution_shift (MC). For plain MC sampling, create_aggregate_mc is the dedicated shortcut.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| max_p | No | Panjer only: cumulative-probability cap. | |
| sheet | Yes | ||
| method | No | Aggregation engine: 'FFT', 'Panjer', or 'MC'. | FFT |
| density | No | FFT only: density discretisation flag. | |
| dry_run | No | ||
| workbook | Yes | ||
| as_object | No | Write the analytic ...Object form (FFT/Panjer only) instead of a per-iteration sample. Lets you read the aggregate distribution without simulating. | |
| intervals | No | Panjer only: number of discretisation intervals. | |
| max_limit | No | MC only: per-severity upper limit. | |
| min_limit | No | MC only: per-severity lower limit. | |
| target_cell | Yes | ||
| distribution_shift | No | MC only: severity shift. | |
| severity_object_cell | Yes | ||
| frequency_object_cell | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | ||
| formula | Yes | ||
| written | Yes | ||
| previous_formula | No |