create_time_series
Create time-series formulas in Excel for Monte Carlo risk modeling, writing functions like VoseTimeGBM into a target range with user-defined parameters.
Instructions
ModelRisk: Build a time-series formula (VoseTimeGBM, VoseTimeAR1, etc.) and write it into the target_range. Time-series tools are exempt from the >50-cell bulk-write guard because the dimension of the time series is the whole point.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | ||
| dry_run | No | ||
| workbook | Yes | ||
| parameters | Yes | ||
| target_range | Yes | A1 range to spill into, e.g. 'D2:D101'. | |
| function_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | ||
| formula | Yes | ||
| written | Yes | ||
| previous_formula | No |