💰 Brokerage Template
Brokerage Template is used to set the Brokerage parameters through multiple schemas available in the template.
User can be able to create Multiple Schema and map it to respective SIP (i.e., Segment, instrument, and Product) in a brokerage template.
⚙️ Template Creation Parameter
| 📋 Field | 📝 Description |
|---|---|
| Template Name | - Control Type: Entry Field + Drop-Down list - Shall display list of Brokerage Templates available in the system. |
| ADD ICON | - Control Type: Button - On Click of ADD, Create New Template Popup shall get enable. - New Template Name Entry Field with Label shall be available - Max 16 Characters shall be allowed. - Alphanumeric with allowed special characters. - Duplicate Template Name is not allowed. - Popup Message shall display as "Template Name Already Exists". In case of entering template name already exists in system. - OK & CANCEL Button Shall be Available. - On OK, template name shall be added to the list. - On CANCEL, "Create New Template" popup shall get close. |
| SAVE | - Control Type: Button - Enable while New Template is created / On Modification of parameter value in the existing template. - Minimum one record shall be available in Brokerage Template to save the template. - On click of SAVE post New Template creation, system shall display confirmation Pop-up as "Are you sure you want to add this template "Template Name" with Yes/No Confirmation. - On YES, template shall get saved and proper Pop-up message shall display as "Template Successfully Added". On NO, pop-up message shall get closed. - On click of SAVE post modification of existing template, system shall display confirmation Pop-up as "Are you sure you want to modify this template "Template Name"" with Yes/No Confirmation. - On YES, template shall get saved and proper Pop-up message shall display as "Template Successfully Modified". On NO, pop-up message shall get closed. |
| SAVE AS | - Control Type: Button - Shall get Enable while loading the existing Template in Template Name drop-Down List. - On click of "SAVE AS" button, new Save As pop-up window shall get open. - New Template Name Entry Field with Label shall be available (All Condition and Validation Applicable as defined in ADD Button Row) |
| CANCEL | - Control Type: Button - Enable while New Template is created - On Click of "CANCEL", New Template Name in "Template Name" drop-down list shall get clear. |
🔍 Filter Condition
| 📋 Field | 📝 Description |
|---|---|
| Market Segment (Drop-Down List) | Shall display list of "Base + Combined" Exchange available in the system. |
| Instrument Name (Drop-Down List) | Shall display list of "Instrument" available in the system for the selected "Market Segment". |
| Product Type (Drop-down List) | Shall display list of "Product Type" available in the system for the selected "Market Segment". |
| Schema (Drop-Down List) | Shall display the list of "Schema Name" added in the "Schema" Section in Brokerage Template. |
| Add/Modify Button | On Click of Add/Modify Button. Record shall get added into the Grid view. |
List of Columns on Grid View:
- Count
- Exchange
- Instrument
- Product
- Schema
📊 Schema Creation Parameter
| 📋 Field | 📝 Description |
|---|---|
| Schema Name | - Control Type: Entry Field + Drop-Down list - Shall display list of Schema available in the system. |
| ADD ICON | - Control Type: Button - On Click of ADD, Create New Schema Popup shall get enable. - New Schema Name Entry Field with Label shall be available - Max 16 Characters shall be allowed. - Alphanumeric with allowed special characters. - Duplicate Schema Name is not allowed. - Popup Message shall display as "Schema Name Already Exists". In case of entering Schema name already exists in system. - OK & CANCEL Button Shall be Available. - On OK, Schema Name shall be added to the list. - On CANCEL, "Create New Schema" popup shall get close. |
| SAVE | - Control Type: Button - Enable while New Schema is created / On Modification of parameter value in the existing Schema. - On click of SAVE post New Schema creation, system shall display confirmation Pop-up as "Are you sure you want to add this "Schema Name" with Yes/No Confirmation. - On YES, Schema shall get saved and proper Pop-up message shall display as "Schema Successfully Added". On NO, pop-up message shall get closed. - On click of SAVE post modification of existing Schema, system shall display confirmation Pop-up as "Are you sure you want to modify this Schema "Schema Name"" with Yes/No Confirmation. - On YES, template shall get saved and proper Pop-up message shall display as "Schema Successfully Modified". On NO, pop-up message shall get closed. |
| SAVE AS | - Control Type: Button - Shall get Enable while loading the existing Schema in Schema Name drop-Down List. - On click of "SAVE AS" button, new Save As pop-up window shall get open. - New Schema Name Entry Field with Label shall be available (All Condition and Validation Applicable as defined in ADD Button Row) |
| CANCEL | - Control Type: Button - Enable while New Schema is created - On Click of "CANCEL", New Schema Name in "Schema Name" drop-down list shall get clear. |
💰 Data Parameter in Schema Division
| 📋 Brokerage Type | 📝 Value |
|---|---|
| Buy Brokerage % | Percentage (0.0000 to 100) |
| Sell Brokerage % | Percentage (0.0000 to 100) |
| Buy Flat Brokerage Per Lot/Qty | Amount_Positive (0 to 900000000000) |
| Sell Flat Brokerage Per Lot/Qty | Amount_Positive (0 to 900000000000 |
| Buy Flat Brokerage Per Order | Amount_Positive (0 to 900000000000 |
| Sell Flat Brokerage Per Order | Amount_Positive (0 to 900000000000 |
| Flat Top-up Add-on Brokerage per Scrip | Amount_Positive (0 to 900000000000 |
| Minimum Brokerage | Amount_Positive (0 to 900000000000 |
| Maximum Brokerage | Amount_Positive (0 to 900000000000 |
✅ Validation
- On selection of existing schema name in the drop-down list, system shall load the data values on Brokerage Data Parameter list irrespective of the any selection in Template filter combination (i.e. "Segment + Instrument + Product + Schema")
- If any new schema added in Schema Division, same shall be passed to "Schema" list field in Template filter condition.
- New Schema shall be allowed to create / Existing schema shall be allowed to modify irrespective of Brokerage Template Selection.
- Brokerage parameter values shall be allowed to modify on selection of existing schema name in Schema Division
🗺️ Template Mapping
- User should be able to map Brokerage Template to any entity, state or profile through Template mapping.
📌 Other Inclusion
- If Order based Brokerage is selected in Other inclusion, system shall compute and consider the Brokerage on Order basis in Margin Utilization.
- If Trade based Brokerage is selected in Other inclusion, then system shall compute and consider the Brokerage on Trade basis in Margin Utilization.
🎯 RRT RULE: Brokerage and Charges
As per this rule configuration, system should compute Brokerage and Charges
Following are the list of variables for this rule
| 📋 Variable Name | ⚙️ Variable Type | 📝 Variable Value | 🔧 Default |
|---|---|---|---|
| Compute Brokerage and Charges | Check-Box | Enable / Disable | Disable |
| Include Regulatory Charges | Toggle | ON/OFF | ON |
- Brokerage Value shall get computed and validated only when the "Compute Brokerage and Charges" is selected in RRT.
- Brokerage Value shall not get computed and validated when the "Compute Brokerage and Charges" is un-selected in RRT.
Regulatory charges
- Regulatory Charges shall get computed and validated only when the "Include Regulatory Charges" toggle option is 'ON' and "Compute Brokerage and Charges" Rule is selected in RRT.
- Regulatory Charges shall not get computed and validated when the "Include Regulatory Charges" toggle option is 'OFF' in RRT.
System should compute brokerage as per the variable applicable on orders and trades for All equity, NFO, currency commodity and NFo.
Member can configure the brokerage.
Case 1
| 📋 Brokerage Type | 📝 Value |
|---|---|
| Buy Brokerage % | 1% |
| Sell Brokerage % | 2% |
Buy Brokerage%. Calculate brokerage on buy value.
Example. Order place for 100 qty for reliance at price 1200 and buy brokerage is 1% than
Calculation for brokerage is.
QTYPRICEBROKERAGE%
1001200=1200001%= 1200
Sell Brokerage % calculate brokerage on sale value.
Example Order placed for 100 qty for reliance at price 1200 and sell brokerage is 2 %
Calculation as follow
QTY*PRICE *BROKERAGE %
100*1200=120000 *2%=2400
Case 2
| 📋 Brokerage Type | 📝 Value |
|---|---|
| Buy Flat Brokerage Per Lot/Qty | 1 |
| Sell Flat Brokerage Per Lot/Qty | 2 |
Buy brokerage flat per Unit/lot
Example order place for 100 qty of reliance at the rate 1200 and brokerage is Rs 1 per Unit/lot
Calculation as follow
QTY*Brokerage
100*1= Rs. 100
Sell brokerage flat per unit/lot
Example Order place for 200 qty of reliance at the rate 1200 and brokerage is Rs 2 per unit/lot
Calculation as follow
QTY*BROKERAGE
200*2= 200.
Case 3
| 📋 Brokerage Type | 📝 Value |
|---|---|
| Buy Flat Brokerage Per Order | 50 |
| Sell Flat Brokerage Per Order | 100 |
Buy brokerage flat per order
Calculation of brokerage will done on buy order placed.
Example. One buy order place for 100 qty of reliance at 1200 and brokerage is Rs 50 per order
Calculation as follow
No of order * brokerage
1*50= 50
Sell brokerage flat per order
Calculation of brokerage will done on sell order placed
Example. One sell order place for 100 qty of reliance at the rate 1200 and brokerage is 100 per order
Calculation as follow
No of order*brokerage
1*100=100
Case 4
| 📋 Brokerage Type | 📝 Value |
|---|---|
| Buy Brokerage % | 1 |
| Flat Top-up Add-on Brokerage per Scrip | 200 |
Flat top us addon brokerage.
Any brokerage calculated by any above variable , this variable is added to the calculated brokerage.
Example Flat top up brokerage is 100 and Buy brokerage variable is applicable than computation is as follow.
Buy brokerage + flat top up brokerage
Buy brokerage %=1, Flat top up brokerage is 200
Buy order placed for 100 qty of reliance at the rate 1200
Qtypricebuy brokerage+ top up brokerage
1001200=1200001%=1200+200=1400.
Case 5
| 📋 Brokerage Type | 📝 Value |
|---|---|
| Buy Brokerage % | 1 |
| Minimum Brokerage | 400 |
Minimum Brokerage
System will compare the brokerage computed after any above variable with the minimum brokerage variable and if computed brokerage is lesser than minimum brokerage than system will charge minimum brokerage.
Example buy order 10 qty of Bank of baroda place at 30 and minimum brokerage is 400.Buy brokerage % is 1
Buy brokerage in this case is 3 and minimum brokerage is 400 system will charge 400 instead of 3.
Calculation is as follow
Qtypricebuy brokerage% compare minimum brokerage
1030=3001%=3<400=400
Case 6
| 📋 Brokerage Type | 📝 Value |
|---|---|
| Buy Brokerage % | 1 |
| Maximum Brokerage | 200 |
Maximum Brokerage
System will compare the brokerage computed after any above variable with maximum brokerage and if computed brokerage is higher than maxmimum brokerage than system will charge maximum brokerage.
Example buy order 100 qty of reliance at the rate 1200 and maximum brokerage is 200. Buy brokerage percentage is 1
Calculation is as follow
Qtypricebuy brokerage% compare maximum brokerage
1001200=1200001%=1200>200
In this case buy percentage brokerage is higher than maximum brokerage hence system will charge 200 instead of 1200.
Any brokerage computed on order based will be added in margin calculation. And any brokerage computed on trade based will added in MTM calculation.
Case 7
| 📋 Brokerage Type | 📝 Value |
|---|---|
| Buy Brokerage % | 1 |
| Sell Brokerage % | 1 |
Multileg order scenario. In this case system will compute brokerage for each order
Example. Buy 100 qty of reliance at 1200 and sell 200 qty of reliance at 1250
Buy percentage brokerage is 1 and sell percentage brokerage is 1
Calculation is as follow
Buy qtybuy pricebuy percentage brokerage + sell qtysell pricesell percentage brokerage
1001200=1200001%=1200+ 1001250=1250001%=1250
1200+1250= 2450.
📊 Scenarios with Multiple Orders of Single Scrip/Contract
Assume Brokerage Value defined in RRT Template for NSEEQ-ACC-Margin Product Type
Buy Brok% is 10,
Sell Brok% is 20
Flat Top-Up Addon Brok: 50
Minimum Brok: 500
Maximum Brok: 1000
Case 1
Place following orders:
Order 1: Place Buy-ACC-Margin-10 Qty @ 100 Price - Order Value is: 1000
Order 2: Again Place Buy-ACC-Margin-5 Qty @ 100 Price - Order Value is: 500
As per Brokerage value Defined ( Computed Brokerage is 200 (i.e. 100 for Order 1, 50 for Order 2 and Flat Top-up on Scrip/Contract is 50) and Min Brok is 500 - So Final Brokerage should be: 500)
Case 2
Place following orders:
Order 1: Place Buy-ACC-Margin-10 Qty @ 100 Price - Order Value is: 1000
Order 2: Again Place Buy-ACC-Margin-5 Qty @ 100 Price - Order Value is: 500
Order 3: Again Place Buy-ACC-Margin-50 Qty @ 100 Price - Order Value is: 5000
As per Brokerage value Defined ( Computed Brokerage is 700 (i.e. 100 for Order 1, 50 for Order 2, 500 for Order 3 and Flat Top-up on Scrip/Contract is 50) and Min Brok is 500 - So Final Brokerage should be: 700)
Case 3
Place following orders:
Order 1: Place Buy-ACC-Margin-10 Qty @ 100 Price - Order Value is: 1000
Order 2: Again Place Buy-ACC-Margin-5 Qty @ 100 Price - Order Value is: 500
Order 3: Again Place Buy-ACC-Margin-50 Qty @ 100 Price - Order Value is: 5000
Order 4: Again Place Buy-ACC-Margin-50 Qty @ 100 Price - Order Value is: 5000
As per Brokerage value Defined ( Computed Brokerage is 1200 (i.e. 100 for Order 1, 50 for Order 2, 500 for Order 3, 500 for Order 4 and Flat Top-up on Scrip/Contract is 50) and Min Brok is 500 and Max Brok is 1000 - So Final Brokerage should be: 1000)
Trade based and order-based computation of brokerage.
Scenario2.
Buy order placed for 100 qty of reliance at the rate of 1200 and 40 qty trade done at the rate of 1200.
Computation of brokerage is as follow.
100 qty placed out of which 40 qty traded than Brokerage on 100 qty will be computed on order based and 40 qty will be on trade based.