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.
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.
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 Rebate and 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.
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.
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.