Hourly Data Set of Final Prices?

45 views
Skip to first unread message

Randy - RRTP since Aug 2012

unread,
Oct 1, 2020, 12:30:45 AM10/1/20
to Com*Ed RRTP User Group
Does anyone have an hourly data set of final prices for RRTP or know an easy source to get them from. 

I just grabbed what I think is it from PJM's site, the data miner tool.
https://dataminer2.pjm.com/feed/rt_hrl_lmps

Let me know if this doesn't seem right, or you think there's something easier or better.

datetime_beginning_ept  Per KwH
9/29/2020 23:00               0.01427
9/29/2020 22:00               0.01392
9/29/2020 21:00               0.01508  

Scott Allen

unread,
Oct 1, 2020, 8:10:54 AM10/1/20
to comed...@googlegroups.com

Here is the hourly pricing from 10/1/17 through 8/31/20. 

 

 

Scott Allen

+1 (847) 217-9067

rscott...@gmail.com

 

1201 Hampton Lane

Mundelein, IL 60060

--
You received this message because you are subscribed to the Google Groups "Com*Ed RRTP User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to comed-rrtp+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/comed-rrtp/f3ca17d2-20fd-4850-afff-9c50edad5126n%40googlegroups.com.

1601554079835-ZUK6TC6D9Z.csv

Randy Bovay

unread,
Oct 1, 2020, 4:10:50 PM10/1/20
to comed...@googlegroups.com
Thanks!
That's supply AND Transmission charges, right?
I was noticing that the data I pulled was a bit lower than yours, so was just trying to reconcile the differences.
-Randy



--

-Randy

Scott Allen

unread,
Oct 1, 2020, 4:41:46 PM10/1/20
to comed...@googlegroups.com

Randy,

 

The data I provided was the hourly energy prices that are used to calculate the Electric Supply Charge line item on my bill.  I downloaded the data from my account on the hourly pricing website (https://hourlypricing.comed.com/) and removed my actual usage. 

 

As you can see from the attached bill image, transmission is charged separately. 

 

 

Scott Allen

+1 (847) 217-9067

rscott...@gmail.com

 

1201 Hampton Lane

Mundelein, IL 60060

 

image001.png

Randy - RRTP since Aug 2012

unread,
Oct 1, 2020, 6:00:02 PM10/1/20
to Com*Ed RRTP User Group
Thanks Scott!
Nice work on the $0 Bill, btw.  Solar I assume.

rzi...@gmail.com

unread,
Oct 2, 2021, 12:21:27 PM10/2/21
to Com*Ed RRTP User Group
When you grabbed data from PJM, did you look at the "Total LMP Real Time"?  There are three components to the price, and ComEd rolls them together (with some rounding).  I don't know what they use for billing, since I've never been able to get mine to work out exactly.  

System Energy Price Real Time
Congestion Price RT
Marginal Loss Price RT

IIRC, there is also a "settlement" period, where the real price is determined.  I think that was just a footnote on a ComEd site somewhere, but I can't find it.  

Later,
Ryan



Reply all
Reply to author
Forward
0 new messages