Hello EMI guys,
In some other jurisdictions spot prices are presented in 3 components - the underlying spot price from generator offer, then the losses, and then the congestion elements. Are we able to do that here?
Thanks
Lana
Hello EMI guys,
In some other jurisdictions spot prices are presented in 3 components - the underlying spot price from generator offer, then the losses, and then the congestion elements. Are we able to do that here?
Thanks
Lana
Hmmm, just re-read this entire thread and I'd have to say that my predictions about when we'll get things done are not even close. That isn't because I have no idea what we're doing. It's because I have no control over what lands on my desk and for the past year an awful lot of stuff has been landing on my desk. That said, I'd hope we can get the price decomposition and price sensitivity reports on EMI within the next three or four months. It certainly won't be this side of 30 June.
Phil
Funny you should mention the price decomposition initiative. Tuong and I were just discussing that yesterday. I would hope that we'd have an EMI report of this by the end of the year.
The reason this will take us a little while is that we're in the midst of migrating our data ingestion/storage/presentation platform from SQL databases running on a SQL Server VM to Databricks and a Delta Lake in our Azure environment. We've got vSPD jobs running in containers producing output into blob storage that then gets ingested into the Delta Lake. But we've yet to wire up the EMI website to talk to the Delta Lake. The price decomposition task is about to get added to one of the container jobs.
Phil
and another question from me - do we have some measure for the spot price volatilty over time?
Hi Lana
Yes, we can do, and indeed have done, all of the things you ask about. However, we're a bit thin on the ground with developer effort at the moment so it might be a while before any of these things make it to an EMI report.
The spot price decomposition is quite straightforward with vSPD. It is our intention to set up an automated daily task that does the price decomposition as well as the sensitivity of price to changes in demand, i.e. perturb demand up and down in small increments and run vSPD with each perturbation to observe a new set of prices. The results of both these experiments will be captured in the data warehouse and then used to power new EMI reports. If we got this done in 2020 Q1 I'd be pleasantly surprised.
As for spot price volatility over time, you could use the wholesale price summary report to gain some insights into volatility, although examining the distribution isn't quite the same as a direct volatility measure. We have a table in our data warehouse that updates daily with the the first four moments of the price distribution for various time scales (daily, weekly, monthly, quarterly, and annual) for all nodes, as well as capturing min, max, quartiles and various percentiles. But that's all a bit drab for an EMI report. It is also on our TODO list to get a measure of price volatility into an EMI report.
Cheers
Phil
Hi,
I was wondering if there had been any updates on the decomposition of the pricing data. Do you guys have a new rough estimate of when such data will be available?
Thanks a lot!
Mathieu
Thanks for the update, Phil.
Great to hear, I look forward to it.
Mathieu
Hi Phil,
Could you please give me an update on the revised expected timeline for the publication of this data?
Thanks!
Mathieu
Our 1371 members have posted 1216 times in 341 discussions
580 users are currently online.
EA tel: + 64 4 460 8860 EMI email: emi@ea.govt.nz Legal information Glossary
© 2024 Copyright material on this site is protected by copyright owned by the Electricity Authority or its licensors.