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:

1. 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.

2. Download the template. Hit Actions, then Asset Valuations Template

3. Fill in the template, then upload.

4. 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.	2023-12-01	Y
ASSET ID	The asset ID you're uploading data to. Note that data for multiple asset IDs can be uploaded at once.	667	Y
PRODUCT	The ticker for the Product you're using to express this shape	M.BHMX(for an hourly forecast load)	Y
CONTRACT	Tenor this row represents	2024-06-01	Y
VALUE	A position value, despite the name	100.04	Y
VALUATION	A P&L value	53.02	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.

• VALUATION RESULTS - A way to store other data in an Asset Valuation row, in JSON format. For example:

[{"TDSP": "5.00"}, {"CONGESTION": "3.25"}]

---

---