simulatefromexcel: Simulate using data from Excel

In rexmacey/aasim: Asset Allocation Simulation

Simulate using data from Excel

Description

This functions reads data from the first two tabs of an Excel workbook. The first is expected to contain general information on the simulation and the second is expected to contain information on the cash flows.

Usage

simulatefromexcel(xlsxfilename)

Arguments

xlsxfilename

File name including path

Details

Columns in the first tab might include: description, nTrials, startValue, lengthType, length, seed, defaultInflation, ror, stdDev, targetValue, targetValueIsReal, stockWt, nConsecMonths, retAdj, minDate, maxDate, overrideInflation, asOfDate, returnGeneratorMethod, p1name, p1init, p1birthdate, p1gender, p1retage, p1mortfactor, p1mortadjyears, p2name, p2init, p2birthdate, p2gender, p2retage, p2mortfactor, p2mortadjyears.

Columns in the second tab should include: simulation, description, starttype, start, endtype, end, type, amount, defaultInflationAdj, inflation.

Value

List containing lists for each simulation in the file.

Examples

## Not run: simulatefromexcel(paste0(testthat::test_path(),"/data/siminput.xlsx"))

rexmacey/aasim documentation built on Oct. 29, 2024, 9:30 a.m.