| Introduction |
| |
| Rule is based on thought: |
| |
| The trend is your friend and trade with the trend |
| |
| Moving average is powerful tool to spot trends. A moving average reveals the general direction and strength of a stock's price trend over a given period. |
| |
| Following Pages are there those will help us to run the process. |
| |
| • Start Form |
| • Configuration Form |
| • Start Process Form |
| • About Us Form |
| |
| The functionality of Product are as follows |
| |
- Configure the database
- Map existing tables
- Export CSV prices of security
- Fetch security prices from the configured database
- Generate Buy type of Alert.
- Show Calculated value
- Print and Print Preview functionality
|
| |
1.2 Start Page |
| |
| Start with the default page. On this page user have the facility to run the Rule or Configure the database according to their specification. |
| |
 |
| |
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. |
| |
 |
| |
| 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. |
| |
 |
| |
| 7. All drop down filled according to the Database selected by the user. Select table name for the Security table from the drop down and then below drop down filled with the column name of the selected Table Name then select the field name from the drop down according to the specification. |
| |
| 8. Next Button => Click on the next button to configure the table name and column names of Security End of day table, security intraday data 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 |
| |
OutPut Button |
| |
| User can Click on the Output button to set the output configuration in which Alert can be saved. There are two options: |
| |
| 1. By Email ïƒ Security Alert send via mail. |
| 2. By Database ïƒ Security Alert save in the database. |
| |
| For the above output process user has to insert correct information of the selected option. Figures are shown below: |
| |
| Steps: How to save Email Parameter. |
| |
| 1. Click on the Output button to set the output configuration. |
| 2. Click on the Email Check box or Database check box according to the requirement. |
| 3. Fill all parameter value and then click on the save button. |
| |
| Next Button ïƒ To set the value of the next parameter or to see the values of the parameter. |
| Back Button ïƒ To see the parameter value of the previous panel. |
| 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. |
| |
| Cancel button ïƒ On the click of the cancel button control is transferred to Start page without storing any data |
| |
 |
| |
To Execute the Rule |
| |
| 1. Click on the Start Process button to run the Rule .Buyceiling Rule Page opens as shown in the below picture. |
| |
 |
| |
| 2. Select Alert option according to the requirement. If user select All Security then this process generate alert for all security or if User select Single Security then it generate Alert for the particular Security, user can also select Selected Security option from the Alert option to generate alert for the selected Security. |
| |
| 3. Enter the Parameter values in the highlighted textbox and then Security Parameter Grid filled with the value entered by the user. User can also change the parameter value of any Security from Grid. The Buyceiling Rule screen is shown below. |
| |
 |
| |
| 4. Generate Alert Button => On click of this button Alert will be generated according to the parameter value and Details of the Alert filled in the Grid as shown below |
| |
 |
| |
| 5. Buy Alert => Blue Grid - Alert filled with SecurityPrice less than equals to the Parameter value entered in the LessThan Parameter. |
| |
| 6. Sell Alert=> Orange Grid - Alert Filled with SecurityPrice Greater than equals to the Parameter value entered in the GreaterThan Parameter. |
| |
 |
| |
| 7. User can see all the Securities for which alert not generated as shown in the below Image highlighted in red. |
| |
 |
| |
| 8. User can also generate the voice Alert. For this click on the check box of voice Alert. |
| |
 |
| |
| 9. This is a continuous application by default after every 1 minutes application run by it own and if user want to minimize the application then it store in the System Tray user can restore it to see the Alert. |
| |
| 10. Print => To Print Alters. |
| |
| 11. Preview => To see the preview of the Alerts. |
| |
| 12. Export => To Export the file in the CSV format (comma (,) separated file).User can see data in this format by saving the file. |
| |
| 13. If User selects Alert for Single Security from the Alert option button then he should enter the Security Symbol and less than and greater than parameter value to generate Alert and then click on the Go button as Shown in the below Image and now click Generate Alert Button to Generate Alerts.. |
| |
 |
| |
| 14. User can also get Moving Average by entering No of days in the Textbox and then Click on the SecurityPosition button and the data of the Selected Security Shown in the Grid as shown in the below Image. |
| |
| 15. Configuration => On Click of this Button User can set database Configuration as explained above. |
| |
16. AboutUs => On Click of this Button User can see the About Us FormAs Shown Below |
| |
 |
| |