You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The report was created according to Fintranslator's instructions available here.
Here is the error:
Enter the IBKR statement CSV path (default: 2023_ibkr_report.csv): test.csv
Enter the rate CSV file path (will try to find it at: usd_ils.csv or otherwise fetch it from BOI):
Traceback (most recent call last):
File "/opt/homebrew/Caskroom/miniconda/base/envs/tfs-workshop-test1/lib/python3.9/runpy.py", line 197, in _run_module_as_main
return _run_code(code, main_globals, None,
File "/opt/homebrew/Caskroom/miniconda/base/envs/tfs-workshop-test1/lib/python3.9/runpy.py", line 87, in _run_code
exec(code, run_globals)
File "/Users/USER/work/TEMP/IBKR-to-1325-form/src/__main__.py", line 115, in <module>
main()
File "/Users/USER/work/TEMP/IBKR-to-1325-form/src/__main__.py", line 35, in main
result_df = statement_to_1325_form(schema_name_to_df['Trades'], rate_csv_path)
File "/Users/USER/work/TEMP/IBKR-to-1325-form/src/statement_to_1325.py", line 13, in statement_to_1325_form
df_statement["Date"] = pd.to_datetime(df_statement["Date/Time"]).dt.date
File "/opt/homebrew/Caskroom/miniconda/base/envs/tfs-workshop-test1/lib/python3.9/site-packages/pandas/core/tools/datetimes.py", line 1112, in to_datetime
values = convert_listlike(arg._values, format)
File "/opt/homebrew/Caskroom/miniconda/base/envs/tfs-workshop-test1/lib/python3.9/site-packages/pandas/core/tools/datetimes.py", line 488, in _convert_listlike_datetimes
return _array_strptime_with_fallback(arg, name, utc, format, exact, errors)
File "/opt/homebrew/Caskroom/miniconda/base/envs/tfs-workshop-test1/lib/python3.9/site-packages/pandas/core/tools/datetimes.py", line 519, in _array_strptime_with_fallback
result, timezones = array_strptime(arg, fmt, exact=exact, errors=errors, utc=utc)
File "strptime.pyx", line 534, in pandas._libs.tslibs.strptime.array_strptime
File "strptime.pyx", line 355, in pandas._libs.tslibs.strptime.array_strptime
ValueError: time data "2022-08-18" doesn't match format "%Y-%m-%d %H:%M:%S", at position 1. You might want to try:
- passing `format` if your strings have a consistent format;
- passing `format='ISO8601'` if your strings are all ISO8601 but not necessarily in exactly the same format;
- passing `format='mixed'`, and the format will be inferred for each element individually. You might want to use `dayfirst` alongside this.
The text was updated successfully, but these errors were encountered:
The report was created according to Fintranslator's instructions available here.
Here is the error:
The text was updated successfully, but these errors were encountered: