To add a new price series go to Price Data and then to the Price Series tab.

There are a 4 type of price series that can be setup in the system. The price series type are Dated, Forward, Posting and Spot. Dated price series type are specifically for Dated Brent. Posting price series type are used for price series which typically publishes one price quote per month. For example : DAS OSP or Basrah OSP, etc.

Setting up Spot Price Series

Setting up Forward Price Series

Setting up Posting Price Series

Setting up Futures Price Series

Setting up Spot Price Series

To add a Spot Price Series, in Price Series view:

1. Click on to create a new line.
2. In Price Series, enter the name of the spot price series. The name needs to be unique for each price series in the system.
3. In Short Name, enter the short name of the spot price series. This short name can be used for selection or for reporting purposes.
4. In Source, select the source of the spot price series. This information is for reference only.

*New Source can be added from Price Data -> Sources.*

5. In Source Reference Id, enter a source reference id associated with this spot price series. This is typically the Platts id for prices provided by Platts.
6. In Price Commodity, select the price commodity for the spot price series. Price commodity is additional grouping or information used to identify the price series.

*New Price Commodity can be added from Price Data -> Price Commodities.*

7. In Market, select the Market for the spot price series. Market is additional grouping or information used to identify the price series.

*New Market can be added from Price Data -> Markets.*

8. In Price Ccy, select the currecny associated with the spot price series. This indicate the default currency for this price series.
9. In Price Unit, select the units associated with the spot price series. This indicate the default unit for this price series. If contract price series unit is different from this unit, Coversion will be used when during valuation process.
10. In Price Series Type, select Spot for spot price series.
11. In Price Frequency, select the frequency of the spot price series. Typically frequency is day for Oil related commodites and week is for coal.
12. In Calendar, select the calendar associated with this spot price series. The system will use this calendar to determine the holiday associated with this price series.

*Calendar setup can be found in Reference Data -> Calendar*

13. In Exposure Period Frequency, select the frequency of the exposure period. The Exposure Frequency determines the Exposure Period on Valuation Item (and therefore all the Exposure views). It needs to be set to generate Exposure. Typically, it is set to "Month".
14. In Exposure Period Frequency Multiplier, enter the multiplier for the exposure period. The Exposure Multiplier determines the number of Exposure Period on Valuation Item (and therefore all the Exposure views). It needs to be set to generate Exposure. Typically, it is set 1.

*If there is a need to change the Exposure Period Frequency and multiplier other than Month and 1, please contact CoreTRM Support.*

15. In Data Provider, select the data provider for the spot price series. Data provider is additional grouping or information used to identify the price series.

*New Data Provider can be added from Price Data -> Data Providers.*

16. In Data Provider Id, enter applicable data provider id for the spot price series. This id is typically used for automatic price import.
17. In Active?, tick the box to set the price series active.
18. Click to confirm creation.
19. To edit price series details after creation, Click to edit.

To add a Spot Price Series, in Price Type view:

1. Click on to create a new line.
2. In Price Series Price Type name, enter the name of the spot price series. The name can be the same as the price series name in price series view. This is the name that appear in most of the view in the system.
3. In Price Type, select the applicable price type. The list of price type are High, Low, Close, MTM, Posting, Settle ,Open Interest and Volume. The price type is used for informational purpose only. For Spot prices, Close can be used.
4. In Source Price Type Id, enter the applicable source price type id. This field can be leave blank.
5. In Data Provider Id, enter applicable data provider id for the spot price series. This id is typically used for automatic price import.
6. In Price Series Price Type Num, this field will be populated with a unique id for this price series price type.
7. Click to confirm creation.
8. To edit price series details after creation, Click to edit.

To add/assigned a forward curve for the spot price series, in Forward Curve view:

*Before a forward curve can be assigned to a spot price series, a Forward Curve is required to be setup. You can setup a new Forward Curve in Price Data -> Forward Curves*

1. Click on to create a new line.
2. In Forward Curve, select the applicable forward curve for this price series.

*New Forward Curve can be setup in Price Data -> Forward Curve.*

3. In Commodity Group, select the applicable commodity group for this forward curve. Spot price series' Forward curve normally doesnt required a commodity group.
4. In Price Rule, select price rule if applicable. Roll one day early is used for Ice Brent Futures.
5. Click to confirm creation.
6. To edit price series details after creation, Click to edit.

Setting up Forward Price Series

To add a Forward Price Series, in Price Series view:

1. Click on to create a new line.
2. In Price Series, enter the name of the forward price series. The name needs to be unique for each price series in the system.
3. In Short Name, enter the short name of the forward price series. This short name can be used for selection or for reporting purposes.
4. In Source, select the source of the forward price series. This information is for reference only.

*New Source can be added from Price Data -> Sources.*

5. In Source Reference Id, enter a source reference id associated with this forward price series. This is typically the Platts id for prices provided by Platts.
6. In Price Commodity, select the price commodity for the forward price series. Price commodity is additional grouping or information used to identify the price series.

*New Price Commodity can be added from Price Data -> Price Commodities.*

7. In Market, select the Market for the forward price series. Market is additional grouping or information used to identify the price series.

*New Market can be added from Price Data -> Markets.*

8. In Price Ccy, select the currecny associated with the forward price series. This indicate the default currency for this price series.
9. In Price Unit, select the units associated with the forward price series. This indicate the default unit for this price series. If contract price series unit is different from this unit, Coversion will be used when during valuation process.
10. In Price Series Type, select Forward for forward price series.
11. In Price Frequency, select the frequency of the forward price series.
12. In Calendar, select the calendar associated with this forward price series. The system will use this calendar to determine the holiday associated with this price series. Typically it is the same calendar as its related price series.

*Calendar setup can be found in Reference Data -> Calendar*

13. In Exposure Period Frequency, select the frequency of the exposure period. The Exposure Frequency determines the Exposure Period on Valuation Item (and therefore all the Exposure views). It needs to be set to generate Exposure. Typically, it is set to "Month".
14. In Exposure Period Frequency Multiplier, enter the multiplier for the exposure period. The Exposure Multiplier determines the number of Exposure Period on Valuation Item (and therefore all the Exposure views). It needs to be set to generate Exposure. Typically, it is set 1.

*If there is a need to change the Exposure Period Frequency and multiplier other than Month and 1, please contact CoreTRM Support.*

15. In Data Provider, select the data provider for the forward price series. Data provider is additional grouping or information used to identify the price series.

*New Data Provider can be added from Price Data -> Data Providers.*

16. In Data Provider Id, enter applicable data provider id for the forward price series. This id is typically used for automatic price import.
17. In Active?, tick the box to set the price series active.
18. Click to confirm creation.
19. To edit price series details after creation, Click to edit.

To add a Forward Price Series, in Price Type view:

1. Click on to create a new line.
2. In Price Series Price Type name, enter the name of the forward price series. The name can be the same as the price series name in price series view. This is the name that appear in most of the view in the system.
3. In Price Type, select the applicable price type. The list of price type are High, Low, Close, MTM, Posting, Settle, Open Interest and Volume. The price type is used for informational purpose only. For Forward prices, MTM can be used.
4. In Source Price Type Id, enter the applicable source price type id. This field can be leave blank.
5. In Data Provider Id, enter applicable data provider id for the forward price series. This id is typically used for automatic price import.
6. In Price Series Price Type Num, this field will be populated with a unique id for this price series price type.
7. Click to confirm creation.
8. To edit price series details after creation, Click to edit.

To add a Forward Price Series, in Forward period view:

1. Click on to create a new line.
2. In Period Name, the period for which this foward price series will cover. Typically, it should cover next 2 years of Forward Period.

*New Forward Period can be setup in Price Data -> Period.*

3. In Period End Date Time, select the end date time of the period. Typically this will be the last day of the month.
4. In Source Reference Id, enter applicable source reference Id for this period. Typically, this is a reference use for automatic price import.
5. In Data Provider Id, enter applicable data provider Id for this period. Typically, this is a reference use for automatic price import .
6. Click to confirm creation.
7. To edit Forward Period details after creation, Click to edit.

*For Forward Price Series, Forward Curves is not required.*

Setting up Posting Price Series

To add a Posting Price Series, in Price Series view:

1. Click on to create a new line.
2. In Price Series, enter the name of the posting price series. The name needs to be unique for each price series in the system.
3. In Short Name, enter the short name of the posting price series. This short name can be used for selection or for reporting purposes.
4. In Source, select the source of the posting price series. This information is for reference only.

*New Source can be added from Price Data -> Sources.*

5. In Source Reference Id, enter a source reference id associated with this posting price series. This is typically the Platts id for prices provided by Platts.
6. In Price Commodity, select the price commodity for the posting price series. Price commodity is additional grouping or information used to identify the price series.

*New Price Commodity can be added from Price Data -> Price Commodities.*

7. In Market, select the Market for the posting price series. Market is additional grouping or information used to identify the price series.

*New Market can be added from Price Data -> Markets.*

8. In Price Ccy, select the currecny associated with the posting price series. This indicate the default currency for this price series.
9. In Price Unit, select the units associated with the posting price series. This indicate the default unit for this price series. If contract price series unit is different from this unit, Coversion will be used when during valuation process.
10. In Price Series Type, select Posting for posting price series.
11. In Price Frequency, select the frequency of the posting price series. Typically frequency is day for Oil related commodites and week is for coal.
12. In Calendar, select the calendar associated with this posting price series. The system will use this calendar to determine the holiday associated with this price series.

*Calendar setup can be found in Reference Data -> Calendar*

13. In Exposure Period Frequency, select the frequency of the exposure period. The Exposure Frequency determines the Exposure Period on Valuation Item (and therefore all the Exposure views). It needs to be set to generate Exposure. Typically, it is set to "Month".
14. In Exposure Period Frequency Multiplier, enter the multiplier for the exposure period. The Exposure Multiplier determines the number of Exposure Period on Valuation Item (and therefore all the Exposure views). It needs to be set to generate Exposure. Typically, it is set 1.

*If there is a need to change the Exposure Period Frequency and multiplier other than Month and 1, please contact CoreTRM Support.*

15. In Data Provider, select the data provider for the posting price series. Data provider is additional grouping or information used to identify the price series.

*New Data Provider can be added from Price Data -> Data Providers.*

16. In Data Provider Id, enter applicable data provider id for the posting price series. This id is typically used for automatic price import.
17. In Active?, tick the box to set the price series active.
18. Click to confirm creation.
19. To edit price series details after creation, Click to edit.

To add a Posting Price Series, in Price Type view:

1. Click on to create a new line.
2. In Price Series Price Type name, enter the name of the posting price series. The name can be the same as the price series name in price series view. This is the name that appear in most of the view in the system.
3. In Price Type, select the applicable price type. The list of price type are High, Low, Close, MTM, Posting, Settle, Open Interest and Volume. The price type is used for informational purpose only. For posting prices, Close can be used.
4. In Source Price Type Id, enter the applicable source price type id. This field can be leave blank.
5. In Data Provider Id, enter applicable data provider id for the spot price series. This id is typically used for automatic price import.
6. In Price Series Price Type Num, this field will be populated with a unique id for this price series price type.
7. Click to confirm creation.
8. To edit price series details after creation, Click to edit.

*For Posting Price Series, Forward Curves is not required.*

Setting up Futures Price Series

To add a Futures Price Series, in Price Series view:

1. Click on to create a new line.
2. In Price Series, enter the name of the Futures price series. The name needs to be unique for each price series in the system.
3. In Short Name, enter the short name of the Futures price series. This short name can be used for selection or for reporting purposes.
4. In Source, select the source of the Futures price series. This information is for reference only.

*New Source can be added from Price Data -> Sources.*

5. In Source Reference Id, enter a source reference id associated with this Futures price series. This is typically the exchange id for prices provided by exchange.
6. In Price Commodity, select the price commodity for the Futures price series. Price commodity is additional grouping or information used to identify the price series.

*New Price Commodity can be added from Price Data -> Price Commodities.*

7. In Market, select the Market for the Futures price series. Market is additional grouping or information used to identify the price series.

*New Market can be added from Price Data -> Markets.*

8. In Price Ccy, select the currecny associated with the Futures price series. This indicate the default currency for this price series.
9. In Price Unit, select the units associated with the Futures price series. This indicate the default unit for this price series. If contract price series unit is different from this unit, Coversion will be used when during valuation process.
10. In Price Series Type, select Forward for Futures price series.
11. In Price Frequency, select the frequency of the Futures price series.
12. In Calendar, select the calendar associated with this Futures price series. The system will use this calendar to determine the holiday associated with this price series.

*Calendar setup can be found in Reference Data -> Calendar*

13. In Exposure Period Frequency, this is not required for Futures price series.
14. In Exposure Period Frequency Multiplier, this is not required for Futures price series.
15. In Data Provider, select the data provider for the Futures price series. Data provider is additional grouping or information used to identify the price series.

*New Data Provider can be added from Price Data -> Data Providers.*

16. In Data Provider Id, enter applicable data provider id for the Futures price series. This id is typically used for automatic price import.
17. In Active?, tick the box to set the price series active.
18. Click to confirm creation.
19. To edit price series details after creation, Click to edit.

To add a Futures Price Series, in Price Type view:

1. Click on to create a new line.
2. In Price Series Price Type name, enter the name of the Futures price series. The name can be the same as the price series name in price series view. This is the name that appear in most of the view in the system.
3. In Price Type, select the applicable price type. The list of price type are High, Low, Close, MTM, Posting, Settle, Open Interest and Volume. The price type is used for informational purpose only. For Futures prices, Close can be used.
4. In Source Price Type Id, enter the applicable source price type id. This field can be leave blank.
5. In Data Provider Id, enter applicable data provider id for the futures price series. This id is typically used for automatic price import.
6. In Price Series Price Type Num, this field will be populated with a unique id for this price series price type.
7. Click to confirm creation.
8. To edit price series details after creation, Click to edit.

To add a Futures Price Series, in Forward period view:

1. Click on to create a new line.
2. In Period Name, the period for which this foward price series will cover. Typically, it should cover next 2 years of Forward Period.

*New Forward Period can be setup in Price Data -> Period.*

3. In Period End Date Time, select the end date time of the period. Typically this will be the expiry day of the futures.
4. In Source Reference Id, enter applicable source reference Id for this period. Typically, this is a reference use for automatic price import.
5. In Data Provider Id, enter applicable data provider Id for this period. Typically, this is a reference use for automatic price import .
6. Click to confirm creation.
7. To edit Forward Period details after creation, Click to edit.

To add/assigned a forward curve for the Futures price series, in Forward Curve view:

*Before a forward curve can be assigned to a Futures price series, a Forward Curves is required to be setup. You can setup a new Forward Curve in Price Data -> Forward Curves*

1. Click on to create a new line.
2. In Forward Curve, select the applicable forward curve for this price series.

*New Forward Curve can be setup in Price Data -> Forward Curve.*

3. In Commodity Group, select the applicable commodity group for this forward curve. For Futures price series, each Commodity group requires a line, so that Price Rule can be assgined to it.
4. In Price Rule, select price rule if applicable. Typically, for Swaps, Diffs and Phsyicals, Roll one day early is used is used.
5. Click to confirm creation.
6. To edit Forward Curve details after creation, Click to edit.