Bookmark this page Print this page

Set-up, Fund Prices & Graphs

Durell allows you to store the names and codes for an almost unlimited number of investment funds, along with their current price and historic prices. The codes should preferably be the standard ones used by the “Financial Times” (e.g. MEX and SEDOL) and most other providers of investment data for computers.

Fund prices and graphs main screen.jpg

This set-up utility allows you to manually create or edit fund names and prices, but if you require fund pricing for business purposes you are advised to use one of the automatic data feeds available from “Financial Express”. Both are inexpensive, and the full one provides over 2,000 up-to-date prices per day or week, while the "lite" version (available at around half the price) can be used for all new funds that you need to enter in your policies and contracts, though you won't receive data about any other funds, for which you'd otherwise have price histories to compare and graph.

The "New" and "Delete" Buttons

 Fund prices and graphs, new button.png  

Click the "New" button, as shown above, to...

1) "Download missing fund names", which will download all the standard fund names and codes not currently on your system (n.b. without prices). This is important because unless you use the standard names and codes you won't be subsequently able to get prices via either of the Financial Express prices feeds. Because there are so many fund names (which could take a long time to download) the system prompts you to search for selected sets, such as for example, all funds beginning with "Aviva". To load the found names you should click the "Select all" followed by the "Add selected funds to local funds list" buttons. If you did want to load every single fund you'd just have to run this 26 times for each letter of the alphabet. 

Fund prices and graphs, download names.png

2) "Create new fund", which allows you to enter an fund name manually, along with all of its details and prices.

3) "Clear current graph list", which will only appear if you've got some funds selected for graph analysis, which is described in full towards the end of this section of Help. This clears the entire current list to allow you to start a new one. In contrast the "Delete" button, shown below, will only remove the currently highlighted one.  

 Fund prices and graphs, del button.png

Creating New Funds

If you subscribe to “Financial Express” then all of your funds will be created automatically. However if you’re determined to work manually, then to create a new fund…



If you click and thereby tick the box “Do not overwrite currency during update”, as suggested above, then your automatic data feed will be prevented from changing these details. This sometimes happens, for example, when the fund price changes from pennies to pounds, or cents to dollars. 


Risk Factors

You do not need to use fund risk factors, as the standard valuation report will not include them. However if you want to include a “Risk Factor” pie diagram at the end of your valuations (see Investments, Valuation Report) then you must first allocate a “Risk” value to each fund that you deal with (see example screen above), where the values and meanings (e.g. “2 – Medium”) are set-up via the “Signpost” button’s option to “Edit Risk Factors”. Use the “Risk factor” dropdown to re-select an existing value so you can edit and re-save the meaning. Alternatively to create a new one you simply over-write an existing “Risk factor” and “Description”, then click “Save”. 


Risk Factors for Investment Products Without Funds

Certain product types, like bank accounts or fixed interest accounts, do not involve funds, so instead you set a sector and risk factor for the entire product type. To do this you click the “Signpost” button’s option to “Edit Non-Fund Risk Factors” and set the rate for each product type, as shown below… 


Update Funds, Prices and Yields

To update fund prices, starting from the “Fund Prices” main screen…


Automatic Fund Price Update

If you subscribe to “Financial Express” for its FULL price feed you will periodically receive emails from them with new fund names and prices in file attachments. As this is a third-party product Durell cannot guarantee exactly how this data will arrive, but typically you should be able to double-click each attachment in order for it to unpack itself into your preferred location (see Set-up, File Paths). Typically this will be a folder called “FundPrices”, which will be a sub-folder of your main Durell data folder called “Imw-Data”. Provided you have unpacked the files into the location specified in your Set-up File Paths utility, then to load the new prices, starting from the “Fund Prices” main screen…

Deleting Old Fund Prices

If your fund price file (i.e. FinExpress.mdb) is getting too large you can strip out old prices as follows...
Fund prices and graphs, del fund prices.png

Updating Policies and Contracts with Edited Fund Details
Quite often funds will be changed to have different names, or currencies (e.g. from UK pounds to pennies), in which case after you've edited them you'll also need to update all instances of them in your policies and contracts. To do so... 

Fund prices and graphs, edit fund.png

Fund prices and graphs, update policies.png

Replacing Funds

If for example, you've created a fund manually and subsequently wish to replace it with a downloaded one that has the standard name and code you should...

Fund prices and graphs, replace fund in contracts.png

Graphing Funds

To view one or more funds in a graph, starting from the “Fund Prices” main screen…


Printing Graphs

To print a graph displayed on screen, either simply click “File / Print current screen”, or…

Then edit and print the resulting Word document. 

Graph Options

When a graph is on screen (i.e. after clicking the “Show graph” button) you can use the “Signpost” button options…