Feedback Form
Single Trail Stop Loss Exit Rule
um User Manual
 
Introduction
 
A security drawdown represents the drop from a peak to a trough for price of a stock, fund or commodity. This product gives us the facility to calculate security drawdown on security end of day close prices and with facility to do this within your existing database so this application can be incorporated into already running application. We can treat this application as a support application for application like trading rules which needs drawdown information for making trading decisions for buying/selling securities. It shows us to analyze the drawdown with the help of graphical charts and also provide graphical chart for Moving average v/s End of day price of security

 
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
  • Calculate Drawdown
  • Show Drawdown and EODPrice v/s Moving average graph
  • Save calculated database in configured database in mapped tables
 

Start Form

 
Start with the default page. On this page user have the facility to run the pullquote process
 
i
 
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.
 

Configure Form

 
1. Click on the Configuration button to configure. User has the ability to configure the database according to their specification.
 
Screenshot
 
configure form
 
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.
 
2
 
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
 
configure
 
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, 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
 
 

• Start Process Form

 
There is following functionality available on this form
 
  • Browse .csv file
  • Export EOD Prices
  • Security Drop down for filling Price data grid with EOD prices of selected security
  • Enter MA Days
  • Calculate Drawdown
  • Show Drawdown graph
  • Save Drawdown data
 
1. Browse .csv file
 
This is for selecting .csv file which will contains security EOD price data. File must be in format of (SecuritySymbol, EODDate, EODPrice). This button is highlighted in the below image.
 
start process
 
2. Export EOD Prices
 
On click of this button price data of selected .csv file will be exported to grid price data shown in the below image.
 
3. Security Drop down for filling Price data grid with EOD prices of selected security
 
The dropdown will be filled from the configured database from security table. On selected of any security the EOD price data grid will be filled with the price data from the configured database from the securitydailydata table.
 
 
4. Enter MA Days
 
This is text box which will be used for calculating the moving average on click of calculate drawdown button as shown in the below image.
 
 
5. Calculate Drawdown
 
On click of this button drawdown values will be calculated and drawdown data grid will be filled with the drawdown data. There are some label also which has been highlighted in the below image. These labels show values for Max Drawdown, Avg Drawdown, Current Drawdown, and High Watermark
 
 
6. Show Drawdown Graph
 
On click of this button graph will be generated for drawdown data and one another graph which will show the graph between moving average and EOD price.
 
 
 

About us Tab

 
This tab shows the company information.
 
 
Close Tab
 
On click of this tab, application will be closed.
 
 
 
 
 
©Copyright 2003 econnoisseur