Fundamental Data Service
Sinara built a bespoke system to enable a major stock exchange to launch a UK Company Fundamental data service for its clients.
At the core of the system was a data extraction tool developed by Sinara to extract structured data from free-text company announcements published on the LSE RNS service.
Regulatory news stories were automatically read in real-time from a news feed and parsed to identify component parts such as the profit/loss statement and balance sheet. These were then broken down into rows and columns which were identified using fuzzy logic. The system was configured to extract over 100 individual fundamental data items which were then saved into a SQL database.
A front end work flow application guided a team of operators through the process of checking the automatically captured data. Users could view the original story alongside the captured data and complete any missing fields with the assistance of a formula based calculator. Users could interactively reconfigure the extraction process by adding text strings that are used to identify fields and tables, and then resubmit stories to the extraction process.
Once checked, the data was then exported for use within a number of the client’s Fundamental Data and other financial information products.
Sinara delivered this project in two phases. The first was an analysis phase that established the feasibility and cost effectiveness of the system, followed by the development and build phase which was completed on time and entirely to the client’s satisfaction. Sinara continued to support and enhance the system over a number of years.