Financial Portfolio Holdings History

This dataset provides a comprehensive time series record of synthetic investment portfolio holdings, including detailed transactions, valuations, risk metrics, and attribution factors. It is ideal for portfolio analytics, risk modeling, and performance attribution studies, enabling in-depth analysis of investment strategies and exposures over time.

  • last updated 21 Jul 2025
  • by GoMask
The brief that made it

Portfolio risk and performance analytics

Sample rows

preview · 8 of 201 rows · all 21 columns
portfolio_idstringinstrument_typestringquantityfloatportfolio_namestringholding_idstringas_of_datedateinstrument_idstringinstrument_namestringcurrencystringmarket_valuefloatcost_basisfloattransaction_idstringtransaction_typestringtransaction_amountfloattransaction_datedatecounterpartystringaccrued_incomefloatvaluation_sourcestringrisk_metricsstringnotesstringattribution_factorsstring
PF10001equity12000Global Equity GrowthHLD-A1012024-03-31AAPL-USApple Inc.USD23400001980000T1000001buy12000002024-03-30Morgan Stanley220marketVaR: 9500; beta: 1.2Initial buy for portfolio expansion.sector: Technology; region: North America; style: Growth
PF10002equity8000Wealth BuilderHLD-B1022024-03-31MSFT-USMicrosoft CorporationUSD21600001480000T1000002buy8000002024-03-29Goldman Sachs185marketVaR: 8800; beta: 1.06Monthly position increase.sector: Technology; region: North America; style: Growth
PF10003etf2500Dividend HarvestHLD-C1032024-03-31VTI-USVanguard Total Stock Market ETFUSD590000570000T1000003buy2500002024-03-28JPMorgan70marketVaR: 2400; beta: 0.99ETF broad market exposure.sector: Equity; region: North America; style: Index
PF20001bond500000Conservative BondsHLD-D1042024-03-31US9128285M81US Treasury Note 2.75% 2025USD511000497000T1000004buy5000002024-03-20Barclays Plc350custodianVaR: 8000; duration: 1.8Core bond allocation.sector: Government; region: North America; style: Fixed Income
PF20002bond95000Emerging Market BondsHLD-E1052024-03-31BRSTNBRL1Brazilian Sovereign 6.25% 2029BRL720000675000T1000005buy7000002024-03-18Itaú BBA430modelVaR: 11200; duration: 6.5Long-dated EM exposure.sector: Sovereign; region: Latin America; style: EM Debt
PF30001cash1600000Money MarketHLD-F1062024-03-31CASH-USDUS Dollar CashUSD16000001600000T1000006transfer_in8000002024-03-31HSBC Bank0custodianVaR: 0Quarterly cash deposit.sector: Cash; region: North America; style: Liquidity
PF10001equity5000Global Equity GrowthHLD-A1072024-03-31GOOGL-USAlphabet Inc. Class AUSD820000670000T1000007buy5000002024-03-25Citigroup55marketVaR: 3700; beta: 1.18Added large cap tech.sector: Technology; region: North America; style: Growth
PF10002equity2000Wealth BuilderHLD-B1082024-02-29TSLA-USTesla Inc.USD405000310000T1000008buy2000002024-02-28JPMorgan0marketVaR: 2200; beta: 1.3High-volatility addition.sector: Industrial; region: North America; style: Growth

What the 201 rows show

from the 201-row sample

Cash (instrument type) stands out: mean quantity is 6,036,061, against 61,009 for the rest.

  • 6,700median quantity
  • 4valuation sources
  • 5transaction types
  • 9currencies
  • 320,000median market_value
  • 310,000median cost_basis
Mean quantity by instrument_type201 rows
04M8M7,254equi…61 ro…237kbond41 ro…4,728etf24 ro…4,688mutu…21 ro…6Mcash31 ro…1.7deri…7 rows3.9other16 ro…
quantity201 rows, in bands of 10M
0100200197011011040M70Mquantity →

Median 6,700, from 0.12 to 62,000,000.

portfolio_name200 rows with a value · 1 left blank
  1. Private Wealth32
  2. Emerging Market Bonds18
  3. Alternative Assets18
  4. Wealth Builder16
  5. Global Equity Growth14
  6. Money Market13
  7. Family Office10
  8. Short Term Liquidity10
  9. Corporate Treasury8
  10. Conservative Bonds7
21 columns by typefrom the column list below
  • string 14
  • float 5
  • date 2

Columns

21 columns in three groups
blueprint · 21 columns
columntypedescriptionexample
Text 14 columns
portfolio_idstringUnique identifier for the investment portfolio.PF10001
portfolio_namestringDescriptive name of the investment portfolio.optionalGlobal Equity Growth
holding_idstringUnique identifier for a specific holding within a portfolio.uniqueHLD-A101
instrument_idstringUnique identifier for the financial instrument (e.g., ISIN, CUSIP, Ticker).AAPL-US
instrument_typestringType of financial instrument (e.g., equity, bond, ETF, mutual fund, cash).7 valuesequity
instrument_namestringFull name of the financial instrument.optionalApple Inc.
currencystringISO 4217 currency code for the holding or transaction (e.g., USD, EUR).9 currenciesUSD
transaction_idstringUnique identifier for the transaction (if applicable).unique · optionalT1000001
transaction_typestringType of transaction (e.g., buy, sell, dividend, interest, transfer, fee).8 values · optionalbuy
counterpartystringName or identifier of the counterparty involved in the transaction, if applicable.optionalMorgan Stanley
valuation_sourcestringSource of the valuation (e.g., market, model, custodian).market · model · custodian · other · optionalmarket
risk_metricsstringJSON object containing risk metrics (e.g., VaR, beta, duration) for the holding as of the specified date.optionalVaR: 9500; beta: 1.2
attribution_factorsstringJSON object containing attribution factors (e.g., sector, region, style) for analytics.optionalsector: Technology; regio…
notesstringFree-text notes or comments about the holding or transaction.optionalCore bond allocation.
Numbers 5 columns
quantityfloatNumber of units held or transacted for the instrument.0 or more12000
market_valuefloatTotal market value of the holding as of the specified date, in the given currency.0 or more2340000
cost_basisfloatOriginal cost of the holding, in the given currency.0 or more · optional1980000
transaction_amountfloatAmount involved in the transaction, in the given currency.optional1200000
accrued_incomefloatAccrued but unpaid income (e.g., interest, dividends) as of the specified date.optional220
Dates and times 2 columns
as_of_datedateThe date for which the holding, valuation, or transaction is recorded.2024-03-31
transaction_datedateDate on which the transaction occurred.optional2024-03-30

Use it for

  • median quantity6,700201 rowsmean quantity by inst…7.3kequi…237kbond4.7ketf4.7kmutu…

    A finance dashboard

    Quantity by instrument_type and a breakdown of portfolio_name. Excel, Power BI or Tableau.

  • Why do the 31 cash rows have a mean quantity of 6,036,061?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable portfolios with portfolio_name, holding_id and as_of_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset201 rows21 columns
Yours1,000 rows21 columns

blueprint · financial-portfolio-holdings-history

Behind this dataset

Same schema. As many rows as you need.

These 201 rows came out of a blueprint — 21 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each portfolio assigned a unique ID
  • Track asset type, position, and transaction type
  • Daily valuations and returns included
  • Include benchmark and sector breakdown
  • Simulate contributions, withdrawals, and rebalancing
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
financial-portfolio-holdings-history

More in Finance

Browse all
Also in FinanceFinancial Portfolio Stress TestingFinance Expense Categorization DatasetPersonal Finance Budgeting RecordsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.