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