Data Files

To support the range of Sandbox Testing, the following data files have been used below.

All files are uploaded for the 01/06/2018.

A. UCITS & NURS (UK, Swiss and Irish)

File NameDescription
Holdings
HoldingExportPortfolio Holdings
Sandbox_NAVPortfolio NAV

Setup Files - Holdings
Security_ManCreation of non-derivative assets
Derivative_ManCreation of derivative assets

Setup Files - Issuers
FTSCOmanualIssuer creation
FTScovotingsharesIssuer voting rights population
FTScononvotingsharesIssuer non-voting rights population
FTScoissuedcapitalIssuer capital population
FTScodebtinissueIssuer debt share population

Pricing files
DerivPF_StocksStock Prices

Counterparties
FTSCOcpmanualCounterparty creation
Deriv_HCPCounterparty assign

Additional Files
FTS_LQTraded Volume Figures
Man_ISRCredit Ratings
FX_RateFX Rates

The files above can be downloaded here.

B. AIFMD ANNEX IV

File NameDescription
Holdings
AIFMD_holdingsPortfolio Holdings
AIFMD_NAVPortfolio NAV
AIFMD Data
Portfolio Entity Assumptions
Portfolio_AIFMD_RiskVaR figures
Portfolio_Expected_AIRAnnual Investment Return
Portfolio_GrossNet_IRRInternal Rate of Return
Portfolio_InvestorGroupsInvestor breakdown - Groups
Portfolio_InvestorTypesInvestor breakdown - Types
Portfolio_SubsRedsSubscriptions/ Redemptions
Portfolio_Investor Liquidity
Portfolio_FinancingLiquidity
Trades
AIFMD_Trades

C. Cashflow Monitoring

File NameDescription
Holdings
CScashflowPortfolio Holdings
DBcashflowPortfolio Holdings
GScashflowPortfolio Holdings