You can use the Lusid.* providers supplied by FINBOURNE to interact with investment data stored in LUSID itself.
Providing you have suitable access control permissions, you can:
Retrieve entities such as portfolios, instruments and transactions from LUSID—and optionally also properties decorated onto those entities—for analysis.
Calculate holdings, valuations and performance returns on demand. You can also access system information such as logs, scopes and property types.
Write certain types of investment data back into LUSID. You must construct a valid table of data in your Luminesce query and use a special
toWriteparameter on the provider to actually write data to LUSID. The query returns a table indicating whether each record has been successfully upserted or not.
Instruments
See a list of all the supported instrument types. Not all have read/write providers yet.
To interact with... | Read using the ... provider | Write using the ... provider |
Instruments of any type (basic definition, not full economic) | ||
Bonds | ||
Complex bonds | ||
Inflation-linked bonds | ||
Amortising loans | ||
CapFloors | ||
CFDs | ||
CDSs | ||
Equities | ||
Equity options | ||
Equity swaps | ||
Exchange-traded options | ||
Forward rate agreements | ||
Funding legs | ||
Fund share classes | ||
Futures | ||
FX forwards | ||
FX options | ||
FX swaps | ||
Interest rate swaps | ||
Interest rate swaptions | ||
Repos | ||
Term deposits | ||
Simple instruments (no full economic definition) |
Portfolios
To interact with... | Read using the ... provider | Write using the ... provider |
Portfolios of any kind | ||
Input transactions added to a transaction portfolio | ||
Instrument resolution for transactions and holdings |
| |
| ||
Constituents in a reference portfolio | ||
Holdings in a transaction portfolio | ||
All the portfolios in a portfolio group | ||
Performance returns for portfolios | ||
Aggregated performance returns |
| |
Change history |
|
|
Custodian accounts |
Corporate actions
To interact with... | Read using the ... provider | Write using the ... provider |
|
| |
Corporate action sources |
Market data
To interact with... | Read using the ... provider | Write using the ... provider |
Prices and spot rates in the LUSID Quote Store |
Valuation and reconciliation
To interact with... | Read using the ... provider | Write using the ... provider |
| ||
A2B reports (PnL) |
| |
Bucketed cash flows |
|
|
Cash ladders |
|
|
| ||
Metrics/queryable keys |
| |
Manifests |
| |
Holding or valuation reconciliations |
|
Financial reports/fund accounting/ABOR
To interact with... | Read using the ... provider | Write using the ... provider |
Funds | ||
Fund configuration modules | ||
Fund valuation points | ||
Fee types | ||
Fees for funds | ||
ABORs (Accounting book of records) | ||
Accounting diaries in ABORs | ||
ABOR configuration modules | ||
Charts of accounts (CoAs) | ||
General ledger accounts in CoAs | ||
Posting modules in CoAs | ||
Posting rules in posting modules | ||
Cleardown modules in CoAs | ||
Cleardown rules in cleardown modules | ||
General ledger profiles in CoAs | ||
Mappings in general ledger profiles | ||
Journal entry lines |
| |
Trial balances |
| |
Fund-level valuation summary (GAV and NAV) |
| |
Fund-level fee accruals (to calculate NAV from GAV) |
| |
Fund-level valuation breakdown | ||
Share class-level valuation summary | ||
Share class-level valuation breakdown | ||
Share class-level fee accruals |
|
Properties
You can either use the dedicated property providers below, or alternatively configure the entity providers in the tables above to first 'inline' properties and/or identifiers so you can then interact with them in the same way as entity data fields. Tips for using Luminesce to write properties.
To interact with... | Read using the ... provider | Write using the ... provider |
Properties on instruments, portfolios, portfolio groups, legal entities and person entities | ||
Instrument properties (and market identifiers) | Not currently available. Use Lusid.Property.Writer instead. | |
Holding properties | Not available. Use Lusid.Portfolio.Holding.Writer instead, having inlined properties first. | |
Transaction properties | ||
Scopes, transaction types, cut labels and calendars
To interact with... | Read using the ... provider | Write using the ... provider |
| ||
| ||
| ||
Dates in calendars |
Order management system (OMS)
To interact with... | Read using the ... provider | Write using the ... provider |
People, legal entities and relationships
To interact with... | Read using the ... provider | Write using the ... provider |
Relationship types |
Custom entities
By default, Luminesce knows nothing about your custom entities, so providers for them do not exist out-of-the-box. You must create a read/write provider pair for each type of custom entity you wish to interact with. Find out more about this.
To interact with... | Read using the ... provider | Write using the ... provider |
Custom entity types | ||
Access metadata for custom entities |
|
|
Structured Result Store data
To interact with... | Read using the ... provider | Write using the ... provider |
| ||
Atomised results (virtual documents) |
|
|
Logs
To interact with... | Read using the ... provider | Write using the ... provider |
HTTP 5xx server error responses |
| |
HTTP 4xx client error responses |
| |
Requests to any application in the FINBOURNE platform |
| |
Successful requests to LUSID only |
| |
Request and response contents |
|
|
Access requests (policy and license-related failures) |
|