|Transaction Amount Tolerance Value||You can enter a transaction tolerance value to allow transactions to exceed amount within certain tolerances.TradeMax completes the calculation using the formula : Amount = Price * Quantity + Commision , if the abs(Amount – Price * Quantity – Commision)>tolerance value, trademax will display a warning message.|
This warning implies that Quantitty, Price, Commission, Fee and Amount Datafields have some problems like a hidden fee not being listed in the trade data csv file.
This problem can be viewed in the warning records
TradeMax has a default tolerance value of 0.5.
In some cases, Microsoft Excel’s column number format might trigger this warning.
Consider this record #1505.
|6-15-2011||Sell||700||VXX||BARCLAYS BANK IPATH NEW IPATH S&P 500 VIX SHORT||24.50||$17,141.14||$2.56|
Excel displays the first two digits after the decimal point under default settings.
Similarly, If the actual price is 24.491 and TradeMax is set to use xls API to import the data by default, TradeMax will read the value as 24.50.
The number of places after the decimal point can be adjusted in the Excel “Price” column format which will change it to the first three digits after the decimal point.
Excel can format numbers any way required using the “Format Cell” feature. Select the cell with the number to be formatted and press CTRL+1 (or right mouse click > format cells) to go to the Number tab in the dialog box. Select “Number” category and change 2 digits to 3 digits. This will force Excel will show the correct value.
Once saved, the excel file can then be used to import correct datafields to TradeMax again.