Home

Market Data

Contents

1. mal A B C D E F G H I J K L M N O P Q i S a 12 28 2013 2014 by McGraw Hill Financial Inc 2 DSP Trans Symbol Bates Freq Curr UOM DEC Conv s7 To_UOM Earliest Latest Description 3 BA AAGQ0O00 chl MA USD MT 3 6 35 BBL 2 1 2001 11 1 2013 Bunker FO 380 CST 3 5 Divd New York MAvg 4 BA AASUBOO chi DW USD MT 3 6 35 BBL 6 1 2010 12 27 2013 Bunker FO 180 CST 1 0 Divd Antwerp 5 BA AARTEOO chi DW USD MT 3 6 35 BBL 2 1 2010 12 27 2013 Bunker FO 180 CST 1 Dlvd Piraeus 6 BA AASUNOO chl DW USD MT 3 6 35 BBL 6 1 2010 12 27 2013 Bunker FO 180 CST 1 0 Divd Dunkirk 7 BA AARUBOO chi DW USD MT 3 6 35 BBL B nn 12 27 2013 Bunker barging rate Philadelphia 8 BA AAWTKOO chi DW USD MT 3 6 35 BBL 6 1 2012 12 27 2013 Bunker FO 380 CST 1 0 Divd Seattle 9 BA AARSSOO chi DW USD MT 3 6 35 BBL 2 1 2010 12 27 2013 Bunker FO 180 CST 1 Dlvd Gibraltar 10 BA PUADYOO chi DW USD MT 3 6 35 BBL 1 7 1986 12 27 2013 Bunker FO 180 CST 3 5 Dlvd Suez 11 BA AAXCZ00 chi DW USD MT 3 2 1 2013 12 27 2013 Bunker FO 380 CST 1 Dlvd Algeciras 12 BA PUAEOOO chi DW USD MT 3 6 35 BBL 7 2 1991 12 27 2013 Bunker FO 380 CST 3 5 Ex Wharf French Med 13 BA AAIAUOO chi MA USD MT 3 6 35 BBL HiH 11 1 2013 Bunker FO 380 CST 3 5 Ex Wharf Vancouver MAvg 14 BA PUABTO3 chi MA USD MT 3 6 35 BBL 7 1 1991 11 1 2013 Bunker FO 180 CST 3 5 Ex Wharf Dunkirk MAvg A transaction indicator in the second column marks symbols that have descriptive informat
2. 2015 by McGraw Hill Financial Inc PLATTS McGRAW HILL FINANCIAL Market Data User Guide Important notice Release 4 1 2 reflects the following change 1 Updated section 2 2 with details about addition of 24 M2MS data categories to EARLY_PNG cut Release 4 1 2 October 2015 Summary of Changes Release 4 1 2 e Updated section 2 2 with details about addition of 24 M2MS data categories to EARLY PNG cut Release 4 1 1 e Updated the Market Data Schedules tables e Included a new cut time for Early M2MS at 6 15pm Release 4 1 0 e Revised header section reflecting the updated year of the copyright notice e Updated corporate branding throughout the document by changing it to McGraw Hill Financial Inc e Edited out IMSFTP content e Updated Assessment frequency table in section A 2 e Updated Appendix section B 1 by updating extended category discontinue notice removed section B 2 Market Data Category Codes list and included column headings in section B 3 Release 4 0 1 4 0 9 e Introduction of the new 3 character Market Data Categories e Affected sections Contents Platts Market Data via FTP Platts Market Data via IMSFTP Platts Market Data csv files via www platts com General Market Data File Notes Appendix B 1 Introduction Appendix B 4 CSV Format Instructional Guide Market Data Category Codes Release 3 0 3 e Removed no longer needed detail from the Summary of Changes section e Removed unnecessary
3. while the remaining 24 correspond to M2MS 10 and 20 Year Power and Natural Gas forward curves This cut is provided to allow subscribers to access this data closer to the time it is first published versus having to wait until 6 45pm for DP EB GM and GN categories or 6 15pm or later cuts for 24 M2MS data categories The 6 15pm Early M2MS cut also includes updates for the same 24 M2MS market data categories referenced above For a detailed description of these categories please see Appendix B The 8 45pm and 11 45pm M2MS Backup cuts include updates for 66 market data categories These cuts provide a backup in the event that the daily M2MS prices are not available or updated in time for the 5 35pm Early Power Natgas 6 15pm Early M2MS 6 45pm N AMER PM FTP and CSV or 7 45pm Final FTP and CSV cut The 12 45am Early Flow Date cut includes updates only for categories for which Platts regularly publishes future dated prices For more information on this cut see 2 5 3 4 and 4 3 Market Data price files include transaction indicators new change etc However the best way to ensure that your database always reflects the latest prices from Platts is to follow these two rules If you use files from more than one market data cut either for a given day or over several days always process them in order Regardless of any transaction indicator in the file if you don t have a given price defined as a symbol bate date comb
4. 201312190000 201312190000 201312190000 201312190000 15 04 14 14 14 14 14 14 14 14 14 do 15 14 14 14 15 18 In addition to price files descriptive information on all the symbols in every market data category can also be retrieved from ftp platts com There are two ways to obtain this information in the form of symbol list files updated each weekend for all data categories e Login using your subscriber Userid and choose the symbols folder as described above or e Log into the Platts FTP site anonymously 10 Session Properties General Startup Advanced Firewall Profile Name Platts Anonymous vi New Host Name Address tp platts com Delete Host Type UNIX standard vi User ID anonymous Iw Anonymous Password lany password Save Pwd Either approach brings you to the root folder where the symbols folder is located Remote System papa 20110410 06 04 This folder contains a text file with a sym extension for each active market data category including ones you may not subscribe to Similar to price files each sym files contains descriptive information for all the symbols in that data category Remote System mm synbols 20110410 06 04 20110410 06 04 20110410 06 04 B E D E FE JG Fi KE K L M N O P a R 12 28 2013 2014 by McGraw Hill Financial Inc 2 DSP Trans Symbol Bates Freq Curr UOM DEC Conv si To UOM Earliest
5. Platts price reporters monitor trading activity in petroleum natural gas petrochemicals power metals and other markets worldwide They collect information on market activity and use standard methodologies to prepare price assessments and indexes Platts also collects price statistical and other data directly from government agencies companies energy traders and exchanges and other 3 party sources Currently 75 80 000 price values update on a typical weekday rising to 120 000 during monthly peak periods Platts identifies market data price values by a 7 character symbol a 1 character bate value type indicator high price low price closing price volume etc and an assessment as of date Prices distributed each day may include current day or prior day prices being published for the first time as well as corrections to previously published prices Symbols are grouped into Market Data categories based on their product and or regional characteristics Examples include Lubricants worldwide US power European petroleum products and 150 others A market data category is the smallest standard package available to Platts price data subscribers For a current list of available market data categories choose Symbol Search Price Symbol amp Page Directories from the Methodology amp Reference menu illustrated above and then under the Symbol Directories tab see the following directions link For dire
6. 00 01 3506 20110416 00 01 24504 Ej cm i co bd gt Jesftp WordPad zb Home View KE 2014 by McGraw Hill Financial Inc PlattsMarketData 201401021541 00104 ASIA cS 20140102 AACQIOOc 201401020000 0 49 AACQIOOh 201401020000 0 47 AACOI001 201401020000 0 51 AACUE001 201401020000 124 67 AACUEOOh 201401020000 124 71 AACUEOOc 201401020000 124 69 AACZFOOc 201401020000 123 19 422222242 If the contents of an FTP market data file appear garbled Z 05P9247 tp Notepad VE ffe Gem Mer le File Edit Format View Help 2014 by McGraw Hill Financial Inc PlattsMarketData 201312200441 00064 FINAL ALD 20131219N GBCLPO1c 201312190000 15 04 N GDCLRO4c 201312190000 17 74N JBCLPO1c 201312190000 15 69N JBCLPO2c 201312190000 15 38N JBCLPO3c 201312190000 14 95N JBCLPO4 you may need to select the ASCII option in your FTP client software to adjust the format as you download it Auto B Kari File Edit Format View Help 2014 by McGraw Hill Financial Inc PlattsMarketData 201312200441 00064 FINAL ede a de Ne sie sie sir bie lg Ar ar sih aje dar GBCLPO1c GBCLPO2c GBCLPO3C GBCLPO4c GBCLPO5c GBCLP06C GBCLPO7C GBCLPO8c GBCLPO09c GBCLP10c GBCLP11C GBCLP12c GBCLROLC GBCLRO2c GBCLRO3c GBCLRO4c GDCLPO1c 201312190000 201312190000 201312190000 201312190000 201312190000 201312190000 201312190000 201312190000 201312190000 201312190000 201312190000 201312190000 201312190000
7. 15pm reflect updates since 7 40pm that day 12 45am files in the postclose folder reflect updates since 7 40pm the previous weekday also see 2 5 for further information about files in this cut 22 2 4 Market Data csv Notes The regular postclose difference does not apply to Market Data csv files The links in the Latest CSV column at www online platts com always point to the latest data for that data category or newsletter bundle Updates in a given csv file reflect all symbol and date combinations where one or more prices have updated or been deleted since 7 40pm the preceding weekday With two exceptions Market Data csv files reflect the same update transactions as Market Data FTP text files for the same cut The exceptions e Market Data csv files include all prices for the symbol date specified even if only some of them have updated or been deleted E g if Platts published high low values for a given symbol yesterday and then corrects the high value today today s csv file would show both the corrected high and original low values FTP users would receive only the corrected high value e Unlike the 10 15pm postclose FTP files Market Data csv files delivered at 10 15pm reflect an Extended Final cut they contain all the data from the Final cut plus any additional updates which occurred between 7 40pm and 10 10pm that day Since most subscribers will access these files the following day this insur
8. 3 1 Introduction Platts Market Data FTP text files consist of a 2 line header followed by individual data records for each price added changed or deleted in the Platts price database during the period covered by a given market data cut see 2 1 for details on cut times etc Data records consist of a transaction code followed by the 7 character symbol the bate price type the assessment date a price value and for corrections and deletions a transaction timestamp GMT Assessment and transaction dates are in yyyymmddhhmm format with hh in 24 hour or international style e g 2am displays as 02 2pm as 14 Prices are left justified FTP files may contain N New F Future dated C Change D Delete and X no price today entries as described below Market Data FTP files are space delimited text files with ftp extensions With one exception they are fixed format files each data item on a line is in a fixed column position The exception is the update timestamp in C and D records which is separated from the price value by a single space since price values are not all the same width the position of the timestamp will vary As indicated above and described in detail below Market Data price files include transaction indicators new change etc However the best way to insure that your database always reflects the latest prices from Platts is to follow these two rules e If you use fi
9. 3 28 2014 by McGraw Hill Financial Inc Trans Symbol Description Currency UOM Date Low 1 High h Close c Index u Prev VolG Volume v Bid b Ask a Open o Prev Opn Int e Mean m AAPJZOO Jet Kero MOPS strip USD BBL 12 3 2013 126 91 126 95 126 93 PJACUOO Jet Kero FOB Spore vs Jet Kero MOPS strip USD BBL 11 22 2013 0 44 0 48 0 46 AAXNBOO Gasoil 25 S 2500ppm FOB Spore Cargo mt USD MT 12 18 2013 927 898 928 196 928 047 PGAEZOO Gasoline Un 95 FOB Spore Cargo USD BBL 12 4 2013 118 23 118 27 118 25 AAPJYOO Gasoil MOPS strip USD BBL 12 24 2013 125 83 125 87 125 85 PJABFOO Jet Kero FOB Spore Cargo USD BBL 12 19 2013 125 57 125 61 125 59 PJACUOO Jet Kero FOB Spore vs Jet Kero MOPS strip USD BBL 12 31 2013 0 31 0 35 0 33 PGAEYOO Gasoline Un 92 FOB Spore Cargo USD BBL 12 9 2013 116 38 116 42 116 4 As with daily Market Data csv files csv history files are designed for direct use in desktop applications such as spreadsheets 40 zid 9 e E NS histcsv Microsoft Exee Home Insert Page Layout Formulas Data Review View e D ve je A B D E F G H J K L M N ES CS FINAL 1 1 2014 1 2 2014 3 28 2014 by McGraw Hill Financial Inc I 2 Trans Symbol Descriptio Currency UOM Date Low l High h Close c Index u Prev Vol w Volume v Bid b Askla 3 AAPJZOO Jet Kero M USD BBL 12 3 2013 126 91 126 95 126 93 4 PJACUOO Jet Kero FC USD BBL 11 22 2013 0 44 0 48 0 46 5 AAXNBOO Gasoil 255 USD MT 12 18 2013 927 898 928 196 928 047 6 PGAEZO
10. File Notes Although Platts makes every effort to provide price updates at consistent times we cannot and do not guarantee the market data cut in which any given price will be delivered to subscribers Our goal in each cut is to deliver as many prices to subscribers as early as possible If a price update is delayed to ensure accuracy due to market volatility or for any other reason it will be delivered as soon as possible in a later cut Market Data price files are cumulative and are rebuilt for each cut they are complete replacements for the files in any earlier cut that day In particular if a price is published ina given cut and corrected later that day files in later cuts will reflect the correction Each market data cut includes updated files for all active data categories except Early Power Natgas 5 35pm 5 30pm EARLY_PNG Early M2MS 6 15pm 6 10pm N_AMER_PM M2MS Backup 1 8 45pm 8 40pm FINAL M2MS Backup 2 11 45pm 11 40pm FINAL Early Flow Date 12 45am 12 40am N_AMER_AM The 5 35pm Early Power Natgas cut include updates for 28 market data categories DP EB GM GN ADC EDC FDC GDC JDC MDC ODC PDC RDC SDC UDC WDC AMC EMC FMC GMC JMC MMC OMC PMC RMC SMC UMC WMC The first four market data categories correspond to European bulk product assessments monthly natural gas assessments and daily power and natural gas forward prices which frequently update shortly after the cutoff for the 3 45pm cut
11. MT 3 6 35 BBL 2 1 2010 12 27 2013 Bunker FO 180 CST 1 Divd Gibraltar 10 BA PUADYOO chi DW USD MT 3 6 35 BBL 1 7 1986 12 27 2013 Bunker FO 180 CST 3 5 Dlvd Suez 11 BA AAXCZ00 chl DW USD MT 3 2 1 2013 12 27 2013 Bunker FO 380 CST 1 Dlvd Algeciras 12 BA PUAEOOO chi DW USD MT 3 6 35 BBL 7 2 1991 12 27 2013 Bunker FO 380 CST 3 5 Ex Wharf French Med 13 BA AAIAUOO chi MA USD MT 3 6 35 BBL HHHH 11 1 2013 Bunker FO 380 CST 3 5 Ex Wharf Vancouver MAvg 14 BA PUABTO3 chi MA USD MT 3 6 35 BBL 7 1 1991 11 1 2013 Bunker FO 180 CST 3 5 Ex Wharf Dunkirk MAvg the entries in row 10 columns F G and I K indicate that prices for symbol PUADY00 are expressed in US metric ton to convert these prices to US barrel the price should be divided by 6 374 Conversion factors are provided only for the most commonly used volume weight conversions arithmetic volume volume and weight weight conversion factors e g 42 gallons barrel are not included 34 As illustrated in 1 2 the symbols csv version folder on the FTP site also includes a file data_category_descriptions csv which lists all the currently active market data categories and their descriptions A B C D E F Pas Platts Market Data Categories as of 03 January 2014 2 BF Agriculture Biofuels BX Agriculture Biofuels Non Platts Data SG Agriculture Sugar SY Agriculture Sugar Freight SP Agriculture Sugar Non Platts Data BA Bunkers CON DO UW B W 3 2 3 This Week Symbol Fil
12. provide one other set of information which may be useful These directories are the only place subscribers can obtain direct access to lists of discontinued symbols e g here are the directories for Natural Gas symbol Search Price Symbol and Page Directories Platts symbol directories list Platts time series price codes and related descriptive information grouped by commodity and data category Page directories provide a page guide to Platts real time news and alert Senices e Symbol Search a Symbol Directories a Page Directories Symbol Search Symbol Directories Page Directories symbol Directories Platts symbol directories are updated every one to two months in spreadshegt form Please check the new code announcements page for any new symbols added in the interim Symbol lists in a text and comma delimited format updated weekly are also available via anonymous login at on our FTP site Directories Active Discontinued Matural Gas 5 MB MB Mh Gas 13 MB 3 MB For directions on how to use Platts symbols directories and for other sources of information on Platts symbols click here When Platts symbols permanently stop updating for any reason they are moved to a discontinued data category There are a few legacy discontinued categories e g OZ for some 36 discontinued oil symbols However most discontinued symbols are moved to specific categories based on the active category they were originally assigned t
13. so the file opens directly in that application Al v f CS g MR po VE VG J K L M N o CS JASIA 1 2 2014 2014 by McGraw Hill Financial Inc 2 Trans Symbol Descriptio Currency UOM Date Low l High h Close c Index u Prev Vol w Volume v Bid b Askla Open o 3 N PJABFOO Jet Kero FC USD BBL 1 2 2014 126 17 126 21 126 19 4 N PHALFOO MTBE FOB USD MT 1 2 2014 1122 1124 1123 5 N PGAMSOO Gasoline L USD BBL 1 2 2014 124 24 124 28 124 26 6 N PGAEZOO Gasoline L USD BBL 1 2 2014 122 29 122 33 122 31 7 N PGAEYOO Gasoline L USD BBL 1 2 2014 118 61 118 65 118 63 8 N PAADCOO Naphtha F USD BBL 1 2 2014 1 05 1515 1 1 9 N PAAAPOO Naphtha F USD BBL 1 2 2014 108 37 108 41 108 39 10 N AAXEROO Gasoline L USD BBL 1 2 2014 0 4 0 44 0 42 11 N AAXFONN Gasoline I 1ISD RRI 1 2 2014 118 19 11223 118 21 Once the file is open all the facilities of the application are immediately available to work with the contents of the file For example to sort the file by symbol description you might choose Sort from the Data command on the toolbar and select column C 17 x id ile Home Inset Page Layout Formulas Data Review View vQ F 1 CS 1 2 2014 1 2 2014 15 40 2014 by McGraw Hill Financial Inc Trar mbo Description renc O ate C igh h close e ceu a x a lel 2 a copytevet gt optons Sorton o j sot The result Insert Page Layout Formulas Data Review View v o Home A1 EN Se MN NE M
14. the directions link For directions on how to use Platts symbols directories and for other sources of information on Platts symbols alae at http www platts com SymbolAndPageDirectories A 1 Bate Codes h High price u Index price or unspecified a Asked price o Opening price b Bid price c Close or Mean price e Previous day open interest KN II m Mean price rarely used SS A 2 Assessment Frequency Codes Assessment Frequency Assessment Frequency HOURLY INTRADAY MONTHLY BW SEMEWEEKLY OR QUARTERLY WEEKLY DAILY WEEKDAY YR YEARLY YEARLY S mr I A 3 Currency Codes 42 BOL BOLIVIAN BOLIVIANO N A Not Applicable gt BRL BRAZILIAN REAL NGN NIGERIAN NAIRA cac CANADIAN CENTS NuG DUTCH GUILDER CAD CANADIAN DOLLAR NOK_ NORWEGIAN KRONE gt CHF swiss FRANC NZD NEW ZEALAND DOLLAR CLP CHILEAN peso Jfomr OMANI RIAL O O CNY CHINESE YUAN PEN PERU INTI gt Cop COLUMBIAN peso PGK PAPAU NEW GUINEA KINA CYP Cyprus Pound pre 2008 PHP PHILLIPPINE PESO CZK CZECHOSLOVAKIA KORUNA PKR PAKASTANI RUPEE GERMAN MARK PEN POLISH ZLOTY gt QAR O DKK DANISH KRONE PORTUGUESE ESCUDO ALGERIAN DINAR QAR OATARI RIAL EUROPEAN CURRENCY UNIT BOL BRL CAC CAD CHP GLE CNY COP CEP DEM DEK SC SIP GIBRALTAR POUND THB THAI san GPE GERMAN PFENNIG TND TUNISIAN DINAR gt GRD GREEK D
15. the correction was made The corrected price would also appear in the final N entry published on April 11 3 5 C Change or Correction Entries 3 6 Market Data FTP files contain C entries only for prices dated and published before today and changed today C WEABF201 201104070000 16 8 201104081621 The prices in C Entries will always reflect the current price in the Platts database as of the cutoff as of time for the market data cut The update timestamp shows the time GMT the value was changed in the Platts database If there were multiple changes before the cutoff time the file will contain a single C entry with the price and timestamp from the latest one If a price is corrected more than once in a day the C entry for it will always reflect the last correction This means that it s possible although rare for a C entry in one ftp file for a given symbol bate date to have a different price than one in an earlier file the same day To insure you always have the most current price you should always process Market Data FTP files in order Note that C entries are not published for future dated prices see 3 4 3 7 D Delete Entries Market Data FTP files will contain D entries only for prices deleted today D ABCDEOOh 201104070000 25 4 201104081840 The timestamp will reflect when the delete was processed in the Platts database the price will show the value deleted If there are multiple deletes during the day ext
16. 0 974 50 O3Janld 7 89 123 48 7 250 987 00 987 50 O3Jan14 LO te PI Fa Fa VO CIF NWE Cargo lt PJAAUOO gt 8 7 8 25513 FOB Med Cargo lt AATIDLOO gt 60 750 960 50 961 00 O3Jani4 7 89 121 77 USD MI Asia Jet India lt AAQWMO0 gt 952 790 O6Janl4 7 9 120 61 South China lt PJABO000 gt 978 000 976 00 980 00 O6Janl4 7 9 123 80 USD Bb1 Asia Jet FOB S pore Cargo lt PJABF00 gt 122 470 122 45 122 49 N Janl4 122 47 MOPS Jet Strip lt AAPJZ00 gt 122 170 122 15 122 19 O6Janl4 122 17 Japan C F Cargo lt PJAANO00 gt 123 660 123 64 123 68 O06Janl4 123 66 Korea Cargo lt PJADGOO gt 122 420 22 40 122 44 N Janl4 122 42 FOB Arab Gulf lt PJAAAOO gt 120 240 120 22 120 26 06Jani4 120 24 LR2 FOB AG lt AAKNZ00 gt 120 640 20 62 120 66 O6Janl4 120 64 Australia lt AAFIYOO gt 127 230 127 21 127 2 O6Janl4 127 23 Cts Gal US Gulf Coast Jet Jet54 Water lt PJABMOO gt 291 760 291 71 291 81 O3Jani4 4 122 54 Jet55 Water lt PJABNOO gt 299 260 299 21 299 31 O3Janl4 4 125 69 ULS Kero Water lt AAVTKO00 gt 305 760 305 71 305 81 O3Jani4 4 126 42 Jet54 Pipe lt PJABO00 gt 290 510 290 46 290 56 O3Jani4 42 122 01 Jet55 Pipe lt PJABP00 gt 298 010 297 96 298 06 O3Jani4 42 125 16 ULS Kero Pipe lt AAVILOO gt 304 510 304 46 304 56 O3Jani4 42 127 89 3 3 Market Data Price History Files In addition to Platts subscription data services Market Data via FTP and the Platts website and realtime data via many vendor partners the Platts Custom
17. 1 2 2014 12 NatGas West WePermian BTRANSWESTERN PEFFDt DICt 3928393 TWP 6 N BGBAF21 Carthage UNS CON 1 2 2014 13 NatGas Central East Texa CARTHAGE HUB FDt DICt 3928287 CARTH 7 N BGBAL21 NGPL Tex UNS CON 1 2 2014 36 NatGas Central East Texa NGPL TEX OK ZONE FDtDICt 3928424 NGPLE 8 N BGBAN21 TX Easterr UNS CON 1 2 2014 1 NatGas East Gul East Texa TEXAS EASTERN E TEFDt DICt 3928384 TETEX 9 N BGBAO21 Texas Gas UNS CON 1 2 2014 17 NatGas Central East Texa TEXAS GAS ZONE 1 FDtDICt 3928387 TGTZ1 10 N BGBAP21 Houston SUNS CON 1 2 2014 11 NatGas Central East Hous Houston Shp Ch FDt DICt 3928336 SHIP 11 N BGBAQ21 Katy FDt C UNS CON 1 2 2014 sol NatGas Central East Hous KATY FDt DICt 3928338 KATY 12 N BGBAV21 Agua Dulc UNS CON 1 2 2014 4 NatGas Central South Corj AQUA DULCE HUB FDtDICt 3928406 AGUA 13 N BGBAW21 FL Gas Zn UNS CON 1 2 2014 7 NatGas East Gul Louisiana Florida Gas Zn 1 FDt DICt 3928334 FGTZ1 14 N BGBAZ21 NGPL S TXUNS CON 1 2 2014 7 NatGas Central South Corj NGPL S TEXAS FDt DICt 3928353 NGPLS 15 N BGBBA21 Tenn ZnO UNS CON 1 2 2014 42 NatGas East Gul South Cor TENNESSEE ZONE O FDt DICt 3928375 TNSTX 16 N BGBBB21 TX Easterr UNS CON 1 2 2014 6 NatGas East Gut South Corj TEXAS EASTERN S TEFDt DICt 3928385 TEXSX 17 N BGBBC21 Transco Zi UNS CON 1 2 2014 5 NatGas East Gul South Cori TRANSCO ZONE 1 FDtDICt 3928389 TRS30 e First note that because this is a power symbol column R commodity indicates Power column
18. 14 75 4 N BGBAD21 Waha FDt UNS CON 1 2 2014 64 5 N BGBAE21 Transwest UNS CON 1 2 2014 12 6 N BGBAF21 Carthage UNS CON 1 2 2014 13 7 N BGBAL21 NGPL Texc UNS CON 1 2 2014 36 8 N BGBAN21 TX Eastern UNS CON 1 2 2014 1 9 N BGBAO21 Texas Gas UNS CON 1 2 2014 17 10 N BGBAP21 Houston SI UNS CON 1 2 2014 dt 11 N BGBAQ21 Katy FDt D UNS CON 1 2 2014 50 12 N BGBAV21 Agua Dulce UNS CON 1 2 2014 4 13 N BGBAW21 FL Gas Zn1 UNS CON 1 2 2014 7 14 N BGBAZ21 NGPL S TX UNS CON 1 2 2014 7 15 N BGBBA21 Tenn ZnO F UNS CON 1 2 2014 42 Note that the first 17 columns A Q when opened in a spreadsheet for all Market Data csv files are identical see 4 2 and 4 3 for details In order to make the new columns for power and natural gas categories visible columns H Q have been hidden in the spreadsheet illustration above the headings for the new columns appear in boldface in the raw illustration The additional columns in new format power and natural gas Market Data csv files provide the elements of the symbol description or descriptive metadata plus certain additional information in separate columns to make it easier to sort and select information in the files For the last symbol above row 8 in the spreadsheet symbol IGBBB21 TX Eastern S TX FDt Com e Column R contains the commodity NatGas in this case e Column S contains the geographic region as shown in the Platts Energy Trader service East Gulf Coast e Column T ind
19. 2 that symbol the frequency currency and unit of measure codes for the symbol the maximum number of decimal places for prices the conversion factor multiply divide indicator and convert to unit of measure the earliest and latest prices for the symbol mm dd yyyy format and the symbol description For a complete list of the currency and other codes used in csv symbol files see Appendix A 33 Here is a partial sample of the csv symbol file for data category BA in its original format Z ba symesv Notepad EE co EK File Edit Format View Help BA 2014 by McGraw Hill Financial Inc INC 131228 BA AAFER0000000c AAFEROOC DW USD MT 000710 131227 Bunker FO 380 CST Ex Wharf Singapore BA AAFER0000000h AAFEROOh DW USD MT 000710 131227 Bunker FO 380 CST Ex Wharf Singapore BA AAFER00000001 AAFEROO DW USD MT 000710 131227 Bunker FO 380 CST Ex Wharf Singapore BA AAFET0000000c AAFETOOC DW USD MT 000710 131227 Bunker FO 180 CST Ex Wharf Singapore BA AAFET0000000h AAFETOOh DW USD MT 000710 131227 Bunker FO 180 CST Ex Wharf Singapore BA AAFET00000001 AAFETOO DW USD MT 000710 131227 Bunker FO 180 CST Ex Wharf Singapore BA AAGQP00000001 AAGQPOO I MA USD MT 900101 131101 Bunker FO 380 CST 3 5 Ex Wharf New York MAvg and as it appears when imported into a spreadsheet application x ti 5 ER BA sym csv Read Only Microsoft Exce ne C1 e Home Insert Page Layout Formulas Data Review View e Bc a R1 k fe
20. 40 A APPENDIX A BATE FREQUENCY CURRENCY AND UNIT OF MEASURE CODES 42 A Pia 42 A 2 ASSESSMENT FREQUENCY CODES ee 42 A 3 RINNAN 42 A 4 UNE OF MEASURE We 43 B APPENDIX B CSV FILE FORMAT FOR POWER NATURAL GAS CATEGORIES 45 B 1 DITO OHIO NT 45 B 2 INDENT 46 B 3 CSV FORMAT INSTRUCTIONAL GUIDE 48 I Introduction 1 1 Platts Market Data Delivery In addition to the prices published in print and online news alert services Platts provides two services for delivering market price data to subscribers e The database access option for real time news services such as Platts Global Alert e Platts Market Data which enables subscribers to retrieve market price data files updated several times each day via the internet This is the User Guide for Platts Market Data Subscribers may receive price data directly from Platts or via many other information providers serving energy metals and financial markets For more information on other sources of Platts data visit www platts com and choose Delivery Platforms amp Partners from the Products amp Services menu UserName Password 99 PLATTS Search Platts McGRAW HILL FINANCIAL Access My Subscriptions Register Contact Us Forgot Help Ko EJ S METHODOLOGY 8 REFERENCE SUBSCRIBER SUPPORT PRODUCTS amp SERVICES NEWS 8 ANALYSIS ELECTRIC POWER SHIPPING PETROCHEMICALS AGRICULTURE NATURAL GAS
21. Data group can assist with 1 time price history requests for special projects etc Unless a special format is requested by the customer Platts normally provides this price history in one or the other of the formats described in the following two sections 5 3 1 Market Data FTP History Files Market Data FTP price history files have almost the same format as daily ftp files The major difference is that they do not have transaction indicators at the beginning of each line since the files represent a snapshot of the price database at a fixed point in time rather than update transactions during a specified time period Price history files consist of a 1 line header record containing a standard copyright notice and separate lines for each price Prices are identified by a 7 character symbol a bate code and an assessment date Here is a sample of a price history file for data category CS 39 3 cs out Notepad emer a NOT File Edit Format View Help COPYRIGHT 2014 by McGraw Hill Financial Inc AAXNAOOT 201312110000 979 455 AAXNAOOc 201312110000 979 625 AAXNAOOh 201312110000 979 795 PGAMSOOh 201312030000 117 77 PGAMSOOT 201312030000 117 73 PGAMSOOc 201312030000 117 75 AAOVCOOh 201312230000 128 28 AAOVCOOC 201312230000 128 26 AAOVCOO 201312230000 128 24 AACZHOOc 201311220000 122 69 AAr7HNNh 0N13112 nNNNN 122 71 There are three versions of Market Data FTP price history files e One year which contain all pric
22. European Gas Daily code list as of September 2011 Platts Gas Daily code list as of May 2009 but instead of the prices the samples show the symbols whose prices appear there Code List European Gas Daily Platts European Gas Midpoints Platts UK Market Assessments p th S MMBtu eur MWh UK NBP Market Within Day AAIGJOO GNCMWOO KALJEJO UK NBP DA Midday GNCMVOO GNCMPOO GNCMTOO Day Ahead NGAAADO GNCWUOO AALIGOO Day Ahead NGAAAOO GNCWUDO AALIGOO M 1 NGAAEOO GNCWM10 AALJOOO Weekend AAAXSOO GNCWWDO RALJIOO Working weeks 1 AMOGCOO GNCWPOO AMOGFOO Dutch TTF pel Moni eects NG EON EEE EEE M 1 NGAAEOO GNCWMi0 KALJOOO va ang S eben S Mis MAAN ONOMAD AALJSOO M 1 GTFVMO1 GIFWM10 GTFTMO1 ua Me a DE 38 In addition to the annotated newsletters described above a growing number of Platts realtime news alert pages containing price values are being reformatted to include both the prices and the underlying symbols E g this is an example of the new format for page PGA0027 Jet Kerosene International Assessments and Conversions 27 Jet Kerosene International Assessments and Conversions 06Jan14 New York Platts 06Janl4 0850 am EST 1350 GMT Caribbean Jet Assessment USD Bbl USD MI Mid Low High Date Conv Caribbean Cargo lt PJAADOO gt 985 940 985 91 985 97 O3Jani4 7 7 128 04 USD MT Europe Jet FOB ARA Barge lt PJABAO0O gt 962 250 62 00 982 50 03Janl4 FOB NWE Cargo lt PJAAV00 gt 9 9 9 2 L 4 250 974 0
23. Latest Description a CS AAPKFOO chl DW USD BBL 3 1 3 2005 12 27 2013 Gasoline Unl 95 FOB Spore Cargo vs Naphtha MOP 4 CS AAXNBOO chl DW USD MT 3 7 45 BBL 10 3 2011 12 27 2013 Gasoil 25 S 2500ppm FOB Spore Cargo mt a CS AAXNAO3 chl MA USD MT 3 8 5 BBL 10 1 2011 11 1 2013 Gasoline Unl 92 FOB Spore Cargo mt MAvg 6 CS AAQUDOC chl DW USD BBL 3 7 62 5 18 2009 12 27 2013 Gasoil 001 S 10ppm CFR Australia Cargo NM CS AAXNAOO chl DW USD MT 3 8 5 BBL 10 3 2011 12 27 2013 Gasoline Unl 92 FOB Spore Cargo mt 8 CS AAFIYOO chi DW USD BBL 3 7 9 MT 10 2 2000 12 27 2013 Jet Kero C F Australia Cargo SM CS AAPJYO3 chi MA USD BBL 3 7 45 MT 1 1 2005 11 1 2013 Gasoil MOPS strip MAvg an icc DC AM shl MA IICA DDI 2 oc x NAT BIVIMAND 44 07 1042 Carcalina lini M CAD Cnara Caran 11 In addition to sym files for each market data category a separate file in the same folder data_category_descriptions sym provides a complete list of all active market data categories d data category descriptions sym Note File Edit Format View Help Platts Market Data Categories as of 03 January 2014 1a gt BF Agriculture Biofuels BX Agriculture Biofuels Non Platts Data SG Agriculture Sugar SY Agriculture Sugar Freight SP Agriculture Sugar Non Platts Data BA Bunkers BL Bunkers Latin America CI Coal International US Export Prices MC Coal Metallurgical Coal 11 See 5 2 1 for more information on text format symbol files 12
24. NE NE ie it Se ee ee ew ee ER CS JASIA 1 2 2014 H 2014 by McGraw Hill Financial Inc 2 Trans Symbol Descriptioi Currency UOM Date Low l High h Close c Index u Prev Vol w Volume v Bid b Ask a Open o 3 N AALPYOO Clean Der USD MT 1 2 2014 16500 E2 N AALQAOO Dirty Dem USD MT 1 2 2014 23500 5 N AAQUDOO Gasoil 00 USD BBL 1 2 2014 132 33 132 37 132 35 Ea N AAOVCOO Gasoil 00 USD BBL 1 2 2014 127 13 127 17 127 15 7 N AAOVDOO Gasoil 00 USD BBL 1 2 2014 1 95 1 99 1 97 kal N AAPPFOO Gasoil 00 USD BBL 1 2 2014 127 127 04 127 02 9 N AAPPHOO Gasoil OO USD BBL 1 2 2014 1 82 1 86 1 84 d i N AAFEX00 Gasoil 055 USD BBL 1 2 2014 125 31 125 35 125 33 11 N AAFFBOO Gasoil 05 USD BBL 1 2 2014 0 13 0 17 0 15 42 N AACUEOO Gasoil 255 USD BBL 1 2 2014 124 67 124 71 124 69 Symbol files the links under the Symbols column on the website are equally easy to work with at your desktop double clicking on the symbol file for data category CS displays 12 28 2013 2014 by McGraw Hill Financial Inc 2 DSP Trans Symbol Bates Freg Curr UOM DEC Conv To UOM Earliest Latest Description 3 CS AAPKFOO chi DW USD BBL 3 1 3 2005 12 27 2013 Gasoline Unl 95 FOB Spore Cargo vs Naphtha MOPS strip 4 cs AAXNBOO chi DW USD MT 3 7 45 BBL 10 3 2011 12 27 2013 Gasoil 25 S 2500ppm FOB Spore Cargo mt 5 CS AAXNAO3 chi MA USD MT 3 85 BBL 10 1 2011 11 1 2013 Gasoline Un 92 FOB Spore Cargo mt MAvg 6 CS AAQUDOO
25. O Gasoline L USD BBL 12 4 2013 118 23 118 27 118 25 7 AAPJYOO Gasoil MO USD BBL 12 24 2013 125 83 125 87 125 85 8 PJABFOO Jet Kero FC USD BBL 12 19 2013 125 57 125 61 125 59 9 PJACUOO Jet Kero FC USD BBL 12 31 2013 0 31 0 35 0 33 10 PGAEYOO Gasoline L USD BBL 12 9 2013 116 38 116 42 116 4 However given the number of historical prices in some data categories these files can sometimes be very large and may for example exceed the maximum number of rows allowed by some spreadsheet applications Platts strongly recommends that users upgrade if necessary to a more current version of their spreadsheet application e g Microsoft Excel 2007 or later which supports spreadsheets with more than 64 000 rows since many csv format price files exceed that size Like Market Data FTP history files there are Full 5 year and 1 year most recent 365 days versions of csv history files see 5 3 1 for details Custom files in this format can also be created to meet your particular needs regarding symbols data categories and date ranges 41 A Appendix A Bate Frequency Currency and Unit of Measure Codes The codes in the following tables will be found in both Market Data FTP symbol files and csv price symbol and history files Note that while bate and frequency codes rarely change currency and unit of measure codes may be adjusted more frequently For updated lists of these codes see the Currencies and Units of Measure tabs in
26. R QR Statistical Updates m NA ElectricPower ol North American CrudeWire ei Q Northeast Power 15 Dec Report North Sea Letter Wus ss OO GR 14 Jan 13 Jan Quarterly Index E Q nuclearFuel 06 Jan NuclearFuel Monthly Statistics fog Q NuclearFuel Uranium 4 Pricing Supplement Ee te 11 28 AM 1 15 2014 PE BESO A d h httpsi online platts com x gt C amp https online platts com PPS Qu Site el G US MarketScan Q3 Jan SS le Weekly Freight Report Df jan el E Weekly Sugar Editorial 70 De a D Weekly Sugar Report 03 Dwe ol D Weekly Weather report R I world crude Table 23086 UDI Data amp Directories Platts Market Data Product Latest Yesterday 45 day Symbols Aqnculture Agriculture Sugar SG Agriculture Sugar Non Platts Data SP Agriculture Sugar Freight SY Agriculture Biofuels Non Platts Data 8X Agriculture Biofuels BF Electric Power ed ed od vek oh 240 month Power historical volatility curves West WMV 240 month Power spark spread curves West WMS 4f moanth Power to Gas historical 38 8 Sees S 8 E B RS Depending on the services associated with your user id you may see several types of files e Copies of newsletters and or newswires you subscribe to in the Latest HTML and Latest PDF columns e Market Data price files in the Latest and Yesterday columns for the data categories that have their prices ap
27. RACHMA TRL Turkish Lira pre 2005 HKD HONG KONG DOLLAR Try Turkish Lira HRK Croatian Kuna TWD NEW TAIWAN DOLLAR HUF HUNGARIAN FORNIT UKs UK STERLING gt IDR INDONESIA RUPIAH uns UNSPECIFIED gt TEB IRISH PUNT Usc UNITED STATES CENTS ISK ICELAND KRONA VEB VENEZUELAN BOLIVAR gt ITL ITALIAN LIRA XOF CFA FRANC BCEAO JMD JAMAICAN DOLLAR ZAR SOUTH AFRICAN RAND gt JPY gey JAPANESE veN TP A 4 Unit of Measure Codes Unit of Measure Unit of Measure NGN NLG NOK OMR PEN PGK PHP PKR PLN PTE BSP SZL THB TND TRL TRY TWD UKS UNS USC VEB XOF ZAR Allowance Emissions BARRELS MILLIONS Barrels Day Barrels Day Millions 43 BBL MCM CUBIC METERS MILLIONS BCF CUBIC FEET BILLIONS MEG BKH MGW BSL MIL CEL MMB BTU MILLIONS MMT METRIC TONS MILLIONS CMT CUBIC METERS THOUSAND MPH MP CON CONTRACTS NO OF CWT MTU DMT TROY OZ MILLIONS FAR N A FL NOD DAYS NO OF GAL NOV VESSELS NO OF GIG PCI GRT RNC GWH IBP INC TAF KG TBB BARRELS THOUSANDS KLT TBD BARRELS DAY THOUSANDS KNT THR KPB THT TONS THOUSANDS TIL KWH TMT METRIC TON THOUSANDS TON TON LGT TOZ 44 B Appendix B csv File Format for Power Natural Gas Categories B 1 Introduction Platts provides additional descriptive information in Market Data csv files for the data categories containing Platts Editorial spot and forward assessments for North American po
28. T region 2 contains the NERC region RFC and column V time of day indicates OFF PEAK e Column Z contains a key to enable sorting of CSV file entries for forward assessments in calendar order e g note that the values in cells Z4 and Z6 would place May 2011 ahead of full year 2013 This sort key can be used along with other columns e g to sort the file by assessment date hub and delivery period sort using columns F U and Z e Columns AA and AB indicate the delivery period May and delivery year 2011 The column AA for delivery period will be null or n a for annual assessments or prices B 3 CSV Format Instructional Guide To better understand how to use csv formatted files please view the following imbedded file CSV_Format_Instruc tional Guide v2 http plts co CS V guide 48
29. The symbols csv version folder on ftp platts com contains another set of symbol files in comma delimited csv format Remote System Zzvu bols csv verslor S Mame Date xE i AA sym cev 20110409 22 53 i AE sym cev 20110409 22 53 i AF sym cev 20110409 22 53 See 1 3 and 5 2 2 for more information on csv format symbol list files The csv version folder also contains a separate file data category descriptions csv containing a master list of all market data categories Here s an illustration of that file when opened in a spreadsheet application A B C D E F En Platts Market Data Categories as of 03 January 2014 2 3 BF Agriculture Biofuels 4 BX Agriculture Biofuels Non Platts Data 5 SG Agriculture Sugar 6 SY Agriculture Sugar Freight 7 SP Agriculture Sugar Non Platts Data 8 BA Bunkers Depending on your requirements Platts Market Data price and symbol files can be downloaded individually or scripts can be set up using the FTP mget command to retrieve all available files Chapters 3 and 5 provide complete information on the format and content of market data price and symbol files respectively 13 1 3 Platts Market Data csv files via www platts com The Platts Market Data csv service allows end users of Platts assessments and other market price data to import the data directly into desktop applications such as spreadsheets The web site for market data csv files can be reached either vi
30. a the Access My Subscriptions link at www platts com after you have logged into the site UserName Password PLATTS Go Og see Pot Q McGRAW HILL FINANCIAL Access My Subscriptions Register Contact Us Forgot Help Advanced Search HOME PRODUCTS amp SERVICES NEWS amp ANALYSIS METHODOLOGY amp REFERENCE SUBSCRIBER SUPPORT ABOUT PLATTS or directly at www online platts com nama Me A 3 McGRAW HILL FINANCIAL PRODUCTS amp NEWS A METHODOLOGY A SUBSCRIBER SERVICES ANALYSIS REFERENCE SUPPORT The page you requested is available only to paying subscribers Request more information below Premium Services Access Need more information Username Platts provides energy information intelligence e and decision tools for the oil electricity Password natural gas petrochemical coal nuclear power shipping and metals industries Request a free trial or Like Market Data FTP Market Data csv requires a user id and password which are assigned by Platts 14 After you have successfully logged in you will see the My Subscriptions page A PLATTS McGRAW HILL FINANCIAL PRODUCTS amp NEWS amp METHODOLOGY amp SERVICES mg EF FERENECE 7 My Subscriptions As you scroll down you will see the newsletter newswire and data files for all the services you have subscribed to and be able to access them by double clicking their links These files are divide
31. bols in a data category or for specified symbols Delivery can be customized to meet your needs email FTP CD ROM etc depending on the size of the results Price history is normally delivered in one of the standard formats described in 5 3 but Platts will try to meet customer needs for other formats if required Pricing for historical data is determined on a per request basis 5 2 Symbol List Files Platts publishes symbol list files weekly on Saturday There is a separate file for each market data category plus a separate file listing all active categories These files are available in either of two formats as described in the next two sections 3 2 1 Market Data FTP Symbol List Files As illustrated in Chapter 1 Market Data FTP symbol files are available in the symbols folder on ftp platts com either via subscriber user id s or via anonymous login to the FTP site The symbol file for each data category is a fixed format text file with a sym extension and contains e A one line header record containing the market data category code a standard copyright notice and the as of date yymmdd of the file e A separate entry for each active symbol bate combination in the data category Each entry includes the data category 12 character symbol bate legacy 7 character symbol bate 9 character symbol legacy frequency code currency code unit of measure code dates of the earliest and latest price yymmdd format for that symbo
32. chl DW USD BBL 3 7 62 5 18 2009 12 27 2013 Gasoil 001 S 10ppm CFR Australia Cargo CS AAXNAOO chi DW USD MT 3 85 BBL 10 3 2011 12 27 2013 Gasoline Unl 92 FOB Spore Cargo mt 8 CS AAFIYOO chl DW USD BBL 3 79 MT 10 2 2000 12 27 2013 Jet Kero C F Australia Cargo 9 CS AAPJYO3 chl MA USD BBL 3 7 45 4 MT 1 1 2005 11 1 2013 Gasoil MOPS strio MAve 10 CS PGAEYOO chl DW USD BBL 3 853 MT 6 2 1993 12 27 2013 Gasoline Unl 92 FOB Spore Cargo Chapter 4 provides complete information on the content and format of daily Market Data csv price files also see Appendix B for information on the extended versions of these files for North American power and natural gas data categories Chapter 5 provides the same information for symbol and other Market Data csv data files 18 In addition to the individual symbol files for the newsletter data bundles and market data categories available to you on the Platts website symbol files for all data categories including ones you don t subscribe to are available via anonymous login from the Platts FTP site See 1 2 for more information on obtaining symbol files from ftp platts com 19 2 Market Data Delivery Schedules 2 1 Market Data Schedules General Information Platts Market Data FTP text and csv price files are rebuilt and posted several times every weekday Monday Friday including holidays Symbol files are updated each weekend Most market data cuts are timed to coincide with th
33. ctions on how to use Platts symbols directories and for other sources of information on Platts symbols a Price data is grouped for delivery to real time data subscribers into data packages sub packages and add on packages Each package consists of one or more market data categories Examples include PGAData containing petroleum related categories aligned with the Platts Global Alert service and EPAData containing European power related categories aligned with the Platts European Power Alert service For more information on data packaging contact your Platts Sales representative Real time data subscribers receive price updates at the same time they go into the Platts database Platts Market Data subscribers receive them by downloading price data files from the Platts FTP site or website there is a separate file for each data category These files are refreshed several times each day as markets close around the world Platts Market Data provides subscribers with two options for receiving Platts assessments and other market price data e Text files delivered via Platts FTP site ftp platts com This service is designed for subscribers and vendor partners who maintain their own databases of Platts price data e Comma delimited csv files delivered via the My Subscriptions section of the Platts website www platts com These files are more suitable for end users of Platts price data who may not have extensive technology sup
34. d into two sections newsletters newswires and associated price data files WEEN NO G e C B tutps online platts com PPS M2MS Nabural Gas Monthly 240 month Forward curves M2MS Power Dady M2MS Power Monthly 240 month a Q Megawatt Daily DS Ian A A I Ki SS ga Metals Daily Qilan I A og Metals Daily Comex ee Report Gel Q sener Daily LME Er i s Averages PRE Metals Wsek CH Gel Monthly EU News Summary RS Q Monthly EU Sugar Report og E Monthly Indian report sol Q Monthly Sugar ae PowerPoint ES Q Monthly Sugar Stabsbcal Updates NA ElectricPower og Gel North Amencan EEE AV NT NOE Si May CrudeWire og Q Northeast Power Gier Report re North Sea Letter and Market Data csv price data files 15 l EA TO kees gt C 8 https online platts com PPS Or memvuvvgy e M2MS Natural Gas Daily 120 month Forward curves M2MS Natural Gas Monthly 240 month Forward curves M2MS Power Daily 120 month Forward curves M2MS Power Monthly 240 month Forward curves Gd Q Megawatt Dail 15 Jan Hoj Q Metals Daily 14 Jan ER Q Metals Daily Comex Gene Report ER Metals Daily LME Report oj Q Metals Monthly 31 Dec Averages gt Metals Week 10 Jan ei Q Monthly EU News Summary ei Q Monthly EU Sugar Report op Q Monthly Indian report 97 Jan Monthly Sugar 7 FR QR PowerPoint emeng Monthly Sugar z E
35. data note that both are case sensitive The primary site for Platts Market Data service is ftp platts com Once you have logged in successfully the system gives you access to a set of folders which contain current and recent historical price files for all the market data categories included in your subscription Remote System JE i Mame Date Size 20110329 20110404 21 38 A 20110330 20110404 21 40 20110331 20110404 21 41 20110401 0110405 17 17 0110404 20110405 00 11 0110405 20110406 00 11 0110406 20110407 00 02 0110407 20110408 00 02 0110406 20110408 20 02 postolose 20110408 02 08 20110408 18 53 20110408 20 02 symbols today lt kS LILI ba Starting at 7 45am each weekday US Eastern local time the today folder will always contain the most recently updated price data available to Market Data subscribers for the remainder of the Platts editorial day which ends with the Final files posted at 7 45pm If you miss or need to reprocess any recent market data files copies of Final files for the most recent 45 weekdays are archived in folders with yyyymmdd names indicate the date Price updates are posted to the postelose folder at 10 15pm and 12 45am The symbols folder provides access to files updated weekly containing lists of Platts symbols Chapter 2 provides complete information on update schedules for the files in each folder In addition to batch and desktop FTP softwa
36. e Low 1 High h Closee Index u Prev Vol w Volume v Bid b Ask a Open o Prev Opn Int e Mean m Note Market Data csv price files for North American power and natural gas data categories including those for the Platts M2MS service contain additional columns which provide more detailed descriptive information For details see Appendix B 4 3 Data Records Each data line in the file for a given market data cut contains a transaction type indicator the symbol symbol description enclosed in double quotes currency and unit of measure codes and the assessment date followed by the price for every active bate for the specified symbol and date N AABCZ00 North Path 15 OPk TDt USD MGW 2014 01 03 1900 54 le 17 B00 ag CH AAMBC00 Into Southern OPk TDt USD MGW 2014 01 03 Ll gs Lal e Oey Ll eg Mygg 29 As also illustrated in Chapter 1 if Market Data csv files are associated with a desktop application such as a spreadsheet double clicking on the link for the file at www online platts com will automatically open the file in that application DNK GD csv Microsoft Exce e ses EI e File Home Insert Page Layout Formulas Data Review View v B gt A1 ui fe GD B K D E F G H J K L M N O BIO R S GD JASIA 1 2 2014 HHHHHHHH 2014 by McGraw Hill Financial Inc 2 Trans Symbol Descriptioi Currency UOM Date Lowi I High t Close c Index u Prev Vi Volt Bid b Ask a Open c Prev Me Commodit Reg
37. e end of the Platts Editorial day in each of the major trading regions as follows Market Data Cut Time file is available Data as of Time File Label na 0 pf pp All times in the table above are US Eastern local times The corresponding GMT Greenwich Mean Time or UTC Universal Time Coordinated times are four hours later during Daylight Saving time in the US roughly March November and five hours later during US Standard time The Available time is the latest time files will normally be posted Platts does not guarantee availability before the stated available times As indicated in the Data as of column the price data in each cut reflects all updates to the Platts market price database through 5 minutes before the Available time E g the prices in Final cut files available to subscribers at 7 45pm US Eastern time reflect updates to the database though 7 40pm Regular Market Data FTP and csv price files reflect all updates to the Platts price database between 7 40pm US Eastern time the previous weekday Monday Friday and the as of time for the cut e g the Europe cut for April 5 2011 reflects all updates between 7 40pm April 4 and 3 40pm April 5 Postclose FTP files posted at 10 15pm contain only prices which updated between 7 40 and 10 10pm on the current day Also see 2 3 2 5 regarding future dated prices and the 12 45am Postclose cut 20 2 2 General Market Data
38. es As indicated in 5 2 2 Market Data csv symbol files for each data category include transaction indicators to mark symbols added or changed during the current week To make it easier for subscribers to manage these changes to the Platts database an additional csv symbol file ThisWeek_sym csv is provided each week It contains all symbol related transactions for the preceding week Saturday through Friday for all market data categories in a single file This file has the same format as other Market Data csv symbol files xi 9 H BE ThisWeek sym csv Microsoft Excel ese Home Insert Page Layout Formulas Data Review View e Boga Al v fe B C D E F G H I J K L M N O P Q R I HHHH 2014 by McGraw Hill Financial Inc 2 DSP Trans Symbol Bates Freg Curr UOM DEC Conv wi To_UOM Earliest Latest Description 3 GFZ Add GNSUH13 Ih DA EUR GIG 2 4 2 2013 UK NBP Eur Gj Aug 2013 4 GFZ Add GNVTB15 c DW EUR MGW 4 UK NBP Idx VOC Eur MW Feb 15 5 THZ Add XNHHZ13 woeclh DW USD MMB 3 HHHH HHHHH NYMEX HH Natgas Fin Dec 2013 Comb 6 GF Del GGBVA13 hl DA GBC THR 2 German Bunde p th Jan 2013 7 GFZ Add GPSWH13 hl DW USD MMB 3 7 1 2013 PEG Sud MMbtu Aug13 8 GF Del GNCVA13 uw DW GBC THR 4 UK NBP Idx Dly Avg p th Jan 2013 As illustrated in 1 3 ThisWeek_sym csv is available on ftp platts com in the symbols csv version folder either via your subscriber user id or via anonymous login The ThisWeek sym csv file may include an additio
39. es added or changed during the 365 days ending with the date the file was created This file may include corrections made during that period to prices dated before this year e Five year which contain all prices for the 5 years ending December 31 of last year These files are rebuilt once a year in January e Full which contain all prices through December 31 of last year These files are also rebuilt annually If you need price history for an entire data category for more than the most recent 365 days it will normally be delivered in two files the first containing prices through December 31 of last year and the second containing prices added or changed this year Users should make sure to process the files in order since a price published before January 1 of this year and then corrected this year will appear in both files Note that for custom data requests for price history other than the 1 year 5 year and full data category level files described above custom files in this format can be created for the exact symbols data categories and date ranges required 5 3 2 Market Data csv History Files Market Data csv history files provide price history in a format similar to csv format daily files The main difference is that there is no transaction indicator at the beginning of each line since these files are snapshots of the Platts database at a fixed point in time File Edit Format View Help cs FINAL 1 1 2014 1 2 2014
40. es that they will include all the transactions for that day this is especially important for futures exchange prices which always update after 7 40pm US Eastern time Because many Market Data csv subscribers retrieve prices for a given day the following morning and because the Latest files get replaced by Early Asia cut files at 7 45am each morning a copy of the previous day s Extended Final file is stored as the Yesterday file starting at 7 35am US Eastern time Prices which updated before the previous weekday are available in the 45 day history file Market Data csv 45 day history files are updated once a day in parallel with the 10 15pm Extended Final cut They reflect all update transactions for the most recent 45 days in a single file Because many of these files are large they are posted in compressed zip format After they re uncompressed they have the same format as Latest CSV files see Chapter 4 for details 2 5 Flow Date and Future dated Prices and the 12 45am Cut Platts normally produces North American power and natural gas assessments and indexes on the trade date These prices are published under trade date symbols on that date and normally update in time for Final cut or earlier descriptions for these symbols include the phrase TD Many subscribers prefer to see these prices dated as of the delivery or flow date To meet their needs most North American spot power and natural gas pr
41. g easier 28 4 Market Data csv Price File Formats 4 1 Introduction Market Data csv files provide Platts price data in a comma delimited format designed to enable end users to view it directly in desktop applications such as spreadsheets These files contain a 2 line comma delimited header followed by one line for each symbol and assessment date combination in the database for which one or more prices were added changed or deleted today Each price line contains all price values for that symbol and date not just those added or changed today The file provides columns for all possible price types bates a symbol may have see 3 10 and A 1 for more information on bate code values The second header line contains column headings for all of them Any price types which are not applicable for the symbol which are inactive or which have no prices in the database for that assessment date display as null entries in the file 4 2 Header Records The first line in Market Data csv files displays the data category the file label FINAL POSTCLOSE etc the file as of date US Eastern time the file creation date and time GMT and a standard copyright notice ES FINAL 2014 01 02 2014 01 03 00 05 GMT 2014 by McGraw Hill Financial Inc 44 rrrvrvrvereveryse The second header line contains fixed text column headings for the data lines in the remainder of the file Trans symbol Description Curr UOM Dat
42. icates the Gas Daily region South Corpus Christi if this had been a power symbol this column would have indicated the NERC region e Column U indicates the hub TEXAS EASTERN S TEXAS e Column V indicates time of day Peak Off peak etc Since this attribute is applicable only for power symbols this column is null in the raw file in this case 47 e Column W indicates that the values in the price columns are flow date common FDt Com prices e Columns X and Y contain the Gas Daily ID and Ticker for the hub 3928385 and TEXSX in this case If this had been a power symbol these columns would be null Columns Z AA and AB apply only to Editorial forward assessments and M2MS forward prices To illustrate these consider row 6 symbol OMHAE11 Mass Hub OPk Fwd May 11 from the csv file for data category DP power forwards z ted 9 NE GD csv Microsoft Excel MTT emf ES Hom Can t Redo Ctrl Y Layout Formulas Data Review View v Q ei K11 X fe A B E D E F J I R S T U V W X Y Z AA AB A 1 GD ASIA 1 2 2014 2014 by McGraw Hill Financial Inc 2 Trans Symbol Descriptio Currency UOM Date Index CommoditRegion1 Region2 Hub TOD Price Tp GD Id GD Tkr Rel Del PcDel Pd Del Yr 3 N BGBAB21 El Paso Pe UNS CON 1 2 2014 75 NatGas West WePermian BEL PASO PERMIAN FDtDICt 3928329 EPP 4 N BGBAD21 Waha FDt UNS CON 1 2 2014 64 NatGas West WePermian BWAHA FDt DICt 3928379 WAHA 5 N BGBAE21 Transwest UNS CON
43. ices also update under a second set of flow date FDt symbols the prices are the same but the assessment dates reflect the flow date rather than the trade date These flow date prices are published twice in Platts Market Data files e As future dated prices in the same cuts as the corresponding trade date prices For details on formats etc for future dated prices see 3 4 e As current day prices in the 12 45am and later cuts on the flow date or for weekend flow dates the following Monday These are repeats of the prices above for subscribers who choose not to database or whose systems do not support future dated prices see 3 3 23 In addition to North American flow date prices several other types of values may initially appear as future dated prices in Market Data files earlier than the day they re dated Examples include day ahead DA values for European power natgas and some Official Selling Prices OSP s for crude oil Platts provides updated market data files in the 12 45am cut only for data categories containing symbols which have future dated prices on a regular basis These categories are EH EJ EK ES ET GD OS Natural Gas European Exch Other Emissions Global Sulfur Nitrous Oxides Spark Spreads N America Electricity US Assessments Indexes Electricity European Exch Other Natural Gas N American Daily Assmts Crude Postings Official Selling Prices 24 3 Market Data FTP Price File Formats
44. in B 1 contain eleven additional columns Region 1 Region 1 geographic as defined in Platts Energy Trader Region2 Region 2 NERC region for power Gas Daily region for natgas TOD Price Time of Day power only peak off peak etc Tp Price type Forward Flow Date Common M2MS etc GD Id Gas Daily ID for the hub natgas only GD Tkr Gas Daily Ticker symbol for the hub natgas only Rel Del Pd Relative delivery period sort key for Editorial forward assessments and power forward prices Del Pd Delivery period Forwards only Jan Qtr1 Winter etc ag etc Here s a sample from the format csv files for market data category GD in its raw comma delimited format GD ASIA 1 2 2014 1 2 2014 15 40 2014 by McGraw Hill Financial In Teen EE EE EE EE EE rr Trans oymbol ee eer EE FOM Date how CR Eer Er Ee Lk Index Pre v Vol w Volume v Bid b Ask a Open o Prev Opn Int e Mean m Commodity Regionl Region2 Hub TOD Price Tp GD Id GD Tkr Rel Del Pd Del Pd Del Yr N BGBAB21 El Paso Permian FDt D1Ct UNS CON 1 2 2014 75 77 NatGas West West Texas Permian Basin Area EL PASO PERMIAN FDt DICt 3928329 EPP 46 N BGBAD21 Waha FDt D1Ct UNS CON 1 2 2014 64 NatGas West West Texas Permian Basin Area WAHA py EDE D1Ct 39203 9 WAHA N BGBAE21 Transwestn Perm FDt D1Ct UNS CON 1 2 2014 12 NatGas West West Texas Permian Basi
45. ination in your database add it and if you already have the price replace it or for delete transactions remove It 21 There are two major reasons the most recently posted market data files may contain no current day prices e Prices for today may not have updated yet for that data category E g files for category UG US Gulf Coast petroleum products will usually have no current prices before the 6 45 or 7 45pm cut since these prices update in late afternoon US time e Today is a holiday in the market s which include that market data category Platts announces publishing holidays in advance for complete information on upcoming Platts publishing holidays go to www platts com and select Holiday Schedule from the Methodology amp Reference menu UserName Password 84 PLATTS McGRAW HILL FINANCIAL Access My Subscriptions Register Contact Us Forgot Help EE PRODUCTS amp SERVICES NEWS amp ANALYSIS METHODOLOGY amp REFERENCE SUBSCRIBER SUPPORT NATURAL GAS ELECTRIC POWER SHIPPING PETROCHEMICALS ALS AGRICULTURE You may sign up to receive holiday notices several days in advance via email by selecting Email Alerts from the Subscriber Services menu Using the same facility you may also sign up to receive email announcements of new symbols price corrections subscriber notes and other useful information With one exception prices in market data files reflect real values Occasional
46. ion 3 N BGBAB21 El Paso Pei UNS CON 1 2 2014 75 NatGas West We 4 N BGBAD21 Waha FDt UNS CON 1 2 2014 64 NatGas West We 5 N BGBAE21 Transwest UNS CON 1 2 2014 12 NatGas West We 6 N BGBAF21 Carthage HUNS CON 1 2 2014 13 NatGas Central G 7 N BGBAL21 NGPL Texc UNS CON 1 2 2014 36 NatGas Central G 8 N BGBAN21 TX Eastern UNS CON 1 2 2014 1 NatGas East Gulf There are four possible values for the transaction indicator in the first column e Nis used for all records where the assessment date is today including prices which may have been entered earlier today and then corrected e NH is used where all prices are being published for the first time today but are dated before today e g postings or monthly averages e Fis used for entries where the assessment date in column F is greater than the file date in cell C1 Prices in this row may have been entered for the first time today or entered and possibly corrected before today and corrected today Note that prices published as F entries will be republished as N entries on the day they re dated see 2 5 for more information e CH marks entries for prior day prices where values for this symbol and date were published before today and then one or more were added changed or deleted today If prices for a symbol and date were published before today and then all of those prices were deleted today today s file will include a CH entry for that symbol and date with all price column
47. ion or data category changed during the preceding week Saturday through Friday e Add indicates that the symbol was added to this data category last week The symbol may be either totally new or an existing one moving to this category from another one e Chg indicates that one or more changes were made to descriptive information for this symbol last week Where applicable Market Data csv symbol files provide the information needed to convert prices expressed in one unit of measure to another In this sample for data category BA Kj ma C E A sym csv Read Only Microsoft Exce ET e Home Insert Page Layout Formulas Data Review View 7 c R1 v ZS eo ENES NR PETE G ii J K ime M N o p Q S Es 12 28 2013 2014 by McGraw Hill Financial Inc 2 DSP Trans Symbol Bates Freg Curr UOM DEC Conv Se To_UOM Earliest Latest Description 3 BA AAGQ000 chl MA USD MT 3 6 35 BBL 2 1 2001 11 1 2013 Bunker FO 380 CST 3 5 Divd New York MAvg 4 BA AASUBOO chi DW USD MT 3 6 35 BBL 6 1 2010 12 27 2013 Bunker FO 180 CST 1 0 Dlvd Antwerp 5 BA AARTEOO chi DW USD MT 3 6 35 BBL 2 1 2010 12 27 2013 Bunker FO 180 CST 1 Divd Piraeus 6 BA AASUNOO chl DW USD MT 3 6 35 BBL 6 1 2010 12 27 2013 Bunker FO 180 CST 1 0 Divd Dunkirk 7 BA AARUBOO chi DW USD MT 3 6 35 BBL HHHHHHHH 12 27 2013 Bunker barging rate Philadelphia 8 BA AAWTKOO chl DW USD MT 3 6 35 BBL 6 1 2012 12 27 2013 Bunker FO 380 CST 1 0 Divd Seattle 9 BA AARSSOO chi DW USD
48. l bate and symbol description For a complete list of frequency currency and unit of measure codes which appear in symbol lists see Appendix A A 2 A 4 31 Here is a sample of the symbol list file for data category BA la i H BA ba sym WordPa 2014 by McGraw Hill Financial Inc INC 131228 BA AAFERO000000c AAFEROOc DW USD MT 000710 131227 Bunker FO 380 CST Ex Wharf Singapore BA AAFERO000000h AAFEROOh DW USD MT 000710 131227 Bunker FO 380 CST Ex Wharf Singapore BA AAFERO0000001 AAFEROOL DW USD MT 000710 131227 Bunker FO 380 CST Ex Wharf Singapore BA AAFET0000000c AAFETOOc DW USD MT 000710 131227 Bunker FO 180 CST Ex Wharf Singapore BA AAFETO000000h AAFETOOh DW USD MT 000710 131227 Bunker FO 180 CST Ex Wharf Singapore BA AAFETO00000001 AAFETOOL DW USD MT 000710 131227 Bunker FO 180 CST Ex Wharf Singapore BA AAGQP00000001 AAGQPOOL MA USD MT 900101 131101 Bunker FO 380 CST 3 5 Ex Wharf New York MAvg As illustrated in 1 2 the symbols folder on the FTP site also includes a file data category descriptions sym which lists all the currently active market data categories and their descriptions 1 data category descriptions sym Notepa File Edit Format View Help Platts Market Data Categories as of 03 January 2014 BF Agriculture Biofuels BX Agriculture Biofuels Non Platts Data SG Agriculture Sugar SY Agriculture Sugar Freight SP Agriculture Sugar Non Platts Data BA Bunkers BL Bunkers Latin A
49. les from more than one Market Data cut each day or from successive days always process them in order e Regardless of any transaction indicator in the file if you don t have a given price symbol bate date combination in your database add it and if you already have the price replace it or for delete transactions remove it As stored on the Platts FTP server lines in Market Data FTP files end with a linefeed or UNIX newline character Platts recommends that subscribers download ftp files using the ASCII option in their FTP client software If necessary this option will automatically convert the newline to the carriage return linefeed combination used in text files on most non unix systems 3 2 Header Records The first line of the file contains a standard copyright notice as follows O 2014 by McGraw Hill Financial Inc The second line contains a file identifier the date and time the file was created GMT a record count a file label the 2 or 3 character data category code and the as of date for the file The following samples show how the second header line appears for each FTP cut PlattsMarketData 201104090021 00112 N AMER AM CS 20110408 PlattsMarketData 201104090021 00112 ASIA PM CS 20110408 PlattsMarketData 201104090021 00112 ASIA CS 20110408 PlattsMarketData 201104090021 00112 EMEA CS 20110408 PlattsMarketData 201104090021 00112 EARLY PNG CS 20110408 PlattsMarketData 201104090021 00112 N AMER PM CS 20110408 PlattsMarke
50. ly when Platts deletes a price from its database the delete entry for it will show 999999 rather than the actual price value which was deleted 999999 price values in Market Data FTP files should be treated as price deletions and ignored as data 2 3 Market Data FTP Notes In addition to any earlier cuts you may process during the day Platts strongly recommends that all Market Data subscribers process the Final 7 45pm cut each day to ensure you receive all new prices and price corrections for the day To receive all updates Nymex ICE exchange prices in particular for a given day as early as possible subscribers should process the 10 15pm Postclose in addition to the Final cut Files in Regular cuts see Type column in the table in 2 1 update on the FTP server in two folders simultaneously the today folder and the folder that has its name as the current date E g files in all regular cuts for April 6 2011 would update in the today and 20110406 folders Final cut files are available for retrieval from the yyyymmdd folders on ftp platts com for the most recent 45 weekdays Postclose cuts update only in the postclose folder at 10 15pm and 12 45am Postclose files are not archived each update to a file in this folder overwrites the previous one However all prices which update in postclose cuts also appear in all regular cuts for the following day Postclose files delivered at 10
51. merica CI Coal International 4 US Export Prices MC Coal Metallurgical Coal HX Coal Misc Non Platts Data CO Coal US Daily Assmts Weekly Indexes NI Crude Nethackc Carihhean 3 2 2 Market Data csv Symbol List Files As illustrated in Chapter 1 Market Data csv symbol files are available To subscribers for the data categories they subscribe to at www online platts com or via the Access My Subscriptions link at www platts com In the symbols csv version folder at ftp platts com for all categories including ones you may not subscribe to either via your subscriber user id or via anonymous login There are three major differences between csv and FTP text symbol files Market Data csv files are comma delimited rather than fixed format which makes them more compatible with desktop applications such as spreadsheets Each file contains one row per symbol rather than a separate row for each symbol bate combination Market Data csv symbol files contain additional information such as conversion factors and transaction indicators Market Data csv symbol files contain A 2 line header record consisting of the as of date for the file and a copyright notice first line and column headings for the remaining lines in the file second line A separate line for each symbol in the data category consisting of the data category code an add change indicator if applicable the 7 character symbol all the active bates for 3
52. n Area TRANSWESTERN PERMIAN FDt DlCt 3928393 TWP N BGBAF21 Carthage Hub FDt D1Ct UNS CON 1 2 2014 13 NatGas Central Gulf Coast Ekast Texas North Louisiana Area CARTHAGE HUB FDt DICE 392623 1 CARTH p N BGBAL21 NGPL Texok Zn FDt D1Ct UNS CON 1 2 2014 36 NatGas Central Gulf Coast East Texas North Louisiana Area NGPL TEX OK ZONE FDt DLCt 3928424 NGPLE e N BGBAN21 TX Eastern E TX FDt D1Ct UNS CON 1 2 2014 l 177777 NatGas East Gulf Coast East Texas North Louisiana Area TEXAS EASTERN E TEXAS FDt DIC 3925504 TETEX N BGBAO21 Texas Gas Zn 1 FDtD1Ct UNS CON 1 2 2014 17 777rrrNatGas Central Gulf Coast East Texas North Louisiana Area TEXAS GAS ZONE 1 FDt DICE 69205077 MOV lani N BGBAP21 Houston ShipChl FDt D1Ct UNS CON 1 2 2014 11 NatGas Central Gulf Coast East Houston Kkaty Houston Shp Chl FDE DICL 39208336 SHELP es N BGBAQ21 Katy FDt D1Ct UNS CON 1 2 2014 50 NatGas Central Gulf Coast F st Houston Katyv KATY FDt and after being opened in a spreadsheet application K ad 9 Oo E 3 GD csv Microsoft Exce ey de f Home Insert Page Layout Formulas Data Review View v o gt A1 v fe GD B C D E F G H J K L M e 1 2 2014 1 2 2014 15 40 2014 by McGraw Hill Financial Inc 2 Trans Symbol Descriptio Currency UOM Date Low l High h Close c Index u Prev Vol w Volume v Bid b 3 N BGBAB21 EI Paso Pei UNS CON 1 2 20
53. nal transaction Del When symbols stop updating they re normally moved to a discontinued data category When this happens the ThisWeek_sym csv file will show a Del transaction for the active category and an Add transaction for the discontinued category Also see 5 2 4 for further information on discontinued symbols 35 5 2 4 Symbol Directories on www platts com In addition to the symbol list files described above which are updated weekly Platts also publishes symbol directories for registered users at www platts com Registration is open to anyone at no charge for more information or to register choose Register Log In from the Subscriber Services menu illustrated below To access these directories select Price Symbol amp Page Directories from the Methodology amp Reference menu UserName Password PLATTS Search Flatts McGRAW HILL FINANCIAL Access My Subscriptions Register Contact Us Forgot Help Achmad Searok HOME PRODUCTS amp SERVICES NEWS amp ANALYSIS METHODOLOGY amp REFERENCE SUBSCRIBER SUPPORT ABOUT PLATTS Symbol directories are stored in spreadsheet xls form the format is similar to the csv symbol list files described in 5 2 2 These symbol directory spreadsheets are updated bi monthly Apart from having symbol information grouped by industry commodity rather than in separate files by data category the symbol directories at www platts com
54. nnennenernernennennnnennennennensenennenneneene 25 DUE IRON GORE DE EE 25 3 2 HEADER RECORDS wsccsssesncescanosdesnseusdessusdeddoreeunsensnededes enews deaeeeeuddad eb ea A ek vo bedaka 25 33 N ANEWIECNTRIES EE 26 54 F FUTURE DATED ENTRIES sccsacssucasnsaedeviinsapncasnccecueeaeusdassenneceanasapscanusteaeseasupheusmeteaeuyaounsevestecesiacnos 26 3 5 C CHANGE OR CORRECTION ENTRIES rrnnnnnnnrnnnnnnnnrrnnrnnnnnnnnnrnnnrnnnnnnnnsnnnnrnnnnnennnnnnnnnnnnnensnennsnnnnneee 21 OE RENE ENE EO DE DEE 2 gt T bo buerg ug ab EN Ae 27 3 8 X NO PUBLISHED PRICE ENTRIES nana Zi 3 9 TRANSACTION ENTRIES IN POSTCLOSE bur 28 3 10 BATES IN MARKET DATA FTP FILES seenereenevernevnvnennvnenevnenevnensvnensnnensnnenennnnensnnensnnensnnensnnensnnenennen 28 SR 28 4 MARKET DATA CSV PRICE FILE FORMATS ivesrerrorenveenernnrnavennennsrnsnansennsrrnrnnsannennnnnanensennnnnnnensee 29 A TIN 29 12 MR NN 29 43 DENN 29 5 MARKET DATA SYMBOL LIST AND PRICE HISTORY FILE FORMATS ee 31 DANE RONI RE E 31 32 ao O ag PLE EE EE ee 31 5 2 1 Market Data FTP Symbol List Files Lauen eege 31 522 Market Data csv Symbol List regeiert 32 5 23 Ths Week SNL Lene 35 5 2 4 Symbol Directories on www platte com 36 5 2 5 Symbol cross references for selected Platts print alert services 37 5 3 MARKET DATA PRICE HISTORY kuEs kana 39 SJ Market Data FIP History FS sveket 39 5 3 2 Market NS History FIICE vvs
55. o e g when a symbol in category BA is discontinued it is moved to category BAZ The ThisWeek_sym csv file 5 2 3 will contain Del and Add entries for categories BA and BAZ respectively The next time the directories are updated on platts com these discontinued symbols will move from category BA in the Active Petroleum Assessments directory to category BAZ in the Discontinued directory 5 2 5 Symbol cross references for selected Platts print alert services In addition to delivery via Platts Market Data and realtime data services subscribers may also receive price values for the majority of Platts symbols in a wide variety of print and realtime news alert services To assist users in relating prices in these services back to the underlying symbols Platts provides annotated versions of many of them at www platts com To locate these coded newsletters either select the desired commodity from the Products amp Services menu PRODUCTS amp SERVIGES NEWS amp ANAL Oil Hatural Gas Electric Power Coal vVerview Related Methodology amp Specifications and then click on 3 or select the commodity from the Methodology amp Reference menu METHODOLOGY amp REFERENCE Ol Hatural Gas Electric Power Coal Nethodology amp Specifications 37 The Codes sections on the commodity methodology pages contain sample copies of many Platts newsletters etc Codes 7 Platts
56. ot yet updated today If you do not need to check for missing prices you may safely ignore X entries 3 9 Transaction Entries in Postclose Files Postclose files published at 10 15pm will contain only N F C and D entries reflecting database update transactions processed between 7 40pm and 10 10pm US Eastern time Postclose files published at 12 45am will contain prices added or changed in the Platts price database between 7 40pm the previous weekday and 12 40am today as well as prices dated today which were originally published in prior day ftp files as F entries Postclose files will normally not contain X entries 3 10 Bates in Market Data FTP Files 3 11 Values in Market Data FTP files are identified by the symbol the bate code and the assessment date Bate codes identify the value type high price h low price 1 etc For a complete list of bate codes see Appendix A A 1 Due to vendor system limitations prices published in market data files with u bates may be delivered to some realtime subscribers with c bates Because of this symbols will never have both c and u bates Platts currently uses w bate for volumes By convention values published by futures exchanges represent trading volumes for the previous trading day However Platts publishes these values as current day volumes so that volumes for a given as of date correspond to prices with the same date which makes analysis and chartin
57. pear in that newsletter These newsletter bundle comma delimited csv files will typically contain prices for several data categories in a single file 16 e The Platts Market Data section contains a separate comma delimited file for each data category you have subscribed to e The Latest Yesterday and 45 day files have equivalent contents in both sections The Latest files are always the most recently updated available versions of the Market Data csv files Starting at 7 35am US Eastern time each weekday Yesterday files contain copies of the final Market Data files from the previous weekday The 45 day files contain all price updates for the most recent 45 day period for the data category or Newsletter bundle in the Latest CSV column The file has in the same csv format as the Latest and Yesterday files but is posted in compressed zip format since some of these files can be rather large e The Symbols files which are updated each weekend provide complete descriptive information for the symbols in the corresponding price files See Chapter 2 for complete information on update schedules for all Market Data files To view the contents of any Market Data price or symbol file just double click on it Seege Fuel oil Cx ei I ei Singapore CS d CH North Asia CJ I S In this example the csv file format has been associated with a spreadsheet software package
58. port or experience with FTP client software They are formatted for direct use in desktop applications such as spreadsheets The next two sections provide an introduction to each option Chapter 2 provides detailed information on Market Data update schedules Chapters 3 and 4 provide complete information on the daily file types and data formats available via each of the two delivery options Chapter 5 provides information on Market Data symbol list files and other options for locating Platts symbols as well as format and other information on price history data files The appendices to this User Guide provide information on codes used in Market Data files and special formatting information related to Market Data csv files for North American Power and Natural Gas data categories 1 2 Platts Market Data via FTP Market Data FTP price data files can be retrieved from Platts FTP site using either FTP scripts run from a scheduler or one of the many available desktop FTP software packages e g Local System Session Properties General Startup Advanced Firewall Frafile Name Platts ll Hew Host Name Address ftp platts cam Delete Host Type UND standard ll User ID pour User id Anonymous Password Eo w Save Prd Account Comment Cancel Apply Help As shown in the illustration above you must enter your Market Data FTP user id and password which are assigned by Platts to obtain access to price
59. re files can also be retrieved from the Platts FTP site using many web browsers Most subscribers access market data files using automated FTP scripts run at predetermined times by a scheduling system You may need to obtain assistance from your Technology support group to set up and manage these scripts Regardless of which approach you decide to use there may also be other technical issues such as obtaining access to external FTP sites through corporate network firewalls Again you should contact your local Technology support group for assistance if necessary The Platts FTP site supports both standard FTP and secure FTP sFTP For standard access using a user id and password users can set up a FTP or sFTP connection directly using their client software sFTP connections can also be made using an SSH Secure Shell key pair for more information contact Platts Client Services or email support platts com Once you have logged into the Platts FTP site opening any folder displays all the market data files authorized under your subscription EI she ftp 130305 23 32 EI ahd ftp 130305 23 32 Ej ahe ftp 130305 23 32 Ej ahf ftp 130305 23 32 Ej ahl ftp 130305 23 32 ahn ftp 130305 23 32 Ej aho ftp 130305 23 32 Ejalc ftp 130305 23 32 S ald ftp 130305 23 32 Ej ale ftp 130305 23 32 Each file contains all the price updates so far today for the symbols in that data category 20110416 00 01 67433 20110416 00 01 10914 20110416
60. references to Platts Dispatch the former brand name for the Platts Market Data service dispatch category now Market Data Category etc e Minor updates to some illustrations to reflect format changes at www platts com e Note There are no functionality or service changes for this release of the User Guide Release 3 0 1 3 0 2 e Updated User Guide to reflect the release of the new file creation and 2 delivery platforms for the Platts Market Data service in August 2011 Release 2 0 2 4 e Complete rewrite of original 1999 2002 Platts FTP Dispatch User Manual e Release of Dispatch CSV the version of Platts Market Data which delivers comma delimited csv format files via www online platts com the My Subscriptions section of www platts com Contents 1 NIR DENN NEE 5 1 1 PLATTS MARKET DATA DELIV ER Y snek ideene epa katel Ee ee tet ati vee vi a ile kel 5 12 PLATIS MARKET DATAVIA FIP Ledende 7 1 3 PLATTS MARKET DATA CSV FILES VIA WWW PLATTS COM ccceccsceccececcsceccececcececescecscecescscesences 14 2 MARKET DATA DELIVERY SCHEDULES reeseersrroravvannsrrnrnenannennernnnanssennrnerensannernnrnenansennnrnnnnneae 20 2 1 MARKET DATA SCHEDULES GENERAL INFORMATION 20 22 GENERAL VIARKET DATA FILE NOTES EEN 21 29 NE A IN EN venn 22 24 MARI DNV NOTES eee 23 2 5 FLOW DATE AND FUTURE DATED PRICES AND THE 12 45AM CUT 23 3 MARKET DATA FTP PRICE FILE FORMATS i eroerervornernernevnennrnerne
61. remely rare the timestamp and price will reflect the last one As indicated in 2 2 999999 price values may occasionally appear in D records in place of real prices but the meaning is the same any existing value for this symbol bate date combination in your database should be deleted Although rare it is possible for prices to be deleted and then reentered into the database D entries will be published only if there is no price in the database as of the cutoff time for the market data cut If a price is entered into the database today and then deleted FTP files will contain a D entry but no N If this price was never published in an earlier market data cut or if you didn t process that cut you may therefore receive a D entry for a price which isn t in your database 3 8 X No Published Price Entries Market Data FTP files will contain X entries for any active symbols in the data category without a current day value 27 X WEABAOOL 201104110000 X entries appear only e In regular not postclose ftp files e For symbol bate combinations which are active and which have had at least one price dated within the last 6 months e For daily symbols with no price dated today weekly symbols with no price dated within the past 9 days and monthly symbols with no price dated within the past 33 days Note that X entries contain no prices They are provided only as a way to identify symbols which have n
62. s set to null That way the user will know that the symbol no longer has any prices for that date The format for the assessment date yyyy mm dd was chosen for compatibility with major desktop applications while still allowing files to be sorted directly by date For symbols with assessment dates include times e g intraday indicators and rack prices the date format will be yyyy mm dd hh m1 with no comma between the date and time hh refers to the hour in international format e g 05 for 5am and 17 for 5pm 30 5 Market Data Symbol List and Price History File Formats 5 1 Introduction In addition to the price files which update several times each weekday there are two other types of files which update weekly e Symbol List files These files updated each weekend include complete descriptive information for the symbols in each data category The csv format symbol files include transaction indicators to highlight symbols added or changed this week In addition to individual files for each category ThisWeek_sym csv provides in a single file a complete list of all symbols added changed or deleted this week across all data categories e Price History files Users of Platts price data with special needs e g price history for more than the most recent 45 days may request it by contacting their local Platts Client Services representative or by emailing support platts com Price history is available for all sym
63. ssment dates of today the file as of date from the end of the 2 header line or earlier However Platts databases some prices with assessment dates in the future examples include flow date power and natural gas prices and some OSP s Official Selling Prices for crude oil For more information on flow date and future dated prices also see 2 5 Future dated prices appear in ftp files as F entries to identify them as future dated Except for the transaction type F records have the same format as N entries PlattsMarketData 2011004080015 03264 FINAL DC 20110407 F IGBXX21u 201104110000 123 45 In this example a price dated April 11 2011 is published in the ftp file for April 7 because the assessment date is later than the file date the transaction indicator is set to F To complete the example this price appears again in the ftp file published on the assessment date for data category DC PlattsMarketData 201104120017 03345 FINAL DC 20110411 N IGBXX21u 201104110000 123 45 Since the assessment date is now the same as the file date the entry has an N new rather than an F future dated transaction type 26 Note that if this price had been entered on April 7 and then corrected on April 8 the initial price would appear as an F entry in the market data files for April 7 and the corrected price would appear also as an F entry since it s still future dated in the files for April 8 in all cuts after
64. tData 201104090021 00112 FINAL CS 20110408 PlattsMarketData 201104090021 00112 POSTCLOSE CS 20110408 25 The record count indicates the number of data records in the file not including the 2 line header It is possible that many Market Data FTP files will contain no data entries especially for postclose When this occurs files will contain only the 2 line header and a record count of 00000 3 3 N New Entries FTP files contain N entries for price values published for the first time today They consist of a transaction code N the symbol and bate the assessment date and the price left justified N AABCZ00u 201104080000 19 7 They may be values dated today or prior day prices e g postings monthly averages published for the first time today N entries will reflect the price in the database as of the cutoff time forthe market data cut see 2 1 for cutoff times If a price current day or delayed prior day is entered into the database for the first time today and then corrected before the cutoff time the current as of the cutoff time price will still be published as a single N record Although very rare it is therefore possible to have an N entry in given FTP file and an N entry for the same symbol bate date with a different value in a file from a later cut the same day The value from the later cut is always the one to use 3 4 F Future dated Entries Most price values in Market Data FTP files have asse
65. wer and natural gas as well as those which make up the Platts M2MS Mark to Market service The special Market Data csv format described in this Appendix applies to the following market data categories MDC Code MDC Description DR Electricity N Amer Forward Assmts Electricity Spark Spreads N Amer Electricity US Assessments Indexes Natural Gas N American Daily Assmts GM Natural Gas US Monthly Assessments G Natural Gas N Amer Forward Assmts Natural Gas N Amer Forward Assmts S o M2MS 120 month Gas forward curves US Gulf Coast ODC M2MS 120 month Power forward curves ERCOT M2MS 120 month Power forward curves North East FDC M2MS 120 month Power forward curves PFC Power Hubs Only M2MS 120 month Power forward curves PUM MISO M2MS 120 month Power forward curves South East M2MS 120 month Power forward curves West M2MS 240 month Gas forward curves Mid Continent M2MS 240 month Gas forward curves North East PMC M2MS 240 month Gas forward curves PFC Hubs Only M2MS 240 month Gas forward curves Rockies and West M2MS 240 month Gas forward curves Upper Midwest M2MS 240 month Gas forward curves US Gulf Coast M2MS 240 month Power forward curves ERCOT ee ee a M2MS 240 month Power forward curves PUM MISO ms 45 B 2 Additional Fields In order to make Platts North American power and natgas price data easier to use in analytical and plotting applications Market Data csv files for the data categories listed

Download Pdf Manuals

Related Search

Related Contents

Manual 83 plus " Get Start"  FABRICANTES DE BASCULAS TORREY        hair mousse . - Grupo Dicoit  Supplement THS720A MOD NV TekScopet      CR 350 - Benza  

Copyright © All rights reserved. Failed to retrieve file