Lusid.Fund.ValuationPointData.Fee

Providing you have sufficient access control permissions, the Lusid.Fund.ValuationPointData.Fee provider enables you to write a Luminesce SQL query that retrieves fee accruals applied to a fund at a point in time.

Note: To retrieve definitions for fees added to a fund, use the Lusid.Fund.Fee provider.

This provider retrieves a fund-level summary of fee accruals only. You can join this provider to others to retrieve more information:

• Join to Lusid.Fund.ValuationPointData to retrieve a fund-level summary of GAV and NAV (which is GAV minus fee accruals). See an example.

• Join to Lusid.Fund.ValuationPointData.ShareClass.Fee (coming soon) to retrieve share class-level fee accruals.

Basic usage

You must specify an end date that is either:

• An arbitrary datetime using the EndDate parameter.

• A pre-defined valuation point using the DiaryEntryCode parameter.

select * from Lusid.Fund.ValuationPointData.Fee
where FundScope = <scope> 
and FundCode = <code>
and <date-or-diary-entry>
;

Query parameters

Lusid.Fund.ValuationPointData.Fee has parameters that enable you to filter or refine a query.

To list available parameters, their data types, default values, and an explanation for each, run the following query using a suitable tool:

select FieldName, DataType, ParamDefaultValue, Description from Sys.Field where TableName = 'Lusid.Fund.ValuationPointData.Fee' and FieldType = 'Parameter';

Data fields

By default, Lusid.Fund.ValuationPointData.Fee returns a table of data populated with particular fields (columns). You can return a subset of these fields.

To list fields available to return, their data types, whether fields are considered 'main', and an explanation for each, run the following query using a suitable tool:

select FieldName, DataType, IsMain, IsPrimaryKey, SampleValues, Description from Sys.Field where TableName = 'Lusid.Fund.ValuationPointData.Fee' and FieldType = 'Column';

Note: Fields marked 'main' are returned by queries that select a ^ character, for example select ^ from Lusid.Fund.ValuationPointData.Fee.

Examples

Note: For more example Luminesce SQL queries, visit our Github repo.

Example 1: Retrieve fee accruals at an arbitrary point in time

You can use the EndDate parameter to retrieve fee accruals at an arbitrary point in time.

select * from Lusid.Fund.ValuationPointData.Fee
where FundScope = 'Growth'
and FundCode = 'Equities'
and EndDate = #2024-06-13 17:00:00#
;

Example 2: Retrieve fee accruals at an official valuation point

Publishing an official fund valuation is a workflow with checks and balances, not all of which is possible using Luminesce.

Assuming an accounting diary entry of type ValuationPoint exists, you can use the DiaryEntryCode parameter to retrieve fee accruals at an official valuation point. 

select * from Lusid.Fund.ValuationPointData.Fee
where FundScope = 'Growth'
and FundCode = 'Equities'
and DiaryEntryCode = '13June2024-5pm-asAt7pm'
;

Example 3: Retrieve GAV and NAV as well as fee accruals

You can join this provider to Lusid.Fund.ValuationPointData in order to also retrieve a fund-level summary. Note you must specify the same EndDate or DiaryEntryCode for both providers.

select
    d.GAV, d.NAV,
    f.*
from
    Lusid.Fund.ValuationPointData d
    inner join Lusid.Fund.ValuationPointData.Fee f
        on d.FundScope = f.FundScope
        and d.FundCode = f.FundCode
where
    d.FundScope = 'Growth'
    and d.FundCode = 'Equities' 
    and d.DiaryEntryCode = '13June2024-5pm-asAt7pm'
    and f.DiaryEntryCode = '13June2024-5pm-asAt7pm'
;