Portfolio > Portfolio Stock

In this screen stock can be entered and maintained. This is a central function, i.e. all bookkeepings use the same file with stock.

A new kind of stock can be entered by pressing F5 (or Ctrl+N) in this tab page.

Code

A stock must have a unique code in Mill7.

Active

To make use of a stock in the portfolio bookkeeping, the check box Active must be activated. If a stock is out of use, the check box Active must be de-activated. No transactions can be made any more for the concerning stock.

Description

A stock must have a unique description in Mill7. When importing transactions, this description is used to recognize shares.

Type

Mill7 supports four kinds of stock:

- Shares

- Bonds

- Call/put options

- Warrants

Standard codes

To import rates, in this screen conversion codes can be entered in standard codes (for example ISIN, SEDOL and CUSIP).

To be able to enter these codes the stock has to be saved first.

Bonds

When bonds are entered, information concerning the issue of bonds must be entered as well.

This information is needed to calculate the (estimated) interest at the moment of buy and sale. Because of different ways of calculating, a small difference will always be in the amount.

- Issue date

This is the date of issue of the bond.

- Final date

This is the date the bond (loan) ends

- Issue price

The value of one bond on issuing. This is also the amount on which interest is calculated. Mostly this amount is 1 or 100.

- Interest

The interest percentage paid on basis of the nominal value.

- Days per year

Days per year is used to calculate the interest on buy or sale.

For example a number of 360 days means that the interest percentage for one day is: yearly interest % / 360.

- Interest payment per year

The number of times per year interest on shares is paid.

- Coupon dates

These are the dates interest is paid. Depending of the number of interest payments per year, coupon data can be entered.

The number of days of interest, since the last interest payment (coupon date) will be calculated as follows:

For example: the last payment of interest was September 1 and today it is September 10, the number of days since the last payment is 9, (2 September up to and including 10 September).

When the last coupon date is before the date of issue (for example when bonds are bought before an interest payment) the date of issue is used to calculate the number of days of interest. The date of issue itself will be used in the calculation.

For example: the date of issue is September 1 and today it is September 10, the number of days since the last payment is 10, (1 September up to and including 10 September).

If the last coupon date and the transaction date is, past or on the final date, no interest will be calculated.

- Floating rates

In case of floating rates the interest percentage can change. This can only be changed on coupon date.