Configuration settings

From Flametree Technologies
Revision as of 06:17, 15 February 2020 by Fiasys (Talk | contribs)
Jump to: navigation, search

Contents

Overview

FIA has a large number of configuration options. These allow all aspects of the calculation to be tailored to your input data formats, investment model and reporting requirements.

Only a small number of quantities must be set in order to run an analysis. In all other cases, FIA provides sensible defaults.

Configuration can be carried out in a configuration file, as settings in the GUI, via calls to the local API, or over the Web API. However, the names and settings of FIA's variables are identical in all cases. In this section, we focus on how to set up a configuration file, as the settings are virtually identical for other modes.

Click here for information on setting up a configuration file.

File settings

Field Description Required? Possible values Example Default
FileHeaders
PortfolioFile Name of portfolio weights and returns file, including file path if required Yes File name as string portfolio.csv Not applicable
BenchmarkFile Name of benchmark weights and returns file, including file path if required No File name as string benchmark.csv None
SecurityFile Name of security definitions file, including file path if required Yes File name as string sec_defs.csv Not applicable
YieldCurveFile Name of yield curve data file, including file path if required No File name as string yc.csv Not applicable
FXFile Name of exchange rate file, including file path if required, containing currency codes, dates and rates. No File name as string fxfile.csv None
IndexFile Name of file containing time series such as inflation indices, LIBOR and paydown schedules No File name as string IndexFile.csv None

Notes

The only exception is when the user has requested allocation attribution, which specifically requires a benchmark. In this case FIA will generate an error message and halt.

Date settings

Field Description
StartDate
EndDate
DateFormat User-supplied format for parsing dates from all files
SecurityDateFormat User-supplied format for parsing dates in security file
PortfolioDateFormat User-supplied format for parsing dates in portfolio returns files
BenchmarkDateFormat User-supplied format for parsing dates in benchmark returns files
YieldCurveDateFormat User-supplied format for parsing dates in yield curve files
FXDateFormat User-supplied format for parsing dates in exchange rate files
IndexDateFormat User-supplied format for parsing dates in index file

Notes

Click here for more information about date formats.

Reporting settings

General reporting settings

Field Type Description Required? Possible values Example Default
BasisPoints Boolean If active, shows all returns in terms of basis points. If false, or not set, all returns are shown as percentages. No Yes, no, true, false, 1, 0 True False
ndp Integer Integer-valued switch, sets how many decimal places are used for reporting. No Any integer between 0 and 12 2 4
TotalsAtTop Boolean Controls whether totals on interactive reports should appear above or below the raw data. No Yes, no, true, false, 1, 0 True False
Smoothing String Name of smoothing algorithm to use when reporting

If set, the given logo file is inserted into every Excel worksheet

No Carino, Geometric Geometric Carino
SortDescending Boolean In interactive reports, controls whether results are shown in ascending or descending order No
BatchID Integer Assigns a number to each report's name. If not set, a random number is assigned.
LookThrough Boolean If true, all holdings in sub-portfolios are displayed as if they are holdings in the top level portfolio.

If false, holdings in sub-portfolios are displayed in aggregate

RootLevelOnly Boolean If true, no reports are generated for sub-portfolios
ReportSectors String Configures the hierarchy and data shown in a drill-down report.

See here for more information.

File-based reporting settings

The following table describes the various file-based reporting options available within FIA.

Field Type Description Required? Possible values Example Default
ReportDirectory String Name of the directory to which reports are written.

If not set, reports are written to the current active directory.

No Any valid directory string for your operating system, including relative paths. c:\mydata

.\

.\mydata

./mydata

None
SingleExcelReportFile String Name of Excel workbook to which all Excel reports are written.

If set, all reports are written into separate worksheeets within workbook If not set, all Excel reports are written to separate workbooks

Note that the Excel suffix should not be provided.

No True False
ZipFile String Name of zip file to which all reports are written

If set, all reports are written into a compressed Zip file with this name, and the originals erased

No True False
LogoFile String Name of logo file in JPG format

If set, the given logo file is inserted into every Excel worksheet

No True False
CSVreport Boolean Generate CSV reports
XLSreport Boolean Generate Excel reports

Notes

If ReportDirectory does not exist, FIA will try to create it before running reports. If this is unsuccessful (for instance, if FIA does not have sufficent permissions on your system) the program will abort with an error message.

Directories are not case sensitive on Windows systems, but are case sensitive on Linux and Unix systems.

Selecting reports

FIA's reporting options are controlled from the configuration file. In this section, we described the options available.

Click on the name of the report for more information.

Field Type Description
SummaryAttributionReport Boolean Generate summary report
InteractiveAttributionReport Boolean Generate hierarchical report
PortfolioRiskNumberReport Boolean Generates history of portfolio and benchmark risk numbers (YTM, MD, C, Z-spread, leverage) at each date over calculation interval
SecurityRiskNumberReport Boolean Generates report showing risk numbers for all securities in portfolio and benchamrk at last date in calculation interval
SecurityAttributionReport Boolean Shows attribution returns for all securities in portfolio and benchamrk over calculation interval
MaturityExposureReport Boolean Shows allocation to maturity buckets at last date in calculation interval. Maturity buckets are defined here
DurationExposureReport Boolean Shows allocation to duration buckets at last date in calculation interval. Duration buckets are defined here
DateRiskReport Boolean Shows aggregated attribution returns at portfolio level over calculation interval. Both daily and cumulative reports are generated.
SQLDataReport Boolean Generates file of normalised returns, ready for import into an SQL data table
ExPostRiskReport Boolean Generates ex-post risk statistics
CurveReport Boolean Generates report on yield curve movements. If more than one yield curve is supplied, Excel reports are written to separate worksheets in the same workbook.
StressReport Boolean Generates stress report
TreeMapReport Boolean Generate data for use in heat map

Notes

Interactive reports can be extensively configured. Click here for more information.

Labels

Field Description Default
TimeReturnLabel Label for time/coupon return. Only used when CouponDecomposition set to AGGREGATED Coupon
RunningYieldLabel Label for return due to runninh yield. Only used when CouponDecomposition set to PULL_TO_PAR Running yield
PullToParLabel Label for return due to pull to par effects. Only used when CouponDecomposition set to PULL_TO_PAR Pull to par
RiskFreeCarryLabel Label for return due to risk free yield. Only used when CouponDecomposition set to CREDIT_CARRY Risk-free carry
CreditCarryLabel Label for return due to pull to par effects. Only used when CouponDecomposition set to CREDIT_CARRY Credit carry
RolldownLabel Label for rolldown return Rolldown
ResidualReturnLabel Label for residual return Residual
SovereignCurveReturnLabel Label for return due to changes in sovereign curve Sovereign curve
CapitalCurveReturnLabel Label for return due to changes in capital return Capital
DurationCurveReturnLabel Label for return due to parallel changes in the sovereign curve. Only used when SovereignCurveDecomposition set to DURATION Duration
NonParallelCurveReturnLabel Label for return due to non-parallel changes in the sovereign curve. Only used when SovereignCurveDecomposition set to DURATION Non-parallel curve
ShiftReturnLabel Label for return due to parallel shift in sovereign curve. Only used when SovereignCurveDecomposition set to STB Shift
TwistReturnLabel Label for return due to steepening or flattening in sovereign curve. Only used when SovereignCurveDecomposition set to STB Twist
CurvatureReturnLabel Label for return due to increasing or decreasing curvature in sovereign curve. Only used when SovereignCurveDecomposition set to STB Curvature
ConvexityReturnLabel Label for return due to convexity. Convexity
SpreadReturnLabel Label for return due to movements in the country or sector spread Spread
FXReturnLabel Label for return due to changes in exchange rates FX return
UnatttributedReturnLabel Label for return to due unattributed securities Unattributed
TotalReturnLabel Label for sum of all returns Total

Notes

FIA allows the names of any of the displayed sources of risk to be changed. For instance, to change Residual to Credit, set

ResidualReturnLabel=Credit

in the configuration file. Note that no quotation marks are required.

Attribution settings

Carry effects

Field Description Default
CarryDecomposition

Curve effects

Field Description Default
AverageCurveLevel
SovereignCurveDecomposition
CapitalAttribution
UpperTwistMaturity
LowerTwistMaturity
ShiftMaturity


Allocation effects

Field Description Default
BrinsonAllocationSectors
CarryAllocationSectors
CurveAllocationSectors
SpreadAllocationSectors
ResidualAllocationSectors
DTS
InteractionAttribution


Credit effects

Field Description Default
SecuritySpecificAttribution
ZSpreadAttribution
AddSpreads


Other effects

Field Description Default
RollDownAttribution
ConvexityAttribution
PaydownAttribution
LeverageAttribution
PriceReturn
InterpolateAtTTM

Notes

Hedging settings

Field Description Default
HedgedReturns
HedgeRatio
HedgeCurrency

Notes

Miscellaneous settings

Field Description Default
BaseToLocal
LocalToBase
PortfolioBaseToLocal
PortfolioLocalToBase
BenchmarkBaseToLocal
BenchmarkLocalToBase
Silent
n_cores
BaseCurrency
MaturityList
DurationList
CouponList
KRDList
TenorList
SmoothingModel
UseCashOffsets

Notes

Personal tools
Namespaces
Variants
Actions
Manual
Attribution methodology
Data
Configuration
Running FIA
Reporting
Tutorials
Additional information
Company
Downloads
Toolbox