Importing Asset Data
Assets, as described in Assets Stack, are items that can hold arbitrary shape. Often, this feature is used for modeling forecasts for i.e., generation (one per generation asset) or load (one per load zone).
Usage
The easiest way to start using Assets is to upload Asset Valuation data via spreadsheet. To do so:
- Go to the Assets screen. Make sure you have an asset set up, and make sure the products you intend to use to express your position are listed in the Asset's Products field.
- Download the template. Hit Actions, then Asset Valuations Template
- Fill in the template, then upload.
- You should see a notification on the right-hand notifications panel that the upload was complete. You can now click the clock to the right of your asset, and see your uploaded data. Note that the As-of date on the top right of the screen must match what you uploaded.
Fields
Required Fields
These fields are included in the template by default.
Name | Description | Format (Example) | Required? |
AS OF | The valuation date (As-Of Date) for the uploaded data. |
| Y |
ASSET ID | The asset ID you're uploading data to. Note that data for multiple asset IDs can be uploaded at once. |
| Y |
PRODUCT | The ticker for the Product you're using to express this shape |
| Y |
CONTRACT | Tenor this row represents |
| Y |
VALUE | A position value, despite the name |
| Y |
VALUATION | A P&L value |
| N |
Optional Fields
INTERVAL ENDING- for hourly/sub-hourly Products, the interval this row represents.- Use the "interval ending" format
hhmm+, where the + represents the repeated hour related to DST/Summer Time changeover. - Note that because Excel trims leading zeroes, it's best to format this column as Text if using Excel.
- Use the "interval ending" format
VALUATION RESULTS- A way to store other data in an Asset Valuation row, in JSON format. For example:
[{"TDSP": "5.00"}, {"CONGESTION": "3.25"}]
