--- title: "Creating an A2B report to understand how valuations change over time" slug: "creating-an-a2b-report-to-understand-how-valuations-change-over-time" updated: 2024-08-30T10:41:54Z published: 2024-08-30T10:41:54Z canonical: "support.lusid.com/creating-an-a2b-report-to-understand-how-valuations-change-over-time" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.lusid.com/llms.txt > Use this file to discover all available pages before exploring further. # Creating an A2B report to understand how valuations change over time In this tutorial we'll see how to create an A2B report for [this example transaction portfolio](/v1/docs/valuing-a-multi-asset-multi-region-portfolio) to understand precisely *how* it has changed in value between two points in time. A holdings report dated 7 March 2022 for this portfolio reveals that: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/5.png) When we ask LUSID to value this portfolio on 7 March 2022, we discover it is worth £114,073.60 (aggregated in the portfolio currency). We then sell some of the USD Microsoft holding during the week and on 11 March 2022 ask LUSID to value the portfolio again using the same metrics; we discover it is now worth £131,687.00: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/1d4eca55-52eb-4dfd-bbe9-125f15edc837.png) An A2B report helps drill down into all the activity that has contributed to the increase of £17,613.40. This could be: - Transactions that have occurred during the window, whether explicit buy or sells or implicit transactions such as dividends or fees. - Fluctuations in market prices and FX rates. Most likely, it will be a combination of the two. In order to generate an A2B report, we require: - Appropriate [market data](/v1/docs/market-data) (market prices, FX rates and so on) loaded into a suitable LUSID store for the start and end dates of the A2B report. Note we do not need to load this data for all the intermediate days in the window. - A suitable [recipe](/v1/docs/what-is-a-recipe) that assembles market data and specifies a pricing model and methodology to use. See [this tutorial](/v1/docs/valuing-a-multi-asset-multi-region-portfolio) for a detailed example of upserting market data and recipes into LUSID. Providing we have appropriate [access control permissions](/v1/docs/setting-up-access-control-for-different-configuration-store-users), we can generate an A2B report using the [LUSID web app](https://www.lusid.com/app/home): ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/78fc252f-daf9-4924-8f5d-2df34087a9fd.png) Alternatively, we can generate an A2B report programmatically: - Using the LUSID [GetA2BData](https://www.lusid.com/docs/api#operation/GetA2BData) API. - Using the equivalent function in [LUSID SDKs](https://github.com/finbourne) in various languages and frameworks. - Using the Luminesce [Lusid.Portfolio.A2B](/v1/docs/lusidportfolioatob) provider. ## Understanding the A2B calculation For each holding in a portfolio, an A2B report performs the following calculation, in both the holding and portfolio currencies: ```plaintext (Start Value + Flows + Gains + Carry) = End Value ``` ...where: - `Start Value` is the market value of the holding at the start of the window. This can be zero if, for example, we first transact in the underlying instrument during the window. - `Flows` are transactions that result in increases or decreases in the quantity of the holding. - `Gains` are capital gains or losses caused by market price and/or FX fluctuations. These are classified as either: LUSID reports delta market price and delta currency (FX) gain separately, so we can track the cause of capital gain/loss. By default, cross gain is included in price gain, though there should soon be an option to report cross gain as included in FX gain. - Realized in that we (for example) sell some of our holding during the window. - Unrealized in that we do not and therefore gains/losses are theoretical and based on price or FX fluctuations. - `Carry` is income (for example, dividend or accrual) or expense (for example, management or transaction fee) activity. - `End Value` is the market value of the holding at the end of the window. > **Note:** LUSID generates a standard A2B report out-of-the-box but we can change the way information is reported by configuring transaction types, in particular using the [dedicated movement types](/v1/docs/using-the-carry-movement-types-to-configure-an-a2b-report) for A2B reports. ## Generating an A2B report for the example portfolio An A2B report generated in the LUSID web app for the example portfolio above starting 7 March 2022 and ending 11 March 2022 looks like this: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/6.png) We can see that: - The figure columns represent, from left to right, `Start Value`, `Flows`, `Gains`, `Carry` and `End Value`. Each column is duplicated: one for the holding currency and one (with a **PC** suffix) for the portfolio currency. Note you may need to re-arrange columns to see them as they are here. - You can click on the arrow to the left of a holding to expand the row and see more information. - There is currently no total row summing the values in each column to calculate totals for the portfolio as a whole. However, you can easily [perform this aggregation yourself](/v1/docs/creating-an-a2b-report-to-understand-how-valuations-change-over-time#aggregating-values-to-calculate-totals-for-a-portfolio-as-a-whole) if you generate an A2B report using an SDK. ### GBP currency holding We can see that the start value and the end value are the same (£42,000) and that there has been no activity of any type during the window: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/7.png) ### UKT 0 3/8 10/22/26 bond holding We can see that the holding increased in value by £24.41. Expanding the row reveals that: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/8.png) - There were no transactions affecting the underlying instrument (no value in the **FlowsPC** column). - Hovering over the value in the **CapGainPC** column reveals the gain is due to an increase in market price: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/39fb3311-27c6-4354-a0dc-2467e3d34494.png) - Hovering over the value in the **CarryPC** column reveals the income is accrued interest: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/4584e847-f63a-4732-ac08-2edc58cdb22d.png) ### BP equity holding We can see that the holding increased in value by £12,800. Expanding the row reveals that: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/9.png) - There were no transactions affecting the underlying instrument (no value in the **FlowsPC** column). - Hovering over the value in the **CapGainPC** column reveals the gain is due to an increase in market price: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/0b6450f8-8d8f-4748-9911-e59021d0cd85.png) ### USD currency holding We can see that the holding increased in value by £8,458 (in the portfolio currency). Expanding the row (and showing only the **PC** columns to normalise USD to GBP) reveals that: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/10.png) - A transaction occurred during the window (with an ID of `MD41007` and using the built-in [side](/v1/docs/what-is-a-side) `Side2`). Hovering over the value in the **FlowsPC** column reveals the transaction resulted in a flow *in* to the instrument: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/1bb16d48-cdeb-490b-ba6e-faa7df4a0723.png) - Hovering over the value in the **CapGainPC** column reveals the gain is due to an increase in the value of USD relative to GBP: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/f8a243f2-ee70-4e1f-bcea-b586d5092c50.png) ### T 2.375% Aug 15 2024 bond holding We can see that the holding increased in value by £310.39 (in the portfolio currency). Expanding the row (and showing only the **PC** columns to normalise USD to GBP) reveals that: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/ec1876cd-56eb-47e4-9166-f520c4267308.png) - There were no transactions affecting the underlying instrument (no value in the **FlowsPC** column). - Hovering over the value in the **CapGainPC** column reveals that, while the holding lost value due to a decrease in market price, it gained overall due to an increase in the value of USD relative to GBP: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/b134d314-9ad7-4e9c-9d4f-f0ba36e346bd.png) - Hovering over the value in the **CarryPC** column reveals the income is accrued interest: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/3d69b1b4-52a6-4b87-81f4-76434504eed2.png) ### Microsoft equity holding We can see that the holding decreased in value by -£3,979.40 (in the portfolio currency). Expanding the row (and showing only the **PC** columns to normalise USD to GBP) reveals that: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/f6ae7671-e6f6-4da8-ae52-96c5f042b824.png) - A transaction occurred during the window (with an ID of `MD41007` and using the built-in `Side1`; this is the counterpart to the USD transaction above). Hovering over the value in the **FlowsPC** column reveals the transaction resulted in a flow *out* of the instrument: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/93558f3b-beb9-4b59-8c1b-aed08c978661.png) - Hovering over the values in the **CapGainPC** column reveals: - On 9 March there was a realized gain due to an increase in market price: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/15e21abe-573b-40b4-b9af-8dc0d06a9e66.png) - By 11 March there has been an unrealized gain for the remainder of the holding due to both an increase in market price *and* in the value of USD relative to GBP: ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/3f38c393-924b-4219-8e9b-e5362505449b.png) ## Aggregating values to calculate totals for a portfolio as a whole The LUSID web app does not currently show a total row summing the values in each column to calculate totals for the portfolio as a whole. However, you can easily aggregate yourself if you generate an A2B report using a LUSID SDK. For example, the following code generates the same A2B report for the example portfolio above using the LUSID Python SDK: ```python # Generate A2B report using Python function equivalent to the LUSID GetA2BData API transaction_portfolios_api = api_factory.build(la.TransactionPortfoliosApi) a2b_report = transaction_portfolios_api.get_a2_b_data(    scope = "FBNUniversity",    code = "Module-4-1",    from_effective_at = "2022-03-07T00:00:00Z",    to_effective_at = "2022-03-11T23:59:59Z",    recipe_id_scope = "FBNUniversity",    recipe_id_code = "Module-4-1Recipe",    property_keys=["Instrument/default/Name"] ) # Transform to Pandas dataframe using Python LPT utility function for better UX a2b_report_df = lusid_response_to_data_frame(a2b_report) # Retain only columns reporting portfolio currency totals a2b_report_filtered_df = a2b_report_df.filter(items=[    "properties.Instrument/default/Name.value.label_value",    "currency",    "start.portfolio_currency.total",    "flows.portfolio_currency.total",    "gains.portfolio_currency.total","carry.portfolio_currency.total",    "end.portfolio_currency.total" ] ) # Rename columns a2b_report_filtered_df.rename(columns = {    "properties.Instrument/default/Name.value.label_value": "Instrument Name",    "start.portfolio_currency.total": "MarketValuePC (Start)",    "flows.portfolio_currency.total": "FlowsPC",    "gains.portfolio_currency.total": "CapGainsPC",    "carry.portfolio_currency.total": "CarryPC",    "end.portfolio_currency.total": "MarketValuePC (End)", }, inplace = True, ) # Show A2B report display(a2b_report_filtered_df.sort_values(by=['currency'])) ``` ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/7dbb7f43-2348-4e36-ab6e-4f5dd0860105.png) We can use the Pandas `sum` function to calculate totals for each column (note it only makes sense to sum columns normalised to the portfolio currency): ```python a2b_report_filtered_df.sum(numeric_only = True).to_frame().transpose() ``` ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/fc6f8b96-ebb2-4815-8509-84dddc023cac.png) We can see the **FlowsPC** total is zero; the flow in of £7,525 to the USD holding and the flow out of -£7,525 from Microsoft cancel each other.