A holding ID is an identifier for a holding in a transaction portfolio that is:
Unique across portfolios. For example, a Microsoft holding in a portfolio does not share an ID with any other holding in a different portfolio, even another Microsoft holding.
Unique across sub-holding keys (SHKs) in a portfolio. For example, a Microsoft holding tagged by one SHK does not share an ID with a Microsoft holding tagged by a different SHK.
Shared across tax lots in a portfolio. For example, a Microsoft holding purchased in one tax lot does share an ID with a Microsoft holding purchased in a different tax lot.
Shared across unsettled and settled cash holdings in a portfolio. For example, a temporary USD balance of holding type
Adoes share an ID with a settled USD balance of holding typeB.
Note: You can audit holding IDs in a valuation report using the
Holding/HoldingIdmetric. In addition, aHolding/UniqueIdmetric returns a GUID that is unique across all the circumstances bulleted above.
Consider a portfolio with a tax lot accounting method of FirstInFirstOut and a SHK that divides holdings into Growth and Income strategies. The following transactions are recorded for that portfolio:
Transaction type | Instrument | Currency | Trade date | Settlement date | Units | Total consideration | Strategy | Notes |
|---|---|---|---|---|---|---|---|---|
FundsIn | USD | USD | 1 July 2023 | 3 July 2023 | 15000 | 15000 | Income |
|
Buy | BP | GBP | 2 July 2023 | 4 July 2023 | 500 | -5000 | Growth |
|
Buy | Microsoft | USD | 3 July 2023 | 5 July 2023 | 300 | -3000 | Income | Tax lot #1 |
Buy | Microsoft | USD | 4 July 2023 | 6 July 2023 | 100 | -1100 | Income | Tax lot #2 |
Dividend | Microsoft | USD | 5 July 2023 | 7 July 2023 | 400 | 40 | Income | 10% of units held |
Calling the GetHoldings API on 6 July 2023 returns the following five holdings. Note the ID of the settled USD balance and the unsettled accrual for the cash dividend transaction is the same:
Calling the GetHoldings API with byTaxlots set to True for 6 July 2023 returns the following six holdings. Note the ID of Microsoft in different tax lots is the same:
You can call the GetHoldingContributors API with a particular holding ID to audit the transactions that have contributed to that position. For example, the following three transactions contributed to the Microsoft holding with ID 67940167:
The following four transactions contributed to the USD holding with ID 67940164:
