Brinson-Fachler.
Allocation, selection and interaction effects, per asset and per date. The effects add up exactly to portfolio return minus benchmark return.
Lab · Module 06 of 06
Decompose. Explain. Improve. Know what worked, and why.
Two complementary methodologies, run together or independently. Every input is aligned to a common date range before anything is computed.
Allocation, selection and interaction effects, per asset and per date. The effects add up exactly to portfolio return minus benchmark return.
The contribution of each style and industry factor, and the stock-specific residual that is left.
Configurable from an Excel parameters workbook, with no code required to run an analysis, or directly from a Python script. A command line initializes projects (init excel) and updates templates.
Brinson-Fachler attribution: breaks active return into allocation, selection and interaction effects, computed per asset and per date and aggregated over time. The effects add up exactly to portfolio return minus benchmark return.
Factor model attribution: decomposes portfolio return into per-factor contributions plus an idiosyncratic residual, using your own factor return series (style factors such as size, momentum, beta, residual volatility and value, plus industry factors).
Cumulative and percentage views: factor contributions are accumulated over time and expressed as a share of total return, so you can see how much of performance each factor explains and how much is stock-specific.
Independent methodology switches: turn Brinson-Fachler and the factor model on or off from the workbook, to run either analysis alone or both side by side.
Interactive dashboards for exploring factor model results, served locally on a configurable port. Static plots are produced for Brinson-Fachler-only runs.
A PyArrow-based engine with pandas reference implementations, behind clean interfaces that make each methodology easy to extend.
Robust data handling: horizontal or vertical weight files detected automatically, configurable date and price columns, every input aligned to a common date range, and start and end dates set by hand or derived from the data.
CSV or Parquet, one file per ticker with date and price. Returns are computed internally.
CSV or Excel: weights by rebalancing date.
CSV, daily.
CSV, one file per factor, with per-asset returns.
An Excel workbook, or configuration in Python.
Attribution Analysis comes with the Investment Lab licence.