Hello Traders!
The data transfer feature on Zerodha charts is very useful.
I have tested many strategies by compiling the data in excel.
What I find a bit irritating is their date and time columns.
I cannot sort the data based on the format provided:
Date and Time will show up as - “Fri May 25 2018 13:15:00” in a single column.
Excel does not capture this data properly to sort as time and date.
I want the date in a separate column as : 25-05-2018
And time in a separate column as : 13:15:00
Or even if it comes in a single column, but in a proper date time format, will also be useful.
Does anyone know a way to do this…
Thanks and Cheers!
@Rahul_Shah1 I had checked this earlier for my backtestings. What you can do is In excel you can use text to column option that will allow you to separate this else you can ask in chatgpt and ask to split this should be possible.
Thanks. I will try this option.