Twitter![[graphic: Real Time Data Icon]](images/content/product_icons_realtime.jpg){kind=icon}
Innotap™ Real Time Data
Real-Time Data Delivery Application
Innotap Real Time Data (RTD) provides real-time data from market sources such as PJM, MISO, ISONE, NYISO, etc. that can be referenced and manipulated inside Excel spreadsheets, where the data displayed is automatically updated whenever it changes at the source. Use your own formulas to define custom rules that trigger actions based on dynamic market data.
Overview
In the spreadsheet (click left thumbnail), PJM's instantaneous dispatch rates and 5 minute aggregate LMPs are monitored (i.e., the data changes in your spreadsheet as it changes in real-time). The cells with values shown in blue are the result of function calls to the Innotap RTD server for PJM. A key feature allows you to specify that you want the last value before the most recent real-time update. That way you can compare the last to the current value and write rules based on the difference between them.
Innotap RTD allows you to name the market data you want to retrieve dynamically. When there are multiple values for a particular data item (e.g., 5Min LMP, Hourly Integrated LMP, etc.), you can also retrieve the market data by specifying an index; i.e., the relative position in the sequence of values published by PJM.
Note in the screenshot (click left thumbnail) that cell E11 is selected. In the formula toolbar, you will see the RTD function which is calling the InnotapRTD.PJM service for the last, 4th AggregateLMP price published by PJM which is for PL ZONE. In the function call the index is the value at cell B11, which is 4.
Real Time Data Screenshots
Listen to the Experts
“Your services have put an extra $750k in my book this year {2010}.”