Support

Search

Sort by

Module Type

Total

153 Modules

    ODIN Modules

  • Transform, Utility

    Fuzzy Matching

    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.

  • Analytical, Utility

    FX Conversion

    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).

  • Artificial Intelligence

    Gemini AI

    This module is used to connect with Google’s Gemini API. This allows Google Gemini’s artificial intelligence model to answer questions or make changes to your data. For example is can help with data validation or calculate and create new columns, or even provide insight into your data. It returns its insights as well as an updated dataset if needed. Different models can be used depending on your preference.

  • Transform, Utility

    Generate Attribute Data

    Modules generates an attribute data set (Columns: Key Column, Start Date Column, End Date Column, Attribute Columns..) off time series account or security time series data. For instance, track the change in sector, industry and country over a period of time.

  • Transform, Utility

    Generate Unique List

    This module is used to generate a unique list for a given column of data. The module can be used to generate a distinct list from string, date and numbers.

  • Transform, Utility

    Generate Web Service HTML Data

    Inserts Process Manager Web Service link into any cell within any DataSet for display within ODIN – App Builder and SAYS Platform™s. Clicking on these hyperlinks within cells will run a web service job and retrieve data or report for display or download.

  • Transform, Utility

    Google Free Text

    Google Free Text module identifies sensitive data within a larger text block. There are over 120 different info types that can be identified such as credit card numbers, names, dates, etc. This can be used in conjunction with our data anonymization module to anonymize data in large free text blocks or by itself to identify the location, text, and likelihood of sensitive data in the larger text block.

  • Transform, Utility

    Groovy

    This module allows you to write Groovy scripts to be used as part of the ODIN Process. They can be used as any type of module and allows for importing from a custom data source, writing a custom report, or doing a custom calculation. A groovy script should implement the interface com.opturo.api.GroovyTransformInterface from the ODIN API.

  • Transform, Utility

    H2 SQL

    This module allows you to manipulate ODIN data using SQL commands. For a full list of supported functions see http://www.h2database.com/

  • Import, Text

    HTML

    This module is used to download web data as text. For example, some websites provide links to download financial data (FX rates, stock prices, benchmark holdings, etc.) as CSV, and this module can be used as part of a ODIN process to automate the task of downloading, transforming and analying the resulting data.

  • Export, Text

    HTML Out

    This module is used to write data to a HTML web page. The page can then be deployed on an internal or external website. The module can be used in a ODIN process, where the results of the process are displayed on a website. The websites would no longer have to be manually updated.

  • Import, Market Data

    IDC Remote Plus

    This module can be used to download latest and historical market from Interactive Data® using its unique Remote Plus product. This module allows the download of descriptive and pricing data for all asset types. This module leverages the ODIN infrastructure to allow the download data directly from Interactive Data® and to a data warehouse or the direct use the market data in fundamental or quantitative analysis. It has unique iterative...

Fuzzy Matching

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.

FX Conversion

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).

Inputs

  • fxData.txt
  • fxData.xls
  • data.xls

    • Outputs

  • output.xls

    • Gemini AI

    This module is used to connect with Google’s Gemini API. This allows Google Gemini’s artificial intelligence model to answer questions or make changes to your data. For example is can help with data validation or calculate and create new columns, or even provide insight into your data. It returns its insights as well as an updated dataset if needed. Different models can be used depending on your preference.

    Generate Attribute Data

    Modules generates an attribute data set (Columns: Key Column, Start Date Column, End Date Column, Attribute Columns..) off time series account or security time series data. For instance, track the change in sector, industry and country over a period of time.

    Inputs

  • 20180228_MarketCapClassification.csv
  • 20180131_MarketCapClassification.csv
  • 20180331_MarketCapClassification.csv
  • MarketCapClassification_HistoricalMerge.csv

    • Outputs

  • Market_Cap_Classification_Attributes.csv

    • Generate Unique List

    This module is used to generate a unique list for a given column of data. The module can be used to generate a distinct list from string, date and numbers.

    Inputs

  • data.txt

    • Outputs

  • output.xls

    • Generate Web Service HTML Data

    Inserts Process Manager Web Service link into any cell within any DataSet for display within ODIN – App Builder and SAYS Platform™s. Clicking on these hyperlinks within cells will run a web service job and retrieve data or report for display or download.

    Google Free Text

    Google Free Text module identifies sensitive data within a larger text block. There are over 120 different info types that can be identified such as credit card numbers, names, dates, etc. This can be used in conjunction with our data anonymization module to anonymize data in large free text blocks or by itself to identify the location, text, and likelihood of sensitive data in the larger text block.

    Inputs

  • inputData.xlsx

    • Outputs

  • outputData_dataGovernance.xlsx
  • outputData_deIdentified.xlsx

    • Groovy

    This module allows you to write Groovy scripts to be used as part of the ODIN Process. They can be used as any type of module and allows for importing from a custom data source, writing a custom report, or doing a custom calculation. A groovy script should implement the interface com.opturo.api.GroovyTransformInterface from the ODIN API.

    Example

    This example shows how to create a dataset using a Groovy script which then can be used in a VIA process.

    Code:

    import com.opturo.api.common.GroovyTransformInterface

    import com.opturo.api.data.DataSet;

    import com.opturo.api.data.TableSet

    class IOTest implements GroovyTransformInterface{

    @Override

    public DataSet runScript(DataSet data) {

    String[] names = [First Name];

    int[] types = [0];

    TableSet ts = new TableSet(names, types);

    ts.addRow();

    ts.setString(Rocco, 0, 0)

    data = new DataSet();

    data.addTableSet(ts);

    return data;

    }

    }

    Inputs

  • IOTest.groovy

    • H2 SQL

    This module allows you to manipulate ODIN data using SQL commands. For a full list of supported functions see http://www.h2database.com/

    HTML

    This module is used to download web data as text. For example, some websites provide links to download financial data (FX rates, stock prices, benchmark holdings, etc.) as CSV, and this module can be used as part of a ODIN process to automate the task of downloading, transforming and analying the resulting data.

    Example

    Download iShares ETF data and save as Excel file.

    Outputs

  • IShares_IVV.xls
  • IShares_IWV.xls

    • HTML Out

    This module is used to write data to a HTML web page. The page can then be deployed on an internal or external website. The module can be used in a ODIN process, where the results of the process are displayed on a website. The websites would no longer have to be manually updated.

    Inputs

  • data.xls

    • Outputs

  • output.html

    • IDC Remote Plus

    This module can be used to download latest and historical market from Interactive Data® using its unique Remote Plus product. This module allows the download of descriptive and pricing data for all asset types. This module leverages the ODIN infrastructure to allow the download data directly from Interactive Data® and to a data warehouse or the direct use the market data in fundamental or quantitative analysis. It has unique iterative technology to allow download of very large amounts of data through time in one single process. Data can be transformed to time series (indexed by date) or case series (indexed by identifier).

    Outputs

  • output_TS.xls
  • output_CS.xls