What is the normal process for accessing final spot prices? I'm interested in combining my own meter reads with spot data for comparisons.
There is the real time prices API, but this appears to be provisional prices? And as it's in 5 minute intervals it doesn't seem to align well with trading periods.
Then there is the Final prices GDX datasets which I've been able to extract some stuff by using the information that Matthew Keir posted. I've managed to use gdxdump with the 'i_tradePeriodEnergyOffer' symbol, but I'm uncertain about the trdBlk, NRGofrCmpnt columns.
Essentially all I'm after is Date, TP, Node, Price. Is there an easier way to achieve this, or is this what a retailer like Flick would be doing when they show you the spot rate?
Any help appreciated :)