Frequently Asked Questions

Vector Securities is updated on a daily basis as data is reported. There is a Period in Progress that is constantly changing as new data for the period is being added. Usually, this Period in Progress is fully updated by the end of the month.

This is due to the Period in Progress, which is updated on a daily basis as new data is available.

The Shared Reports folder includes a Data Update Status report that provides the completion percentage for the current Period in Progress. As data is being added, the percent complete is updated to reflect the status.

There is a report in the Shared Reports folder titled Data Update Status that provides the status of the most recent data updates. Since Vector Securities is updated on a daily basis, there will usually be a data period that has not been fully updated. This will be identified as the Data Period in Progress which is usually fully complete by the end of the month.

If you run reports against that data period, the results may not reflect all the activity for that period. The Data Update Status report will provide a percent complete for each active data period. Once the data for a period is fully updated, the status will reflect 100% for the Percent Completed status.

Note:    The filter object titled "Most Recent Data Period" will reflect the latest data period that is at 100% complete. This filter object will never apply to an incomplete data period. Once the Data Period in Progress is fully complete, the "Most Recent Data Period" is updated to reflect the new data period.

The maximum number of rows and columns that are displayed at one time are defined in the Grid Display preferences. You may modify the maximum number of rows and/or columns displayed for your user account.

Click here for more information on Grid Display Preferences.

To strat your output by one or more of the aggregate attributes, add the attribute as a row header on your report. Each attribute has predefined strat dimensions (i.e., bucket ranges).

These attributes can be found in the Aggregate Attributes folder in the Attributes Browser.

The predefined buckets for the aggregate attributes cannot be modified. You can define your own bucketing for an attribute using Custom Groups. Click here for more information on Custom Groups and how to define them.

There are several conditions that may cause a report to take an extended time to process.

• Custom Groups added to report - the number of custom groups and/or the complexity of the setup will impact the processing time.

Click here for more information on tips to eliminate processing issues related to custom groups.

• Attributes and metrics on a report that are not included on the grid. These may require additional SQL passes on the source data to generate the output.

The CPR calculation is limited to those loans that have paid off in the reporting period and the investor balance and the time of payoff is used for the payoff balance.

Due to principal adjustments from loan modifications, using the actual balance and including non-paid off loans in the CPR calculation would artificially inflate the prepayment rate.

Vector Securities provides predefined aggregate reports that include metrics with additional logic applied in the calculation. The Insert Metric option allows you to create your own calculated metrics.

When comparing your own calculated metric to compare to a predefined metric, the values may differ because your calculated metric does not use the same logic.

An example:

The Loss Severity metric on an aggregate report uses divides the Loss Amount by the Payoff Balance. The calculation for this metric evaluates the underlying loan level detail to determine if a paid off loan has reported a loss. If no Loss Amount is reported, the loan is not included in the Loss Severity.

If you create a your own Loss Severity calculated metric, you must eliminate any paid off loans that have not reported a loss. This cannot be done in the formula for the calculated metric, you must apply filter conditions to limit the list of loans that are actually eligible for this calculation.

The standard Roll Rate report has a predefined set of delinquency bucketing. You may define the metrics whose roll rates you wish to view but all delinquency statuses are included in the output.

The more custom Roll Rate report with Metric Prompt allows you to specify the target (or TO) delinquency status buckets you wish to include in the output.

Example:

Standard Roll Rate report includes all From (starting period) and To (ending period) statuses (e.g., Current to Current, Current to 30, et al).

Custom Roll Rate report with Metric Prompt includes all From (starting period) statuses but allows you to specify the To (ending period) statuses you wish to include in the output.

These three metrics provide prepayment information as of the To period in the Roll Rate report.

• Prepay includes loans that transition from Current, 30 days delinquent or 60 days delinquent to Paid Off status between the From and To reporting periods.

• Liquidated without Loss includes loans that transition from 90 days delinquent or Foreclosure to Paid Off between the From and To reporting periods whose pool reports losses and no loss amount was reported.

• Liquidated with a Loss includes loans that transition from 90 days delinquent, Foreclosure or REO to Paid Off between the From and To reporting periods with a loss amount or whose pool does not report losses (in this case there is no loss amount but a loss is assumed)

Vector Securities supports portfolio reporting by deals and/or pools. There are two ways to generate a report using a list of CUSIPs.

• If your portfolio always includes the same deals, you can create your own predefined Portfolio filter using the Match CUSIP to Deal or Match CUSIP to Pool options. This custom Portfolio filter limits the output to the deals you wish to analyze.
  
  Click here for more information on Portfolio Filters.

·        If the deals in your portfolio change every month, use the predefined prompted Portfolio filter. When requesting a report, you will be prompted to enter or import a list of CUSIPs to determine the deals to be included in the output.

Click here for more information on how to use the prompted Portfolio filter.

Use the Match CUSIP to Deal or CUSIP to Pool options in the Shared Filter folder within Shared Reports. This allows you to enter your CUSIPs, match the deals or pools associated with those CUSIPs and then create a filter using some or all of those deals or pools.

Click here for more information on the steps to create the Portfolio Filter.

The entry field for the CUSIP list is limited to 2,000 elements or a 300KB import file.

There are several ways to use a Portfolio filter on a report:

·        As a report filter condition to isolate only those deals or pools associated with that CUSIP. Click here for more information.

·        As a selection on a report that includes a Portfolio filter prompt. Click here for more information.

·        As a parameter for a Custom Group. Click here for more information.

You can define your CUSIPs at report run time using the CUSIP prompt. To add this to a report, open the report in Edit mode and add the CUSIP prompt from the Shared Prompts folder. Save the customized report to My Reports.

When you run that customized report, you will be prompted to either manually enter the CUSIPs or import a list of CUSIPs from a file.