Hi vspd_user
I don't think we've got it wrong. But if you're not persuaded please do let us know.
In a nutshell, we only present meaningful records and suppress all records that don't tell us something that we didn't already know from a previous submission. I'll expand on what I mean by this further below. In doing so, I'll refer to the attached Excel file containing three tabs as follows:
- From WITS as per vspd_user (let’s call it ‘vspd_user WITS’)
- From WITS as per EA (let’s call it ‘EA WITS’)
- From EMI (i.e. taken from what the EA publishes on EMI).
The attached spreadsheet only contains data pertaining to HLY2201 HLY2 offer submissions by GENE for trading period 1 on 6 June 2022, i.e. the focus of your question above.
The first point to note is that the structure of the file you have obtained from WITS (or constructed yourself from data that you've downloaded from WITS) is different to the file we receive each day from WITS. In the vspd_user WITS file there is only a single record that relates to HLY2201 HLY2 offer submissions by GENE for trading period 1 on 6 June 2022 whereas in the EA WITS file there are 51 records. Some of this difference is explained by the fact that you appear to show only energy offers whereas the EA file contains energy, FIR and SIR offers. Also, the EA WITS file has each band or tranche of the offer on a new line whereas the vspd_user WITS file shows the bands as columns.
In any event, the vspd_user WITS file shows only one energy offer – the offer submitted at 2:17am on 31 May. The EA WITS file shows three energy offer submissions: 1:03am on 26 May, 5 past midnight on 31 May, and 2:17am on 31 May (see rows 20-34 of the EA WITS tab of the attached file). Significantly, the MW associated with all three energy offer submissions is zero in all tranches. Not so significant is the fact that while the prices for all tranches and submissions are non-zero, the price of some tranches differs across the three submissions. The energy offer prices in this situation are really of no consequence because nothing is being offered. The max ramp up and down values are zero for all three offers as well (this is curious but of no practical significance because, as just noted, no megawatts are being offered and it’s not germane to the question at hand).
The key point to note from all of this is that the second (5 past midnight on 31 May) and third (2:17am on 31 May) energy offer submissions don't change anything from what was initially offered, i.e. zero megawatts are being offered in all tranches in all three submissions. In other words, the second and third energy offer submissions don't tell us anything we didn't already know. Yes, some prices in some tranches are changing with each submission but it’s the price of nothing! To be sure, the second and third offers are significant and meaningful when it comes to the FIR and SIR components of these offers but given the data you attached to your post I understood your question was related to only energy offers.
If you look at the third tab in the attached spreadsheet, you’ll see that in the file we publish on EMI we show only the first energy offer submitted, i.e. the one submitted at 1:03pm on 25 May UTC time (or 1:03am on 26 May NZ time). Moreover, we flag it as the latest submitted offer. Again, that’s because the energy submissions that follow are meaningless. If we published every meaningless change to submitted offers, the file that we publish would be enormous.
I hope this makes sense.
Cheers
Phil
P.S. - three CSVs uploaded with names as per bullet points above. Can't upload an .xlsx file.
