Name |
|
Comment |
TRADINGPRICE sets out 5 minutes 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. |
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. |
Name |
PERIODID |
REGIONID |
RUNNO |
SETTLEMENTDATE |
Name |
LASTCHANGED |
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 |
Period number where 1 represents the trading interval ending at 00:05 AEST |
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" |
RAISE1SECRRP |
NUMBER(15,5) |
|
Regional Raise 1Sec Price - R1Price attribute after capping/flooring |
RAISE1SECROP |
NUMBER(15,5) |
|
Raise1Sec Regional Original Price - uncapped/unfloored and unscaled |
LOWER1SECRRP |
NUMBER(15,5) |
|
Regional Lower 1Sec Price - RegionSolution element L1Price attribute |
LOWER1SECROP |
NUMBER(15,5) |
|
Lower1Sec Regional Original Price - uncapped/unfloored and unscaled |
|
|
|