Vision Portfolio Management FAQ: Range Groups

Goal

To define a classification scheme that uses value ranges to group related instances.

Description

Three RangeGroup feeds are pre-defined with the Portfolio Management Application Layer: MCapGroups, PeGroups, and PbGroups.

RangeGroups are used to define ranges of values for a particular attribute. For example, you may want to define market capitalization ranges that group securities into "less than $500 million", "$500 million - 1 billion", and "greater than $1 billion" based on the value of the security's marketCapUS. This FAQ illustrates how to define your own ranges for each of these groups.

DataFeed Assumptions

DataFeed	Fields
McapGroups	startValue, endValue, label
DataItemFeed	id, shortName, sortCode, baseClass, accessPath, isGroup
ClassSetup	ClassId, ParentId, Description
PropertySetup	classId, property, defaultValue, description
RangeGroupSetup	feedId, rangeClassId, updateClassId, updatePath, accessRule

Topic 1: Using the McapGroups range group to define market capitalization ranges.

1. Load the instances for the RangeGroup, McapGroups.
   1. Set up the spreadsheet to look like the following. Note that the feed name MCapGroups is in the top left of the range.

      MCapGroups
      
      startValue	endValue	label
      NA        	250     	less than $250M
      250             500	        $250M - $500
      500        	1000      	$500M - $1B
      1000        	2500      	$1B - $2.5B
      2500        	5000      	$2.5B - $5B
      5000        	10000      	$5B - $10B
      10000        	NA      	greater than $10B
      

   2. Select the entire range.
   3. Select Upload Data from the VUpload menu.
   4. Select the Range button

   The McapGroups instances have been created.

2. Define MCap Group as a grouping choice.
   1. Set up the spreadsheet to look like the following. Note that the feed name DataItemFeed is in the top left of the range.

      DataItemFeed
      
      id         shortName    baseClass    accessPath       isGroup
      mcapGroup  MCap Group   Security     marketCapGroup   Y
      

   2. Select the entire range.
   3. Select Upload Data from the VUpload menu.
   4. Select the Range button.

   MCap Group has been defined as a grouping choice.

3. Test browser to confirm the addition of MCap Group as a grouping choice:

   1. Open the Vision Reporter in your web browser
   2. Select Account Reports.
   3. Select AccountBreakdown.
   4. Enter an account and run the report.

   MCap Group should now appear in the group menu at the bottom of report.

---

Topic 2: Creating New RangeGroups

Create a new range group that will group securities by price ranges:

1. Define a RangeClassification subclass PriceGroup:
   1. Set up the spreadsheet to look like the following. Note that the feed name ClassSetup is in the top left of the range.

      ClassSetup
      
      ClassId     ParentId              Description
      PriceGroup  RangeClassification   This class tracks security price range.
      

   2. Select the entire range.
   3. Select Upload Data from the VUpload menu.
   4. Select the Range button.

   The RangeGroup class PriceGroup has been created.

2. Define a property at Security to hold priceGroup
   1. Set up the spreadsheet to look like the following. Note that the feed name PropertySetup is in the top left of the range.

      PropertySetup
      
      classId  property       defaultValue     description
      Security priceGroup     PriceGroup       price group
      

   2. Select the entire range.
   3. Select Upload Data from the VUpload menu.
   4. Select the Range button.

   The priceGroup property has been created for Security.

3. Define a new RangeGroup feed
   1. Set up the spreadsheet to look like the following. Note that the feed name RangeGroupFeedSetup is in the top left of the range.

      RangeGroupFeedSetup
      
      feedId	      rangeClassId	updateClassId	updatePath	accessRule
      PriceGroups   PriceGroup	Security	priceGroup	price
      

   2. Select the entire range.
   3. Select Upload Data from the VUpload menu.
   4. Select the Range button.

   The RangeGroup feed PriceGroups has been created. The updatePath name of the property is defined by the updateClassId which holds the group value. The accessRule defines the expression which accessed the basic data value grouped into the correct range.

4. Load the instances for the RangeGroup PriceGroups:
   1. Set up the spreadsheet to look like the following. Note that the feed name PriceGroups is in the top left of the range.

      PriceGroups
      
      startValue        endValue        label
      NA                8               less than 8
      8                 25              8 - 25
      25                100             25 - 100
      100               NA              greater than 100
      

   2. Select the entire range.
   3. Select Upload Data from the VUpload menu.
   4. Select the Range button.

   The PriceGroup ranges have been created.

5. Define Price Group as a grouping choice for a report:
   1. Set up the spreadsheet to look like the following. Note that the feed name DataItemFeed is in the top left of the range.

      DataItemFeed
      
      id          shortName    baseClass    accessPath       isGroup
      priceGroup  Price Group  Security     priceGroup       Y
      

   2. Select the entire range.
   3. Select Upload Data from the VUpload menu.
   4. Select the Range button.

   Price Group has been defined as a grouping choice.

6. Test that Price Group has been added as a grouping choice:

   1. Open the Vision Reporter in your web browser.
   2. Select Account Reports.
   3. Select AccountBreakdown.
   4. Enter an account and run the report.

   Price Group should now appear in the group menu at the bottom of report.