Nordnet

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:

     • Handelsdag

     • Oppgjørsdag

     • Transaksjonstype

     • Type verdipapir

     • Verdipapir (Ticker)

     • ISIN

     • Antall

     • Valuta

     • Kurtasje

     • Beløp

     • Totale Avgifter

     • Vekslingskurs

     • Verdipapir

     • Verifikationsnummer

     • Transaksjonstekst

     • Kjøpsverdi

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 Handelsdag and Oppgjørsdag follow the appropriate date format. The code uses DateTime.Parse to read date values.

5. Numeric Values:

   • Numeric columns should contain valid numeric values. The code expects positive numeric values for Antall, Beløp, Totale Avgifter, Vekslingskurs, and Kjøpsverdi columns.

6. Currency Codes:

   • The Valuta column should contain valid currency codes. Ensure that currency codes are in uppercase (e.g., USD, EUR).

7. Instrument Type:

   • Type verdipapir column indicates the type of the instrument.

8. Transaction Types:

   • The Transaksjonstype column defines the type of transaction, and the code handles various transaction types accordingly.

9. ISIN, Ticker, and Instrument Name:

   • Ensure that ISIN and Verdipapir (Ticker) columns are provided for each row. The code uses Verdipapir for the instrument name.

10. Positive Values:

    • The code assumes positive values for Antall, Beløp, Totale Avgifter, Vekslingskurs, and Kjøpsverdi columns.

11. Optional Columns:

    • Include optional columns if relevant to your data:

      • Kurtasje

      • Verifikationsnummer

      • Transaksjonstekst

12. 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 Nordnet 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!