Cerca
Why the date field on Trades export files is "missing"
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 microseconds 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:
History_DateTimeFormat_10042020.png
For Microsoft Excel on Windows and MacOS:
  1. 1
    Highlight the cells you need to format.
  2. 2
    Right click and choose Format Cells.
  3. 3
    Click Custom.
  4. 4
    Enter YYYY-MM-DD HH:MM:SS.000 in the "type" field and click OK.
Screen_Shot_2020-09-24_at_6.47.40_PM.png
General_CustomExcelDateFormatting_08162022.png
Note:
  • Depending on your device's language settings the above custom formula may not work. This happens because in Excel date format placeholder letters will sometimes vary with device language settings. In order to adjust the formula correctly please visit the following external Microsoft documentation, change the page language to the same one as your device and adjust the formula to your language according to the correct date and time formatting placeholders. 
  • If you live in a country which uses decimal commas, then please correct it in by following our guide before adjusting the the date field formatting.
  • While we provide data to the Microsecond (four decimal places after a second) Microsoft Excel rounds time data to the nearest Millisecond (three decimal places).
If it still doesn't work: