Vision Portfolio Management Application: Getting Started

Assembling Starter Files

To start each system, you will minimally want to prepare the following data feeds: SecurityTypeMaster, SecurityMaster, PortfolioMaster, and HoldingsFeed.

Assume the data for SecurityTypeMaster looks like the following:

Id	name	          unitCalc     AssetCategory

0	Cash & Equiv	  1	       Cash
1	Common Stock	  1	       Equity
2	Preferred Stock	  1	       Equity

This feed will be saved as sectype.txt.

Assume the data for SecurityMaster looks like the following:

id	   name	                 ticker   type   latestMarketCapUS
				
00195710   AT&T CORP COM         T	  1      55447562.63
00811710   AETNA INC COM         AET      1      14458498.5
20449310   COMPAQ COMPUTER CORP	 CPQ	  1      26578000

This feed will be saved as sec.txt.

Assume the data for PortfolioMaster looks like the following:

id	name
	
102	INSYTE GROWTH FUND
232	INSYTE INCOME FUND
332	INSYTE GROWTH & INCOME FUND
532	INSYTE PENSION

This feed will be saved as portfolio.txt.

Assume the data for HoldingsFeed looks like the following:

date	acctId	secId	   shares   mval
				
971215	102	00195710   8823	    49422.22
971215	102	00811710   6111	    42122.11
971215	232	00811710   7700	    444444.4
971215	232	20449310   7001	    424344.4
971215	332	20449310   7800	    497741.4
971215	332	00195710   7100	    463321.4

This feed will be saved as holdings.txt.

More information about Feed Formats and Starter Feeds is available.


Using VAdmin to Load the Data

Before the files can be loaded into the database, they must be moved to the appropriate directory. When you have a data file available, you place it in a pre-defined directory on your Server machine. On Unix servers this directory is normally /localvision/upload/feeds. On NT servers, this directory is normally stored relative to a specific disk and may include an additional prefix as part of its path. Check with your system administrator for the exact location in your environment.

If you have not yet obtained a valid license file entry for your server(s), please contact Insyte. You will be unable to commit updates to the database until you have done so.

After moving the files, start the VAdmin module. You should see the files that you saved in the Pending Files section on the left of the form.

VAdmin Interface with sample feeds

You will want to load the files in the following order: sectype.txt, sec.txt, portfolio.txt, holdings. To start, select the sectype.txt data file from the left and the entity data feed SecurityTypeMaster, from the right. Press the Update button to load this data. When the update finishes, you should see a summary report similar to:

VAdmin Diagnostics Report for SecurityType

Press the Save button to save the feed. When the save finishes, you should see a message similar to:

Saved message

The file sectype.txt has now been removed from the Pending files list box. It has been moved to the directory /localvision/upload/feeds/done. Continue loading the files in the following order: sec.txt, portfolio.txt. The last file to load is the holdings.txt, whose feed name is HoldingsFeed. To access the feed, you select the category Transaction from the top right list box.

Each time you add data to the Vision database, Vision creates a new version or view of the database. To see the history of your updates to the database, click on the Vision DBA menu and select the Version History choice. This displays the history of your changes. If you want to undo one or more updates, you can select the version that you wish to eliminate and press the Rollback option on this form. For more information on this topic, see the section Reviewing Version History.

Restarting Master Listeners

When the database administrator has loaded new data and is ready to make it available to web users, the master listeners should be restarted.

Listener menu

Select the Restart Master Listeners choice from this menu. For more information on listeners, see the section Controlling the Web Reporter.


Viewing the Data via Browser Applications

To access the browser, enter the url http://visionWeb/vision. You should see the Vision Application home page.

To see a Security Profile report for AET, select Security Reports, then select Security Profile. Enter AET or 00811710. You should see the AET profile.

AET Profile

The information you supplied via the SecurityMaster upload is displayed.

To see a list of all Accounts, do the following:

Select Home at the bottom of the current profile. Select Account Reports then AccountProfile. Enter Submit with no accounts selected. You should see a listing of all accounts that you loaded in hyperlink form. Select the link for account 102. You should see an Account Profile for account 102.


Using Data in Excel

You can also use the Vision data in Excel. Start a new Excel and connect to vision. You are now ready to extract and/or upload data.

To extract holdings for portfolio 102, select the following range:

portfolio extraction

Select Get Entity By Item Data from the Vision menu.

portfolio extraction results

The information you supplied via the SecurityMaster, PortfolioMaster, and HoldingsFeed upload is displayed.

For more samples of using data in Excel see Sample Usage.

Related Topics