Export Trades to CSV: "Seconds" in Time don't translate

[ScottyA]

When I export my trades to a CSV file, the Time column (which contains both Time AND Date) does not export Seconds. For example, when the MW Trade Panel shows that I executed a trade at 8:32:52, the CSV export shows that same trade as 8:32:00. Why is this?

Without this delineation, it makes journaling and reviewing my trades quite clunky.

May I make two suggestions:

1) Separate the Time and Date into two columns in hopes that a .csv file might read this accurately?

2) Allow for an Export to other formats that would take this nuance into account?

 

[MotiveWave_Jason]

Hello Scotty,

I will look into this for you and send it off to development or a feature request.

Are there any formats besides CSV that would be useful? Plain text?

Regards.

 

[ScottyA]

Thanks Jason.

Great question. Perhaps .xlsx?

 

[ScottyA]

I will look into this for you and send it off to development or a feature request.

Jason, I figured out a way to get seconds. Not sure if it was on your end or not, but here's what I found using a .csv

First, I saved it to .xlsx from .csv.

Second, I created a custom format for the Time/Date cell. The file began with "m/d/yy h:mm," and I added "m/d/yy h:mm:ss"

It works now! Thanks man.

Scotty