Type

Indices, Funds, Commodities, Shares, Gilts, Inflation Linked

Indices name

Name of table to be loaded

Filename

Specify the Filename to load data from

    ■    {R} - r case reference

    ■    {D}{M}{Y} -  for current day month and year

    ■    {P} - for multi-lender cases the P refers to the Policy and for investment cases P refers to Complaint Ref

    ■    {N} - for multi-lender cases the N refers to Our Ref and for investments N refers to Account Ref

    ■    {clipboard} for data that has been copied to the clipboard

Note reference numbers P and N must be saved in the case before running the wizard

Filename can be up to 255 characters

First line header

Set to indicate first line of data is a header

Data in pence/cents

Set this to indicate that the data is to be divided by 100

Ignore ZERO data

Set this to ignore zero data

Decrypt data

When loading encrypted data from the Exasoft site this will decrypt it

Date column

The column containing the date

Value column

The column containing the value

Load data

Select whether to Load or Load & Close