What is RUBBERIMP

The Singapore Exchange (SICOM) offers a service for distributing Rubber prices. At the end of their business day they build a .txt (tab separated values) file of prices for their commodities TSR20 and RSS3.

The import is explicit for locating the correct Day’s data so the business date needs to be a valid working date for that exchange and the Website is further identified with an unique reference

This process will access their site http://infopub.sgx.com/Apps?A=COW_Infopubdtstat_Content&B=DailyDataDownload&F=UUUU&G=MMDDFut.zip and retrieve the file, if present. UUUU = unique number and MMDD is the business date.

If the operating site has proxy fireguard software enabled to stop rogue files being brought down to their server, RUBBERIMP will need to be told what is the proxy server.

RUBBERIMP will then import the prices into it’s TPRICE table, using the TCCM (3^rd party-tcy20_feedcode) interface codes e,g, TSR20 and RSS3

What is TOCOMIMP

This is a similar process to RUBBERIMP except accesses the Tokyo Commodity Exchange (TCE) website (http://www.tocom.or.jp/data/yakujou/ ) to get their prices. The link to locating the correct prices for the various instruments e.g. Palladium, Rubber is the TCCM Price Feed code (3^rd party - tcy20_feedcode) i.e. Paladium = 13, Rubber = 81. An association is made when the Commodity Exchange is set to TCE.

What is BMDIMP

This is a similar process to RUBBERIMP except accesses the Bursa Malaysia Exchange (BMD) website (http://www.bursamalaysia.com/website/bm/market_information/market_statistics/derivatives/historical_data.html) to get their prices.

The link to locate the correct prices for the various instruments e.g. Crude Palm Oil Futures, USD Crude Palm Oil Futures is the TCCM Price Feed code (3^rd party - tcy20_feedcode) i.e. Crude Palm Oil Futures = FCPO, USD Crude Palm Oil Futures = FUPO. An association is made when the Commodity Exchange is set to BMD.

Technical Setup

The account running ITASSERVER service needs a CMP record (this account does not need to be authorized or assigned any companies)

The actual command is drive:\Itas\Exec\T\T95 MenuBatch gf DEP or

drive:\Itas\Exec\T\T95 MenuBatch gf DEP /TOCOM for TOCOMIMP

Day end batch file needs a command before S96 is run i.e. drive:\Itas\Exec\menu\menu /batchmail/inits=IS (example IS = User initials used in the CMP record for the ITASSERVER service account)  Running batchmail sets up the correct ITAS date in the registry for the user account running the ITASSERVER service which is used by the T95 program.