We include both the time and date under the Time column, using the format:
YYYY-MM-DD HH:MM:SS.0000
The issue is that in many spreadsheet applications, dates with milliseconds aren't built-in formats. So the Time column may end up being displayed with only the time value.
The date data is still there, the Time column just needs to be reformatted in the spreadsheet application to include date formatting.
Below is a screenshot of how to adjust this setting in Google Sheets:
For Microsoft Excel on MacOS:
- Highlight the cells you need to format
- Right click and choose "Format Cells"
- Click "Custom"
- Enter YYYY-MM-DD HH:MM:SS.0000 in the "type" field and click OK
For Microsoft Excel on Windows:
- Click on the "Home" tab
- Click on dropdown arrow beside "General"
- Choose "Long Date" from the listed options
If it still doesn't work:
- Try another spreadsheet application,
- Try a text editor to view the raw csv contents,
- Try re-downloading your Trades export,
- Try requesting a new Trades export.