If import fails with Missing Quantity, Missing Price or Missing Required Columns, your file is missing a quantity or price header, or some rows have no values in those columns.
What these errors mean
- Missing Quantity — some trades are missing the number of shares.
- Missing Price — some trades are missing the execution price.
- Missing Required Columns — the header row is missing one or more required fields.
You may also see Invalid Quantity, Invalid Price or Number Format Problem when a cell is present but not a usable number.
Required columns for Custom CSV
Your file needs a header row and these five columns: Date/Time, Symbol, Side, Quantity and Price.
Rize Trade matches quantity headers named qty, quantity, shares or size. Price headers can be price, fill or execution.
How to fix it
- Open the file and check the first row for quantity and price headers. If either is missing, add one.
- Fill every data row under Quantity and Price.
- Confirm quantity is a real size, not zero or empty, and price is a numeric fill value.
- Save the file as CSV.
- Re-upload from Add Trades, then confirm status and trade count under Settings > Import History.