Bookmark this page Print this page

Set-up, On-line Contract Enquiry

Your Durell system can revalue investments and pensions on-line. To begin the set-up process, starting from Durell’s Main Menu…

There are two aspects to this setting-up process. One is to agree the manner in which everyone in your company should use Contract Enquiry, while the other is to enter the passwords or certificate details for each individual provider. We’ll start with overall settings that will apply to everyone…

Standard CE Settings for all Providers

Click the “Standard CE settings for all providers” button at the bottom right of the above screen, which will activate the following…

Provided you don’t clear the tick at the bottom-left of the above screen then everyone will still be able to override the settings (i.e. they will just be your default or standard settings). However if you do clear this tick then no-one will be able to vary the set procedure.


The RETAIN option is recommended if you wish to keep details of investment events, such as withdrawals for income and switches. The downside of this choice is that you’ll also have to match the insurer’s (sometimes non-standard) fund names with standard MEX and SEDOL ones. On the plus side it’ll allow you to use the Standard valuation report, which includes a full history of all investment transactions. You must use this option if you plan to link to other third-party investment tools like “Analytics” that require the use of standard codes.

The DELETE option is recommended if you want to minimise your workload. In this case the system will simply delete all existing fund details and replace them with the current fund totals, using the provider’s fund names. The downside of this choice is you won’t be able to keep details of switches and income withdrawals, but provided you use the Basic valuation report this won’t matter. The benefit is that it is much quicker and simpler to use.

Tick the “Always value each client’s entire portfolio…” in order to value complete portfolios instead of just one contract at a time.

Next choose the option to take in the event that a contract fails to revalue on-line (typically there’s a 70% failure rate for a variety of reasons). They are…

1) To leave the contract unchanged

2) To leave the units unchanged but update the prices using your company’s data feed from Financial Express

3) Ditto, but use a centralised data feed from Financial Express, sponsored by Durell

Note that the third option will give you the same prices as the second, but should cost your company about half as much. On the other hand you only get prices for the funds you are actually revaluing, while the second option gives your company a price history for over 2,500 funds and indices. If you don’t wish to subscribe to either of these you must select the first option.

Finally choose a “number of days” for how old Financial Express fund prices can be before the system forces you to correct them manually.

When done click the “Apply settings to ALL contracts” button, followed by the “Close” button.

Setup CE for Individual Product Providers

Back on the first Setup screen, use a piece of paper to make your own list of the product providers you use…

Set the Insurer Codes

Back at the main Setup screen, double-click the words “Insurers (Life)” in the menu list on the right

Set FSA Number and Postcode

§ Your postcode should appear at the end of your “Name & address” on the Setup screen, as shown below. This can only be entered via a licence issued from Durell, so if yours is not correct please contact Durell’s Help Desk and request a new one. The postcode must appear on a line by itself, and must be in two blocks of characters separated by a single space. It need not be on the bottom line of the “Name & address”, but must be the last line of the address with any characters in it.

UNIPASS Certificates – Getting, Saving & Importing

§ They’ll receive the certificates as downloads or email attachments, which could be saved in a location accessible to all Durell users, e.g. in the \Imw-Data\Certificates\Personal folder, as shown below

§ Even if the certificates are saved in a shared drive they will still have to be set up individually within Internet Explorer.

§ You’ll then need to import this Personal UNIPASS certificate, or any other special ones required by Cofunds, etc,  into the Internet Browser of EVERY computer (or Remote Desktop) where the user wishes to get on-line valuation, as follows...

Importing the Personal UNIPASS and Other Certificates

  • On the first computer (or Remote Desktop) open “Internet Explorer”
  • Click “Tools” on the menu line and select “Internet Options”
  • Click the “Content” tab on the “Internet Options” pop-up
  • Click the “Certificates” button, as shown below

  • On the “Certificates” pop-up click the “Import” button, as shown below...
  • A “Certificate Import Wizard” will start in which you should use the “Browse” button to find your previously saved certificate
  • You may not be able to “see” your saved certificate/s until you set “Files of type” (bottom of screen, below) to “All Files”
  • Enter the certificate’s password
  • If the “Certificate Store” screen, above, is not set to “Personal” click the “Browse” button to find the “Personal” store, below
  • Repeat this process for any other special certificates you might require, such as the Cofunds one
  • The Durell Company Certificate  - Only Required for Canada Life

    If you don’t require valuations from Canada Life you may skip this section.

    Importing the Durell certificate is similar to that described above, except afterwards you must import a further three certificates that have to go in specific locations. You’ll find a copy of the Durell Company Certificate in your \Imw-Data\Certificates\Personal folder. Import it using the password Happ1ne55 [n.b. note that this password starts with a capital H and contains three digits).

    Now select the tab for “Intermediate Certification Authorities”, as shown above, and import (n.b. one after the other) the two certificates you’ll see below. You’ll find them in your \Imw-Data\Certificates\Intermediary folder...

    Both of these must be saved in the INTERMEDIATE CERTIFICATION AUTHORITIES store, as shown below

    If you can’t see this store use the Browse button to find it, as shown below

    When you’ve finished loading BOTH of these your Certificates screen should include the two OSIS ones shown below

    Now select the Trusted Root Certification Authorities tab, as shown below

    Repeat the import process, but this time loading the OSIS Root certificate that you’ll find in your \Imw-Data\Certificates\Trusted Root folder, as shown below

    And ensure you import it into the TRUSTED ROOT CERTIFICATION AUTHORITIES store

    Set Passwords and Certificates

  • Import the Personal UNIPASS and all other required certificates into the Internet Explorer of every computer (or Remote Desktop) where the user wishes to get on-line valuations
  • o Click the “Set Certificate” button, shown above

    o Double-click the relevant certificate, which should appear in the “Personal” folder of the “Current User” on the left

    o For Canada Life you will also need to set the Durell company certificate, shown below

    o For Cofunds you’ll need to set their specific Cofunds certificate instead of the UNIPASS one, shown below

    Cofunds Only - Set the Clients

    For Cofunds the on-line enquiry system also requires you to enter Cofund’s own unique client ID for each client, which they should send to you on a CD or in an email

    To enter these codes, starting from the Durell Main Menu…