When I use the Export function to output backtest or explore results to a CSV file (from Python), I encounter the following issue with the default datetime formatted columns (Date/Time column for Explore and Date, Ex. Date for Backtest): If the data is daily, everything works fine, but if the data is intraday, the default datetime formatted columns only show the column names in the CSV file without any data. I tried adding a column using the AddColumn command in the AFL code (e.g., AddColumn(DateTime(), "CustomDateTime", formatDateTime)), and this added column exports data to the CSV normally. However, for Backtest, I don’t know how to add a column in this way. If I export the report directly in AmiBroker, the data in the default columns is exported correctly, so it seems the issue lies with the Export command executed in Python. Does anyone have a solution? Thank you.
Your AB version?
Ami 6.93.0 64 bit is my ami version
Check actual exported file, not what Python seems to interpret out of it. Date time column in case of EOD data contains only date, while in Intraday contains both date and time separated by SPACE. This space might confuse your Python code
1 Like
Thank you Tomasz, my problem us solved.
This topic was automatically closed 100 days after the last reply. New replies are no longer allowed.