Schwab brokerage transcations csv changes and unhandled BrokerageActions

[pmeckoni]

I compared the schwab bokerage transactions csv downloaded on 2022-08-02 with those in folder testdata/source/schwab_csv/test_basic/transactions/

Below are the changes in csv file and the unhandled BrokerageActions that I encountered with version 1.3.5

1. Last empty column is dropped

The CSV transaction files from Schwab brokerage have dropped the last empty column.

Old header

 "Date","Action","Symbol","Description","Quantity","Price","Fees & Comm","Amount",

New headers

 "Date","Action","Symbol","Description","Quantity","Price","Fees & Comm","Amount"

2. First line and Last line have changes

I am not sure if this is useful, but the first and last lines have changed

Old first line

 "Transactions  for account Brokerage XXXX-1234 as of 11/15/2020 18:00:21 ET"

New first line

 "Transactions  for account Brokerage ...234 as of 08/03/2022 02:16:23 AM ET"

Old last line

  "Transactions Total,"","","","","","",-$9620.64

New last line

  "Transactions Total","","","","","","","-$9620.64",

3. Unhandled BrokerageAction

I experience the following unhandled BrokeageActions:

1. Pr Yr Non Qual Div
2. Cash Merger
3. Cash Merger Adj
4. Pr Yr Lt C/G Rein
5. Pr Yr Long Term Cap Gain
6. Special Qual Div
7. Name Change

[naskooskov]

I've ran into the same issue with the csv format changing. Additional transaction types I've hit are:

Assigned Wire Sent Options Frwd Split

Happy to supply example csv contents if that would help.