You can create a valuation point for a fund NAV type that specifies both:
An
effectiveAt
date and time determining the end of the current accounting period and simultaneously the start of the next period.A
queryAsAt
date and time determining a cut-off point for data to be incorporated in the current accounting period. This can be the same as theeffectiveAt
, or later. A later date enables you to incorporate relevant data loaded into LUSID late.
You can use a valuation point when you strike a NAV or generate any other financial report.
Note that a valuation point has an initial status of Estimate
, and that striking a NAV is part of a workflow with checks and balances. Only when the status is set to Final
does LUSID persist all the data associated with the valuation point so reports are always reproducible.
Methods
Call the UpsertDiaryEntryTypeValuationPoint API, for example:
curl -X POST 'https://<your-domain>.lusid.com/api/api/funds/MyFunds/Growth/valuationpoints?navTypeCode=OFFICIAL'
-H 'Content-Type: application/json-patch+json'
-H 'Authorization: Bearer <your-API-access-token>'
-d '{
"diaryEntryCode": "31Jan2025",
"name": "End January 2025",
"effectiveAt": "2025-01-31T17:00:00.0000000+00:00",
"queryAsAt": "2025-01-31T19:59:59.0000000+00:00"
}'
Navigate to Fund Accounting > Calendar Management, select a fund and click Create valuation point:
Write a Luminesce SQL query using the Lusid.Fund.ValuationPoint.Writer provider and execute it using a tool such as the LUSID web app, for example:
Data fields and properties
This section supplements the API documentation and on-screen help text in the LUSID web app.
Fields
A valuation point is identified by a diaryEntryCode
that must be unique within the parent NAV type.
A valuation point must have an effectiveAt
. You can specify a queryAsAt
, which must be the same or later. In most circumstances, we recommend omitting this field to use the system datetime of the request (‘now’).
Properties
You can optionally extend the data model of a valuation point by adding custom properties from the DiaryEntry
domain.
Subsequent updates
You cannot currently update a valuation point. To change it, call the DeleteValuationPoint API and recreate it.