Help with exported historical data

[styvens]

How do I convert the time that Ninjatrader gives me when I export historical data to a readable time in excel?

[NinjaTrader_ShawnB]

Hello styvens,

Thank you for your post.

Unfortunately, there isn't an option within NinjaTrader to change this. Here is the Exporting Help Guide to assist you further.

Please let me know if you have any questions.

[s.kinra]

Hello styvens,
You can do this in excel itself, be sure to store time as text so 0 on left is not ignored then in next column you can use formula & format.
Refer attached snapshot. Hope it helps!