REQUIREMENT -
An application given an SQL table will plot a graphical representation of the same data using values from the provided table. The data is from a live feed.
The representation of the data needs to be in (multiple axes)
1. Stock Line / HLOC / Japanese candle sticks.
2. Bar graph ( for volumes )
The above application will be run on a computer with multiple screens and hence there is a requirement to create multiple graphs / resize the window to fit multiple graphs / display different graphs on different screens, from the same application.
An example file of the output of the table in CSV format is available at .
The application has to be customizable to select the field from the table that has to be plotted on the graph.
The axes should recalibrate according to the data returned.
For example if the data has a low of 100 and high of 120 axis should be from 95 to 125, and id the high / low value changes the axis should recalibrate accordingly.
WORKING OF THE APPLICATION -
Step 1 - Application needs to connect to the database hosted on Sql Server 2008, and pull the field names from the table required and populate (for example) combo boxes.
Step2 - The user selects the required fields and the time range ( which includes filtering according to both date as well as time ). The data feed will be live and hence the time range should also include an option to select last (x) minutes and update accordingly.
Step3 - The above data needs to be grouped.
Example the data has to be grouped by per minute. Every minute will have a maximum as high and minimum as low value. The first second data would be the open value and the last would be the close value which will be plotted.
Required is a field to specify the grouping value.
Zoom levels and scrolling for the graph are required.
DETAILS OF HARDWARE / SOFTWARE
OS : Windows Server 2003 / Windows 7
SQL Server : SQL Server Version 2008.
## Deliverables
REQUIREMENT -
An application given an SQL table will plot a graphical representation of the same data using values from the provided table. The data is from a live feed.
The representation of the data needs to be in (multiple axes)
1. Stock Line / HLOC / Japanese candle sticks.
2. Bar graph ( for volumes )
The above application will be run on a computer with multiple screens and hence there is a requirement to create multiple graphs / resize the window to fit multiple graphs / display different graphs on different screens, from the same application.
An example file of the output of the table in CSV format is available at .
The application has to be customizable to select the field from the table that has to be plotted on the graph.
The axes should recalibrate according to the data returned.
For example if the data has a low of 100 and high of 120 axis should be from 95 to 125, and id the high / low value changes the axis should recalibrate accordingly.
WORKING OF THE APPLICATION -
Step 1 - Application needs to connect to the database hosted on Sql Server 2008, and pull the field names from the table required and populate (for example) combo boxes.
Step2 - The user selects the required fields and the time range ( which includes filtering according to both date as well as time ). The data feed will be live and hence the time range should also include an option to select last (x) minutes and update accordingly.
Step3 - The above data needs to be grouped.
Example the data has to be grouped by per minute. Every minute will have a maximum as high and minimum as low value. The first second data would be the open value and the last would be the close value which will be plotted.
Required is a field to specify the grouping value.
Zoom levels and scrolling for the graph are required.
DETAILS OF HARDWARE / SOFTWARE
OS : Windows Server 2003 / Windows 7
SQL Server : SQL Server Version 2008.