[Unitized] Time-Series-Manager application suite

Foreword

[Unitized] Time-Series-Manager is designed to simplify the highly complex and reactive task of Market Data Management to
compute Multivariate Risk Factors used by Financial-Risk-Management calculation servers.

[Unitized] Time-Series-Manager was engineered as a lightly coupled application. As such the engine is completely generic and adaptable to any type of format. If you have special formats that are not currently covered by TSM, please let us know so we can incorporate them in the next release.

Although designed with Risksvr™ in mind, [Unitized] Time-Series-Manager has been successfully used to feed Risk Factors into other Financial Calculation Servers.

[Unitized] Time-Series-Manager was first designed as a separate collection of tools that were used on www.risksvr.com to compute stochastic variables for more than 10'000 Vertices at a time. Time-Series-Manager is used for both End of Day and Real-Time Risk Factor Computations. It currently provides all the necessary interfaces to:

Snap, Scrub and Create Risk Factors on the Fly for Time-Series accumulation. Fill missing points with user defined functions. (PreviousValid, NextValid, AverageToDate, MLE, VolToDate, etc)
Compute Absolute and Relative Moments (Volatility, Correlation, Skewness & Kurtosis) for:
- Currencies, Equities, Commodities, Riskless Curves and Spread curves (Additive, Multiplicative & Full), Volatilities
- Full Spread and Riskless Curve Correlations for dual multivariate stochastic movements
- Forward Volatilities and Correlations for Market Model and Volatility Function Models.
- Interest Rate Mean Reversion.
Spectral Decomposition and correct Non-Definite or Semi-Definite Matrices. Expected Maximum Likelihood estimators. Compute Unitize and non standardized Correlations for Cholesky Bypass
Save Results in multiple format. (Database, xml, csv, name value pair)
Compute Correlation Delta and Moments of Volatility.

The standalone version of [Unitized] Time-Series-Manager available for download is a simplified versions of the same Time-Series-Manager interface used on-line to compute data.

Are you trying out Risksvr™ ?

Risksvr™ is designed to work with Both Online and / or Standalone versions of [Unitized] Time-Series-Manager.
If you just want to try Risksvr™ out, you do not need to download [Unitized] Time-Series-Manager.

You can indeed run Risksvr™ directly by clicking on Run rather than Save during download.

If you choose to run Risksvr™ online bear in mind you will need to maintain an active internet connection so that Risksvr™ can keep in sync with the online versions of [Unitized] Time-Series-Manager and time-Series-Manager.

Get Started

To run [Unitized] Time-Series-Manager on your computer two prerequisites must be satisfied:

A Database Server to which FRM can connect must be running with the Risksvr™ Database Schema installed.
A default Realm is necessary. The default Realm acts as the default data repository where data can either be sourced or sinked.

These two tasks are performed automatically for you during setup.

Setup will actually check you computer for any valid previous pre-requisites. if no valid database is already installed on your computer

Setup will install a database server with the necessary RiskServer Schema. This Database will not interfere with other existing databases running on your computer. .

Important:

If setup installs the database server, you will be asked to define your own administrator account and password. If your are not the administrator of your computer you might want to ask your administrator to do this for you

If a valid database is already configured on your computer, you will need to ask your system administrator to either:

create a new user with read/write /create permissions

Or provide a temporary access to the administrative user rights.

Once the database is installed you will be asked again to enter this administrative username and password.

Note: This is the username / password pair just defined or provided by your administrator.

This is important because setup needs proper user rights to install the Risksvr™ Database Schema. If you do not provide the proper user name (i.e. the user that has (read /write) privileges setup will fail!

For further information on database user access please see user access.

Once setup has installed the Schema, it will create a standard user account will lower privileges. Create user account by setup:

login	:	risksvr
password	:	risksvr

You are obviously free to you use this account or you can delete it and define other user accounts with lower or higher privileges.

If you haven't installed Risksvr™ and you are running setup for the first time, a wizard will offer to setup Realm path, name and alias for you.

In most cases, we recommend you accept the default values provided by the wizard

You can configure Realms and DataSources manually in the Settings Tab of the main dialog once setup has been completed.

For more information on Realms see Realms and DataSources section below

Minimum System Requirements

Currently [Unitized] Time-Series-Manager holds on 2.8 Mb of disk space. This highly compact footprint allows it to run on very tight configurations!

1. System Requirements for Installing [Unitized] Time-Series-Manager

Processor	Minimum: 400 megahertz (MHz) Pentium processor Recommended: 1 gigahertz (GHz) Pentium processor Dual processor if used in real-time or near real-time. If you run risk on a real-time basis or near-real time basis, we recommend you use a dual processor so other tasks can be performed in the background
Operating System	TSM can be installed on any of the following systems: Microsoft Windows 2003 Server Service Pack 1 (SP1) Windows XP SP2 with updates Windows Vista SP1
RAM	Minimum: 256 megabytes (MB) Recommended: 512 MB
Hard Disk	Up to 500 MB of available space may be required, depending on the amount of data stored.
CD or DVD Drive	Not required.
Display	Minimum: 800 x 600, 256 colors Recommended: 1024 x 768 high color, 32-bit

[Unitized] Time-Series-Manager Installation: Known Issues

2.1 Download Failure due to Bad Administrative Password rights

The download and installation of [Unitized] Time-Series-Manager might fail if the Database connection is badly specified.

To resolve this issue

Define a proper root account. This procedure is explained in detail in the Database connection topic in the Help file.

2.2 [Unitized] Time-Series-Manager fails because the database cannot be installed. This happens when users have installed previous versions of MySql. MySql does not remove it's database properly ! alas!
To resolve this issue
Check the Services utility and disable the MySQL running service. Remove the Mysql Path in the Program Files directory. Finally check the LOCAL_MACHINE Registry Hive and Clean up the MySql Keys.