Attachment+6+-+Invest.+Holdings+sample.xlsx

This is a data template file supporting North Dakota's "Days of our Legacy" contract opportunity, which solicits proposals for Legacy Fund website building and data management. The template demonstrates the structure and format required for investment holdings data consolidation, showing approximately 5,000 rows of legacy fund account information across multiple accounts. The data file requires submission in a standardized format with approximately 40 columns of data, including account identifiers, valuation dates, market prices, asset valuations, share/par values, currency information, asset categorization, maturity dates, and asset identifiers. The template provides sample entries showing holdings across various asset types, including equities (common stock) and fixed income securities (municipal/provincial bonds and corporate bonds) denominated in multiple currencies (Australian dollars and United States dollars) and held across different countries of risk (Australia, Canada, and the United States).

The transformed data output should consolidate holdings information into a simplified format showing holding descriptions, market values in USD, asset categories, asset sub-categories, and country of risk designations. The template indicates that holdings may require aggregation across multiple accounts and that additional data transformation may be necessary as determined by the state. The file serves as a reference standard for vendors responding to the Legacy Fund website and data management solicitation, ensuring consistent data submission and enabling the state to effectively consolidate and manage investment portfolio information across all legacy fund accounts.