Responsive Web Search System for Stock Brokers

1
Stock Search Engine
2
About Client

• The client is one of the leading stock brokers in
  United Kingdom. They provide a platform to their
  customers to sell funds, shares and other related
  products to the retail investors.

3
Requirement

• There was a requirement of a system that allows
  the users to perform a search through granular
  criteria specified by them. User has to choose
  the necessary criteria and then specify the
  acceptable range. Based on it, the system will
  populate matching stocks to the users.

4
Solution

• The stock search engine had to provide screening
  on different stock types i.e. shares, ETFs,
  funds, bonds, investment trusts, venture capital
  trusts, warrants, etc. And each of the stock
  types had different set of criteria. For e.g.,
  for shares there are earnings per share (EPS),
  while for bonds there are coupon rates and
  redemption dates to be searched for.
• Solr provides fast and sophisticated text search
  with scalability. The query response time in case
  of Solr server is faster and more predictable
  against any SQL database where query speed
  depends based on design and use case.
• The main challenge for the stock search engine
  was to deliver real time results and for that all
  the data needs to be accessed very fast.

5

• All the data was pulled from different data
  sources like Thomson Reuters, Digital Look,
  Proquote, MorningStar, InteractiveData, etc. and
  after merging the data and making a flat
  structure was injected into different Solr cores
  based on their respective stock types.
• The solution to that was to index all the data
  into the Solr server and then front-end can query
  from data from the Solr server. Also, we
  implemented multiple Solr cores for searching of
  different criteria based on stock types.
• To fetch all the data quickly, we chose Solr for
  indexing and storing the data over traditional
  RDBMS databases.

6
Technical Architecture
7
Tools Technologies
8

• Let's Discuss Your Requirement!
•  info_at_azilen.com  1-972-325-2243

9

• Original Source
• http//www.azilen.com/case-study/stock-search-engi
  ne/

10
Thanks You www.azilen.com