Finwin Spots (Query)

Request:

Spots

Types:

·Query

·Standardxml

·Chart

Sample Code:

Coldfusion

ASP

JSP

PHP

Perl

Spots (Query)

Spots Type=Query returns a WDDX recordset with the following columns :

HUB - This is the symbol of the hub you requested.
TRADINGDATE - This is the date the spot price was recorded .
HUBINDEX - The index price based on calculations of accumulated prices from hundreds of locations throughout the U.S. and the markets.
SPOTPRICE - This is the calculated price for each and every spot.
BASIS - The basis is the industry standard formula (cash-futures=basis).
BTUSPARK_8 & BTUSPARK_10 - This is the power industry's way of measuring the cost effectiveness of burning natural gas as opposed to buying spot power.
AGA - The American Gas Association (AGA) represents over 180 natural gas utilities that deliver gas to 54 million homes and businesses in all 50 states. Their weekly data has been archived since the trade association began its survey in December 1993.
NETCAPACITY - This refers to the maximum, or design capacity of a reactor in megawatts.
PERCENTPOWER - This is the current operating status in percentage form compared with the net capacity. In other words, a plant that has a net (or maximum) capacity of 1,000 Mw and is operating at that capacity would be producing 100% of its power. If the same plant was operating at 500 Mw, it would be at 50% power.
NETMEGAWATT - similar to percent power, except that the measurement is in Mws rather than in a percentage. Simply flip the above explanation.
LOCATION - This is the location or description of the Hub symbol.

Required Parameters

URL = http://www.finwin.com/processct/processspottag.cfm Username = myUsername
Password = myPassword
Id = 1183
Request = Spots
Type = Query
*Hub = WHHUB - can be a comma delimited list

*Can use "all" and receive every hub you are authorized for. To view a list of all available hubs click here.

Optional Parmeters

*Queryname = GetSpots
Months = The number of months in the past you wish to receive spot prices. - max of 12
Days = The number of days in the past you wish to receive spot prices. This would be used in place of months, so you could reduce the amount of data. (default is 30)

* Will work only when using Cold Fusion with Finwin's custom tags

Example WDDX Packet

Spot Query

Cold Fusion Example

<cf_spots 
      request="Spots"
      type="Query"
      username="myUsername"
      password="myPassword"
      id="1183"
      queryname="GetSpots"
      hub="WHHUB"
      days="2">

ASP Example

Dim strHub
strHub   = Request.Form("Hub")
  
Request_POST = 	1
Set HttpObj  = Server.CreateObject("SOFTWING.AspTear")
FinwinURL 	 = "Http://www.finwin.com/processCT/ProcessSpotTag.cfm"

PostData = "username=myUsername&password=myPassword&id=1183&request=spots&Hub=" & strHub & 
"&type=query&months=2"

content = HttpObj.Retrieve(FinwinURL, Request_POST,PostData, "", "")
Response.write(content)

Spots (Type = Query) Example:

Name	Month	Index	Basis	Spot Price
WCAOR	February			44.880
WHHUB	February	5.270	0.132	4.910
WKATY	February	5.370	0.130	4.910