How To Import Trade History Using TraderFyles Formatted CSV
If your broker is not directly supported by Traderfyles, or you are having trouble importing your data, you may be able to use our generic import format.
Only for use in Audit My Broker.
Formatting symbols for some broker CSVs into the TraderFyles format can be challenging if you don't have experience using advanced Excel formulas. We offer free formatting for all paid users of TraderFyles. Email your CSVs to our Integrations team at integrations@traderfyles.com and we will format them and email them back to you within 1 business day.
Download TraderFyles .CSV format here:
Data Requirements
Date (req'd):
The date MUST be in mm/dd/yyyy format
Time (optional):
Format MUST be HH:MM:SS, such as 09:01:40.
Parser will not work if your time looks like 9:01:40, missing the leading zero. If there is no time, leave the column blank. Do not delete the header. If no time is present, First-in-first-out (FIFO) will be used to match executions.
Symbol (req'd):
Stock
Symbol must be all caps, such as AAPL.
Options
Options symbols must be in the following format:
AAPL 21 JAN 22 $175 CALL
(Symbol, DD MMM YY, Strike Price, Call/Put)
Crypto
Format must be:
Symbol-Currency
For example, DOGE-USD // BTC-USD // ETH-USD
Quantity (req'd):
Format must be General. No number formats.
Price (req'd):
Format must be General. No currency or accounting formats.
Action (req'd):
For long equities/crypto:
Action must be either Buy or Sell.
For short equities/crypto:
Action must be either Sold Short or Buy To Cover.
For long options:
Action must be either Buy To Open or Sold To Close.
For short options:
Action must be either Sell To Open or Buy To Close.
Commissions/Fees (optional):
To get an accurate calculation, verify if your price does/doesn't include commissions and fees in your file.
If your price includes commissions and fees, leave this column blank. Do not delete the header.
If your price does not include commissions and fees, total them together and then input in each cell for the transaction they apply to.
Tip: Use a simple SUM(A1+B1) formula to total your commissions and fees for each transaction. Drag the formula down for all transactions and then copy the return value and paste the Values Only in the Commissions column.
Here is what the final format should look like:
