|
Overview
|
|
In order to provide the most immediate and versatile access to the industry’s most important data, PIRA has launched the DOE Weekly Petroleum Data web portal. Updated every Wednesday (Thursday if preceded by a Monday holiday) after the DOE releases its "Weekly Petroleum Status Report," the portal provides historical and current data sets conveniently bundled into reports, tables, and charts for immediate access and ready reference. Through the portal’s highly functional, yet easy-to-use interface, this wealth of data can also be queried, allowing users to create their own customized data series, which in turn can be easily charted or exported into a variety of formats. Whether through its pre-defined reports or user-customized data sets, the DOE Weekly Petroleum Data portal gives users the necessary tools to conduct their own analysis and identify trends as they emerge.
|
|
|
A Value-Added Service
|
|
The Weekly Petroleum Data portal is
not merely a convenient way to access and format the
DOE data — which is available to the public in TXT,
CSV, and XLS formats on the DOE Website. PIRA has
created a tool that guides users toward mining the
right data in the most efficient
manner in order for them to conduct the kind of
analysis that PIRA itself does when creating its
Weekly DOE Analysis
report. With a click of the mouse, the user can launch a concise report that PIRA deems critical to
have.
|
|
|
|
Weekly
Crude Oil Balance Table (in
HTML)
|
|
|
Furthermore, analysts who now manually download
file after file and painstakingly manipulate the data
will be able to create the exact report they like
— in the desired format — in a matter of seconds.
And finally, PIRA has captured and stored all this
data into a queriable archive (to 1982), allowing
quick analysis of week-on-week, month-on-month, and
year-on-year trends.
If your company relies on DOE data as the foundation to understanding and forecasting U.S. oil markets, PIRA’s DOE Weekly Petroleum Data portal is a must have.
|
|
|
Top
|
|
|
|
Components of the PIRA DOE Weekly Petroleum Data Portal
|
|
The portal is divided into 5 sections:
|
|
1. Crude and Product Balances
|
|
In this section, users can view latest weekly crude and product supply/demand balances for the U.S. These balances provide an effective road map to estimate and anticipate run levels and import/exports, creating a basis to view the impact of increasing, or decreasing, product demand in the U.S. Ultimately, inventory levels drive relative prices, and these are determined by the balances.
The data categories in this section include:
|
|
|
|
|
|
-
Exports
-
Products Supplied
|
|
|
|
|
2. Six-Year Comparison Reports
|
This section provides ready-made or user-defined data tables that create a snapshot of six-year actuals as well as week-on-week and year-on-year data comparisons. The tables offer a quick way for users to see emerging trends and seasonal patterns on a multitude of products and locations. It is divided into two sub-sections: Standard and Custom. The Standard sub-section provides PIRA-defined tables; the Custom sub-section allows the user to aggregate products and locations.
|
Six-Year Comparison Reports include DOE weekly data for:
|
-
Total Commercial Stocks
- Commercial Stocks, by
PADD
-
Crude and Four Major Products Stocks
-
Total Products Stocks
-
Crude Oil Commercial Stocks, by PADD
-
Distillate Stocks
-
Distillate Stocks, by PADD
-
Distillate Stocks for Central Atlantic
-
Distillate Stocks for Lower Atlantic
-
Distillate Stocks for New England
-
Total Gasoline Stocks, by PADD
-
Gasoline Blending Components Stocks
-
Reformulated Gasoline Stocks, by PADD
-
HS Distillate Stocks, by PADD
-
LS Distillate Stocks, by PADD
-
Jet Kerosene Stocks
-
Residual Fuel Oil Stocks
-
Unfinished Oils Stocks
-
Products Supplied
-
Products Four Major Products Supplied
-
Finished Gasoline Products Supplied
-
Distillate Products Supplied
|
- Jet Kerosene Products Supplied
-
Residual Fuel Oil Products Supplied
-
Other Products Supplied
-
Crude Oil Commercial Imports
-
Finished Gasoline Imports
-
Reformulated Gasoline Imports
-
Gasoline Blending Components Imports
-
Total Gasoline Imports
-
Distillate Imports
-
Jet Kerosene Imports
-
Residual Fuel Oil Imports
-
Crude Oil Refinery Inputs
-
Crude Oil Days Supply Forward Cover
-
Gasoline Days Supply Forward Cover
-
Distillate Days Supply Forward Cover
-
Residual Fuel Oil Days Supply Cover
-
Jet Kero Days Supply Forward Cover
-
Four Major Products Days Supply Cover
-
Gasoline Yields on Crude (%)
-
Distillate Yields on Crude (%)
-
Residual Yields on Crude (%)
-
Jet Kero Yields on Crude (%)
|
|
|
3. Standard Reports
|
|
This section includes four standard PIRA-prepared reports that use key DOE data to provide instant statistical analysis — conveniently formatted — of market-moving trends, saving users valuable time.
The four reports in this section include:
|
- Summary of DOE Weekly Statistics — Provides latest four weeks of data and four-week averages (current and year-ago) for refinery input and output, stocks, imports, and yields. This table appears in PIRA’s DOE Weekly Analysis report.
- DOE Weekly Major Product Stocks — Detailed breakdown, by location, of motor gasoline, reformulated gasoline, distillate, jet
kero, and residual fuel oil.
- DOE Weekly Petroleum Production, Crude Runs and Yields — Broken down by
PADD.
- DOE Weekly Commercial Crude Oil Cumulative Stock Change — Provides the cumulative stock change through an itemization of production, imports,
SPR, and crude runs.
|
|
4. Weekly Charts
|
|
Similar to the Six-Year Comparison section, the Weekly Charts section provides a convenient interface to create either ready-made or user-defined charts that graph the yearly trend, and how that trend compares to the prior year and to a five-year range. It is divided into two sub-sections: Standard and Custom. The Standard sub-section contains PIRA’s predefined charts selection for key data segments, with the user able to determine
which is the base year. The custom sub-
|
|
|
|
Custom-Made Chart
|
section allows the user to aggregate products and
locations and determine the type
of chart.
|
Create a custom chart by…
|
|
Choosing a category…
|
then product(s)…
|
and location(s)…
|
|
Closing Commercial Stocks
|
Crude Oil
|
Central Atlantic
|
|
Closing Government Stocks
|
Distillate Fuel Oil
|
Lower Atlantic
|
|
Days Supply Forward Cover
|
Distillate Fuel Oil by Type
|
New England
|
|
Exports
|
Jet Fuel Kerosene
|
PADD I
|
|
Field Production
|
Jet Kero - Commercial
|
PADD II
|
|
Imports: Commercial
|
Jet Kero - Military
|
PADD II - Cushing, OK
|
|
Imports: Government
|
Motor Gasoline, by Type
|
PADD III
|
|
Imports: Net
|
Other Oils (API)
|
PADD IV
|
|
Imports: Total
|
Other Products
|
PADD IV-V
|
|
Inputs: Refinery
|
Propane/Propylene
|
PADD V
|
|
Operable Capacity
|
RFO: Residual Fuel Oil
|
Total U.S.
|
|
Product Supplied
|
Total Product and Crude
|
|
|
Refinery Net Output
|
Total Products
|
|
|
Refinery Yields
|
Unfinished Oils
|
|
|
5. Data Query Analyzer
|
|
This section gives DOE Weekly Petroleum Data portal users timely and convenient access to constantly updated weekly data as well as charting, aggregation and “drill-down” capabilities. User-defined queries can generate data tables for any category, product, location — or combination of them — for any date. Flexibility in data retrieval allows the user to view the requested information for that date over history in order to examine historical market structure and relationships.
The Data Query Analyzer section is divided into three subsections:
|
- Aggregate by PADD - This subsection allows users to create, for a particular category and product(s), an aggregated total across any combination of PADDs.
For example:
Total commercial imports of crude oil and distillate fuel oil in PADDs I, II, and III.
- Aggregate by Product
- This subsection allows users to create, for a particular category and location(s), an aggregated total across any combination of products.
For example:
Closing commercial stocks in PADDs IV and V of jet fuel and motor gasoline.
- Drill Down - This section allows users to “drill down” within all available data categories for a specific time period. Data are conveniently structured by individual category, product and location.
For example:
Refinery inputs of crude oil from the week of May 6, 2005, to the week of July 1, 2005, by region.
|
|
|
|
|
|
Top
|
|
|
Options for Purchasing the DOE Weekly Petroleum Data Portal
|
|
The DOE Weekly Petroleum
Data portal is available on
an annual subscription basis
and can be purchased on a
single-user or multi-user
basis. Discounts are offered
to PIRA Global Oil Retainer
Clients and to clients of
PIRA’s Oil
Products Trading Analyzer
Go to the Acceptance Form
for more information.
Contact your PIRA representative for a
live online demonstration.
|
