be development instructions – itti. important the ‘items’ numbered in this document correspond...
TRANSCRIPT
![Page 1: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/1.jpg)
New TSI Iron Ore Document
BE Development Instructions – ITTI
![Page 2: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/2.jpg)
ImportantThe ‘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.
![Page 3: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/3.jpg)
PAGE 1
![Page 4: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/4.jpg)
Item 1 – The Steel Index Iron Ore Reference PricesPresent on the pre-existing document.Data recorded in the database.Data entered in BE as follows:
Data EntryIron Ore Index Data Entry
![Page 5: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/5.jpg)
Item 2 – Iron Ore Reference Prices
Present on the pre-existing document.Data recorded in the database.Data entered in BE as follows:
Data EntryIron Ore Index Data Entry
![Page 6: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/6.jpg)
Item 3 – Today’s Iron Ore Market
Item under developmentSee Todo DEV entry entitled text entry for
daily iron ore report
![Page 7: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/7.jpg)
Item 4 – SBB Top Iron Ore News StoriesWeb development neededDevelopment request to be logged in Todo
DEV
![Page 8: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/8.jpg)
Item 5 – Indicative Freight Rates to ChinaPresent on the pre-existing document.Data recorded in the database.Data entered in BE as follows:
Data EntryFreight rates
![Page 9: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/9.jpg)
Item 6 – TSI 62% Fe average price
Data recorded in the database.Data entered in BE as follows:
Data EntryIron 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.
![Page 10: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/10.jpg)
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 latest Brazil – 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
![Page 11: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/11.jpg)
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)
![Page 12: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/12.jpg)
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.
![Page 13: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/13.jpg)
PAGE 2
![Page 14: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/14.jpg)
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)
![Page 15: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/15.jpg)
Item 11 – Average Waiting Time for BerthData 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.
![Page 16: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/16.jpg)
Item 12 – Average Load Time – AustraliaData 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)
![Page 17: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/17.jpg)
Item 13 – Chinese Export HRC PriceData 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
![Page 18: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/18.jpg)
Item 14 - TSI 62% Fe Fines Spot / Swap CurveData 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)
![Page 19: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/19.jpg)
Item 15 – Steel Futures
Web development neededDevelopment request to be logged in Todo
DEV
![Page 20: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/20.jpg)
Item 16 – Freight forward prices
Item under developmentSee Todo DEV entry entitled data entry for
freight forward prices
![Page 21: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/21.jpg)
PAGE 3
![Page 22: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/22.jpg)
Item 17 – Normalisation Co-efficientsData recorded in database.Data entered in BE as follows:
Data Entry Iron Ore Normalisation Data 62% Fe Fines Coefficient 58% Fe Fines Coefficient
![Page 23: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/23.jpg)
Item 18 / 19 / 20 – Contact The Steel IndexWeb development neededDevelopment request to be logged in Todo
DEV
![Page 24: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/24.jpg)
Item 21 – Data sources
Web development neededDevelopment request to be logged in Todo
DEV
![Page 25: BE Development Instructions – ITTI. Important The ‘items’ numbered in this document correspond with the charts and tables as numbered on the attached](https://reader030.vdocuments.us/reader030/viewer/2022032600/56649dbb5503460f94aad64e/html5/thumbnails/25.jpg)
END