Argus Data - Documentation
Argus provides the following subscriber documentation files for new style CSV format:
- latestCodes.csv – A list of all commodities Argus publishes or has published with their properties such as publishing frequency, timing information, measurement units, etc. The code is a basic assessment descriptor and it does not include any information about types of datapoints assessed for a commodity, or when those assessments are made, etc.
- latestModules.csv – The list of modules Argus publishes with their descriptions, short names and locations.
- latestPricetype.csv – A list of descriptors that clarifies the type of value published, for example High, Low, Average etc. Also known as PriceType or PT.
- latestTimestamp.csv – List of time periods Argus publishes its assessments. Also known as TimeStamp or TS.
- latestQuotes.csv – A list of all Code-TS-PT-CFWD(CFWD = continuous forward - explained below) combinations Argus ever assessed with their start and end dates and other parameters. In conjunction with date that combination represents a unique datapoint key.
- latestModuleDetails.csv – describes the content of each module in a form of Code-TS-PT-CFWD combination (note, that it is possible to have daily and weekly, weekly and monthly, etc published data within one module, so not every csv file contains all assessments only when they are due).
- latestCategory.csv – A list of all codes mapped to their specific categories, displayed in a tree format.
- latestDoc.csv – A combined list of all the documentation above in a decoded format.
The relationships between tables are shown here
DATA CSV file format
The CSV data files contain considerably more information than only name, date, value and a timestamp for each assessment. The extra information relates to the timing of the assessment and the basis from which it is priced. For example, Argus North Sea Dated is calculated from a forward month North Sea the csv file will include data to say which month it is priced from. Some series are both forward prices and based on another series and the csv file will have all this timing information.
In addition (using the same example), all North Sea months (currently there are four Argus forward North Sea months) are given the same code, so the csv file has a "continuous forward" field. The continuous forward value holds the sequence number of each forward period. For example, Argus posts North Sea month 1, North Sea month 2, North Sea month 3 and North Sea month 4 prices the forward period might be 10,11,12,1 (Oct, Nov, Dec, Jan) but the continuous forward periods will always be 1,2,3,4 for 1st, 2nd, 3rd and 4th month.
Used in conjunction with the date, the forward period and continuous forward fields allow for databases to extract data by effective month, ie August or by First month depending on what the user requires. The Year allows these fields to be used to produce an August 2003 query.
A final field indicates whether a data record is new or a correction. This allows Argus to place corrections into a regular daily data file along side the new data. This allows user to access new data and corrections in one download, which should ensure that user databases are kept as up to date as the Argus master database.
Example of CSV file:
- Code,TS Type,PT Code,Date,Value,Fwd Period,Diff Base Roll,Year,Cont Fwd,Record Status
- PA0001723,6,1,06-JUN-2006,68.19,0,7,2006,0,N
- PA0001723,6,2,06-JUN-2006,68.25,0,7,2006,0,N
- PA0001723,6,3,06-JUN-2006,-1.800,0,7,2006,0,N
- PA0002654,6,1,06-JUN-2006,68.62,6,0,2006,1,N
- PA0002654,1,1,06-JUN-2006,70.28,6,0,2006,1,N
- PA0002654,1,2,06-JUN-2006,70.36,6,0,2006,1,N
- PA0002654,6,2,06-JUN-2006,68.72,6,0,2006,1,N
- PA0002654,1,1,06-JUN-2006,71.36,7,0,2006,2,N
- PA0002654,6,1,06-JUN-2006,69.99,7,0,2006,2,N
- PA0002654,6,2,06-JUN-2006,70.05,7,0,2006,2,N
- PA0002654,1,2,06-JUN-2006,71.42,7,0,2006,2,N
- PA0002654,6,1,06-JUN-2006,71.32,8,0,2006,3,N
- PA0002654,1,1,06-JUN-2006,72.42,8,0,2006,3,N
- PA0002654,1,2,06-JUN-2006,72.50,8,0,2006,3,N
- PA0002654,6,2,06-JUN-2006,71.42,8,0,2006,3,N
- PA0002654,1,1,06-JUN-2006,73.13,9,0,2006,4,N
- PA0002654,6,1,06-JUN-2006,72.09,9,0,2006,4,N
- PA0002654,6,2,06-JUN-2006,72.17,9,0,2006,4,N
- PA0002654,1,2,06-JUN-2006,73.21,9,0,2006,4,N
- PA0002654,1,1,05-JUN-2006,70.43,7,0,2006,1,C
- PA0002654,1,2,05-JUN-2006,70.49,7,0,2006,1,C
Note: the first line contains the field headings.
Code - column 1
A character string field. This is the identifier of the commodity. The identifier links to the codes description table giving information such as commodity, units, etc.
For example: PA0002654
Code: PA0002654
DisplayName: North Sea month
DeliveryMode: fob
Unit: US dollars per barrel
Timing: Month
ForwardPeriodDescription: month value
Frequency: daily
Time Stamp Type - column 2
A numerical integer field. TS (Time Stamps) Type is the time at which the assessment is fixed, the value is an identifier which is assigned to a specific time. A Code can have multiple time stamps, for example Argus produces North Sea month crude assessments at London midday and London close (Please refer to the relevant methodology for exact time values). By using one code and multiple time stamp modifiers all the data (in this example North Sea Dated) is kept together. Download the list of Time Stamps
Price Type Code - column 3
A numerical integer field. PT (Price Type), is an identifier that describes the type of price that the assessment is. A Code can have multiple Price Types, for example Argus produces North Sea Dated crude assessments for Bid, Ask and Midpoint. By using one code and multiple price type modifiers all the data (in this example North Sea Dated) is kept together. Download the list of Price Types
Date - column 4
A date field in DD-MMM-YYYY format. A self-explanatory field - the assessment date.
Value - column 5
A non-integer numerical field. This is the assessment value, again a self-explanatory field. The code description table describes the units of this value.
Forward Period - column 6
A numerical integer field. The Forward (Fwd) Period, (sometimes referred to as delivery period) describes the period of time the assessment applies to. The value of this field can represent years, months, weeks, days depending on the definitions in the codes.csv file.
Diff Base Roll - column 7
A numerical integer field. The Differential (Diff) Base Roll is primarily a field used by crude assessments (but not exclusively) that are assessed relative to another crude (or commodity if not a crude). Argus North Sea Dated is a crude assessment that is assessed relative to a forward month of North Sea forward months series. To be able to keep track of the basis month the Diff Base Roll stores the month value. Diff Base Roll are month values in range 1 to 12.
Year - column 8
This is the effective year of the assessment. If the series is a prompt or dated price then the year is the same as the year of the assessment date in column 4. If the series is for a forward delivery or future price, or even, previous time period, then this year value is for the actual year of the forward period. In the sample file above there are 10 rows of data for code PA0002731, which is Natural gas Bacton forward months. This represents 2004 at the moment because the prices are for Feb 2004 through to June 2004. Around August, the data might look like:
- Code,TS Type,PT Code,Date,Value,Fwd Period,Diff Base Roll,Year,Cont Fwd,Record Status
- PA0002731,6,1,17-AUG-2004,29.6,9,0,2004,1,N
- PA0002731,6,2,17-AUG-2004,29.8,9,0,2004,1,N
- PA0002731,6,1,17-AUG-2004,23.4,10,0,2004,2,N
- PA0002731,6,2,17-AUG-2004,23.6,10,0,2004,2,N
- PA0002731,6,1,17-AUG-2004,21.6,11,0,2004,3,N
- PA0002731,6,2,17-AUG-2004,21.8,11,0,2004,3,N
- PA0002731,6,1,17-AUG-2004,18.85,12,0,2004,4,N
- PA0002731,6,2,17-AUG-2004,18.95,12,0,2004,4,N
- PA0002731,6,1,17-AUG-2004,18,1,0,2005,5,N
- PA0002731,6,2,17-AUG-2004,18.1,1,0,2005,5,N
or tabulated for better representation:
| Code |
TS Type |
PT Code |
Date |
Value |
Fwd Period |
Diff Base Roll |
Year |
Cont Fwd |
Record Status |
| PA0002731 |
6 |
1 |
17-AUG-2004 |
29.6 |
9 |
0 |
2004 |
1 |
N |
| PA0002731 |
6 |
2 |
17-AUG-2004 |
29.8 |
9 |
0 |
2004 |
1 |
N |
| PA0002731 |
6 |
1 |
17-AUG-2004 |
23.4 |
10 |
0 |
2004 |
2 |
N |
| PA0002731 |
6 |
2 |
17-AUG-2004 |
23.6 |
10 |
0 |
2004 |
2 |
N |
| PA0002731 |
6 |
1 |
17-AUG-2004 |
21.6 |
11 |
0 |
2004 |
3 |
N |
| PA0002731 |
6 |
2 |
17-AUG-2004 |
21.8 |
11 |
0 |
2004 |
3 |
N |
| PA0002731 |
6 |
1 |
17-AUG-2004 |
18.85 |
12 |
0 |
2004 |
4 |
N |
| PA0002731 |
6 |
2 |
17-AUG-2004 |
18.95 |
12 |
0 |
2004 |
4 |
N |
| PA0002731 |
6 |
1 |
17-AUG-2004 |
18 |
1 |
0 |
2005 |
5 |
N |
| PA0002731 |
6 |
2 |
17-AUG-2004 |
18.1 |
1 |
0 |
2005 |
5 |
N |
For the last two rows, the year has rolled around to 2005. This is because the Forward Period of this price is now 1 (January) for this code, which takes the Forward Period into the next year (2005).
Cont forward - column 9
Closely related to the Forward Period and year is the cont (continuous) period. Continuing the example from above, the code PA0002731 has 10 rows of data. There are five pairs of data. The differencies between each pair are the price types, values, forward periods and continuous periods. The Price Types indicate that these are bid/ask pairs. The Forward Periods indicate that these are for months September through to January. The continuous periods show that these are month 1, month 2, month 3, month 4 and month 5 forward prices.
Status - column 10
The status flag indicates if the price is a new data point or a corrected data point. The values are either “N” for new, “C” for correction or “H” for historically corrected data (see below). Corrections sometimes provide data which was omitted previously. This flag highlights that the data is extra to the normal daily data because of a previous problem with that particular record. The flag can be used to locate an existing record to overwrite the data as long as a failed “search” does not stop a new record being created from the correction.
Argus continually cleans and audits its time series data and corrects discrepancies when they are discovered. If the data is “old” (i.e. after 6 months) then no new correction would normally be issued, unless the number was a significant index such as “North Sea Dated” on which a large number of other prices are based. Argus may issue corrections for “old” data at its discretion.
Argus provides the following subscriber documentation files for old style (G-code) format:
The spreadsheets may contain conversion factors as follows:
- Conversion 1 is factor to convert to $/barrel
- Conversion 2 is factor to convert to $/tonne
- Conversion 3 is factor to convert to $/US gallon
DATA G-code file format
The files are in standard ASCII space delimited whose format is four columns; code (ticker, instrument), date, price (assessment), time stamp. The code is a unique identifier for each price assessment, high or low.
Example of G-code file:
- GC012$1$L 20MAY1994 16.35 12:00HRS
- GC012$1$H 20MAY1994 16.38 12:00HRS
- GC013$1$L 20MAY1994 14.95 12:00HRS
- GC013$1$H 20MAY1994 15.00 12:00HRS
- GC234$1$L 20MAY1994 17.15 18:30HRS
- GC234$1$H 20MAY1994 17.25 18:30HRS
- GC012$2$L 20MAY1994 16.29 12:00HRS
- GC012$2$H 20MAY1994 16.30 12:00HRS
Note: consecutive delimiters are treated as one.