ww_ftrmth
Monthly FTR Auction Bids

Current Status

Report Name

Change Summary

Effective Date

Description

Template

Sample

ww_ftrmth Modified. Added a new column "Masked Customer ID" to the end of the report. This new column will be included on the report distributed April 1, 2011 for the December 2010 auction month. 12.01.2010 PDF XLTX CSV
Access Monthly FTR Auction Historical Bid Data

 


WW_FTRMTH – Monthly FTR Auction Bids – Rev 1

WW_FTRMTH_ISO_date_version.CSV
Date: mm/dd/yyyy and Version: mm/dd/yyyy hh:mm:ss GMT
Availability: Monthly

Description

Auction bid data received by the ISO from participants for the Monthly FTR Auction. Published with the FERC-ordered time lag, and with market participant identity. Masked identifier numbers are consistent with pre-SMD and post-SMD identifiers. The reports are generated monthly; one report for each monthly auction.

Delivery Method

WWW (ISO-NE website)

Filename

WW_FTRMTH_ISO_settlement_version.CSV
settlement is the date of the first day of the month for which the data applies, formatted as YYYYMMDD,
version is the date/time when the report was generated, formatted as YYYYMMDDHHMSS
Note: The comments will detail the 'from' and 'to' dates for which the bids apply.

Format

Comma Delimited (CSV)

Size

Up to 50,000 records per auction

Lifetime

N/A

 

Column Name

Type

Description

 

N/A

String

The first position on every record is occupied by the character 'C', 'H', 'D', or 'T' which describes what is contained on that record (row.)
C = Comment – provides description such as report name and vintage.
H = Heading – denotes column headings.
D = Data – denotes data contained on the record.
T = Terminate – denotes the end of the file. The total number of 'D' lines contained in the file is also noted on this record.

1

Source Location ID

Number

The location identification number of the bid's source.

2

Source Location Name

String

The location name of the bid's source.

3

Source Location Type

String

The location type of the bid's source. One of 'HUB', 'LOAD ZONE', or 'NETWORK NODE.'

4

Sink Location ID

Number

The location identification number of the bid's sink.

5

Sink Location Name

String

The location name of the bid's sink.

6

Sink Location Type

String

The location type of the bid's sink. One of 'HUB', 'LOAD ZONE', or 'NETWORK NODE.'

7

Buy / Sell

String

'BUY' bid or 'SELL' offer.

8

Class Type

String

Whether the bid is for the 'OFFPEAK' or 'ONPEAK' auction.

9

Bid MW

MW

The MW quantity of the bid.

10

Bid Price

$/MW

The bid price in $/MW

11

Bid Status

String

Whether the bid was 'CLEARED' or 'DENIED.'

12

Masked Customer ID

Number

Participant, masked by a unique, consistent identifier.

  Copyright ©2014 ISO New England Inc.