MVB Integrator

MVB Integrator provides for easy integration of the output from the Multi-Factor Regression into your portfolio views.

With MVB Integrator you'll be able to:

  • Easily create ad-hoc multivariate beta factor scenarios to keep current with market conditions
  • Analyze the impact of including or removing beta factors on your real-time portfolio valuations
  • Automate beta scenario integration to eliminate error prone manual extract processes

Our MVB Integrator app provides the following key features:

  • Generate the results for up to 3 source books in one run
  • Show beta weighted results in real time views
  • Compare impact of additional factors in one portfolio view

For information on our pricing and our support policies, please visit our pricing and our support pages.

Once the MVB Integrator app is obtained form Imagine's IFP Marketplace, you can run the generator app (sc.MVB.gen.js) which is found in your 'MyApp' section of the App Explorer.

MVB Integrator - My App

When you select sc.MVB.gen.js and press the Run button, the App Inputs screen will appear. This is where you will enter your factor portfolio and at least one portfolio which contains the source holdings you want to run the regression on. (If you have more than 3 portfolios, you can rerun for the additional portfolios, but make sure to uncheck the 'Recreate CRT if exists?' checkbox). The Custom Reference Table (CRT) name is defaulted to SCMVBDATA. This name is also the default that the Custom Columns app use, so don't change this unless you are setting up for a non-default portfolio view containing multiple factor portfolios.

MVB Integrator App Inputs

After inputting your parameters, press the Ok button. The app will run the beta calculations (which may take some time, depending on number of factors and of number of source holdings). Upon completion, you will get a status screen similar to this:

MVB Integrator App Output

If you checked the 'Display results detail?' checkbox, you'll see betas by source holding and factor for each portfolio selected. The app will also update the Custom Reference Table with the betas. At this point, you can integrate the results in your portfolio views with some basic look ups that you can set up like:

MVB Integrator Custom Reference Table

In addition to this basic setup, we provide custom column apps that give you more flexibility to display the factors. There are five custom column apps that enhance the functionality of the MVB Integrator app suite:

  • SCMVBFactorBeta - returns the beta for the holding. Parameters are factor name and an options CRT name which defaults to SCMVB_DATA
  • SCMVBFactorCount - returns number of factors. Parameter is optional CRT name which defaults to SCMVB_DATA
  • SCMVBFactorSeqName - returns name of factor denoted by number in factor sequence. Parameters are factor sequence and an optional CRT name which defaults to SCMVB_DATA.
  • SCMCBFactorSeqBeta - returns beta of factor denoted by number in factor sequence. parameters are factor sequence and an optional CRT name which defaults to SCMVB_DATA.
  • SCMVBFactorCalcDate - returns date that beta was last calculated for this holding. Parameter is optional CRT name which defaults to SCMVB)_DATA

Here is an example of some of the apps used in custom columns for a portfolio view:

MVB Integrator Custom Columns Examples

Here is a view of the Portfolio:

MVB Integrator Portfolio View

which used the output of the sc.MVB.gen.js app that created the CRT:

MVB Integrator Custom Reference Table Output of sc.MVB.gen.js

As reference, these are the input and results of the Imagine ITS Multi-factor Regression. This is the input:

MVB Integrator Multi Factor Regression Input

and the results:

MVB Integrator Multi Factor Regression Output

MVB Support

There are many way to configure MVB Integrator. The best way to try out the functionality is:

  • Create a Portfolio with ONLY the factors. It should include .SPX, .DXY, CLc1 for the demonstration of functionality
  • Run this install script
  • Run sc.MVB.gen.js and select a Portfolio, Book, or Ledger as the Source Holdings
  • Open a view to this source Portfolio, Book, or Ledger and add the custom columns