Additional Fund Data

The Additional Fund Data file is a CSV file that users can upload, which allows users to provide supplementary data for the various Regulatory Reporting products FundApps offer.

Uploading and Downloading Additional Fund Data

To upload or download the Additional Fund Data file:

Navigate to the Annex IV page under Reporting.
Select the relevant reporting period to unlock CSV-related actions.
From there, you can:
- Download the current Additional Fund Data held in FundApps.
- Upload a new CSV file with the desired additional properties.

File Structure

The CSV file must follow this structure:

Header Row: The first row should include the field names (headers) that define the additional data you wish to provide for each portfolio or entity.
Data Rows: Each subsequent row represents a portfolio or entity and contains the corresponding data values for them.

Requirements:

Each row must correspond to a portfolio or entity defined in your FundApps environment.
The PortfolioId, Aggregation, and PortfolioType must match exactly with existing records in your system.
The data types and required fields vary depending on whether it is portfolio or entity. For complete details, refer to the official documentation: FundApps AIFMD Annex IV Properties

Example File

Below is an example that can be used for AIFMD Annex IV:

PortfolioId,Aggregation,PortfolioType,GrossInvestmentReturnsRate_January,GrossInvestmentReturnsRate_February,GrossInvestmentReturnsRate_March,GrossInvestmentReturnsRate_April,GrossInvestmentReturnsRate_May,GrossInvestmentReturnsRate_June,GrossInvestmentReturnsRate_July,GrossInvestmentReturnsRate_August,GrossInvestmentReturnsRate_September,GrossInvestmentReturnsRate_October,GrossInvestmentReturnsRate_November,GrossInvestmentReturnsRate_December,NetInvestmentReturnsRate_January,NetInvestmentReturnsRate_February,NetInvestmentReturnsRate_March,NetInvestmentReturnsRate_April,NetInvestmentReturnsRate_May,NetInvestmentReturnsRate_June,NetInvestmentReturnsRate_July,NetInvestmentReturnsRate_August,NetInvestmentReturnsRate_September,NetInvestmentReturnsRate_October,NetInvestmentReturnsRate_November,NetInvestmentReturnsRate_December,NavChangeRate_January,NavChangeRate_February,NavChangeRate_March,NavChangeRate_April,NavChangeRate_May,NavChangeRate_June,NavChangeRate_July,NavChangeRate_August,NavChangeRate_September,NavChangeRate_October,NavChangeRate_November,NavChangeRate_December,Subscription_January,Subscription_February,Subscription_March,Subscription_April,Subscription_May,Subscription_June,Subscription_July,Subscription_August,Subscription_September,Subscription_October,Subscription_November,Subscription_December,Redemption_January,Redemption_February,Redemption_March,Redemption_April,Redemption_May,Redemption_June,Redemption_July,Redemption_August,Redemption_September,Redemption_October,Redemption_November,Redemption_December,RiskMeasureType_1,RiskMeasureValue_1,LessFiveYearsRiskMeasureValue_1,FifteenYearsRiskMeasureValue_1,MoreFifteenYearsRiskMeasureValue_1,CurrentMarketRiskMeasureValue_1,LowerMarketRiskMeasureValue_1,HigherMarketRiskMeasureValue_1,VarValue_1,VarCalculationMethodCodeType_1,RiskMeasureDescription_1,RiskMeasureType_2,RiskMeasureValue_2,LessFiveYearsRiskMeasureValue_2,FifteenYearsRiskMeasureValue_2,MoreFifteenYearsRiskMeasureValue_2,CurrentMarketRiskMeasureValue_2,LowerMarketRiskMeasureValue_2,HigherMarketRiskMeasureValue_2,VarValue_2,VarCalculationMethodCodeType_2,RiskMeasureDescription_2,PrivateEquityFundStrategyType_1,PrivateEquityFundPrimaryStrategyFlag_1,PrivateEquityFundStrategyNAVRate_1,PrivateEquityFundStrategyTypeOtherDescription_1,PrivateEquityFundStrategyType_2,PrivateEquityFundPrimaryStrategyFlag_2,PrivateEquityFundStrategyNAVRate_2,PrivateEquityFundStrategyTypeOtherDescription_2,FinancingLiquidity_TotalFinancingAmount,FinancingLiquidity_0to1Rate,FinancingLiquidity_2to7Rate,FinancingLiquidity_8to30Rate,FinancingLiquidity_31to90Rate,FinancingLiquidity_91to180Rate,FinancingLiquidity_181to365Rate,FinancingLiquidity_365MoreRate,ShareClassNationalCode_1,ShareClassIdentifierIsin_1,ShareClassIdentifierCusip_1,ShareClassIdentifierSedol_1,ShareClassIdentifierTicker_1,ShareClassIdentifierRic_1,ShareClassName_1,InvestorLiquidity_0to1Rate,InvestorLiquidity_2to7Rate,InvestorLiquidity_8to30Rate,InvestorLiquidity_31to90Rate,InvestorLiquidity_91to180Rate,InvestorLiquidity_181to365Rate,InvestorLiquidity_365MoreRate,InvestorIlliquidAssetArrangement_SidePocketRate,InvestorIlliquidAssetArrangement_GatesRate,InvestorIlliquidAssetArrangement_DealingSuspensionRate,InvestorIlliquidAssetArrangement_OtherArrangementType,InvestorIlliquidAssetArrangement_OtherArrangementRate,InvestorIlliquidAssetArrangement_TotalArrangementRate,AifIdentifierIsin,AifIdentifierCusip,AifIdentifierSedol,AifIdentifierTicker,AifIdentifierRic,InvestorPreferentialTreatmentFlag,DisclosureTermsPreferentialTreatmentFlag,LiquidityTermsPreferentialTreatmentFlag,FeeTermsPreferentialTreatmentFlag,OtherTermsPreferentialTreatmentFlag,HedgeFundStrategyType_1,HedgeFundPrimaryStrategyFlag_1,HedgeFundStrategyNAVRate_1,HedgeFundStrategyTypeOtherDescription_1,OtherFundStrategyType_1,OtherFundPrimaryStrategyFlag_1,OtherFundStrategyNAVRate_1,OtherFundStrategyTypeOtherDescription_1,RealEstateFundStrategyType_1,RealEstateFundPrimaryStrategyFlag_1,RealEstateFundStrategyNAVRate_1,RealEstateFundStrategyTypeOtherDescription_1,FundOfFundsStrategyType_1,FundOfFundsPrimaryStrategyFlag_1,FundOfFundsStrategyNAVRate_1,FundOfFundsStrategyTypeOtherDescription_1,PrimeBrokerName_1,PrimeBrokerLEI_1,PrimeBrokerBIC_1,TurnoverSubAssetType_1,TurnoverMarketValue_1,TurnoverNotionalValue_1,ClearedRepos_CcpRate,ClearedRepos_BilateralClearingRate,ClearedRepos_TriPartyRepoClearingRate,AssumptionFcaRef_1,AssumptionDesc_1,StressTestsResultArticle15,StressTestsResultArticle16,TradedDerivatives_RegulatedMarketRate,TradedDerivatives_OtcRate,TradedSecurities_RegulatedMarketRate,TradedSecurities_OtcRate,ClearedDerivatives_CcpRate,ClearedDerivatives_BilateralClearingRate,InvestorGroupType_1,InvestorGroupRate_1,FilingType,HftTransactionNumber,HftBuySellMarketValue,UnencumberedCash,CommitmentMethodRate,GrossMethodRate,UnsecuredBorrowingAmount,SecuredBorrowingPrimeBrokerageAmount,SecuredBorrowingReverseRepoAmount,SecuredBorrowingOtherAmount,AnnualInvestmentReturnRate
FAEC,AnnexIV,Entity,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,AMND,,,,,,,,,,
FAEC,Management,Entity,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,INIT,,,,,,,,,,
MFI,Management,Portfolio,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,NET_CS01,,234891,23849,3424234,,,,,,Ebbe,VAR,,,,,,,,,,Monte Carlo Simulation,VENT_CAPL,True,24,,GRTH_CAPL,False,76,,9991,25,0,0,25,25,25,0,,,,,,,,0,5,0,5,20,70,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,SEC_CSH_CSH,100,90,,,,1A,,,,,,,,,,,,AMND,1234,300000,23427866,2.4,10.99,,,,,NA

📘
The top header row contains headers defining the structure of the data. Subsequent data rows contain values for a specific portfolio/entity. The second row in this example illustrates how users sets the filing type to AMND for the FAEC entity using the AnnexIV aggregation.

Uploading and Downloading Additional Fund Data

File Structure

Example File

📘The top header row contains headers defining the structure of the data. Subsequent data rows contain values for a specific portfolio/entity. The second row in this example illustrates how users sets the filing type to AMND for the FAEC entity using the AnnexIV aggregation.

📘
The top header row contains headers defining the structure of the data. Subsequent data rows contain values for a specific portfolio/entity. The second row in this example illustrates how users sets the filing type to AMND for the FAEC entity using the AnnexIV aggregation.