Trying to import from Alpaca’s activities log via the clipboard, and am running into an issue with the date/time format.
E.g Input is Aug 11, 2025, 09:57:38 AM and get Aug 1, 2011, 8:00 PM as the imported date/time (The day from the input is used as the last two digits of the year on import, and the year gets dropped).
Could use help configuring the conversion, unless this is a bug.
Ah, I technically didn’t. I started by just Copy-pasting from the activities table. I plan to add a fetcher script to fetch the data through the Trader API and prepare a csv for capitally in the future.
@claudioivm if it’s possible to copy a table and it contains relevant data, you can copy & paste into a spreadsheet (including the header) and send me a CSV to support@mycapitally.com.
For example Finax does not allow customers to export the data, so this is how the importer is done (along with the instructions ).