<< Click to Display Table of Contents >> Navigation:  General > Import data > Import Portfolio stock

The next fields can be allocated:

 

1. Code *

2. Active (when not connected or empty default value is 0 = not active)

3. Description *

4. Type (when not connected or empty default value is 0 =  shares)

5. Currency *

6. Issue date **

7. Final date **

8. Issue price **

9. Annual interest **

10. ISIN

11. SEDOL

12. CUSIP

 

 

Code

The stock code. This code must be unique and has a maximum of 10 characters.

 

Description

The stock description. This must be unique and has a maximum of 40 characters.

 

Active

To be able to use a code it must be active. This is indicated with the value "1".

 

Type

Mill7 contains four kinds of stock:

0 = Shares

1 = Bonds

2 = Call/put options

3 = Warrants

 

In case of Type is uneven "1" the fields 6 to 9 are not imported.

 

ISIN, SEDOL en CUSIP

These conversion codes can be used for importing stock rates.

A code should not be longer than 15 characters.

 

Default values for Bonds

The following fields will get a default value:

Days per year = "360"

Interest payments per year = "1"

Coupon date = "1 january"