Spreadsheet: 853591d1703485756-bond-portfolio-automation-bondportfolio-with-pq
Sheet: Example2

 | Transactions
 | Side | Date | Type | ISIN | Ticker | Ccy | Maturity | Cpn% | CpnFqcy | Notional ($) | Date2 | PRICE
 | B | 2019-03-22 00:00:00 | Bond | US900123CT57 | TURKEY 7.625 2029 | USD | 2029-04-26 00:00:00 | 7.625 | 2 | 300000 | 2019-03-24 00:00:00 | 85 |  | 43616 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | 300000 | 43618 | 100
 | B | 2019-05-31 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | 300000 | 2019-06-02 00:00:00 | 100 | S | 43714 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | -300000 | 43716 | 111
 | S | 2019-09-06 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -300000 | 2019-09-08 00:00:00 | 111 | B | 43899 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | 400000 | 43901 | 108
 | S | 2019-10-18 00:00:00 | Bond | US900123CT57 | TURKEY 7.625 2029 | USD | 2029-04-26 00:00:00 | 7.625 | 2 | -300000 | 2019-10-20 00:00:00 | 92 | S | 43902 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | -300000 | 43904 | 95
 | B | 2020-03-01 00:00:00 | Bond | US900123AY60 | TURKEY 6.875 2036 | USD | 2036-03-17 00:00:00 | 6.875 | 2 | 200000 | 2020-03-03 00:00:00 | 89 | S | 43924 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 54483 | 8.7 | 2 | -200000 | 43926 | 94
 | B | 2020-03-09 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | 400000 | 2020-03-11 00:00:00 | 108
 | B | 2020-03-09 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | 400000 | 2020-03-11 00:00:00 | 85
 | B | 2020-03-09 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 500000 | 2020-03-11 00:00:00 | 92
 | S | 2020-03-12 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -300000 | 2020-03-14 00:00:00 | 95
 | S | 2020-03-12 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | -200000 | 2020-03-14 00:00:00 | 93
 | B | 2020-03-31 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 300000 | 2020-04-02 00:00:00 | 88
 | S | 2020-04-03 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -200000 | 2020-04-05 00:00:00 | 94
 | Portfolio
 | X | Date | Type | ISIN | Ticker | Ccy | Maturity | Cpn% | CpnFqcy | Notional ($) | Date | PRICE
 |  |  | Bond | US900123AY60 | TURKEY 6.875 2036 | USD | 2036-03-17 00:00:00 | 6.875 | 2 | 200000 | 2020-03-03 00:00:00 | 89
 |  | 2020-03-09 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | 100000 | 2020-03-11 00:00:00 | 108
 |  | 2020-03-09 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | 200000 | 2020-03-11 00:00:00 | 85
 |  | 2020-03-09 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 800000 | 2020-03-11 00:00:00 | 92
 |  |  | Bond | US900123AY60 | TURKEY 6.875 2036 | USD | 2036-03-17 00:00:00 | 6.875 | 2 | 200000 | 2020-03-03 00:00:00 | 89
 |  | 2019-05-31 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -100000 | 2019-06-02 00:00:00 | 100
 |  | 2020-03-09 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | 200000 | 2020-03-11 00:00:00 | 85
 |  | 2020-03-09 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 800000 | 2020-03-11 00:00:00 | 92
 | Side | Date | Type | ISIN | Ticker | Ccy | Maturity | Cpn% | CpnFqcy | Notional ($) | Date2 | PRICE
 | B | 2020-03-01 00:00:00 | Bond | US900123AY60 | TURKEY 6.875 2036 | USD | 2036-03-17 00:00:00 | 6.875 | 2 | 200000 | 2020-03-03 00:00:00 | 89 | <= | Power Query
 | B | 2020-03-31 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 800000 | 2020-04-02 00:00:00 | 88
 | S | 2020-03-12 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | 200000 | 2020-03-14 00:00:00 | 93
 | S | 2020-04-03 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -100000 | 2020-04-05 00:00:00 | 94