1 / 25

New TSI Iron Ore Document

New TSI Iron Ore Document. BE Development Instructions – ITTI. Important. The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached design of the new document.

ramiro
Télécharger la présentation

New TSI Iron Ore Document

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. New TSI Iron Ore Document BE Development Instructions – ITTI

  2. Important • The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached design of the new document. • Please note, this development is to create a new document option – meaning a ‘New Media Type’ (under Media Settings) in addition to the existing Iron Ore Daily as listed in the TSI BE under Media Settings. DO NOT OVER WRITE THE EXISTING IRON ORE DAILY DOCUMENT. We still need it! Please create a new document / new media type entitled Iron Ore Premium.

  3. PAGE 1

  4. Item 1 – The Steel Index Iron Ore Reference Prices • Present on the pre-existing document. • Data recorded in the database. • Data entered in BE as follows: • Data Entry • Iron Ore Index Data Entry

  5. Item 2 – Iron Ore Reference Prices • Present on the pre-existing document. • Data recorded in the database. • Data entered in BE as follows: • Data Entry • Iron Ore Index Data Entry

  6. Item 3 – Today’s Iron Ore Market • Item under development • See Todo DEV entry entitled text entry for daily iron ore report

  7. Item 4 – SBB Top Iron Ore News Stories • Web development needed • Development request to be logged in Todo DEV

  8. Item 5 – Indicative Freight Rates to China • Present on the pre-existing document. • Data recorded in the database. • Data entered in BE as follows: • Data Entry • Freight rates

  9. Item 6 – TSI 62% Fe average price • Data recorded in the database. • Data entered in BE as follows: • Data Entry • Iron Ore Index Data Entry • Monthly averages: mean average of all published 62% Fe prices in the calendar month • Quarterly averages: mean average of all published 62% Fe prices in the calendar quarter. Q1 is Jan-Mar, etc.

  10. Item 7 – TSI 62% FOB net back • Data recorded in database. • Implied FOB calculated as follows: • 62% Fe (Data Entry / Iron Ore Index Data Entry) • Less the respective freight rates (Data Entry / Freight rates) • Brazil: Brazil – China (ore) • Australia: W. Australia – China (ore) • India: India – China ore (average) • Current day’s 62 price less latest freight entry (previous day) • Implied CFR Europe calculated as follows: • Implied FOB (as arrived at as above) plus freight rate. • Implied FOB Brazil plus latestBrazil – Europe (ore) • Cells that relate to Australia and India under Implied CFR Europe to be left blank • Implied CFR Europe QTD • The quarter to date average of the derived (as above) Implied CFR Europe price • The mean average of the prices published in the calendar quarter

  11. Item 8 – Iron Ore Stock at Chinese Ports • Data recorded in database. • Data entered in BE as follows: • Data Entry • China Stock Levels • Total (historic)

  12. Item 9 – Iron Ore Stock • Data recorded in database. • Data entered in BE as follows: • Data Entry • China Stock Levels • Qingdao / Tianjin / Caofeidian / Rizhao (data point for current week treated as This Week. Data point for previous week treated as Last Week.

  13. PAGE 2

  14. Item 10 – Average Waiting Time for Berth • Data recorded in the database. • Data entered in the BE as follows: • Data Entry • China Port Vessel Wait • All vessel classes (historic) • Capesize (historic)

  15. Item 11 – Average Waiting Time for Berth • Data recorded in the database. • Data entered in the BE as follows: • Data Entry • China Port Vessel Wait • Qingdao / Tianjin / Caofeidian / Rizhao (data point for current week treated as This Week. Data point for previous week treated as Last Week.

  16. Item 12 – Average Load Time – Australia • Data recorded in the database. • Data entered in the BE as follows: • Data Entry • Average Load Time – Australia • Australia iron ore (historic) • Australia coal (historic) • Australia combined (historic)

  17. Item 13 – Chinese Export HRC Price • Data recorded in the database. • Data entered in the BE as follows: • Data Entry • Iron Ore Index Data Entry (62% Fe) • Steel Index Data Entry (Flat product HRC – Chinese exports to Asia / Flat product HRC – Chinese exports to Europe or North America

  18. Item 14 - TSI 62% Fe Fines Spot / Swap Curve • Data recorded in database. • Data entered in BE as follows: • Data Entry / Iron Ore Index Data Entry (62% Fe) • Take historic of the IO 62% Fe • Forward Curve Data • Use the latest day for which there are completed fields (day prior)

  19. Item 15 – Steel Futures • Web development needed • Development request to be logged in Todo DEV

  20. Item 16 – Freight forward prices • Item under development • See Todo DEV entry entitled data entry for freight forward prices

  21. PAGE 3

  22. Item 17 – Normalisation Co-efficients • Data recorded in database. • Data entered in BE as follows: • Data Entry • Iron Ore Normalisation Data • 62% Fe Fines Coefficient • 58% Fe Fines Coefficient

  23. Item 18 / 19 / 20 – Contact The Steel Index • Web development needed • Development request to be logged in Todo DEV

  24. Item 21 – Data sources • Web development needed • Development request to be logged in Todo DEV

  25. END

More Related