Client:
Web Financial Group - Spanish Market
Data solutions company
Problem:
WFG provides data-agnostic hosted services for presenting market data, research and news on the websites of banks, wealth managers and stockbrokers. It is the dominent supplier of this type of service to banks in Spain and has offices in France and Germany. It had just opened an office in London when an opportunity arose in the UK stockbroking subsidiary of one of its European clients. The London Stock Exchange had given three months notice of the withdrawal of their data feed for company fundamental information. There was no time to redevelop and test the website before the data feed cut-off date.
Solution:
Given that there had to be the absolute minimum disruption to the stockbroking site, it was decided to replicate the data feed. New sources of data were found and an ETL process was developed to map and to transform the data elements from the new data sources into a file format that could be accepted by the website with very little change. stpsolutions was engaged for a ten week assignment to project manage the installation and to provide local expertise in the mapping of complex financial data.
Outcome:
On the date when the London Stock Exchange service was withdrawn, the switch-over to the replacement data feed was completed and clients of the stockbroker were presented with identical data to that which they were accustomed to.