Trying to find out if it’s just me seeing mismatched values between ENTSOE and VRM, if you can please:
- Use the ENTSOE web page to check today’s prices per hour
- Post your location and VRM DESS energy graph
- Check for possible discrepancies
thanks all!
The difference between the values in ENTSOE and VRM would depend on the price formula you entered in the DESS config, no ?
Correct, what i’m asking is to take the p from ENTSOE, plug into your formula, compute it and compare against what VRM is showing for the same timeframe
Example, here in Portugal ENTSOE shows a p of €159.37/MWh for the 8h-9h timeframe (UTC)
My formula is ((p+0.009)*(1+0.16))+0.001 => (((159.37/1000)+0.009)*(1+0.16))+0.001 => €0.19630920000000002 kW/h
Now i look at the VRM graph, since Portugal is currently UTC+1, i’d expect to find this value in the 9h-10h timeframe but what i find is some other one, €0.1963 shows up on the 7h-8h timeframe
Belgium here and when I ran the ENTSOE prices for today through some Excel voodoo, I got the exact same values as reported by VRM, without the need for timezone corrections.
As far as I know, prices from ENTSOE are already in your local timezone.
In Belgium we’re in CEST since last weekend, so UTC+2.
Quick question: do you have your timezone and/or location set up correctly in VRM and your GX ?
Thanks for checking! Mind posting a VRM screenshot of your prices graph so i can have something to compare against?
As far as I know, prices from ENTSOE are already in your local timezone.
Going through the doc they mention that all API results are in UTC which kinda makes sense to me, it also matches one other datasource for Portugal/Spain which is OMIE
Quick question: do you have your timezone and/or location set up correctly in VRM and your GX ?
Location is both set on VRM General and Dynamic ESS tabs, on the GX i have it set to GMT Standard Time (Lisbon) although i now see it doesn’t support daylight savings as it’s showing one hour earlier
Prices for today in VRM and the relevant columns in my Excel file.
My DESS formula is “((0.01395+p)*1.06)+0.01582+0.050329+0.020417”
First part between brackets is the supplier formula, last 3 items are extra local tariffs.
1 Like
That will probably be the cause of your time shift in VRM.
If the timezone is set in your GX, that one takes precedence over the location in VRM.
How do you not set a timezone in your GX? I’m forced to chose one or pick UTC, is that you have?
No idea. I’ve always set mine to the local timezone and that has always worked for me.
If you’re certain that your prices in VRM are offset [by one hour] you could post a possible bug against VRM.
If you’re certain that your prices in VRM are offset [by one hour] you could post a possible bug against VRM.
Posted it here at few days ago, let’s see what it turns up, thanks for the help!