Fee Rounding

Owned by Oleg Barshay
Last updated: Nov 23, 2012
1 min read

As mentioned here, the precision (total number of digits) of each fee that can be assessed is as follows:

Value

Data Type

Largest Value

Commission

DECIMAL(10,4)

999,999.9999

Misc Fee

DECIMAL(10,4)

999,999.9999

SEC Fee

DECIMAL(8,4)

9,999.9999

TAF

DECIMAL(10,6)

9,999.999999

Exchange Fee

DECIMAL(14,8)

999,999.99999999

NSCC Fee

DECIMAL(8,4)

9,999.9999

Clearing Fee

DECIMAL(10,4)

999,999.9999

For example, commission assessed on a single execution may not exceed 999,999.9999.  If it does, 999,999.9999 will be stored. You are also limited to 999,999.9999 across all trades for a specific symbol, account and day.

Furthermore, commission cannot have more than 4 decimal paces.  If a commission amount with more than 4 decimal places is computed, it will be rounded according to how formula rounding is configured. 

Rounding Methods

PropReports supports five rounding methods: Half Up, Half Down, Always Up, Always Down and Truncate.

Half Up 

This is the most common method of rounding and is the default.   Fractions that are 0.5 are rounded up.  Examples:

Before After
7.6
↑
8
7.5
↑
8
7.4
↓
7
-7.4
↑
-7
-7.5
↑
-7
-7.6
↓
-8

Half Down

Fractions that are 0.5 are rounded down.  Examples:

Before After
7.6
↑
8
7.5
↓
7
7.4
↓
7
-7.4
↑
-7
-7.5
↓
-8
-7.6
↓
-8

Always Up (Ceiling)

Round up regardless of the dropped digit.  Examples:

Before After
7.6
↑
8
7.5
↑
8
7.4
↑
8
-7.4
↑
-7
-7.5
↑
-7
-7.6
↑
-7

Always Down (Floor)

Round down regardless of the dropped digit.  Examples:

Before After
7.6
↓
7
7.5
↓
7
7.4
↓
7
-7.4
↓
-8
-7.5
↓
-8
-7.6
↓
-8

Truncate (No Rounding)

No rounding is performed: extra digits are simply dropped.   Examples:

Before After
7.6
↓
7
7.5
↓
7
7.4
↓
7
-7.4
↑
-7
-7.5
↑
-7
-7.6
↑
-7