# Formula Pricing Guide

1. Please click on **Trade>Physical Trade **to access the physical trade details page, and click on **Next** to access the **Benchmark Pricing **page. Please select **FORMULA **from the dropdown list to use formula pricing. You may repeat the same steps to set up formula pricing for **MTM Pricing **as well.

2. The Quantity will be auto filled based on the quantity you have input in the previous page.

3. Please click on the blue “+” button to add new item for each section. The variables a, b, c etc will be generated accordingly to assist you with writing the formulas for calculations.

Please note that “e” and “pi” are special numbers so you are advised not to allow them to add, subtract and multiply as part of your formula equation, division is fine. If the case is necessary, you may add space after “e” and “pi”.

For example: e+300 will not be valid, so you can change to e + 300

Please create new row to add new products (eg SGX TSI Iron Ore CFR China (62% Fe Fines) Index Futures) and the **Formula CCY** will be auto filled based on the products, and input the **Month/Year** and** Value Date** according to the product’s characteristics.

Futures product: Input Month/Year

Forward product: Input Value Date

4. If you have input specifications data in https://mafint.atlassian.net/wiki/spaces/MCUGX/pages/1967489039 , you may choose the variables (WMT, DMT, FE %) from the drop down list:

Once selected, **Value (%) **will be automatically filled based on your data input in https://mafint.atlassian.net/wiki/spaces/MCUGX/pages/1967489039 . If **Value (%)** is empty, it means that your specifications data have not been input yet, so you may return to previous page and click on **Edit **button under the **Specifications** section to access the specifications page to fill in the data. If you are unable to click on the **Edit **button, you may have to save the page first for the system to auto-generate the trade ID, and you will then be able to click on the **Edit **button.

Please note that if any value in WMT, DMT, FE % and MOIS% is changed in math formula, system will perform P/L recalculation.

Check:

Are there spec variables in math formula?

Are those spec variables in the math formula value changed?

if both check yes, then MAF will recalculate P/L. If no formula pricing mode or no math formula, check 1 and 2 are not valid, then wont recalculate P/L

5. If you have **Premium** or **Discount** data, you may input them under the **Others** section.

6. If you have sub-variable such as **DMTU**, you may input them under the **Sub-Variable** section. This sub-variable’s value can be used to calculate formula using above variables according to your requirements, and its variable can be used as part of the final formula calculation in point 7 below.

7. Please fill in the **Formula Name **and** Formula** details accordingly. The **Formula Name **is tied to the **Formula** so when you input the **Formula Name** and **Formula **and save, the system will save it into the database. So when you select the **Formula Name **from the **Formula Template **drop down list at the top of the page, all the variables and data of the **Formula Name** will be auto-filled accordingly, reducing the need for you to manually input the formula for each trade.

Use the assigned variables (a, b, c, etc.) together with operators (+, -, *, /, ^, etc.), parentheses, and constants (2, 2.5, 6/3, etc.) to create your own formula (e.g. 1/a, a-b, (a+b)/2, (a/(a+b+c))*100).

__Updating of existing formula name’s formula:__

Formula name will save latest trade ID’s formula, regardless of whether you change old trade formula it will always use latest trade ID’s formula

For example, trade ID 100 and trade 101 use the same formula name A

so if you edit trade ID 100’s formula, the formula will apply to trade ID 100 only, if choose formula name A, it will use the latest trade ID 101’s formula

so if you edit trade ID 101’s formula, the next time you use formula name A, it will use the latest formula aka trade ID 101’s formula

When any variable is modified and saved, the system will automatically recalculate the P/L details.

Please refer to the following ** Percentage % Calculation Logic** to learn how to enter the calculation formula for %.

8. Please click on **Next **to access the **MTM Pricing** page, which you may use the above same steps if formula pricing is required, and click on **Submit** to save the details.

9. Once saved successfully, the **Formula Name** and** Formula **will be saved as a template, which can be selected from the **Formula Template** drop down list. Once you select from the list, the respective variables and formula will be auto-filled accordingly, reducing the need for you to manually input the formula for each trade.

10. If you want to edit the **Formula Name**, you may return to the same page and change the name before saving, and the template name in the **Formula Template **dropdown list will be adjusted accordingly based on the last saved name.

Please note that the system will not help to check for duplicated **Formula Name**, if the **Formula Name** is duplicated (used multiple times), the system will only return the last saved formula tied to the last saved **Formula Name.**

11. The system will automatically calculate your positions, price, and size etc according to your formula pricing set up. You may proceed to Dashboard>Individual Dashboard and create the Portfolio P/L Details app to verify if the formula and calculated P/L are accurate.

Please note that:

Invalid formula will cause Brought Price or Sold Price to be closed and become 0

Actual Qty will be linked to various models/reports app in Dashboard

Premium and Discount under Others section will allow unlimited decimal point

Exp/Inc table will show Unit Price according to product price or actual price, unless Specifications have no value or formula is incorrect

If Actual Qty has been input, when return to edit physical trade page, formula details are editable

__Percentage % Calculation Logic:__

If the **FE %** and **MOIS %** values in the **Specifications** section show, for example, 62%, it is actually calculated using 0.62 in the system. So the display is 62 but 0.62 will be used for calculations. So you need to consider adding *100 to express "multiplied by" or /100 to express "divide by" to match the corresponding calculations when entering in the final calculation formula.

**Specifications section:****FE%**and**MOIS%**are displayed as eg 62%, but 0.62 will be used to do calculations.**Sub-Variable section:**If**FE%**or**MOIS%**is needed, you may input the variable eg a or b accordingly, but if additional related % value is required, you may input in % form eg 65 in the**DMTU**value. Display is 65% but calculated amount will be using 0.65.**Formula section:**If**FE%**and**MOIS%**eg 62% is needed, you may input the variable eg a or b accordingly, and multiply by 100 (input *100 after the variable) so that the value becomes 0.62*100 to get 62, in order to standardise the digit format in the calculation formula. You may also choose to input the percentage eg 62% instead of the variable by entering 62 in the calculation formula.