Electra Data+ facilitates our clients’ cost reconciliations in a number of different ways. One of the bigger challenges occurs when the client favors a Position Report and the required cost basis data element is not included.
A recent example involves a client of both our Electra Data+ and Electra Reconciliation (eSTaARS) services. While they preferred the trade date based FTP Report that Electra receives for quantity/MV matching, this client requires cost basis as a data element whenever possible. The hitch being that this data is only available on a settlement dated .csv file received from the UBS PaineWebber website.
By using the eSTaARS combine feature and tweaking the mapping document of each file from our standard mapping, we were able to extract the cost basis data from the settlement file and combine it with the trade date based quantity/MV report and successfully matched it against their manager records. (Chris Koumou - Project Manager, Data Services)