Skip to content

NEM Schema

MNSP_DAYOFFER

MNSP_DAYOFFER

MNSP_DAYOFFER updates as bids are processed. All bids are available as part of next day market data. MNSP_DAYOFFER is the parent table to MNSP_BIDOFFERPERIOD, and joins to BIDOFFERFILETRK for 5MS Bids.

MNSP_DAYOFFER shows own (confidential) data updates as bids are processed. All bids are available as part of next day market data.

Volume

4, 000 per year

Column Schema

LINKID

Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to.

SQL Type: VARCHAR2(10) Polars Type: str

This column is mandatory, and a primary key.

Examples:

BLNKTAS
BLNKVIC

OFFERDATE

Time this bid was processed and loaded

SQL Type: TIMESTAMP(3) Polars Type: pl.Datetime()

This column is mandatory, and a primary key.

Example: 2026/05/05 15:16:58.000

Unlike most datetime columns, this one includes a millisecond component. e.g. 2029/03/15 00:00:00.123.

PARTICIPANTID

Participant Identifier

For more information, see the dedicated documentation page.

SQL Type: VARCHAR2(10) Polars Type: pl.Categorical

This column is mandatory, and a primary key.

Example: BASSLINK

SETTLEMENTDATE

Market Date from which bid is active

SQL Type: DATE Polars Type: pl.Date()

This column is mandatory, and a primary key.

Example: 2026/07/01 00:00:00

Note that AEMO represents dates as datetimes with a midnight time component.

VERSIONNO

Version of data for other key data - a higher version for same key data will take precedence

SQL Type: NUMBER(3,0) Polars Type: pl.UInt16

This column is mandatory, and a primary key.

Example: 1

ENTRYTYPE

Bid type. Either Rebid or Daily

SQL Type: VARCHAR2(20) Polars Type: pl.Categorical

This column is not mandatory.

Example: DAILY

LASTCHANGED

Last date and time record changed

For more information, see the dedicated documentation page.

SQL Type: DATE Polars Type: pl.Datetime()

This column is not mandatory.

Example: 2026/05/05 15:16:58

MR_FACTOR

Mandatory Restriction Offer Factor

SQL Type: NUMBER(16,6) Polars Type: pl.Float64

This column is not mandatory.

PRICEBAND1

Price for Availability Band 1

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 0.01, 0

PRICEBAND2

Price for Availability Band 2

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 25, 40

PRICEBAND3

Price for Availability Band 3

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 55, 61

PRICEBAND4

Price for Availability Band 4

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Example: 75

PRICEBAND5

Price for Availability Band 5

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 89, 95

PRICEBAND6

Price for Availability Band 6

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 104, 135

PRICEBAND7

Price for Availability Band 7

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 114, 200

PRICEBAND8

Price for Availability Band 8

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 200, 1000

PRICEBAND9

Price for Availability Band 9

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 450, 5000

PRICEBAND10

Price for Availability Band 10

SQL Type: NUMBER(9,2) Polars Type: pl.Float64

This column is not mandatory.

Examples: 20299, 20300

REBID_AWARE_TIME

Intended to support the Rebidding and Technical Parameters Guideline. The time at which the participant became aware of the event(s) / occurrence(s) that prompted the rebid. Not validated by AEMO

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

REBID_CATEGORY

Intended to support the Rebidding and Technical Parameters Guideline. A provided rebid category. Not validated by AEMO

Warning

AEMO does not enforce compliance with the bidding rules. One in every few million rows has a lowercase value here. You should coerce to uppercast before casting to enum or querying.

The SQL type is VARCHAR2(1). This is actually a factor/enum, with values:

A
P
F
E
Z
I

This column is not mandatory.

REBID_DECISION_TIME

Intended to support the Rebidding and Technical Parameters Guideline. The time at which the participant made the decision to rebid. Not validated by AEMO

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

REBID_EVENT_TIME

The time of the event(s) or other occurrence(s) cited/adduced as the reason for the rebid. Required for rebids, not required for fixed load or low ramp rates. Expected in the format: HH:MM:SS e.g. 20:11:00

SQL Type: VARCHAR2(20) Polars Type: str

This column is not mandatory.

Example: 15:15:00

REBIDEXPLANATION

Explanation for all rebids and inflexibilities

SQL Type: VARCHAR2(500) Polars Type: str

This column is not mandatory.

Example: INITIAL OFFER

REFERENCE_ID

A participants unique Reference Id

SQL Type: VARCHAR2(100) Polars Type: str

This column is not mandatory.

Examples:

BASSLINK_EO_20260701_20260505151658284
BASSLINK_EO_20260702_20260505151658365
BASSLINK_EO_20260703_20260505151658345
BASSLINK_EO_20260704_20260505151658332
BASSLINK_EO_20260705_20260505151658322
BASSLINK_EO_20260706_20260505151658306
BASSLINK_EO_20260707_20260505151658299
BASSLINK_EO_20260708_20260505151658291
BASSLINK_EO_20260709_20260505151742359

New Data Timing

Generated as submissions are processed in next-day reports

Code Examples

Polars

Casting is enums, categoricals etc is not essential, but may speed up parsing. Swapping int for pl.UInt16, pl.Int32 would also speed up parsing. However some of the datatypes are inferred, so they may be wrong.

This code deduplicates for you. Deduplication is normally only required across multiple months.

This code assumes that all columns are present, which may not be true for older files.

import polars as pl
import polars.selectors as cs

# e.g. "2029/03/15 00:05:00"
dt_s_fmt = "%Y/%m/%d %H:%M:%S"

# Dates are represented as datetimes at midnight

d_fmt = "%Y/%m/%d 00:00:00"

# for "TIMESTAMP" columns
# Note that Polars uses slightly different format strings for fractional seconds to `dt.strptime`
# e.g. "2029/03/15 00:00:00.123".
dt_ms_fmt = "%Y/%m/%d %H:%M:%S%.3f"

csv_paths = ["SOMEFILE.CSV", "OTHERFILE.CSV"]

lf = (
    pl.concat(
        [
            pl.scan_csv(
                csv_path,  # must be unzipped beforehand
                skip_rows=1,  # skip the header
                infer_schema=False,  # much faster
            )
            .filter(cs.by_index(0) == "D")  # drop the footer
            .select(~cs.by_index(range(4)))  # drop metadata columns
            for csv_path in csv_paths
        ],
        how="diagonal_relaxed",
    )
    .with_columns(
        pl.col("REBID_CATEGORY").str.to_uppercase(),
    )
    .with_columns(
        pl.col("LASTCHANGED").str.strptime(pl.Datetime, dt_s_fmt),
        pl.col("SETTLEMENTDATE").str.strptime(pl.Date, d_fmt),
        pl.col("OFFERDATE").str.strptime(pl.Datetime, dt_ms_fmt),
    )
    .cast(
        {
            "LINKID": str,
            "PARTICIPANTID": pl.Categorical,
            "SETTLEMENTDATE": pl.Date(),
            "VERSIONNO": int,  # or pl.UInt16
            "ENTRYTYPE": pl.Categorical,
            "MR_FACTOR": pl.Float64,
            "PRICEBAND1": pl.Float64,
            "PRICEBAND2": pl.Float64,
            "PRICEBAND3": pl.Float64,
            "PRICEBAND4": pl.Float64,
            "PRICEBAND5": pl.Float64,
            "PRICEBAND6": pl.Float64,
            "PRICEBAND7": pl.Float64,
            "PRICEBAND8": pl.Float64,
            "PRICEBAND9": pl.Float64,
            "PRICEBAND10": pl.Float64,
            "REBID_AWARE_TIME": str,
            "REBID_CATEGORY": pl.Enum(["A", "P", "F", "E", "Z", "I"]),
            "REBID_DECISION_TIME": str,
            "REBID_EVENT_TIME": str,
            "REBIDEXPLANATION": str,
            "REFERENCE_ID": str,
        }
    )
    # Deduplicate
    # We want one row per ['LINKID', 'OFFERDATE', 'PARTICIPANTID', 'SETTLEMENTDATE', 'VERSIONNO']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(
        subset=["LINKID", "OFFERDATE", "PARTICIPANTID", "SETTLEMENTDATE", "VERSIONNO"],
        keep="last",
    )
)

Nemosis

from nemosis import dynamic_data_compiler

df = dynamic_data_compiler(
    '2024/01/01 00:00:00',
    '2024/01/31 00:00:00',
    "MNSP_DAYOFFER",
    "data/"
)

Nemosis only includes a subset of columns by default, as an optimisation. (i.e. the commonly used columns.) To include others:

from nemosis import defaults

defaults.table_columns["MNSP_DAYOFFER"] += ["ENTRYTYPE", "LASTCHANGED", "MR_FACTOR", "REBID_AWARE_TIME", "REBID_CATEGORY", "REBID_DECISION_TIME", "REBID_EVENT_TIME", "REBIDEXPLANATION", "REFERENCE_ID"]
df = dynamic_data_compiler(...)

Example File

From PUBLIC_ARCHIVE_MNSP_DAYOFFER_FILE01_202607010000.zip

Table without MetadataTable with MetadataRaw Text without Metadata

SETTLEMENTDATE	OFFERDATE	VERSIONNO	PARTICIPANTID	LINKID	ENTRYTYPE	REBIDEXPLANATION	PRICEBAND1	PRICEBAND2	PRICEBAND3	PRICEBAND4	PRICEBAND5	PRICEBAND6	PRICEBAND7	PRICEBAND8	PRICEBAND9	PRICEBAND10	LASTCHANGED	MR_FACTOR	REBID_EVENT_TIME	REBID_AWARE_TIME	REBID_DECISION_TIME	REBID_CATEGORY	REFERENCE_ID
2026/07/01 00:00:00	2026/05/05 15:17:01.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:01		15:15:00			P	BASSLINK_EO_20260701_20260505151658284
2026/07/01 00:00:00	2026/05/05 15:17:01.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:17:01		15:15:00			P	BASSLINK_EO_20260701_20260505151658284
2026/07/02 00:00:00	2026/05/05 15:17:09.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:09		15:15:00			P	BASSLINK_EO_20260702_20260505151658365
2026/07/02 00:00:00	2026/05/05 15:17:09.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:17:09		15:15:00			P	BASSLINK_EO_20260702_20260505151658365
2026/07/03 00:00:00	2026/05/05 15:16:58.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:16:58		15:15:00			P	BASSLINK_EO_20260703_20260505151658345
2026/07/03 00:00:00	2026/05/05 15:16:58.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:16:58		15:15:00			P	BASSLINK_EO_20260703_20260505151658345
2026/07/04 00:00:00	2026/05/05 15:17:03.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:03		15:15:00			P	BASSLINK_EO_20260704_20260505151658332
2026/07/04 00:00:00	2026/05/05 15:17:03.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:17:03		15:15:00			P	BASSLINK_EO_20260704_20260505151658332
2026/07/05 00:00:00	2026/05/05 15:17:07.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:07		15:15:00			P	BASSLINK_EO_20260705_20260505151658322
2026/07/05 00:00:00	2026/05/05 15:17:07.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:17:07		15:15:00			P	BASSLINK_EO_20260705_20260505151658322
2026/07/06 00:00:00	2026/05/05 15:17:04.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:04		15:15:00			P	BASSLINK_EO_20260706_20260505151658306
...

C	SETP.WORLD	DVD_MNSP_DAYOFFER	AEMO	PUBLIC	2026/08/08	12:31:31	001786156291635	MONTHLY_ARCHIVE	001786156291635
I	BIDS	MNSP_DAYOFFER	1	SETTLEMENTDATE	OFFERDATE	VERSIONNO	PARTICIPANTID	LINKID	ENTRYTYPE	REBIDEXPLANATION	PRICEBAND1	PRICEBAND2	PRICEBAND3	PRICEBAND4	PRICEBAND5	PRICEBAND6	PRICEBAND7	PRICEBAND8	PRICEBAND9	PRICEBAND10	LASTCHANGED	MR_FACTOR	REBID_EVENT_TIME	REBID_AWARE_TIME	REBID_DECISION_TIME	REBID_CATEGORY	REFERENCE_ID
D	BIDS	MNSP_DAYOFFER	1	2026/07/01 00:00:00	2026/05/05 15:17:01.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:01		15:15:00			P	BASSLINK_EO_20260701_20260505151658284
D	BIDS	MNSP_DAYOFFER	1	2026/07/01 00:00:00	2026/05/05 15:17:01.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:17:01		15:15:00			P	BASSLINK_EO_20260701_20260505151658284
D	BIDS	MNSP_DAYOFFER	1	2026/07/02 00:00:00	2026/05/05 15:17:09.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:09		15:15:00			P	BASSLINK_EO_20260702_20260505151658365
D	BIDS	MNSP_DAYOFFER	1	2026/07/02 00:00:00	2026/05/05 15:17:09.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:17:09		15:15:00			P	BASSLINK_EO_20260702_20260505151658365
D	BIDS	MNSP_DAYOFFER	1	2026/07/03 00:00:00	2026/05/05 15:16:58.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:16:58		15:15:00			P	BASSLINK_EO_20260703_20260505151658345
D	BIDS	MNSP_DAYOFFER	1	2026/07/03 00:00:00	2026/05/05 15:16:58.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:16:58		15:15:00			P	BASSLINK_EO_20260703_20260505151658345
D	BIDS	MNSP_DAYOFFER	1	2026/07/04 00:00:00	2026/05/05 15:17:03.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:03		15:15:00			P	BASSLINK_EO_20260704_20260505151658332
D	BIDS	MNSP_DAYOFFER	1	2026/07/04 00:00:00	2026/05/05 15:17:03.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:17:03		15:15:00			P	BASSLINK_EO_20260704_20260505151658332
D	BIDS	MNSP_DAYOFFER	1	2026/07/05 00:00:00	2026/05/05 15:17:07.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:07		15:15:00			P	BASSLINK_EO_20260705_20260505151658322
D	BIDS	MNSP_DAYOFFER	1	2026/07/05 00:00:00	2026/05/05 15:17:07.000	1	BASSLINK	BLNKVIC	DAILY	INITIAL OFFER	0.01	40	61	75	89	104	114	200	450	20300	2026/05/05 15:17:07		15:15:00			P	BASSLINK_EO_20260705_20260505151658322
D	BIDS	MNSP_DAYOFFER	1	2026/07/06 00:00:00	2026/05/05 15:17:04.000	1	BASSLINK	BLNKTAS	DAILY	INITIAL OFFER	0	25	55	75	95	135	200	1000	5000	20299	2026/05/05 15:17:04		15:15:00			P	BASSLINK_EO_20260706_20260505151658306
...
C	END OF REPORT	21

SETTLEMENTDATE,OFFERDATE,VERSIONNO,PARTICIPANTID,LINKID,ENTRYTYPE,REBIDEXPLANATION,PRICEBAND1,PRICEBAND2,PRICEBAND3,PRICEBAND4,PRICEBAND5,PRICEBAND6,PRICEBAND7,PRICEBAND8,PRICEBAND9,PRICEBAND10,LASTCHANGED,MR_FACTOR,REBID_EVENT_TIME,REBID_AWARE_TIME,REBID_DECISION_TIME,REBID_CATEGORY,REFERENCE_ID
"2026/07/01 00:00:00","2026/05/05 15:17:01.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:01",,15:15:00,,,P,BASSLINK_EO_20260701_20260505151658284
"2026/07/01 00:00:00","2026/05/05 15:17:01.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:17:01",,15:15:00,,,P,BASSLINK_EO_20260701_20260505151658284
"2026/07/02 00:00:00","2026/05/05 15:17:09.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:09",,15:15:00,,,P,BASSLINK_EO_20260702_20260505151658365
"2026/07/02 00:00:00","2026/05/05 15:17:09.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:17:09",,15:15:00,,,P,BASSLINK_EO_20260702_20260505151658365
"2026/07/03 00:00:00","2026/05/05 15:16:58.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:16:58",,15:15:00,,,P,BASSLINK_EO_20260703_20260505151658345
"2026/07/03 00:00:00","2026/05/05 15:16:58.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:16:58",,15:15:00,,,P,BASSLINK_EO_20260703_20260505151658345
"2026/07/04 00:00:00","2026/05/05 15:17:03.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:03",,15:15:00,,,P,BASSLINK_EO_20260704_20260505151658332
"2026/07/04 00:00:00","2026/05/05 15:17:03.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:17:03",,15:15:00,,,P,BASSLINK_EO_20260704_20260505151658332
"2026/07/05 00:00:00","2026/05/05 15:17:07.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:07",,15:15:00,,,P,BASSLINK_EO_20260705_20260505151658322
"2026/07/05 00:00:00","2026/05/05 15:17:07.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:17:07",,15:15:00,,,P,BASSLINK_EO_20260705_20260505151658322
"2026/07/06 00:00:00","2026/05/05 15:17:04.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:04",,15:15:00,,,P,BASSLINK_EO_20260706_20260505151658306
...

Raw Text with Metadata

C,SETP.WORLD,DVD_MNSP_DAYOFFER,AEMO,PUBLIC,2026/08/08,12:31:31,001786156291635,MONTHLY_ARCHIVE,001786156291635
I,BIDS,MNSP_DAYOFFER,1,SETTLEMENTDATE,OFFERDATE,VERSIONNO,PARTICIPANTID,LINKID,ENTRYTYPE,REBIDEXPLANATION,PRICEBAND1,PRICEBAND2,PRICEBAND3,PRICEBAND4,PRICEBAND5,PRICEBAND6,PRICEBAND7,PRICEBAND8,PRICEBAND9,PRICEBAND10,LASTCHANGED,MR_FACTOR,REBID_EVENT_TIME,REBID_AWARE_TIME,REBID_DECISION_TIME,REBID_CATEGORY,REFERENCE_ID
D,BIDS,MNSP_DAYOFFER,1,"2026/07/01 00:00:00","2026/05/05 15:17:01.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:01",,15:15:00,,,P,BASSLINK_EO_20260701_20260505151658284
D,BIDS,MNSP_DAYOFFER,1,"2026/07/01 00:00:00","2026/05/05 15:17:01.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:17:01",,15:15:00,,,P,BASSLINK_EO_20260701_20260505151658284
D,BIDS,MNSP_DAYOFFER,1,"2026/07/02 00:00:00","2026/05/05 15:17:09.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:09",,15:15:00,,,P,BASSLINK_EO_20260702_20260505151658365
D,BIDS,MNSP_DAYOFFER,1,"2026/07/02 00:00:00","2026/05/05 15:17:09.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:17:09",,15:15:00,,,P,BASSLINK_EO_20260702_20260505151658365
D,BIDS,MNSP_DAYOFFER,1,"2026/07/03 00:00:00","2026/05/05 15:16:58.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:16:58",,15:15:00,,,P,BASSLINK_EO_20260703_20260505151658345
D,BIDS,MNSP_DAYOFFER,1,"2026/07/03 00:00:00","2026/05/05 15:16:58.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:16:58",,15:15:00,,,P,BASSLINK_EO_20260703_20260505151658345
D,BIDS,MNSP_DAYOFFER,1,"2026/07/04 00:00:00","2026/05/05 15:17:03.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:03",,15:15:00,,,P,BASSLINK_EO_20260704_20260505151658332
D,BIDS,MNSP_DAYOFFER,1,"2026/07/04 00:00:00","2026/05/05 15:17:03.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:17:03",,15:15:00,,,P,BASSLINK_EO_20260704_20260505151658332
D,BIDS,MNSP_DAYOFFER,1,"2026/07/05 00:00:00","2026/05/05 15:17:07.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:07",,15:15:00,,,P,BASSLINK_EO_20260705_20260505151658322
D,BIDS,MNSP_DAYOFFER,1,"2026/07/05 00:00:00","2026/05/05 15:17:07.000",1,BASSLINK,BLNKVIC,DAILY,"INITIAL OFFER",0.01,40,61,75,89,104,114,200,450,20300,"2026/05/05 15:17:07",,15:15:00,,,P,BASSLINK_EO_20260705_20260505151658322
D,BIDS,MNSP_DAYOFFER,1,"2026/07/06 00:00:00","2026/05/05 15:17:04.000",1,BASSLINK,BLNKTAS,DAILY,"INITIAL OFFER",0,25,55,75,95,135,200,1000,5000,20299,"2026/05/05 15:17:04",,15:15:00,,,P,BASSLINK_EO_20260706_20260505151658306
...
C,"END OF REPORT",21

Availability

Visibility: Private & Public Next-Day

This table is in the public monthly MMSDM archive.

I have collated the list of all those files into one place, in this CSV metadata file. (Columns year, month, url, compressed_size in bytes).

The earliest available data is month 1 of 2015. The most recent available data is month 7 of 2026.

Warning

There are some months with no files.

Data Size

Each year of data is approximately 9 KB when zipped, 94 KB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

LINKID
OFFERDATE
PARTICIPANTID
SETTLEMENTDATE
VERSIONNO

The transaction type is "insert", which means that you will usually not see duplicate data. If you do, you can deduplicate based on the primary keys, without sorting first. Rows from different files with the same primary keys should have the same values.

PDR Loader configuration is:

Report Name	Report Subtype	Version	Undisclosed
BID	MNSP_DAYOFFER	2
BIDS	MNSP_DAYOFFER	1
OFFER	MNSP_DAYOFFER	2	⚠️

Warning

Some of these file mappings are not in the published PDR Loader configuration file, even though files for this table exist with those metadata values. Mappings marked with ⚠️ have been added by me after manually inspecting those files.

This means that the CSV files start with metadata columns:

I,BID,MNSP_DAYOFFER,2,...
D,BID,MNSP_DAYOFFER,2,...

or

I,BIDS,MNSP_DAYOFFER,1,...
D,BIDS,MNSP_DAYOFFER,1,...

or

I,OFFER,MNSP_DAYOFFER,2,...
D,OFFER,MNSP_DAYOFFER,2,...

Indexes

LASTCHANGED

Links

This page as JSON (schema documented here, but may change)

Download a JSON Schema specification for this table.

Official AEMO schema documentation

Other Information

Package: BIDS