Welcome to the Flametree Technologies Wiki
Report settings
πŸ”§

Report settings

Report activation switches

These settings determine which reports are generated when FIA is run.

Description
Link
Summary attribution report
πŸ”§SummaryAttributionReport
Interactive attribution report
πŸ”§InteractiveAttributionReport
Portfolio risk number report
πŸ”§PortfolioRiskNumberReport
Security risk number report
πŸ”§SecurityRiskNumberReport
Security attribution report
πŸ”§SecurityAttributionReport
Maturity exposure report
πŸ”§MaturityExposureReport
Duration exposure report
πŸ”§DurationExposureReport
Date and risk report
πŸ”§DateRiskReport
Ex-post risk report
πŸ”§ExPostRiskReport
Yield curve report
πŸ”§CurveReport

Report formats

These switches determine what report formats are generated by FIA.

Description
Link
CSV format
πŸ”§CSVReport
XLS format
πŸ”§XLSReport
JSON format
πŸ”§JSONReport
SQL format
πŸ”§SQLDataReport
Treemap format
πŸ”§TreeMapReport

Report tab names

These settings allow the user to set the names of tabs in the Excel report. If not set, a sensible default is used.

Description
Link
Summary attribution tab name
SummaryAttributionTabname
Portfolio risk tab name
PortfolioRiskNumberTabname
Security risk tab name
SecurityRiskNumberTabname
Security attribution tab name
SecurityAttributionTabName
Maturity exposure tab name
MaturityExposureTabname
Duration exposure tab name
DurationExposureTabname
Summary attribution by date tab name
SummaryByDateTabname
Cumulative attribution by date tab name
CumulativeSummaryByDateTabname
Ex-post risk tab name
ExPostRiskTabname
  • Interactive reports have their tab name set indivdidually via β€˜Name=’ in the ReportSectors setting.
  • Yield curve reports tabs always have their name set to the name of the yield curve being displayed.

Report labels

These labels set up the names of the various risk sources on reports.

Description
Link
Label for carry return
πŸͺ§TimeReturnLabel
Label for running yield return
πŸͺ§RunningYieldLabel
Label for pull to par return
πŸͺ§PullToParLabel
Label for risk free carry return
πŸͺ§RiskFreeCarryLabel
Label for credit carry return
πŸͺ§CreditCarryLabel
Label for roll-down return
πŸͺ§RolldownLabel
Label for residual return
πŸͺ§ResidualReturnLabel
Label for sovereign curve return
πŸͺ§SovereignCurveReturnLabel
Label for capital curve return
πŸͺ§CapitalReturnLabel
Label for duration return
πŸͺ§DurationCurveReturnLabel
Label for non-parallel curve return
πŸͺ§NonParallelCurveReturnLabel
Label for shift return
πŸͺ§ShiftReturnLabel
Label for twist return
πŸͺ§TwistReturnLabel
Label for curvature return
πŸͺ§CurvatureReturnLabel
Label for convexity return
πŸͺ§ConvexityReturnLabel
Label for spread return
πŸͺ§SpreadReturnLabel
Label for exchange rate return
πŸͺ§FXReturnLabel
Label for unattributed return
πŸͺ§UnattributedReturnLabel
Label for total return
πŸͺ§TotalReturnLabel

Summary report labels

These labels set up the names of the various summarised risk sources on the summary report only.

Description
Link
Label for summary carry return
πŸͺ§SummaryCarryLabel
Label for summary curve return
πŸͺ§SummaryCurveLabel
Label for summary spread return
πŸͺ§SummarySpreadLabel
Label for summary rolldown return
πŸͺ§SummaryRolldownLabel
Label for summary residual return
πŸͺ§SummaryResidualLabel
Label for summary other return
πŸͺ§SummaryOtherLabel
Label for summary FX return
πŸͺ§SummaryFXLabel
Label for summary allocation return
πŸͺ§SummaryAllocationLabel
Label for summary interaction return
πŸͺ§SummaryInteractionLabel
Label for carry allocation return
πŸͺ§SummaryCarryAllocationLabel
Label for curve allocation return
πŸͺ§SummaryCurveAllocationLabel
Label for spread allocation return
πŸͺ§SummarySpreadAllocationLabel
Label for residual allocation return
πŸͺ§SummaryResidualAllocationLabel

Miscellanous report settings

These settings configure reports in other ways.

Description
Link
Number of decimal places on reports
πŸ”§NDP
User-assigned batch ID number
πŸ”§BatchID
Destination directory for reports
πŸ”§ReportDirectory
Name of Excel file that contains all reports as separate sheets
πŸ”§SingleExportReportFile
Name of compressed (Zip) file that contains all reports
πŸ”§ZipFile
Name of logo file to appear on all Excel files
πŸ”§LogoFile
Whether to display returns as basis points
πŸ”§BasisPoints
Whether interactive reports show security-level data from all subholdings or summarise sub-portfolio data
πŸ”§LookThrough
Whether interactive reports show all totals and sub-totals above or below grouped data
πŸ”§TotalsAtTop
Whether interactive reports show data in ascending or descending order
πŸ”§SortDescending
Sub-intervals for reporting
πŸ”§Interval
Whether to annualise reported returns
πŸ”§AnnualisedReturn
Whether to set empty entries to zero or blank
πŸ”§BlankZeros
Whether to show security name, ID or both on interactive report
πŸ”§SecurityIdentifier
πŸͺ§TimeReturnLabelπŸͺ§SummaryCarryLabelπŸͺ§SummaryCurveLabelπŸͺ§SummarySpreadLabelπŸͺ§SummaryRolldownLabelπŸͺ§SummaryOtherLabelπŸͺ§SummaryResidualLabelπŸͺ§SummaryFXLabelπŸͺ§SummaryAllocationLabelπŸͺ§SummaryInteractionLabelπŸͺ§SummaryCarryAllocationLabelπŸͺ§SummaryCurveAllocationLabelπŸͺ§SummarySpreadAllocationLabelπŸͺ§SummaryResidualAllocationLabelπŸͺ§RunningYieldLabelπŸͺ§PullToParLabelπŸͺ§RiskFreeCarryLabelπŸͺ§CreditCarryLabelπŸͺ§RolldownLabelπŸͺ§ResidualReturnLabelπŸͺ§SovereignCurveReturnLabelπŸͺ§CapitalReturnLabelπŸͺ§DurationCurveReturnLabelπŸͺ§NonParallelCurveReturnLabelπŸͺ§ShiftReturnLabelπŸͺ§TwistReturnLabelπŸͺ§CurvatureReturnLabelπŸͺ§ConvexityReturnLabelπŸͺ§SpreadReturnLabelπŸͺ§FXReturnLabelπŸͺ§UnattributedReturnLabelπŸͺ§TotalReturnLabelπŸͺ§PaydownReturnLabelπŸͺ§SpecificReturnLabelπŸͺ§PriceReturnLabelπŸͺ§LeverageReturnLabelπŸ”§CSVReportπŸ”§XLSReportπŸ”§JSONReportπŸ”§SQLDataReportπŸ”§TreeMapReportπŸ”§SummaryAttributionReportπŸ”§InteractiveAttributionReportπŸ”§SummaryAttributionTabnameπŸ”§PortfolioRiskNumberTabnameπŸ”§SecurityRiskNumberTabnameπŸ”§PortfolioRiskNumberReportπŸ”§SecurityRiskNumberReportπŸ”§SecurityAttributionReportπŸ”§SecurityAttributionTabnameπŸ”§MaturityExposureTabnameπŸ”§DurationExposureTabnameπŸ”§SummaryByDateTabnameπŸ”§CumulativeSummaryByDateTabnameπŸ”§ExPostRiskTabnameπŸ”§MaturityExposureReportπŸ”§DurationExposureReportπŸ”§DateRiskReportπŸ”§ExPostRiskReportπŸ”§CurveReportπŸ”§UnitPriceReportπŸ”§BatchIDπŸ”§SingleExportReportFileπŸ”§LogoFileπŸ”§ZipFileπŸ”§ReportDirectoryπŸ”§BasisPointsπŸ”§LookThroughπŸ”§SortDescendingπŸ”§TotalsAtTopπŸ”§FileHeadersπŸ”§ShowSecurityAAπŸ”§ShowSecurityIDπŸ”§SecurityIdentifierπŸ”§ShowRiskTypeπŸ”§NDPπŸ”§AnnualisedReturnπŸ”§BlankZerosπŸ”§Interval