We have MySQL database. Data updates every second. It is stocks (stock exchange) related data.
Mathematics formula will be given to calculate and to shortlist stocks from data of 500 stocks. Screenshot of database is shown in 2nd attachment. Screenshot shows it in table format. It is actually in MySQL database.
We should be able to control which all websites can use these snippets. We should be able to maintain website on which these widgets are allowed to appear.
What can be controlled from JS snippet:
1. Which widget to show. This will be specified as widget code in snippet
2. Size of table to show results (height and width in pixels)
3. Exchange (this is a dummy place holder which we feel might be usable later in running query on server)
4. Count of results to show in table
Widgets will keep showing updating results as and when data updates (data to be sourced through [login to view URL]). There should not be need to refresh page to reload data. Data should update dynamically when it is updated in database. Database is updated by our other programs every second.
Program should be efficient enough not to overload server. [login to view URL] or similar socket technology is preferred.
Widget must change color of cell (which shows its price) to green if price of item is higher than previous price and to red if price of item is lower than previous price (Example of it will be shown to you)
Additional requirement (not shown in attached picture):
1 html table to be written that will show all the data coming from DB server via socket.io. User must be able to sort this table as per different columns. User must be able to search items in this html table (Example of it will be shown to you)
All original code should be properly documented, organized, and handed over to us before release of any milestone. Milestone will be released only when code delivered is tested for any issues.
Please do read all requirements carefully before applying. Apply only if you can do it. No change in proposal price will be allowed.