There are 2 types of financial ratios in the Function Selection object: General and Custom.
General ratios are the built-in ratios. Custom ratios are the ones you created using EquityRT Function Language and MyFunction tool.
Ratio Type: Financials, Daily, Internal Liquidity, Operating Efficiency, etc.
Template: You can select the template which will be used in the calculation of ratio. If you select "Empty", the template will be selected automatically using the system prerequisites.
Ratio List: The list of ratios available in the selected Ratio Type.
 |
The GroupRatio() function is the function used for the calculation of financial ratios. You can find the parameters and descriptions of this function in this topic. |
| Parameter | Description | Default Value |
| Group | Selected group | CurrentSecurity |
| Day | You can select a date or write a date function. | CurrentDay |
| Quarter | Selected quarter | CurrentQuarter |
| Ratio Name | Selected ratio | |
| Template | Selected table template | CurrentTemplate |
| Currency | Selected currency | Currentcurrency |
| Pivot Quarter | The quarter which will be used as the reference inflation quarter | |
| Rollback | Yes/No. If data is not available for the selected quarter and you want the calculations to be done with the previous data then select "Yes". If you don't want any calculations to be done then select "No". | CurrentRollback |
| Method | Announced, Calculated, Announced/Calculated. Calculated indicates the difference between the last quarter item value and the previous quarter. Announced indicates the item value in the last quarter financial table. Announced/Calculated indicates that the system looks for the announced item first, if not available then calculates the value. | Calculated |
| Inflation |
The inflation index which will be used in the calculation. If this field is empty, then Tools>Options>Inflation Security definition will be used. | CurrentInflation |
| Exclude Negatives | Ignores the negative values during calculation. | TRUE |
| Exclude Errors | Ignores the errors during calculation. | TRUE |
|
Display Unit |
Calculated result will be displayed in this unit. (If it is greater than 1 it will be divided by the value and will be multiplied otherwise.) |
1 |
 |
Examples: When Group Ratio Type=Liquidity, Template=Empty, Ratio=Cash Ratio are selected, then the function will look like GroupRatio(CurrentSecurity, CurrentDay, CurrentQuarter, "Cash_Ratio", Template(0), CurrentCurrency, Empty, CurrentRollback, Calculated) When Group Ratio Type=Operating Profitability, Template=XI_29, Ratio=Net Margin are selected, then the function will look like GroupRatio(CurrentSecurity, CurrentDay, CurrentQuarter, "Net Margin", Template(21), CurrentCurrency, Empty, CurrentRollback, Calculated) |