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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"workbook": "<workbook>",
"sheet": "<sheet>",
"target_range": "<target_range>",
"function_name": "<function_name>",
"parameters": "<parameters>"
},
"name": "create_time_series"
}
}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 |