Global Securities
Chapter 12 - Global Securities
[[Screen not in online version of documentation.]]
The Global Security Table, brought up from the Main Menu, shows global securities, listed in alphabetical order by global security symbol.
The values displayed for each security are:
- Global security Symbol.
- Global security Name.
- Security Type.
- The most recent Price recorded in the Price History File.
- The current Yield.
At the bottom of the Global Security Table is a scrollable row of functions:
- Ctrl-F1:Function List - popup a list of functions to choose from.
- Ins:Add - add a security.
- ENTER:Change - change the highlighted security.
- Del:Delete - delete the highlighted security.
- Esc:Exit - exit from the table, returning to the Main Menu.
- Ctrl-PgUp:Top - go to the first record.
- Ctrl-PgDn:Bottom - go to the last record.
- F3:Price History Table - view the price history table for the highlighted security.
- F4:Price Update - update the prices of all global securities, by entering the information from the screen or reading in a file.
- F5:Global Security Report - generate the Global Security Report.
- F6:Total Return Report - generate the Total Return Report.
- F7:Split Shares - execute a stock split for the highlighted security.
- F10:More - scroll the list of functions.
Each of these functions is described below.
12.1 Add a Global Security
[[Screen not in online version of documentation.]]
The Global Security Form is brought up to add a global security when you hit the Ins key while viewing the Global Security Table. The fields in the Global Security Form are:
- (Required) The Global Symbol for the security. For stocks, you probably want to enter the symbol used in the newspaper's stock exchange listings. You use this symbol to tie local securities to global securities.
- (Required) The global security Name. The security name is used on many other forms, tables, and reports by tracing the link from the local security to the global security.
- (Required) The Broker/Investment Company responsible for selling and/or holding the shares. For stocks and bonds, this will be a broker or the actual company. For mutual funds, this will be the mutual fund investment company or a broker. This name provides a link to the Broker/Investment Company File, which contains addresses and phone numbers. If you leave this entry blank or enter an invalid name, the Broker/Investment Company Lookup Table pops up. A discussion of how broker/investment companies are related to local and global securities appears in Chapter 2.
- (Optional) Account Number. For stocks and bonds, this will be your brokerage account number, company dividend reinvestment plan number, or blank. For mutual funds, this will be your fund's account number, a brokerage account number, or blank. A discussion of how account numbers are related to local and global securities appears in Chapter 2.
- (Required) Security Type. Entering a blank or invalid security type causes the Security Type Lookup Table to pop up. This table is described below. Chapter 14 contains a description of the predefined security types shipped with Capital Gainz. After entering or selecting a security type, the security type's description is displayed.
- (Optional) Dividends/Year or Interest/Year. This is the number of times this security is expected to distribute dividends or interest - not the amount of the dividends or interest. Most securities make annual, bi-annual, quarterly, or monthly payments. This value is extremely important in calculating an accurate yield for the security.
Function keys at the bottom of the screen are:
- Form Accept - accept all entries, the same as hitting Enter on each field. This key is only displayed when changing records.
- Form Reject - exit immediately, the same as hitting Esc to back out of the form. This key is only displayed when adding or changing records.
- F2:Price Update - enter a date/price value for this security. This key is only displayed when changing records.
- F3:Toggle Div/Int - this key toggles whether the security distributes dividends or interest. The Dividends/Year field label will change to Interest/Year, or vice-versa. This key is only displayed when adding or changing records.
- F4:Modify Type - bring up the Security Type Form to change values in the associated security type. This key is only displayed when changing records.
After completing the form, the global security record is added. You return to the Global Security Table, and the just added global security is highlighted.
12.1.1 Security Type Lookup
[[Screen not in online version of documentation.]]
The Security Type Lookup Table is brought up automatically if you enter an invalid security type. This table lists all of the previously entered security Types and Descriptions.
Unlike other lookup tables, the cursor is not positioned on the closest matching type. Instead, it's positioned at the top of the table, since a best match can't be determined without knowing the security class. Function keys at the bottom of the screen are:
- Enter:Select - select the highlighted security type, inserting it into the form's Type field.
- Ins:Add - define a new security type.
- F2:Change - change the highlighted security type.
- Del:Delete - delete the highlighted security type.
- Esc:Exit - exit from the table, without selecting a security type.
See Chapter 14 for details on adding, changing, and deleting security types.
12.1.2 Broker/Investment Company Lookup
[[Screen not in online version of documentation.]]
The Broker/Investment Company Lookup Table is brought up automatically if you enter an invalid broker/investment company name. This table lists all of the previously entered broker/investment company Names.
If you entered an invalid broker/investment company, the cursor is positioned on the broker/investment company that best matches the entered name. Function keys at the bottom of the screen are:
- Enter:Select - select the highlighted broker/investment company, inserting its name into the form's Broker field.
- Ins:Add - define a new broker/investment company.
- F2:Change - change the highlighted broker/investment company.
- Del:Delete - delete the highlighted broker/investment company.
- Esc:Exit - exit from the table, without selecting a broker/investment company.
See Chapter 13 for details on adding, changing, and deleting broker/investment companies.
12.1.3 Price Update
Choosing the Price Update function key on the Global Security Form brings up the Price Form to record a price/date for the global security. See Chapter 9 for details.
12.1.4 Toggle Div/Int
You can change the global security to receive Interest instead if Dividends, or Dividends instead of Interest. Depending on the setting, when you record a distribution for a local security linked to this global security, the type of distributions available will include DIV or INT. A better approach is to modify the security type instead.
12.1.5 Modify Type
The Modify Type function key on the Global Security Form lets you bring up the Security Type Form to modify the associated security type. This form is discussed in Chapter 14. If you just want to change the security type that the global security uses, use the type field on the Global Security Form.
12.1.6 Example - Add a Global Security
Say you create a global security:
Global Symbol :CPL
Name :Carolina Power & Light
Broker/Inv Co :Wachovia Bank & Trust
Account Number:
Type :LCS
Dividends/Year:4
- The broker/investment company and security type were previously defined.
- The global security record is created.
12.2 Change a Global Security
The Global Security Form is brought up to change the highlighted global security when you hit the Enter key while viewing the Global Security Table. The Global Security Form, described earlier, is initialized to the current values of the global security to be changed.
===>>> After completing the form, the global security record is updated. If you changed the symbol or dividend/interest setting, all the local security records and price history records linked to this global security are also changed. Confirmation is required regardless of the Confirm Update global setting, since many records could be affected. You return to the Global Security Table, and the just changed global security is highlighted.
12.2.1 Example - Change a Global Security
Using the previous example, say you change the Global Symbol to CP&L.
- The global security record is changed.
- Any local securities linked to this global security are updated to use the new Global Symbol.
- Price history records are updated to use the new Global Symbol.
12.3 Delete a Global Security
The Global Security Form is brought up to delete the highlighted global security when you hit the Del key while viewing the Global Security Table. The Global Security Form, described earlier, is initialized to the current values of the security to be deleted.
===>>> The global security record is deleted, as are all related price history records. However, all related local securities are NOT deleted. Instead, the global symbol field in the local security records is set to all spaces. Confirmation is required regardless of the Confirm Delete global setting, since many records could be affected. When you're finished with the Global Security Form, you return to the Global Security Table, and the security after the one just deleted is highlighted.
12.3.1 Example - Delete a Global Security
Using the previous example, say you delete the global security CP&L.
- The global security record is deleted.
- Any local securities linked to this global security are updated to use a blank Global Symbol.
- Price history records for this Global Symbol are deleted.
12.4 Price History Table
When you choose the Price History Table function key from the Global Security Table, you are asked for a date range. Then, the Price History Table for the highlighted global security and requested range of dates is shown.
The Price History Table, and adding, changing, or deleting price history entries, is described in Chapter 9.
12.5 Price Update
Choosing the Price Update function key from the Global Security Table lets you update the prices of securities by entering values from the screen or reading in a file. See Chapter 9 for more information.
12.6 Global Security Report
You can generate the Global Security Report for the highlighted security from the Global Security Table. See Chapter 15 for a description of this report.
12.7 Total Return Report
You can generate the Total Return Report for the highlighted security from the Global Security Table. See Chapter 15 for a description of this report.
12.8 Split Shares
You can record a stock split for the highlighted security from the Global Security Table. The split is applied to all local securities, in all portfolios, linked to the global security. For details and examples, see Chapter 8.
