Support

Search

Sort by

Module Type

Total

148 Modules

    ODIN Modules

  • Import, Import Utility Modules

    System List

    Gets system lists such as Language, Fonts etc.

  • Arithmetic, Utility

    Table Arithmetic

    This module is used to perform arithmetic operations on single columns within a table. For example, sum values in a column, average values in a column, calculate the standard deviation of values in a column, calculate the standard deviation of values in a column or calculate correlation between values in two columns.

  • Transform, Utility

    Table Designer

    This modules allows you to build your own custom reports using Opturo’s Table Designer. Using the Table Designer UI you can position your data, design your report, and view your report while developing in real time.

  • Transform, Utility

    Table Subset

    This module is used to retrieve a subset of data by providing the start row and column and end row and column.

  • Export, Export Utility Modules

    Template

    This module allows you to create an arbitrary template file and populate variables in the file with variables defined in TableSets.

  • Import, Import Text

    Text

    This module is used to read data from text based files. It supports multiple file formats. The module can be used to read data from a single text file or from a series of text files that are date stamped (e.g data.20080101.txt, data20080102.txt, etc.). To read a series of text files that are date stamped, define the file directory, file prefix (e.g. data.), date range, frequency and format (e.g. yyyyMMdd)...

  • Export, Export Text

    Text Out

    This module is used to write data to text based files. It supports multiple file formats. The module can be used to write data to a single text file or to a series of text files that are date stamped (e.g. data.20080101.txt, data20080102.txt, etc.). To write a series of text files that are date stamped, define the file directory, file prefix (e.g. data.), file date format (e.g. yyyyMMdd) and file...

  • Import, Import Market Data

    ThomsonReuters DataScope Select

    This module is used to download data from ThomsonReuters DataScope select product.

  • Transform, Utility

    Time Series

    This module is generally used to create time indexed table sets. It takes a single table set and splits it into multiple table sets based on the identifier or group column. This module is used to split a single data set with historical prices, into multiple table sets, where each table set contains data for one identifier.

  • Transform, Utility

    Union

    This module is used to join or merge two data sets or table sets. This module requires the row header and column headers to be defined for each table set being merged. For example, it could merge market data to a portfolio of securities. The first module in the above list would be the module that defines the portfolio of securities and the second module would define the market data...

  • Export, Export Utility Modules

    User Automation Out

    This module can be used to automate any GUI task. The user defines the mouse movements, clicks, system commands and text needed for a task or sequence of tasks. This can be used, for example, to automate logging into a website and dowloading information or taking screenshots.

  • Export, Export Utility Modules

    Visualization Out

    This module is used to output data to the visualization tool, which includes heat maps, line graphs, pie charts, etc. This is a powerful tool to visualize large amounts of data, e.g., returns and market values for hundreds of portfolios over several years.

System List

Gets system lists such as Language, Fonts etc.

Table Arithmetic

This module is used to perform arithmetic operations on single columns within a table. For example, sum values in a column, average values in a column, calculate the standard deviation of values in a column, calculate the standard deviation of values in a column or calculate correlation between values in two columns.

Inputs

  • data.xls

    • Outputs

  • output.xls

    • Table Designer

    This modules allows you to build your own custom reports using Opturo’s Table Designer. Using the Table Designer UI you can position your data, design your report, and view your report while developing in real time.

    Table Subset

    This module is used to retrieve a subset of data by providing the start row and column and end row and column.

    Inputs

  • data.xls

    • Outputs

  • output.xls

    • Template

    This module allows you to create an arbitrary template file and populate variables in the file with variables defined in TableSets.

    Text

    This module is used to read data from text based files. It supports multiple file formats. The module can be used to read data from a single text file or from a series of text files that are date stamped (e.g data.20080101.txt, data20080102.txt, etc.). To read a series of text files that are date stamped, define the file directory, file prefix (e.g. data.), date range, frequency and format (e.g. yyyyMMdd) and file suffix (e.g. .txt).

    Example

    Take a text file and output it to Excel.

    Basic example of converting file types.

    Inputs

  • data.txt

    • Outputs

  • output.xls

    • Text Out

    This module is used to write data to text based files. It supports multiple file formats. The module can be used to write data to a single text file or to a series of text files that are date stamped (e.g. data.20080101.txt, data20080102.txt, etc.). To write a series of text 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. .txt).

    Inputs

  • data.xls

    • Outputs

  • output.txt

    • ThomsonReuters DataScope Select

    This module is used to download data from ThomsonReuters DataScope select product.

    Inputs

  • identifierList.txt

    • Outputs

  • datascope.csv

    • Time Series

    This module is generally used to create time indexed table sets. It takes a single table set and splits it into multiple table sets based on the identifier or group column. This module is used to split a single data set with historical prices, into multiple table sets, where each table set contains data for one identifier.

    Inputs

  • data.xls

    • Outputs

  • ouput_opt1232.csv
  • ouput_opt5467.csv

    • Union

    This module is used to join or merge two data sets or table sets. This module requires the row header and column headers to be defined for each table set being merged. For example, it could merge market data to a portfolio of securities. The first module in the above list would be the module that defines the portfolio of securities and the second module would define the market data table set. If the first data set has multiple table sets and the second data set has only one table set, then each table in the first data set will be merged to the table set in the second data set. If two data sets with multiple table sets are merged, then the program will merge the tables whose table labels match.

    Inputs

  • mktData.csv
  • accounts.xls

    • Outputs

  • output.xls

    • User Automation Out

    This module can be used to automate any GUI task. The user defines the mouse movements, clicks, system commands and text needed for a task or sequence of tasks. This can be used, for example, to automate logging into a website and dowloading information or taking screenshots.

    Visualization Out

    This module is used to output data to the visualization tool, which includes heat maps, line graphs, pie charts, etc. This is a powerful tool to visualize large amounts of data, e.g., returns and market values for hundreds of portfolios over several years.

    Example

    Heat map example using Visualization.