Positions Table
Positions Table
Each row of the valuation position table describes a position captured at a particular time for a valuation snapshot. It can represent multiple holdings of an account for an asset class.
Schema
This table can be populated from the openalloc/valuation/position schema.
The attributes for position can be modified manually in the UI.
Typically position rows are generated indirectly through import of holdings. However, a comma- or tab-delimited file adhering to the following schema can also be imported through drag and drop or the Import menu:
Name | Type | IsRequired | IsKey | Descript |
---|---|---|---|---|
valuationPositionSnapshotID | string | true | true | The valuation snapshot ID for the position. |
valuationPositionAccountID | string | true | true | The account hosting the position. |
valuationPositionAssetID | string | true | true | The asset class of the position. |
totalBasis | double | true | false | The price paid to establish position. |
marketValue | double | true | false | The market value of the position. |