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
- Wholesale
- Decomposition of spot price into underlying components
Decomposition of spot price into underlying components
- 1.4K Views
- Last post 07 May 2021
LanaStockman
posted this
15 December 2019
and another question from me - do we have some measure for the spot price volatilty over time?
- #Permalink
- 0
- 0
- 0
Phil Bishop
posted this
16 December 2019
- Last edited 13 February 2020
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
- #Permalink
- 0
- 0
- 0
Mathieu
posted this
22 October 2020
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
- #Permalink
- 0
- 0
- 0
Phil Bishop
posted this
22 October 2020
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
- #Permalink
- 1
- 0
- 0
- Liked by
-
Mathieu
posted this
22 October 2020
Thanks for the update, Phil.
Great to hear, I look forward to it.
Mathieu
- #Permalink
- 0
- 0
- 0
Mathieu
posted this
21 April 2021
Hi Phil,
Could you please give me an update on the revised expected timeline for the publication of this data?
Thanks!
Mathieu
- #Permalink
- 0
- 0
- 0
Phil Bishop
posted this
07 May 2021
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
- #Permalink
- 2
- 0
- 0
- Liked by
-
-
Find discussions by tag
See all
This week's high earners
-
Bradinator 2
-
Jonty NZ 2
-
ERANZ 2
-
Phil Bishop
2
-
Vainui Moresi 2
-
es101 1
-
msouness
1
-
SolarP 1
