Export Templates with Portfolio Valuations

One useful feature of Export Templates is the ability to generate a portfolio valuation during the export. When the export template is configured to generate a portfolio valuation, a new top-level tag becomes available: PortfolioValuation.

Creating a Portfolio Valuation Export Template

First, create a .txt file with the following contents and save it on your computer:

<< ForEach($Valuation, PortfolioValuation.Valuations) >>
<< $Valuation.ClearLifeCase.CaseReference >>
Valuation $<< $Valuation.ValuationResults.At(0).Npvs.At(0).Value >> (<< $Valuation.ValuationResults.At(0).Npvs.At(0).NDBIrr * 100 >>%/<< $Valuation.ValuationResults.At(0).Npvs.At(0).PremiumIrr *  100 >>%/<< $Valuation.ValuationResults.At(0).Npvs.At(0).FeesIrr * 100 >>%)
IRR Export Results:
	<< ForEach($IrrResult, $Valuation.IrrExportResults) >>
	- $<< $IrrResult.Npv >> (<< $IrrResult.Irr * 100 >>%)
	<< Next() >>
<< Next() >>

Failures:
<< ForEach($Failure, PortfolioValuation.ValuationFailures) >>
* << $Failure.ClearLifeCase.CaseReference >> failed to value: << $Failure.Failure Reason >>
<< Next() >>

This is a simple export template that lists all the valuation results in the portfolio valuation, all of the IRR export results and a list of any cases that failed to value.

Next, go to the Admin, Export Templates page. Create a new template and upload the text file as the template file:

Now, edit the template and check the “Generate Portfolio Valuation” checkbox:

Go to the Portfolios, Reporting tab and click run on the report’s actions menu:

Set the pricing parameters as required. Note that the example template exports the IRR Results so ensure that checkbox is checked when running the template.

Click the “RUN REPORT” button and a valuation will be generated and the export template populated from the results. The valuation will not be saved.

Supported locations

Export templates requiring a portfolio valuation may only be run from the Portfolio, Reporting tab.

Running them is not supported in the scratch pad but it is possible to explore the available tags in the left-hand side tree view on the scratch pad.