Search

Sort by

Module Type

Import(28)
Import Database(7)
Import Market Data(4)
Import Utility Modules(7)
Import Documents(4)
Import Text(6)
Utility(84)
VICAP(3)
MATLAB(8)
- Mathematical(2)
- Statistical(2)
- Financial(3)
Risk(1)
Transform(48)
Processing(3)
Analytical(15)
Performance(2)
Arithmetic(4)
Export(27)
Export Database(7)
Export Documents(4)
Export Utility Modules(8)
Export Text(8)
ODIN(9)

Total

148 Modules

ODIN Modules

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, 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, 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, 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...
Transform, Utility
Insert Data Column
This module is used to either create a new data set (one table set) or inserts data columns into an existing data set.
Transform, Utility
Insert Index Column
This module is used to create an index column with unique values. The column could be used as an identifier column for the data set.
Transform, Utility
Insert Row Header Data Column
This module is used to insert the row header as a data column within the data set.

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