Spreadsheet: 103469d1301224827-pivot-problem-pivot-sort-problem
Sheet: Sheet2

Client_Name | Client_Number | Portfolio_Number | Type | Security_Name | Description | Sedol | ISIN | Quantity_Held | Price | Price_Currency | Estimated_Value | Book_Cost | Average_Cost | Date | Price USED | BookCost | Holding | Asset Type | Asset Type- details | Sub Category | Security | Currency | Exchange Rate | Price2 | % 1 YR Return | PX Change 1 Wk | PX % Change 1Wk | PX Change 1 Mth | PX % Change 1 Mth | Accrued Interest/ Gross Income | Yield | Market Value CCY | Market Value GBP | Perf GBP | Security Weight (GBP equiv) % | cpn | days acc | accrued basis | Accrued Bond Int CCY | Accrued Bond Interest GBP | Gross Annual Bond Income CCY | Gross annual Bond Income GBP | [NAME] | Fund avg dvd yld | [NAME] ind | Gross annual Income equity CCY | Gross Annual Income Equity GBP | Gross Annual Income GBP | New Market Value | Yield % | Bond Accured narrative | Stock Full Name | Price_Currency2 | Price_Currency3
mack |  |  | CASH |  |  |  |  |  | 0 | GBP | 170419.41 | 0 |  |  | 1 | 170419.41 |  | Cash |  |  |  | GBP | 1 | 1 |  |  |  |  |  |  |  | 170419.41 | 170419.41 |  | 4.22 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | Cash A/c - 10 | GBP
mack |  |  | CASH |  |  |  |  |  | 0 | GBP | 5849.76 | 0 |  |  | 1 | 5849.76 |  | Cash |  |  |  | GBP | 1 | 1 |  |  |  |  |  |  |  | 5849.76 | 5849.76 |  | 0.14 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | Cash A/c - 11 | GBP
mack |  |  | CASH |  |  |  |  |  | 0 | USD | 5417.05 | 0 |  |  | 1.626 | 5417.05 |  | Cash |  |  |  | USD | 1.626 | 1 |  |  |  |  |  |  |  | 5417.05 | 3331.519065190652 |  | 0.08 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | Cash A/c - 1 | USD
mack |  |  | CASH |  |  |  |  |  | 0 | EUR | 473.27 | 0 |  |  | 1.163 | 473.27 |  | Cash |  |  |  | EUR | 1.163 | 1 |  |  |  |  |  |  |  | 473.27 | 406.938950988822 |  | 0.01 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | Cash A/c - 1111 | EUR
mack |  |  | CASH |  |  |  |  |  | 0 | EUR | 0.01 | 0 |  |  | 1.163 | 0.01 |  | Cash |  |  |  | EUR | 1.163 | 1 |  |  |  |  |  |  |  | 0.01 | 0.008598452278589854 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | Cash A/c - 17 | EUR
mack |  |  | CASH |  |  |  |  |  | 0 | CAD | 745.24 | 0 |  |  | 1.5867 | 745.24 |  | Cash |  |  |  | CAD | 1.5867 | 1 |  |  |  |  |  |  |  | 745.24 | 469.6792084199912 |  | 0.01 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | Cash A/c - 18 | CAD
mack |  |  | CASH |  |  |  |  |  | 0 | USD | 0 | 0 |  |  |  |  |  |  |  |  |  | USD | 1.626 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | CHF | 0 | 0 |  |  |  |  |  |  |  |  |  | CHF | 1.5106 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | CHF | 0 | 0 |  |  |  |  |  |  |  |  |  | CHF | 1.5106 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | CAD | 0 | 0 |  |  |  |  |  |  |  |  |  | CAD | 1.5867 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | NOK | 0 | 0 |  |  |  |  |  |  |  |  |  | NOK | 9.0624 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | NOK | 0 | 0 |  |  |  |  |  |  |  |  |  | NOK | 9.0624 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | HKD | 0 | 0 |  |  |  |  |  |  |  |  |  | HKD | 12.6985 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | HKD | 0 | 0 |  |  |  |  |  |  |  |  |  | HKD | 12.6985 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | SGD | 0 | 0 |  |  |  |  |  |  |  |  |  | SGD | 2.068 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | SGD | 0 | 0 |  |  |  |  |  |  |  |  |  | SGD | 2.068 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | AUD | 0 | 0 |  |  |  |  |  |  |  |  |  | AUD | 1.6048 | 1 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0
mack |  |  | CASH |  |  |  |  |  | 0 | AUD | 0 | 0 |  |  |  |  |  |  |  |  |  | AUD | 1.6048 | 1 |  |  |  |  |  |  |  | 0 | 0
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 31192 | 44501.35 |  |  | 12 | 3000 | 2000 | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 31192 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP | 20
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 10275 | 8256.45 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 10275 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | AUD | 56025 | 25442.97 |  |  |  |  |  | Equities |  |  |  | AUD | 1.6048 |  |  |  |  |  |  |  |  |  | 34910.89232303091 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 100950 | 41922 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 62084.87084870849 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 81850 | 48311.54 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 81850 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 25287 | 26011.43 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 25287 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 28910 | 24804 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 28910 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 45725 | 57468 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 45725 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 49277 | 52314.49 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 49277 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 59250 | 32028.08 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 37341.6524862923 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 72020 | 60843 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 72020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 83880 | 88335.32 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 83880 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 90410 | 65597 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 90410 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 92390 | 96544.45 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 92390 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 98460 | 99096 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 98460 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 98600 | 100405.12 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 98600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 99750 | 98773 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 99750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 100340 | 100225 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 100340 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 100390 | 102339 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 100390 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 101520 | 99872 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 101520 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | BONDS |  |  |  |  |  |  | GBP | 103570 | 99619 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 103570 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 0 | 0 |  |  |  |  |  | Delisted |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 16280 | 16799.2 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 16280 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 24360 | 29121.93 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 24360 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | USD | 44880 | 50351 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 27601.47601476015 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 34545 | 29744 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 34545 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | USD | 13200 | 24975.27 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 8118.081180811809 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 14230.5 | 18090.83 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 14230.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 62475 | 40686.76 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 39374.17281149555 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 29412.5 | 31190 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 29412.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | HEDGE FUNDS |  |  |  |  |  |  | GBP | 200194 | 200025 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 200194 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 24446.4 | 25213 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 24446.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 39660 | 28327.23 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 24995.27320854604 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | HEDGE FUNDS |  |  |  |  |  |  | GBP | 54352.8119694 | 47509 |  |  |  |  |  | Alternatives |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 54352.8119694 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 34195.5 | 30252.96 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 34195.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 51637.5 | 36200 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 51637.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | USD | 63945 | 25145.89 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 39326.56826568266 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | NOK | 241650 | 25170.41 |  |  |  |  |  | Equities |  |  |  | NOK | 9.0624 |  |  |  |  |  |  |  |  |  | 26665.1218220339 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOK
mack |  |  | SHARES |  |  |  |  |  |  | USD | 43096 | 30494 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 26504.30504305043 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 56128 | 29795.63 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 34519.06519065191 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | EUR | 30125.7 | 30204 |  |  |  |  |  | Equities |  |  |  | EUR | 1.163 |  |  |  |  |  |  |  |  |  | 25903.43938091144 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EUR
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 136153 | 35564 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 85808.91157748787 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 33512.5 | 29727 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 33512.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | HKD | 417825 | 31649.74 |  |  |  |  |  | Equities |  |  |  | HKD | 12.6985 |  |  |  |  |  |  |  |  |  | 32903.4925384888 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HKD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 20211.4 | 20020.19 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 20211.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | USD | 51256.25 | 23224.22 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 31522.90897908979 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 55806.25 | 24989 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 35171.26741034853 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 53347 | 25995.64 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 32808.73308733087 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 61159 | 20921.44 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 37613.16113161132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | SGD | 49050 | 27814.12 |  |  |  |  |  | Equities |  |  |  | SGD | 2.068 |  |  |  |  |  |  |  |  |  | 23718.56866537717 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SGD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 51372.825 | 51345 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 51372.825 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 290893.125 | 287487.88 |  |  |  |  |  | Bonds |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 290893.125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | USD | 25561.25 | 16039.16 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 15720.32595325954 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 64944 | 26262 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 39940.9594095941 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 49070 | 25417.03 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 30178.35178351784 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 55000 | 28253 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 33825.33825338254 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 75270 | 32409 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 46291.51291512915 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | NOK | 415700 | 31914.67 |  |  |  |  |  | Equities |  |  |  | NOK | 9.0624 |  |  |  |  |  |  |  |  |  | 45870.85098870056 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOK
mack |  |  | SHARES |  |  |  |  |  |  | USD | 70119 | 21823.65 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 43123.61623616236 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 58684.35 | 49917 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 58684.35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 48037.5 | 49999.74 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 48037.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | AUD | 54382.5 | 36317.34 |  |  |  |  |  | Equities |  |  |  | AUD | 1.6048 |  |  |  |  |  |  |  |  |  | 33887.40029910269 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUD
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 95647.5 | 57536 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 60280.77141236528 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 50880 | 34791.37 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 32066.55322367177 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | SHARES |  |  |  |  |  |  | AUD | 37440 | 16269.61 |  |  |  |  |  | Equities |  |  |  | AUD | 1.6048 |  |  |  |  |  |  |  |  |  | 23330.00997008973 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 46749.75 | 43918.79 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 46749.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 11125 | 15349.24 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 11125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 24700 | 16258.88 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 15566.89985504507 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 95300 | 30093.94 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 60061.76340833176 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 54841.5 | 31594.55 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 33727.85977859779 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 44621.5 | 18673 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 27442.49692496925 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | USD | 58850 | 30016 |  |  |  |  |  | Equities |  |  |  | USD | 1.626 |  |  |  |  |  |  |  |  |  | 36193.11193111931 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 40446 | 35560.61 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 40446 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 16335.9 | 30344.82 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 16335.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | GBP | 40357.75 | 31114 |  |  |  |  |  | Equities |  |  |  | GBP | 1 |  |  |  |  |  |  |  |  |  | 40357.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 86872.5 | 29042 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 54750.42541123086 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | SHARES |  |  |  |  |  |  | CAD | 77184 | 41430.46 |  |  |  |  |  | Equities |  |  |  | CAD | 1.5867 |  |  |  |  |  |  |  |  |  | 48644.35621100396 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CAD
mack |  |  | SHARES |  |  |  |  |  |  | CHF | 78884 | 45012 |  |  |  |  |  | Equities |  |  |  | CHF | 1.5106 |  |  |  |  |  |  |  |  |  | 52220.30981067126 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHF