in generated csv file, the field name mismatch with value about robinhood-to-csv HOT 2 OPEN

When the file is read as comma delimited, commas within the executed_notional limit buy/sell field (which is a dictionary) cause that column to be read as three separate columns and this spills over to execution_state and extended_hours. The same is true for the total_notional column.

For a very quick fix, I've added the following snippet at line 74 of csv_export.py:

    if order['executed_notional'] is not None:
        order['executed_notional'] = order['executed_notional']['currency_id']+' | '+order['executed_notional']['amount']+' | '+order['executed_notional']['currency_code']
    if order['total_notional'] is not None:
        order['total_notional'] = order['total_notional']['currency_id']+' | '+order['total_notional']['amount']+' | '+order['total_notional']['currency_code']

it seems last_trail_price may have the same issue.

        if order['executed_notional'] is not None:
            order['executed_notional'] = order['executed_notional']['currency_id']+' | '+order['executed_notional']['amount']+' | '+order['executed_notional']['currency_code']
        if order['total_notional'] is not None:
            order['total_notional'] = order['total_notional']['currency_id']+' | '+order['total_notional']['amount']+' | '+order['total_notional']['currency_code']
        if order['last_trail_price'] is not None:
            order['last_trail_price'] = order['last_trail_price']['currency_id']+' | '+order['last_trail_price']['amount']+' | '+order['last_trail_price']['currency_code']

from robinhood-to-csv.

When the file is read as comma delimited, commas within the executed_notional limit buy/sell field (which is a dictionary) cause that column to be read as three separate columns and this spills over to execution_state and extended_hours. The same is true for the total_notional column.

For a very quick fix, I've added the following snippet at line 74 of csv_export.py:

    if order['executed_notional'] is not None:
        order['executed_notional'] = order['executed_notional']['currency_id']+' | '+order['executed_notional']['amount']+' | '+order['executed_notional']['currency_code']
    if order['total_notional'] is not None:
        order['total_notional'] = order['total_notional']['currency_id']+' | '+order['total_notional']['amount']+' | '+order['total_notional']['currency_code']

from robinhood-to-csv.