| Introduction |
| |
| This product is used to provide live market data with the help of IQFeed API. This helps us in monitoring variations in price with the help of grid based display and colors changed based on price movement. This application provide us the database portability means we can use any database (presently only for sql server and ms-access but extensible). |
| |
| Following Pages are there those will help us to run the process. |
| |
- Start Form
- Configuration Form
- Start Process Form
- About Us Form
|
| |
Start Form |
| |
| |
| Screenshot 1 |
| |
| Start with the default page. On this page user have the facility to run the pullquote process |
| |
 |
| |
| There are four buttons on the form |
| These buttons gives following functionalities: |
| |
| Start: Start buttons is used to run the process after setting the configuration before running the configuration one need to set the configuration. It is required because the application run on your database. |
| |
| Configuration: This button goes to the page configuration where one set his own database. |
| |
| About: This button tells about the company information for which product belong to. |
| |
| Close: This button is used to exit from the application. |
| |
|
| |
| 1. Click on the Configuration button to configure. User has the ability to configure the database according to their specification. |
| |
| Screenshot |
| |
 |
| |
| 2. Select Database Type: User can choose from the above drop down his own database option weather he uses Access or Sql Database. |
| |
| 3. Now fill the Database Information according to the selected database type. Browse the Access Database or fill the required field for Sql database as shown in the image. |
| |
 |
| |
| 4. Enter Server Name, User Name and Password for sqlserver database. |
| |
| 5. Now select any database Name from the drop down which already filled on the basis of the above database entries. |
| |
| 6. Click on the next button to fill the information of the Security Table. |
| |
| Screenshot |
| |
 |
| |
| 7. All drop down filled according to the Database specification entered by the user. Select table name for the Security table from the drop down and then all drop down of this form is filled with the column name of the selected Table Name then select the field name from the drop down according to the Column Name. |
| |
| 8. Next Button => Click on the next button to configure the table name and column names of Security End of day table and Security Most Recent Price Table. |
| |
| 9. Save Button ïƒ Finally click the Save button. On the click of the button, the database configuration is saved and the control is transferred to the Start page. |
| |
| 10. Cancel button ïƒ On the click of the cancel button control is transferred to Start page without storing any data |
| |
| |
• Start Process Form |
| |
| There is following functionality available on this form |
| |
- Pull quote for all securities
- Pull quote for single security (on the base of symbol entered in the textbox)
- IQFeed API Status (Connected/Disconnected)
- Alpha Filter
- Price Grid with automatic refresh after few seconds
|
| |
| 1. Pull quote for all securities |
| |
| This is radio button and on click will show all securities in the price grid given below as shown in the image given below. |
| |
 |
| |
| .2. Pull Quote for single Security. |
| |
| This is radio button and on click will enable textbox to enter security symbol and price grid will show price data for this symbol only as shown in image given below |
| |
 |
| |
| 3. Start/Stop process |
| |
| This button is used to start/stop the background application which pulls data from IQFeed and store in the database specified in configuration section. The grid will also start refreshing for latest price data on click of start button and stop refreshing on click of stop button. |
| |
 |
| |
| 4. Alpha Filter |
| |
| There are some filters based on alphabets. On click of any alphabet shown in image given below, grid will be filled with only those securities starting with that alphabet. |
| |
 |
| |
| 5. Close button |
| |
| On click of this button the start process tab will disappear. |
| |
 |
| |
About us Tab |
| |
| This tab shows the company information. |
| |
 |
| |
| Close Tab |
| |
| On click of this tab, application will be closed. |
| |
 |
| |
| |
