Dashboard Reports are provided to users of the Sygration Dashboard service. It is a collection of useful reports that allow subscribers to execute complex data queries directly against the Sygration data warehouse. Using the Sygration Query Express engine, users can view the data on-line or download the data in native Microsoft Excel.
Reports are created based on suggestions and feedback of Sygration customers. Your feedback and suggestions are encouraged by emailing Sygration. For a report to be considered, it must provide value-added benefits and be useful to other subscribers.
Admin Pricing to HOEP: A list of all hours having prices changed by the IESO Ex-Post desk in the last 180 days.
Average Prices (2 Weeks): This report shows the past two weeks of electricty prices including energy and operating reserve. There are three types of operating reserve reflecting how quickly the reserve must be provided if called upon: 10 minute spinning (currently, only generators can provide this), 10 minute non-spinning and 30 minute reserve.
Generator Peer Group: This report compares the average rate of return ($/MWh) of each Generator of the same fuel group (Nuclear, Coal, Hydro, Gas, Wind) for a selected month. It ranks the generators by $/MWh, but also includes their total GWh, average Capability (% of MCR) and average Output (% of MCR) for the target month.
Global Adjustments (and OPG Revenue): A process runs hourly to track output of each OPG and NUG-contract resource, and applies it against regulated and non-regulated rate formulas to estimate OPG Rebates and Global Adjustments. This report shows the MWh for each generation class (Regulated Nuclear, Regulated Hydro, Non-Regulated Hydro, Non-Regulated Fossil, and NUG). It reports on the MWh and revenue adjustments (OPG Rebate or portion of Global Adjustment) with values updated hourly. A sub-report also shows the estimated spot and adjusted revenue from energy for OPG - weeks before it is officially reported.
Note: There is still much room for improvements on the Global Adjustment estimates, so please provide feedback on potential ideas to improve this. For example, calculations do not include adjustments to cover OPA initiatives such as RFP generator contracts and demand response projects.
Delivery Points: This is a list of Delivery Points (generators, loads) whose locational pricing data is being collected in the Sygration database. The Ontario electricity market sets a single market price for all Ontario resources, so these location price data reflect "shadow" prices to help identify transmission constraints within the system. There are currently about 320 Delivery Points.
Intertie Curtails & SMO: This report is experimental and exploits a difference between the published Adequacy report (generated by the DSO in Predispatch timeframe) and the Intertie Schedule and Flow (ISF) report (likely generated by the Interchange Scheduler leading up to the dispatch hour). The ISF report includes Segregated Mode of Operations (SMO) transactions at Q4C (Chats Falls) and B31L (RH Saunders) which are not included in the Adequacy report as they are considered out of market transactions. Even with the SMO values accounted for, there remains differences between the two IESO reports which are likely the result of curtailed or failed intertie transactions. This report highlights those differences.
Intertie Limits: This report lists the Real-Time and Predispatch Intertie Limits for each Ontario Intertie for the past 2 days up to the current day, or day ahead if a predispatch run exists for that day.
On-Off Peak Prices: This report is useful for traders of financial swaps. It shows the mix of current and forecast energy prices for each hour, categorized into On-Peak and Off-Peak times. On-peak is defined as Monday-Friday, 7AM - 10PM local Eastern Time. The prices adjusts automatically for HOEP when it is available, and uses the latest Predispatch prices otherwise.
OPG Emissions Forecast The Ministry of Energy mandated that OPG's coal-based generation does not produce CO2 emissions in excess of 19.6 Million Tonnes in 2009, and 15.6 Million Tonnes in 2010. This corresponds approximately to a total coal-based generation of 20 TWh in 2009 and 16 TWh in 2010. This report tracks the energy output of their coal-fueled fleet and uses a projection based on the previous 5-years of data to forecast how well they will be on target.
Predispatch Price Bias: While HOEP is based on the average energy price during the hour, the Predispatch forecast price is based on the peak demand expected within the hour. As a result, the forecast price is often higher than the final HOEP. The IESO provides an estimate for this "Predispatch price bias" as part of their intertie transaction failure charge. This report tracks the actual average price bias for each hour, as well as the bias' standard deviation that can be used as a measure of the forecast quality.
Price Correlations: This report shows the Market Demand and Energy Price for the last three days, along with Generator Output and Imports. It shows the approximate correlations between demand, supply and price. Market Demand (MW) is the Ontario Load + Losses + Exports, and is provided every 5-minutes along with the Energy Price. The supply side of the equation includes Generator Output (by fuel-class) and Imports on an hourly resolution.
Shadow Prices: This report allows you to dump (HTML or Microsoft Excel) the past 2-weeks of shadow price data for one of over a hundred Delivery Points. It includes 5-minute prices for energy and each class of operating reserve.
Station Monthly Summary: This report lists the history of all Generators in the Ontario market. You can select any generator to show Maximum Output (MW), Output Energy (MWh), Average Capability and Revenue Estimate (based on Output[h] X HOEP[h]) for all months starting from December 2003.
Time-of-Use Rates: Retail customers on Smart Meters in Ontario will soon be paying a regulated time-of-use rate. This report categorizes each spot market energy price (HOEP) into the appropriate OEB peak definition (On Peak, Mid-Peak or Off-Peak) and reports on the actual average spot market price for each category. This shows how close the regulated rates are to the actual spot-market rates for those hours.
Today's 5-Minute Prices: This query shows the 5 minute market clearing prices (MCP) for Ontario electricity; energy and the three classes of operating reserve. All times are in Eastern Standard Time (EST).
Transmission Catalog: This report is a catalog of Ontario Transmission Circuits and Images from the Sygration database. Circuit names are automatically detected by the Sygration Market Scraper when processing IESO SSR files.
Uplift and IOG Estimates: This report provides a 2-week history of the Ontario Uplift Estimate, and the component of the Uplift attributed by the Intertie Offer Guarantee.