Table: TRADINGPRICE

TRADINGPRICE

Name

TRADINGPRICE

Comment

TRADINGPRICE sets out half-hourly spot market price, including fields to handle the Ancillary Services functionality. If prices are adjusted, the final price is recorded in the regional reference price (RRP) field with price before adjustment recorded in the regional original price (ROP) field.


Description

TRADINGPRICE data is public, so is available to all participants.

Source

TRADINGPRICE updates every 30 minutes.

Notes

INVALIDFLAG

The INVALIDFLAG field is used to indicate whether the Trading interval price has been adjusted after the trading interval was completed. On a very restricted set of events, the market rules allow a dispatch price (5 min) to be adjusted on the next business day, and, when this occurs, the corresponding trading interval price for that region is also adjusted and marked as adjusted with INVALIDFLAG of 'A'.

The INVALIDFLAG = 'Y' only applies to historical periods when not all six of the 5-minute dispatch intervals were run in the trading interval. System changes implemented on 30 September 2001 mean this situation no longer occurs since missing dispatch intervals are automatically populated from a previous interval.

If the INVALIDFLAG field = '0', the price was not adjusted and all six dispatch intervals are present.

Prices

There is no field in the TRADINGPRICE table (or the MMS data model anywhere) telling you that the price is provisional or final. The only reliable method is to ensure that the trading date is at least 2 business days old.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

PERIODID

REGIONID

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Date that this data applies to

RUNNO

NUMBER(3,0)

X

Run No

REGIONID

VARCHAR2(10)

X

Region Identifier

PERIODID

NUMBER(3,0)

X

Trading Interval Period

RRP

NUMBER(15,5)

 

Regional reference price for this dispatch period

EEP

NUMBER(15,5)

 

Excess energy price where negative average

INVALIDFLAG

VARCHAR2(1)

 

Indicates when the Trading interval price has been adjusted after the trading interval was completed

LASTCHANGED

DATE

 

Last date and time record changed

ROP

NUMBER(15,5)

 

Regional Original Price. The price before any adjustments were made

RAISE6SECRRP

NUMBER(15,5)

 

Regional reference price for this dispatch period

RAISE6SECROP

NUMBER(15,5)

 

Original regional price - prior to APC or VoLL overrides applied

RAISE60SECRRP

NUMBER(15,5)

 

Regional reference price for this dispatch period

RAISE60SECROP

NUMBER(15,5)

 

Original regional price - prior to APC or VoLL overrides applied

RAISE5MINRRP

NUMBER(15,5)

 

Regional reference price for this dispatch period

RAISE5MINROP

NUMBER(15,5)

 

Original regional price - prior to APC or VoLL overrides applied

RAISEREGRRP

NUMBER(15,5)

 

Regional reference price for this dispatch period

RAISEREGROP

NUMBER(15,5)

 

Original regional price - prior to APC or VoLL overrides applied

LOWER6SECRRP

NUMBER(15,5)

 

Regional reference price for this dispatch period

LOWER6SECROP

NUMBER(15,5)

 

Original regional price - prior to APC or VoLL overrides applied

LOWER60SECRRP

NUMBER(15,5)

 

Regional reference price for this dispatch period

LOWER60SECROP

NUMBER(15,5)

 

Original regional price - prior to APC or VoLL overrides applied

LOWER5MINRRP

NUMBER(15,5)

 

Regional reference price for this dispatch period

LOWER5MINROP

NUMBER(15,5)

 

Original regional price - prior to APC or VoLL overrides applied

LOWERREGRRP

NUMBER(15,5)

 

Regional reference price for this dispatch period

LOWERREGROP

NUMBER(15,5)

 

Original regional price - prior to APC or VoLL overrides applied

PRICE_STATUS

VARCHAR2(20)

 

Status of regional prices for this dispatch interval "NOT FIRM" or "FIRM"