ODIN Modules

This module is used to read data from MS Excel files. ODIN is java based and can run on any platform. It also supports reading from MS Excel files on any platform. The module can be used to read data from a single Excel file or from a series of Excel files that are date stamped (e.g. data.20080101.xls, data20080102.xls, etc.). To read a series of Excel files that are date...

This module is used to write data to MS Excel files. The module can be used to write data to a single Excel file or to a series of Excel files that are date stamped (e.g. data20080101.xls, data20080102.xls, etc.). To write a series of Excel files that are date stamped, define the file directory, file prefix (e.g. data.), file date format (e.g. yyyyMMdd) and file suffix (e.g. .xls).

This module has various purposes. It can be used to bring in all file names in a directory of a certain type. Also, this module can be used to wait a specified number of minutes for a file to appear. If it does not appear the process will fail. If it does appear then the process can optionally kick off a process.

Use this module in ODIN Process Manager config files that launch the ODIN File Manager in App Builder.

The module is used to forward fill missing data files. Used in cases for example where month-end files exist and those files need to copied forward every day for the next month (e.g. 31-May-2010 copied and saved as file with dates 1-Jun-2010, 2-Jun-2010 etc.)

The module is used to forward fill missing data rows. Used in cases for example where month-end prices exist and those prices need to copied forward every day for the next month (e.g. price from 31-May-2010 copied and saved as price with dates 1-Jun2010, 2-Jun-2010 etc.)

This module is used to flip or pivot the data set. The table set should have defined row and column headers.

This module is used to format a date column.

This module is used to format a number column. It also allows you to specify a prefix or suffix.

This module can be used to upload/download files to/from a remote server as part of a ODIN process. For example, if used as the POST_UPLOAD_MODULE, text files that are outputted by a ODIN process can be automatically uploaded to a remote web server.

This module can be used to fuzzy match strings in two columns. A ratio is calculated that indicates how similar two strings are in the comparison columns.

This module is used for foreign exchange conversion. It supports fx conversion for both price and return (%) type market data values. It also has a feature to resolve inverse rate quoted currency pairs (e.g. GBP->USD).