Omni – Fidelity Valuation Feeds

 

Fidelity may provide you with a list of all clients with values of their portfolios. The values can be used to update the values of the segregated portfolios stored in Omni.

 

Before processing the feed you need to set up the location of the feed files and the Account Number for each portfolio:-

 

Settings – File Location

 

On the System, Master User Options, Settings screen, Data Feeds tab, the folder that you want to store the Fidelity files in can be set.

 

Account Numbers

 

Fidelity’s Account Number is used to identify each client’s portfolio. The segregated portfolio is set up in the Investments, Stocks screen. The Account Number is stored in the Other Details field. It should not be confused with the Account Designation.

 

Downloading Ongoing Values

 

Once the folder setting has been stored and the Account Numbers entered, the feed can be processed as follows:

 

1.     Download the file from Fidelity

2.     Save in the folder you have selected

3.     Open the menu option System, Data Feeds, Fidelity

4.     Select the file that you have just downloaded

 

The date for each portfolio value is taken from the date in the first row of the Fidelity file.

 

A spreadsheet will be produced showing each of the records contained in the Fidelity data file. If the portfolio has been found in Omni, the scheme name and portfolio name will be shown, otherwise these columns will be left blank. The Action taken will be shown:

1.     Value created – means no price existed on that date and a new record was created

2.     Value overwritten – means there was already a price stored for that date and the value has been overwritten with the value from the data file

3.     Portfolio not found – means that the Account Number could not be found in the Other Details field of any portfolio