Handelsbanken Excel

1. Worksheet Name:

   • Ensure that your Excel file contains the necessary data in an appropriate worksheet. The code does not rely on a specific worksheet name.

2. Column Headers:

   • The code expects specific columns in your worksheet. Make sure your columns have the following headers:

     • SETTLEMENT_DATE

     • TRADE_DATE

     • TRANSACTION_TYPE

     • INSTRUMENT_NAME

     • ISIN

     • ORG.NR VP

     • ISO_CURR

     • CONTRACT_NOTE

     • ANTALL

     • RENTER VALUTA

     • BELØP VAL

     • RENTER NOK

     • BELØP NOK

     • CASH_ACCOUNT

     • SAFE_ACCOUNT

     • TICKER_CODE

     • BROKER

     • FEE NOK

3. Data Entries:

   • Enter your data in the appropriate columns below the headers. The code processes rows based on specific columns and their corresponding values.

4. Date Formats:

   • Ensure that date-related columns like SETTLEMENT_DATE and TRADE_DATE follow the format "yyyyMMdd" for successful parsing by the system.

5. Numeric Values:

   • Numeric columns should contain valid numeric values. The code expects positive numeric values for ANTALL, RENTER VALUTA, BELØP VAL, RENTER NOK, BELØP NOK, and FEE NOK columns.

6. Currency Codes:

   • The ISO_CURR column should contain valid currency codes in uppercase (e.g., USD, EUR).

7. OrgNr, ISIN, and Instrument Name:

   • Ensure that ORG.NR VP and ISIN columns are provided for each row. Additionally, the code uses INSTRUMENT_NAME for instrument names.

8. Positive Values:

   • The code assumes positive values for quantity (ANTALL), currency interests (RENTER VALUTA), currency amount (BELØP VAL), interest (RENTER NOK), total amount (BELØP NOK), and broker fee (FEE NOK) columns.

9. Optional Columns:

   • Include optional columns if relevant to your data:

     • TICKER_CODE

     • CASH_ACCOUNT

     • SAFE_ACCOUNT

     • (Add any other optional columns your data may have)

10. Save the File:

    • Save your Excel file in a common format (e.g., .xlsx).

By following these guidelines and replacing the placeholders with your actual column names, your Excel file will align with the expectations of the provided HandelsBanken Excel Converter code. If you have any specific business rules or requirements related to your data, make sure to follow those as well. If you have any questions or need further assistance, feel free to ask!

Feel free to customize this list based on your specific column names and requirements!