All ideas

Occasional incorrect cost basis with large CMC trades via import

Expected Behavior Cost basis in "Consideration" column in the downloaded CSV = Price x Quantity+Brokerage exactly. Current Behavior Price column x Quantity column + Brokerage column is incorrect when the price involves four decimal places. This only shows up for large trades. The issue is CMC doesn't provide enough precision in the Price column, i.e., 4 decimal places is inaqequate. Possible Solution The price needs more decimal places. It equals (Consideration - Brokerage)/Quantity. Include at least 6 decimal places, preferablly more. The fractional price only occurs when multiple trades at different prices are required to fill an order. Steps to Reproduce From CSV file for my last trade uploaded to Navexa: Price: 104.0698 Quantity: 2536 Brokerage: 239.93 Consideration: 264,161.03 The consideration was actually charged by CMC, thus the actual share price is: (264,161.03-239.93)/2536 = 104.0698344. With CMC truncating the price to 4 dp results in a cost basis of: 264,160.9428 which differs from the actual cost basis by 8.72 cents. With enough trades like this the cash account ends up being quite out from what is actually there due to this random roundoff error. Context (Environment) Spent quite some time trying to track down why my cash account balance wasn't exactly correct. Just don't use the price listed in the CSV file downloaded by CMC, there's not enough dp. There's clearly no issue at all for trades that are filled at a single price.