At TradeJournal, we understand that some brokers and trading platforms only export trade execution details without including the exact time of each execution. This limitation can be frustrating when importing trade data into TradeJournal. However, we have solutions to help you navigate this problem.
Which brokers are affected? Some brokers like Fidelity, Schwab, Questrade, and others do not export execution times for each trade. In such cases, TradeJournal allows you to import trade data from these platforms without execution times by using our Generic Import Format. For more details on this, check out the link to our Import Transactions page below.
What do you need to know? When importing trade data, ensure that your data is sorted in chronological order, from oldest to newest. Also, note that all trade executions will be imported with a time of 12:00:00 Eastern Time.
During the import process, TradeJournal typically sorts executions by date and time to match executions into trades. However, if you are importing executions for a specific day, and none of them have a time, TradeJournal will not be able to sort the executions. In such cases, ensure that your data is sorted correctly to avoid any issues.
What are the limitations? Without correct execution times, some of the reports in TradeJournal may not show accurate data. The following reports on the Detailed tab, Win vs Loss Days, and Compare tabs may have issues:
- Distribution/Performance by Hour of Day
- Distribution/Performance by In-trade Price Range
Similarly, the following limitations apply to the Advanced reports tab and when viewing individual trades:
- Duration (for intraday trades)
- All MFE/MAE-related values
- Intraday price charts will be created, but all your executions will be plotted at 12:00:00
- Running P&L charts will not appear correct for intraday timeframes
- MFE and MAE data will not correctly reflect the price and P&L movement during the trade
Can I fix this? Yes, you can fix this by adding the real execution times after importing your data. To do so, open an individual trade and edit each individual transaction DateTime field in turn to reflect its correct time.
We hope that this helps you import your trade data without any hassle. For more details on importing data using our Generic Import Format, visit our Import Transactions page at https://www.tradejournal.co/import/transactions/.
