How do I create a valuation point?

Prev Next

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 the effectiveAt, 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.