US Securities - FAQs

If I have a large number of US securities, how can I receive them from a data feed?

The answer to this depends on which data feed is in use.

• Exshare feed. The Exshare feed from ICE Data Services (formerly Interactive Data) does not add US ISIN codes to your database or update them.  The feed does contain an alternative security code which is the SEDOL code. Unfortunately the main reason users use ISIN codes, rather than SEDOL codes, is to avoid the charges from the London Stock Exchange for SEDOL codes. Documentation on these charges can be found at:  http://www.londonstockexchange.com/products-and-services/reference-data/sedol-master-file/documentation/documentation.htm
  • If you are willing to pay the SEDOL licensing charges, Trust Accounts provides a method of converting from ISIN codes to SEDOL codes using QTRUMP32.EXE under Tools > Securities Parameters. Then select Convert to SEDOLs (automatic conversion). You should perform this conversion before upgrading to Trust Accounts 2017.4. After the upgrade you can no longer perform an automatic conversion, although a manual conversion will still be possible.
  • If you are not willing to pay the SEDOL licensing charges and you still need a data feed of US securities then your only other option at the time of writing is to convert to the Telekurs Data Feed from SIX Financial. This uses a Valor code to represent US securities.
• Telekurs feed from SIX Financial uses a Valor code to represent US securities. The data feed will continue to supply data on US securities. You could still face a problem in data entry when you receive a contract note or dividend advice that uses a US ISIN. You could search for the security by name, but if you need to be able to search by ISIN then you could subscribe to a service by which you could look up the ISIN and find the Valor code. SIX Financial offers the Valor Data Browser which does this and there may be other services.

If I have a feed of transactions from a broker that uses US ISINs, how can I import them into Trust Accounts?

• The broker may be able to provide a different code. For instance, a Swiss broker might be able to supply a Valor code.
• Otherwise the only solution is to manually create a spreadsheet that maps the US ISIN codes to the codes in use in Trust Accounts. You can then use this spreadsheet to map the codes in the brokers’ files to the Trust Accounts codes. But this solution does increase the time required to import data and you should check the licence terms on the CSG website.

What is the easiest way to search for a security by name?

On the Securities screen there is a Find button. There are several options here, but the most useful is:

• Quick (First word plus text search)

This option is used when the first word of the security name is known plus one or more other words. The search program will quickly return the matching securities. For instance, entering Fidelity Inc returns Fidelity Funds Income Units but does not return Professional Life Fidelity Inc Units. In the second case, Fidelity is present but is not the first word. This option is useful for searching for funds or gilts, e.g. Treasury 2018.

There are also options that search for any part of the security name, and even search through former names if the old name is available in Edit Security > Other > Name changes. But these options take longer to run, particularly on a C-Tree database. So the Quick option is the most popular.