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 |
|
|
Misc Fee |
|
|
SEC Fee |
|
|
TAF |
|
|
Exchange Fee |
|
|
NSCC Fee |
|
|
Clearing Fee |
|
|
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 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 |