{ "cells": [ { "cell_type": "markdown", "id": "66b1484c", "metadata": {}, "source": [ "# Factor Attribution\n", "\n", "In this tutorial we are going to show how to run a factor-based attribution (return and risk) using the Reporting API. This API is currently under active development.\n", "\n", "The steps are as follows:\n", "- Uploading a set of portfolios\n", "- Organizing the portfolios into a hierarchy\n", "- Creating a factor model\n", "- Running a factor return attribution report\n", "- Pulling out different aggregations and drill-downs\n", "- Running a factor risk attribution report" ] }, { "cell_type": "markdown", "id": "b1275c1e", "metadata": {}, "source": [ "## Imports & Setup\n", "\n", "For this tutorial notebook, you will need to import the following packages." ] }, { "cell_type": "code", "execution_count": 2, "id": "9e479577", "metadata": {}, "outputs": [], "source": [ "import datetime as dt\n", "import polars as pl\n", "\n", "from bayesline.apiclient import BayeslineApiClient\n", "from bayesline.api.equity import (\n", " FactorRiskModelSettings,\n", " UniverseSettings,\n", " ExposureSettings,\n", " ContinuousExposureGroupSettings,\n", " CategoricalExposureGroupSettings,\n", " ModelConstructionSettings,\n", " PortfolioHierarchySettings,\n", " ReturnAttributionReportSettings,\n", " XSRReportSettings,\n", ")" ] }, { "cell_type": "markdown", "id": "a8b965fb", "metadata": {}, "source": [ "We will also need to have a Bayesline API client configured." ] }, { "cell_type": "code", "execution_count": null, "id": "4652c791", "metadata": { "tags": [ "skip-execution" ] }, "outputs": [], "source": [ "bln = BayeslineApiClient.new_client(\n", " endpoint=\"https://[ENDPOINT]\",\n", " api_key=\"[API-KEY]\",\n", ")" ] }, { "cell_type": "markdown", "id": "f1584f6d", "metadata": {}, "source": [ "We will first upload a portfolio and set a hierarchy. The steps followed here are the same as in the [Portfolio Hierarchies Tutorial](https://docs.bayesline.com/0.24.2/notebooks/tutorial_portfolio_hierarchies.html)." ] }, { "cell_type": "code", "execution_count": 3, "id": "cd7f4d11", "metadata": {}, "outputs": [], "source": [ "uploader = bln.equity.uploaders.get_data_type(\"portfolios\").create_or_replace_dataset(\"portfolio-attribution-demo\")" ] }, { "cell_type": "code", "execution_count": 4, "id": "fd939dd3", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (20, 7)
portfolio_idasset_idasset_id_typedatecurrencyshare_qtynav
strstrstrdatestrf64f64
"AGTHX""02079K305""cusip9"2026-01-01nullnull0.5
"AGTHX""02079K305""cusip9"2026-01-31nullnull0.55
"AGTHX""2588173""sedol7"2026-01-01nullnull0.5
"AGTHX""2588173""sedol7"2026-01-31nullnull0.45
"FCNTX""67066G10""cusip8"2026-01-01nullnull1.0
…………………
"SPX""2588173""sedol7"2026-01-31nullnull0.2
"SPX""67066G10""cusip8"2026-01-01nullnull0.3
"SPX""67066G10""cusip8"2026-01-31nullnull0.25
"SPX""85371710""cusip8"2026-01-01nullnull0.3
"SPX""85371710""cusip8"2026-01-31nullnull0.25
" ], "text/plain": [ "shape: (20, 7)\n", "┌──────────────┬───────────┬───────────────┬────────────┬──────────┬───────────┬──────┐\n", "│ portfolio_id ┆ asset_id ┆ asset_id_type ┆ date ┆ currency ┆ share_qty ┆ nav │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ str ┆ str ┆ date ┆ str ┆ f64 ┆ f64 │\n", "╞══════════════╪═══════════╪═══════════════╪════════════╪══════════╪═══════════╪══════╡\n", "│ AGTHX ┆ 02079K305 ┆ cusip9 ┆ 2026-01-01 ┆ null ┆ null ┆ 0.5 │\n", "│ AGTHX ┆ 02079K305 ┆ cusip9 ┆ 2026-01-31 ┆ null ┆ null ┆ 0.55 │\n", "│ AGTHX ┆ 2588173 ┆ sedol7 ┆ 2026-01-01 ┆ null ┆ null ┆ 0.5 │\n", "│ AGTHX ┆ 2588173 ┆ sedol7 ┆ 2026-01-31 ┆ null ┆ null ┆ 0.45 │\n", "│ FCNTX ┆ 67066G10 ┆ cusip8 ┆ 2026-01-01 ┆ null ┆ null ┆ 1.0 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ SPX ┆ 2588173 ┆ sedol7 ┆ 2026-01-31 ┆ null ┆ null ┆ 0.2 │\n", "│ SPX ┆ 67066G10 ┆ cusip8 ┆ 2026-01-01 ┆ null ┆ null ┆ 0.3 │\n", "│ SPX ┆ 67066G10 ┆ cusip8 ┆ 2026-01-31 ┆ null ┆ null ┆ 0.25 │\n", "│ SPX ┆ 85371710 ┆ cusip8 ┆ 2026-01-01 ┆ null ┆ null ┆ 0.3 │\n", "│ SPX ┆ 85371710 ┆ cusip8 ┆ 2026-01-31 ┆ null ┆ null ┆ 0.25 │\n", "└──────────────┴───────────┴───────────────┴────────────┴──────────┴───────────┴──────┘" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "portfolio_df = pl.DataFrame({\n", " \"portfolio_id\": [\n", " \"AGTHX\", \"AGTHX\", \"AGTHX\", \"AGTHX\",\n", " \"FCNTX\", \"FCNTX\",\n", " \"VADGX\", \"VADGX\", \"VADGX\", \"VADGX\", \"VADGX\", \"VADGX\",\n", " \"SPX\", \"SPX\", \"SPX\", \"SPX\", \"SPX\", \"SPX\", \"SPX\", \"SPX\",\n", " ],\n", " \"asset_id\": [\n", " # AGTHX\n", " \"02079K305\", \"02079K305\", \n", " \"2588173\", \"2588173\",\n", "\n", " # FCNTX\n", " \"67066G10\", \"67066G10\",\n", "\n", " # VADGX\n", " \"02079K305\", \"02079K305\", \n", " \"2588173\", \"2588173\", \n", " \"67066G10\", \"67066G10\",\n", "\n", " # SPX\n", " \"02079K305\", \"02079K305\", \n", " \"2588173\", \"2588173\",\n", " \"67066G10\", \"67066G10\",\n", " \"85371710\", \"85371710\",\n", "\n", " ], \n", " \"asset_id_type\": [\n", " # AGTHX\n", " \"cusip9\", \"cusip9\", \"sedol7\", \"sedol7\",\n", "\n", " # FCNTX\n", " \"cusip8\", \"cusip8\",\n", "\n", " # VADGX\n", " \"cusip9\", \"cusip9\", \"sedol7\", \"sedol7\", \"cusip8\", \"cusip8\",\n", "\n", " # SPX\n", " \"cusip9\", \"cusip9\", \"sedol7\", \"sedol7\", \"cusip8\", \"cusip8\", \"cusip8\", \"cusip8\",\n", " \n", " ],\n", " \"date\": [\n", " # AGTHX\n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31), \n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31),\n", "\n", " # FCNTX\n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31),\n", "\n", " # VADGX\n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31), \n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31), \n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31), \n", " \n", " # SPX\n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31), \n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31), \n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31), \n", " dt.date(2026, 1, 1), dt.date(2026, 1, 31), \n", " ],\n", " \"currency\": [None] * 20,\n", " \"share_qty\": [None] * 20,\n", " \"nav\": [\n", " # AGTHX\n", " 0.5, 0.55, \n", " 0.5, 0.45,\n", "\n", " # FCNTX\n", " 1.0, 1.0,\n", "\n", " # VADGX\n", " 0.3, 0.5, \n", " 0.4, 0.2,\n", " 0.3, 0.25,\n", "\n", " # SPX\n", " 0.3, 0.3, \n", " 0.4, 0.2,\n", " 0.3, 0.25,\n", " 0.3, 0.25,\n", " ],\n", "}).with_columns(pl.col(\"currency\").cast(pl.String), pl.col(\"share_qty\").cast(pl.Float64))\n", "\n", "portfolio_df" ] }, { "cell_type": "code", "execution_count": 5, "id": "341987db", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "UploadCommitResult(version=1, committed_names=[])" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "uploader.fast_commit(portfolio_df, mode=\"append\")" ] }, { "cell_type": "code", "execution_count": 6, "id": "931fadfa", "metadata": { "lines_to_next_cell": 2 }, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (4, 5)
fundbooktickerportfolio_idbenchmark_id
strstrstrstrnull
"some_fund""book_1""AGTHX""AGTHX"null
"some_fund""book_1""FCNTX""FCNTX"null
"some_fund""book_2""VADGX""VADGX"null
"some_fund""book_2""SPX""SPX"null
" ], "text/plain": [ "shape: (4, 5)\n", "┌───────────┬────────┬────────┬──────────────┬──────────────┐\n", "│ fund ┆ book ┆ ticker ┆ portfolio_id ┆ benchmark_id │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ str ┆ str ┆ str ┆ null │\n", "╞═══════════╪════════╪════════╪══════════════╪══════════════╡\n", "│ some_fund ┆ book_1 ┆ AGTHX ┆ AGTHX ┆ null │\n", "│ some_fund ┆ book_1 ┆ FCNTX ┆ FCNTX ┆ null │\n", "│ some_fund ┆ book_2 ┆ VADGX ┆ VADGX ┆ null │\n", "│ some_fund ┆ book_2 ┆ SPX ┆ SPX ┆ null │\n", "└───────────┴────────┴────────┴──────────────┴──────────────┘" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "portfolio_hierarchy_df = pl.DataFrame(\n", " {\n", " \"fund\": [\"some_fund\", \"some_fund\", \"some_fund\", \"some_fund\"],\n", " \"book\": [\"book_1\", \"book_1\", \"book_2\", \"book_2\"],\n", " \"ticker\": [\"AGTHX\", \"FCNTX\", \"VADGX\", \"SPX\"],\n", " \"portfolio_id\": [\"AGTHX\", \"FCNTX\", \"VADGX\", \"SPX\"],\n", " }\n", ")\n", "portfoliohierarchy_settings = PortfolioHierarchySettings.from_polars(\n", " portfolio_hierarchy_df, \n", " portfolio_source=\"portfolio-attribution-demo\",\n", ")\n", "portfoliohierarchy_settings.to_polars()" ] }, { "cell_type": "markdown", "id": "e6855e85", "metadata": {}, "source": [ "Now that we have the portfolio hiearachy in place, we define a basic factor model." ] }, { "cell_type": "code", "execution_count": 7, "id": "8cb72a14", "metadata": {}, "outputs": [], "source": [ "factorriskmodel_settings = FactorRiskModelSettings(\n", " universe=UniverseSettings(),\n", " exposures=ExposureSettings(\n", " exposures=[\n", " ContinuousExposureGroupSettings(hierarchy=\"market\"),\n", " CategoricalExposureGroupSettings(hierarchy=\"trbc\"),\n", " ContinuousExposureGroupSettings(hierarchy=\"style\"),\n", " ]\n", " ),\n", " modelconstruction=ModelConstructionSettings(\n", " estimation_universe=None,\n", " zero_sum_constraints={\"trbc\": \"mcap_weighted\"}\n", " ),\n", ")" ] }, { "cell_type": "markdown", "id": "a5f90576", "metadata": {}, "source": [ "We then define and load the report. We have different multi-period aggregation settings available, which we do not go into here." ] }, { "cell_type": "code", "execution_count": 8, "id": "8f5661e9", "metadata": {}, "outputs": [], "source": [ "report_settings = ReturnAttributionReportSettings(\n", " portfolio_hierarchy_settings=portfoliohierarchy_settings,\n", " factor_model_settings=factorriskmodel_settings,\n", " normalize_holdings=False, \n", " return_aggregation_type=\"arithmetic\",\n", ")\n", "report_engine = bln.equity.reports.load(\n", " report_settings.with_dataset(\"bayesline/Bayesline-US-All-1y\")\n", ")\n", "report = report_engine.calculate(start_date=\"2026-01-05\", end_date=\"2026-01-30\")" ] }, { "cell_type": "markdown", "id": "26124e9e", "metadata": {}, "source": [ "Let's first look at the return attribution from all sources at the ticker level (recall that ticker is defined in the portfolio hierarchy). For a specific ticker, we want to know the return attribution to different assets at each date." ] }, { "cell_type": "code", "execution_count": 9, "id": "b8a7515a", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (76, 4)
tickerdateinput_asset_idPnL
strdatestrf32
"AGTHX"2026-01-05"02079K305"0.002221
"AGTHX"2026-01-05"2588173"-0.000093
"AGTHX"2026-01-05"67066G10"0.0
"AGTHX"2026-01-05"85371710"0.0
"AGTHX"2026-01-06"02079K305"-0.003514
…………
"AGTHX"2026-01-29"85371710"0.0
"AGTHX"2026-01-30"02079K305"-0.000399
"AGTHX"2026-01-30"2588173"-0.003319
"AGTHX"2026-01-30"67066G10"0.0
"AGTHX"2026-01-30"85371710"0.0
" ], "text/plain": [ "shape: (76, 4)\n", "┌────────┬────────────┬────────────────┬───────────┐\n", "│ ticker ┆ date ┆ input_asset_id ┆ PnL │\n", "│ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ date ┆ str ┆ f32 │\n", "╞════════╪════════════╪════════════════╪═══════════╡\n", "│ AGTHX ┆ 2026-01-05 ┆ 02079K305 ┆ 0.002221 │\n", "│ AGTHX ┆ 2026-01-05 ┆ 2588173 ┆ -0.000093 │\n", "│ AGTHX ┆ 2026-01-05 ┆ 67066G10 ┆ 0.0 │\n", "│ AGTHX ┆ 2026-01-05 ┆ 85371710 ┆ 0.0 │\n", "│ AGTHX ┆ 2026-01-06 ┆ 02079K305 ┆ -0.003514 │\n", "│ … ┆ … ┆ … ┆ … │\n", "│ AGTHX ┆ 2026-01-29 ┆ 85371710 ┆ 0.0 │\n", "│ AGTHX ┆ 2026-01-30 ┆ 02079K305 ┆ -0.000399 │\n", "│ AGTHX ┆ 2026-01-30 ┆ 2588173 ┆ -0.003319 │\n", "│ AGTHX ┆ 2026-01-30 ┆ 67066G10 ┆ 0.0 │\n", "│ AGTHX ┆ 2026-01-30 ┆ 85371710 ┆ 0.0 │\n", "└────────┴────────────┴────────────────┴───────────┘" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# for a specific ticker, the return attribution across dates and assets\n", "(\n", " report.accessor.get_data(\n", " [(\"ticker\", \"AGTHX\")], # filters: [ticker=AGTHX]\n", " expand=(\"date\", \"input_asset_id\",), # combinations define the rows\n", " value_cols=(\"PnL\",), # exclude benchmark / active\n", " )\n", " .select(\"ticker\", \"date\", \"input_asset_id\", \"PnL\")\n", ")" ] }, { "cell_type": "code", "execution_count": 10, "id": "a5e03b9a", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (76, 4)
tickerdateinput_asset_idPnL
strdatestrf32
"AGTHX"2026-01-05"02079K305"0.002221
"AGTHX"2026-01-05"2588173"-0.000093
"AGTHX"2026-01-05"67066G10"0.0
"AGTHX"2026-01-05"85371710"0.0
"AGTHX"2026-01-06"02079K305"-0.003514
…………
"AGTHX"2026-01-29"85371710"0.0
"AGTHX"2026-01-30"02079K305"-0.000399
"AGTHX"2026-01-30"2588173"-0.003319
"AGTHX"2026-01-30"67066G10"0.0
"AGTHX"2026-01-30"85371710"0.0
" ], "text/plain": [ "shape: (76, 4)\n", "┌────────┬────────────┬────────────────┬───────────┐\n", "│ ticker ┆ date ┆ input_asset_id ┆ PnL │\n", "│ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ date ┆ str ┆ f32 │\n", "╞════════╪════════════╪════════════════╪═══════════╡\n", "│ AGTHX ┆ 2026-01-05 ┆ 02079K305 ┆ 0.002221 │\n", "│ AGTHX ┆ 2026-01-05 ┆ 2588173 ┆ -0.000093 │\n", "│ AGTHX ┆ 2026-01-05 ┆ 67066G10 ┆ 0.0 │\n", "│ AGTHX ┆ 2026-01-05 ┆ 85371710 ┆ 0.0 │\n", "│ AGTHX ┆ 2026-01-06 ┆ 02079K305 ┆ -0.003514 │\n", "│ … ┆ … ┆ … ┆ … │\n", "│ AGTHX ┆ 2026-01-29 ┆ 85371710 ┆ 0.0 │\n", "│ AGTHX ┆ 2026-01-30 ┆ 02079K305 ┆ -0.000399 │\n", "│ AGTHX ┆ 2026-01-30 ┆ 2588173 ┆ -0.003319 │\n", "│ AGTHX ┆ 2026-01-30 ┆ 67066G10 ┆ 0.0 │\n", "│ AGTHX ┆ 2026-01-30 ┆ 85371710 ┆ 0.0 │\n", "└────────┴────────────┴────────────────┴───────────┘" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# for a specific ticker, the return attribution across dates and assets\n", "(\n", " report.accessor.get_data(\n", " [(\"ticker\", \"AGTHX\")], # filters: [ticker=AGTHX]\n", " expand=(\"date\", \"input_asset_id\",), # combinations define the rows\n", " value_cols=(\"PnL\",), # exclude benchmark / active\n", " )\n", " .select(\"ticker\", \"date\", \"input_asset_id\", \"PnL\")\n", ")" ] }, { "cell_type": "markdown", "id": "6950a24a", "metadata": {}, "source": [ "Using different settings, we can split out the returns across all sources (factors and idio) at a different level. Below we show the returns on a specific date, for a specific book, split out by factor." ] }, { "cell_type": "code", "execution_count": 11, "id": "5d66f0d6", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (22, 6)
datebooktypefactor_groupfactorPnL
datestrstrstrstrf32
2026-01-05"book_1""Factors""market""Market"0.014189
2026-01-05"book_1""Factors""style""Dividend"0.000737
2026-01-05"book_1""Factors""style""Growth"0.001491
2026-01-05"book_1""Factors""style""Leverage"-0.000592
2026-01-05"book_1""Factors""style""Momentum"-0.002769
………………
2026-01-05"book_1""Factors""trbc""Institutions, Associations & O…0.0
2026-01-05"book_1""Factors""trbc""Real Estate"0.0
2026-01-05"book_1""Factors""trbc""Technology"-0.005175
2026-01-05"book_1""Factors""trbc""Utilities"0.0
2026-01-05"book_1""Idiosyncratic"""""-0.022578
" ], "text/plain": [ "shape: (22, 6)\n", "┌────────────┬────────┬───────────────┬──────────────┬─────────────────────────────────┬───────────┐\n", "│ date ┆ book ┆ type ┆ factor_group ┆ factor ┆ PnL │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪════════╪═══════════════╪══════════════╪═════════════════════════════════╪═══════════╡\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ market ┆ Market ┆ 0.014189 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ style ┆ Dividend ┆ 0.000737 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ style ┆ Growth ┆ 0.001491 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ style ┆ Leverage ┆ -0.000592 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ style ┆ Momentum ┆ -0.002769 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ trbc ┆ Institutions, Associations & O… ┆ 0.0 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ trbc ┆ Real Estate ┆ 0.0 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ trbc ┆ Technology ┆ -0.005175 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ trbc ┆ Utilities ┆ 0.0 │\n", "│ 2026-01-05 ┆ book_1 ┆ Idiosyncratic ┆ ┆ ┆ -0.022578 │\n", "└────────────┴────────┴───────────────┴──────────────┴─────────────────────────────────┴───────────┘" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# for a specific book on a specific date, the factor return attribution across assets\n", "(\n", " report.accessor.get_data(\n", " [(\"date\", \"2026-01-05\"), (\"book\", \"book_1\")], # filters\n", " expand=(\"type\", \"factor_group\", \"factor\",),\n", " value_cols=(\"PnL\",),\n", " )\n", " .select(\"date\", \"book\", \"type\", \"factor_group\", \"factor\", \"PnL\")\n", ")" ] }, { "cell_type": "markdown", "id": "1cb3efb2", "metadata": {}, "source": [ "We can drill down further by including the asset dimension. This decomposes the returns of the assets in a specific book, on a specific date." ] }, { "cell_type": "code", "execution_count": 12, "id": "cc974505", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (88, 7)
datebooktypefactor_groupfactorinput_asset_idPnL
datestrstrstrstrstrf32
2026-01-05"book_1""Factors""market""Market""02079K305"0.003563
2026-01-05"book_1""Factors""market""Market""2588173"0.00346
2026-01-05"book_1""Factors""market""Market""67066G10"0.007166
2026-01-05"book_1""Factors""market""Market""85371710"0.0
2026-01-05"book_1""Factors""style""Dividend""02079K305"0.000104
…………………
2026-01-05"book_1""Factors""trbc""Utilities""85371710"0.0
2026-01-05"book_1""Idiosyncratic""""""02079K305"-0.002482
2026-01-05"book_1""Idiosyncratic""""""2588173"-0.002861
2026-01-05"book_1""Idiosyncratic""""""67066G10"-0.017234
2026-01-05"book_1""Idiosyncratic""""""85371710"0.0
" ], "text/plain": [ "shape: (88, 7)\n", "┌────────────┬────────┬───────────────┬──────────────┬───────────┬────────────────┬───────────┐\n", "│ date ┆ book ┆ type ┆ factor_group ┆ factor ┆ input_asset_id ┆ PnL │\n", "│ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- ┆ --- │\n", "│ date ┆ str ┆ str ┆ str ┆ str ┆ str ┆ f32 │\n", "╞════════════╪════════╪═══════════════╪══════════════╪═══════════╪════════════════╪═══════════╡\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ market ┆ Market ┆ 02079K305 ┆ 0.003563 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ market ┆ Market ┆ 2588173 ┆ 0.00346 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ market ┆ Market ┆ 67066G10 ┆ 0.007166 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ market ┆ Market ┆ 85371710 ┆ 0.0 │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ style ┆ Dividend ┆ 02079K305 ┆ 0.000104 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ 2026-01-05 ┆ book_1 ┆ Factors ┆ trbc ┆ Utilities ┆ 85371710 ┆ 0.0 │\n", "│ 2026-01-05 ┆ book_1 ┆ Idiosyncratic ┆ ┆ ┆ 02079K305 ┆ -0.002482 │\n", "│ 2026-01-05 ┆ book_1 ┆ Idiosyncratic ┆ ┆ ┆ 2588173 ┆ -0.002861 │\n", "│ 2026-01-05 ┆ book_1 ┆ Idiosyncratic ┆ ┆ ┆ 67066G10 ┆ -0.017234 │\n", "│ 2026-01-05 ┆ book_1 ┆ Idiosyncratic ┆ ┆ ┆ 85371710 ┆ 0.0 │\n", "└────────────┴────────┴───────────────┴──────────────┴───────────┴────────────────┴───────────┘" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# for a specific book on a specific date, the factor return attribution by asset\n", "(\n", " report.accessor.get_data(\n", " [(\"date\", \"2026-01-05\"), (\"book\", \"book_1\")], # filters\n", " expand=(\"type\", \"factor_group\", \"factor\", \"input_asset_id\"),\n", " value_cols=(\"PnL\",),\n", " )\n", " .select(\"date\", \"book\", \"type\", \"factor_group\", \"factor\", \"input_asset_id\", \"PnL\")\n", ")" ] }, { "cell_type": "markdown", "id": "211b9b0c", "metadata": {}, "source": [ "By using the filters, we can also isolate the specific return attribution." ] }, { "cell_type": "code", "execution_count": 13, "id": "0d57774e", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (76, 4)
funddateinput_asset_idPnL
strdatestrf32
"some_fund"2026-01-05"02079K305"-0.005461
"some_fund"2026-01-05"2588173"-0.00744
"some_fund"2026-01-05"67066G10"-0.027575
"some_fund"2026-01-05"85371710"0.0
"some_fund"2026-01-06"02079K305"-0.024126
…………
"some_fund"2026-01-29"85371710"0.0
"some_fund"2026-01-30"02079K305"0.026471
"some_fund"2026-01-30"2588173"-0.00128
"some_fund"2026-01-30"67066G10"0.023653
"some_fund"2026-01-30"85371710"0.0
" ], "text/plain": [ "shape: (76, 4)\n", "┌───────────┬────────────┬────────────────┬───────────┐\n", "│ fund ┆ date ┆ input_asset_id ┆ PnL │\n", "│ --- ┆ --- ┆ --- ┆ --- │\n", "│ str ┆ date ┆ str ┆ f32 │\n", "╞═══════════╪════════════╪════════════════╪═══════════╡\n", "│ some_fund ┆ 2026-01-05 ┆ 02079K305 ┆ -0.005461 │\n", "│ some_fund ┆ 2026-01-05 ┆ 2588173 ┆ -0.00744 │\n", "│ some_fund ┆ 2026-01-05 ┆ 67066G10 ┆ -0.027575 │\n", "│ some_fund ┆ 2026-01-05 ┆ 85371710 ┆ 0.0 │\n", "│ some_fund ┆ 2026-01-06 ┆ 02079K305 ┆ -0.024126 │\n", "│ … ┆ … ┆ … ┆ … │\n", "│ some_fund ┆ 2026-01-29 ┆ 85371710 ┆ 0.0 │\n", "│ some_fund ┆ 2026-01-30 ┆ 02079K305 ┆ 0.026471 │\n", "│ some_fund ┆ 2026-01-30 ┆ 2588173 ┆ -0.00128 │\n", "│ some_fund ┆ 2026-01-30 ┆ 67066G10 ┆ 0.023653 │\n", "│ some_fund ┆ 2026-01-30 ┆ 85371710 ┆ 0.0 │\n", "└───────────┴────────────┴────────────────┴───────────┘" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# the idiosyncratic returns in a specific fund\n", "(\n", " report.accessor.get_data(\n", " [(\"fund\", \"some_fund\"), (\"type\", \"Idiosyncratic\")], # filters\n", " expand=(\"date\", \"input_asset_id\",),\n", " value_cols=(\"PnL\",),\n", " )\n", " .select(\"fund\", \"date\", \"input_asset_id\", \"PnL\")\n", ")" ] }, { "cell_type": "markdown", "id": "094607e3", "metadata": {}, "source": [ "We can now to the same for risk attribution / decomposition" ] }, { "cell_type": "code", "execution_count": 14, "id": "eb59eac9", "metadata": {}, "outputs": [], "source": [ "report_settings = XSRReportSettings(\n", " portfolio_hierarchy_settings=portfoliohierarchy_settings,\n", " factor_model_settings=factorriskmodel_settings,\n", " normalize_holdings=False,\n", ")\n", "report_engine = bln.equity.reports.load(\n", " report_settings.with_dataset(\"bayesline/Bayesline-US-All-1y\")\n", ")\n", "report = report_engine.calculate(start_date=\"2026-01-05\", end_date=\"2026-01-30\")" ] }, { "cell_type": "code", "execution_count": 15, "id": "06b907fb", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (22, 14)
tickerdatetypefactor_groupfactorExposureVolatilityCorrelationContributionBetaRelativeExposureRelativeContributionExposureRawPositionValue
strdatestrstrstrf32f32f32f32f32f32f32f32f32
"AGTHX"2026-01-05"Factors""market""Market"0.994520.1207390.5500690.0660510.01.00.2773481.00.99452
"AGTHX"2026-01-05"Factors""style""Dividend"0.0138610.024763-0.093918-0.0000320.01.0-0.0001350.0139380.99452
"AGTHX"2026-01-05"Factors""style""Growth"0.919890.0148470.1367540.0018680.01.00.0078430.9249590.99452
"AGTHX"2026-01-05"Factors""style""Leverage"-0.1378320.025365-0.4042540.0014130.01.00.005935-0.1385910.99452
"AGTHX"2026-01-05"Factors""style""Momentum"1.109220.0582270.307710.0198740.01.00.0834511.1153320.99452
……………………………………
"AGTHX"2026-01-05"Factors""trbc""Institutions, Associations & O…0.00.2133410.5422260.00.0NaN0.00.00.99452
"AGTHX"2026-01-05"Factors""trbc""Real Estate"0.00.075666-0.2448050.00.0NaN0.00.00.99452
"AGTHX"2026-01-05"Factors""trbc""Technology"0.994520.0517570.3948330.0203230.01.00.0853381.00.99452
"AGTHX"2026-01-05"Factors""trbc""Utilities"0.00.111759-0.1589060.00.0NaN0.00.00.99452
"AGTHX"2026-01-05"Idiosyncratic"""""0.994520.1483210.62280.0923740.0NaN0.387881.00.99452
" ], "text/plain": [ "shape: (22, 14)\n", "┌────────┬────────────┬────────────┬───────────┬───┬───────────┬───────────┬───────────┬───────────┐\n", "│ ticker ┆ date ┆ type ┆ factor_gr ┆ … ┆ RelativeE ┆ RelativeC ┆ ExposureR ┆ PositionV │\n", "│ --- ┆ --- ┆ --- ┆ oup ┆ ┆ xposure ┆ ontributi ┆ aw ┆ alue │\n", "│ str ┆ date ┆ str ┆ --- ┆ ┆ --- ┆ on ┆ --- ┆ --- │\n", "│ ┆ ┆ ┆ str ┆ ┆ f32 ┆ --- ┆ f32 ┆ f32 │\n", "│ ┆ ┆ ┆ ┆ ┆ ┆ f32 ┆ ┆ │\n", "╞════════╪════════════╪════════════╪═══════════╪═══╪═══════════╪═══════════╪═══════════╪═══════════╡\n", "│ AGTHX ┆ 2026-01-05 ┆ Factors ┆ market ┆ … ┆ 1.0 ┆ 0.277348 ┆ 1.0 ┆ 0.99452 │\n", "│ AGTHX ┆ 2026-01-05 ┆ Factors ┆ style ┆ … ┆ 1.0 ┆ -0.000135 ┆ 0.013938 ┆ 0.99452 │\n", "│ AGTHX ┆ 2026-01-05 ┆ Factors ┆ style ┆ … ┆ 1.0 ┆ 0.007843 ┆ 0.924959 ┆ 0.99452 │\n", "│ AGTHX ┆ 2026-01-05 ┆ Factors ┆ style ┆ … ┆ 1.0 ┆ 0.005935 ┆ -0.138591 ┆ 0.99452 │\n", "│ AGTHX ┆ 2026-01-05 ┆ Factors ┆ style ┆ … ┆ 1.0 ┆ 0.083451 ┆ 1.115332 ┆ 0.99452 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ AGTHX ┆ 2026-01-05 ┆ Factors ┆ trbc ┆ … ┆ NaN ┆ 0.0 ┆ 0.0 ┆ 0.99452 │\n", "│ AGTHX ┆ 2026-01-05 ┆ Factors ┆ trbc ┆ … ┆ NaN ┆ 0.0 ┆ 0.0 ┆ 0.99452 │\n", "│ AGTHX ┆ 2026-01-05 ┆ Factors ┆ trbc ┆ … ┆ 1.0 ┆ 0.085338 ┆ 1.0 ┆ 0.99452 │\n", "│ AGTHX ┆ 2026-01-05 ┆ Factors ┆ trbc ┆ … ┆ NaN ┆ 0.0 ┆ 0.0 ┆ 0.99452 │\n", "│ AGTHX ┆ 2026-01-05 ┆ Idiosyncra ┆ ┆ … ┆ NaN ┆ 0.38788 ┆ 1.0 ┆ 0.99452 │\n", "│ ┆ ┆ tic ┆ ┆ ┆ ┆ ┆ ┆ │\n", "└────────┴────────────┴────────────┴───────────┴───┴───────────┴───────────┴───────────┴───────────┘" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# for a specific ticker and date, the risk attribution across the factors\n", "(\n", " report.accessor.get_data(\n", " [(\"ticker\", \"AGTHX\"), (\"date\", \"2026-01-05\")], # filters: [ticker=AGTHX]\n", " expand=(\"type\", \"factor_group\", \"factor\",), # combinations define the rows\n", " value_cols=report.accessor.metric_cols, # Exposure, Stand-alone Volatility, Variance Contribution\n", " )\n", " .select(\"ticker\", \"date\", \"type\", \"factor_group\", \"factor\", *report.accessor.metric_cols)\n", ")" ] }, { "cell_type": "code", "execution_count": 16, "id": "f8312d12", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "shape: (76, 13)
tickerfactordateinput_asset_idExposureVolatilityCorrelationContributionBetaRelativeExposureRelativeContributionExposureRawPositionValue
strstrdatestrf32f32f32f32f32f32f32f32f32
"AGTHX""Volatility"2026-01-05"02079K305"0.1267430.1379440.5902290.0103190.0-2.7733330.043330.2506510.505655
"AGTHX""Volatility"2026-01-05"2588173"-0.1724440.1379440.590229-0.014040.03.773333-0.058954-0.3527420.488865
"AGTHX""Volatility"2026-01-05"67066G10"0.00.1379440.5902290.00.0-0.00.00.4187880.0
"AGTHX""Volatility"2026-01-05"85371710"0.00.1379440.5902290.00.0-0.00.00.00.0
"AGTHX""Volatility"2026-01-06"02079K305"0.1244010.1375230.590780.0101070.0-2.6408210.0425140.2477420.502141
…………………………………
"AGTHX""Volatility"2026-01-29"85371710"0.00.1292040.5467180.00.00.00.00.00.0
"AGTHX""Volatility"2026-01-30"02079K305"0.0638450.1323480.5489940.0046390.022.1763760.018820.1182450.539936
"AGTHX""Volatility"2026-01-30"2588173"-0.0609660.1323480.548994-0.004430.0-21.176376-0.017972-0.1370440.444864
"AGTHX""Volatility"2026-01-30"67066G10"0.00.1323480.5489940.00.00.00.00.4064530.0
"AGTHX""Volatility"2026-01-30"85371710"0.00.1323480.5489940.00.00.00.00.00.0
" ], "text/plain": [ "shape: (76, 13)\n", "┌────────┬────────────┬────────────┬───────────┬───┬───────────┬───────────┬───────────┬───────────┐\n", "│ ticker ┆ factor ┆ date ┆ input_ass ┆ … ┆ RelativeE ┆ RelativeC ┆ ExposureR ┆ PositionV │\n", "│ --- ┆ --- ┆ --- ┆ et_id ┆ ┆ xposure ┆ ontributi ┆ aw ┆ alue │\n", "│ str ┆ str ┆ date ┆ --- ┆ ┆ --- ┆ on ┆ --- ┆ --- │\n", "│ ┆ ┆ ┆ str ┆ ┆ f32 ┆ --- ┆ f32 ┆ f32 │\n", "│ ┆ ┆ ┆ ┆ ┆ ┆ f32 ┆ ┆ │\n", "╞════════╪════════════╪════════════╪═══════════╪═══╪═══════════╪═══════════╪═══════════╪═══════════╡\n", "│ AGTHX ┆ Volatility ┆ 2026-01-05 ┆ 02079K305 ┆ … ┆ -2.773333 ┆ 0.04333 ┆ 0.250651 ┆ 0.505655 │\n", "│ AGTHX ┆ Volatility ┆ 2026-01-05 ┆ 2588173 ┆ … ┆ 3.773333 ┆ -0.058954 ┆ -0.352742 ┆ 0.488865 │\n", "│ AGTHX ┆ Volatility ┆ 2026-01-05 ┆ 67066G10 ┆ … ┆ -0.0 ┆ 0.0 ┆ 0.418788 ┆ 0.0 │\n", "│ AGTHX ┆ Volatility ┆ 2026-01-05 ┆ 85371710 ┆ … ┆ -0.0 ┆ 0.0 ┆ 0.0 ┆ 0.0 │\n", "│ AGTHX ┆ Volatility ┆ 2026-01-06 ┆ 02079K305 ┆ … ┆ -2.640821 ┆ 0.042514 ┆ 0.247742 ┆ 0.502141 │\n", "│ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … ┆ … │\n", "│ AGTHX ┆ Volatility ┆ 2026-01-29 ┆ 85371710 ┆ … ┆ 0.0 ┆ 0.0 ┆ 0.0 ┆ 0.0 │\n", "│ AGTHX ┆ Volatility ┆ 2026-01-30 ┆ 02079K305 ┆ … ┆ 22.176376 ┆ 0.01882 ┆ 0.118245 ┆ 0.539936 │\n", "│ AGTHX ┆ Volatility ┆ 2026-01-30 ┆ 2588173 ┆ … ┆ -21.17637 ┆ -0.017972 ┆ -0.137044 ┆ 0.444864 │\n", "│ ┆ ┆ ┆ ┆ ┆ 6 ┆ ┆ ┆ │\n", "│ AGTHX ┆ Volatility ┆ 2026-01-30 ┆ 67066G10 ┆ … ┆ 0.0 ┆ 0.0 ┆ 0.406453 ┆ 0.0 │\n", "│ AGTHX ┆ Volatility ┆ 2026-01-30 ┆ 85371710 ┆ … ┆ 0.0 ┆ 0.0 ┆ 0.0 ┆ 0.0 │\n", "└────────┴────────────┴────────────┴───────────┴───┴───────────┴───────────┴───────────┴───────────┘" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# for a specific ticker and factor, the risk attribution across dates and assets\n", "(\n", " report.accessor.get_data(\n", " [(\"ticker\", \"AGTHX\"), (\"factor\", \"Volatility\")], # filters\n", " expand=(\"date\", \"input_asset_id\",), # combinations define the rows\n", " value_cols=report.accessor.metric_cols, # Exposure, Stand-alone Volatility, Variance Contribution\n", " )\n", " .select(\"ticker\", \"factor\", \"date\", \"input_asset_id\", *report.accessor.metric_cols)\n", ")" ] } ], "metadata": { "jupytext": { "text_representation": { "extension": ".py", "format_name": "percent", "format_version": "1.3", "jupytext_version": "1.19.3" } }, "kernelspec": { "display_name": ".venv", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.11.15" } }, "nbformat": 4, "nbformat_minor": 5 }