Spreadsheet: 737791d1624605978-solver-formula-2-parameters-portfolio-optimization-sample-fixed-income-hydr2-
Sheet: Sheet1

Currency | Sector | Investment Grade Bonds | Non Investment Grade Bonds | Name | Range Months Maturity | Less than 3 months | 3 to 6 months | 6 to 12 months | 1 to 2 years | 2 to 3 years | More than 3 years | Amount | vars |  |  |  |  |  |  |  |  |  | Parameter 1
EUR | Investment Grade Bonds |  |  | iShares iBoxx $ High Yield Corporate Bond ETF | 1 to 2 years |  |  |  |  |  |  | 3305 | 0 |  | INPUT
EUR | Non Investment Grade Bonds |  |  | SPDR Bloomberg Barclays High Yield Bond ETF | 6 to 12 months |  |  |  |  |  |  | 831 | 1 |  | high | low | chosen | U Bound | L Bound |  | final % |  | Row Labels | Sum of Amount | %
EUR | Investment Grade Bonds |  |  | iShares Broad USD High Yield Corporate Bond ETF | 6 to 12 months |  |  |  |  |  |  | 3318 | 1 |  | 0.03 | 0.03 |  |  |  | 0.9580703006863677 |  |  | Investment Grade Bonds | 170434 | 0.9580703006863677 |  |  |  |  |  | Investment Grade Bonds | ?
EUR | Investment Grade Bonds |  |  | Xtrackers USD High Yield Corporate Bond ETF | More than 3 years |  |  |  |  |  |  | 2462 | 1 |  | 0.03 | 0.03 |  |  |  | 0.04192969931363235 |  |  | Non Investment Grade Bonds | 7459 | 0.04192969931363235 |  | To remove 35,000 |  |  |  | Non Investment Grade Bonds | ?
EUR | Investment Grade Bonds |  |  | Invesco Senior Loan ETF | 6 to 12 months |  |  |  |  |  |  | 3337 | 0 |  |  |  |  |  |  |  |  |  | Grand Total | 177893 | 1
EUR | Investment Grade Bonds |  |  | SPDR Blackstone Senior Loan ETF | 6 to 12 months |  |  |  |  |  |  | 3351 | 1
EUR | Investment Grade Bonds |  |  | iShares 0-5 Year High Yield Corporate Bond ETF | More than 3 years |  |  |  |  |  |  | 4508 | 1 |  |  |  |  |  |  |  |  |  | Parameter 2
EUR | Investment Grade Bonds |  |  | SPDR Bloomberg Barclays Short Term High Yield Bond ETF | 6 to 12 months |  |  |  |  |  |  | 4149 | 1
EUR | Investment Grade Bonds |  |  | VanEck Vectors [NAME] High Yield Bond ETF | 6 to 12 months |  |  |  |  |  |  | 3346 | 0 |  |  |  |  |  |  |  |  |  | Row Labels | Sum of Amount | %
EUR | Investment Grade Bonds |  |  | iShares Fallen Angels USD Bond ETF | 1 to 2 years |  |  |  |  |  |  | 2545 | 1 |  | 0.02 | 0.02 |  |  |  | 0.2765538835142473 |  |  | 2 to 3 years | 49197 | 0.2765538835142473 |  |  |  |  |  | 2 to 3 years | ? | 0.2765538835142473
EUR | Investment Grade Bonds |  |  | First Trust Tactical High Yield ETF | 6 to 12 months |  |  |  |  |  |  | 2498 | 1 |  | 0.02 | 0.02 |  |  |  | 0.2533770300124232 |  |  | 1 to 2 years | 45074 | 0.2533770300124232 |  |  |  |  |  | 1 to 2 years | ? | 0.2533770300124232
EUR | Investment Grade Bonds |  |  | First Trust Senior Loan Fund | 2 to 3 years |  |  |  |  |  |  | 4246 | 1 |  | 0.03 | 0.03 |  |  |  | 0.2500491868707594 |  |  | More than 3 years | 44482 | 0.2500491868707594 |  |  |  |  |  | More than 3 years | ? | 0.2500491868707594
EUR | Investment Grade Bonds |  |  | PIMCO 0-5 Year High Yield Corporate Bond Index ETF | 1 to 2 years |  |  |  |  |  |  | 2544 | 1 |  | 0.03 | 0.03 |  |  |  | 0.1731939986396317 |  |  | 6 to 12 months | 30810 | 0.1731939986396317 |  |  |  |  |  | 6 to 12 months | ? | 0.1731939986396317
EUR | Investment Grade Bonds |  |  | JPMORGAN HIGH YIELD RESEARCH ENHANCED ETF | 6 to 12 months |  |  |  |  |  |  | 3332 | 0 |  | 0.02 | 0.02 |  |  |  | 0.03290742187719584 |  |  | Less than 3 months | 5854 | 0.03290742187719584 |  |  |  |  |  | Less than 3 months | ? | 0.03290742187719584
EUR | Investment Grade Bonds |  |  | Pacer Trendpilot US Bond ETF | Less than 3 months |  |  |  |  |  |  | 2487 | 1 |  | 0.02 | 0.02 |  |  |  | 0.01391847908574255 |  |  | 3 to 6 months | 2476 | 0.01391847908574255 |  |  |  |  |  | 3 to 6 months | ? | 0.01391847908574255
EUR | Investment Grade Bonds |  |  | Invesco BulletShares 2022 High Yield Corporate Bond ETF | Less than 3 months |  |  |  |  |  |  | 3367 | 1 |  |  |  |  |  |  |  |  |  | Grand Total | 177893 | 1
EUR | Investment Grade Bonds |  |  | VanEck Vectors Emerging Markets High Yield Bond ETF | 6 to 12 months |  |  |  |  |  |  | 2493 | 1
EUR | Investment Grade Bonds |  |  | Invesco Fundamental High Yield® Corporate Bond ETF | 1 to 2 years |  |  |  |  |  |  | 2517 | 1 |  | Required |  | Calculated
EUR | Investment Grade Bonds |  |  | [NAME] 2021 High Yield Corporate Bond ETF | 1 to 2 years |  |  |  |  |  |  | 2514 | 1
EUR | Investment Grade Bonds |  |  | [NAME] 2023 High Yield Corporate Bond ETF | 2 to 3 years |  |  |  |  |  |  | 2509 | 1
EUR | Investment Grade Bonds |  |  | Xtrackers Low Beta High Yield Bond ETF | 1 to 2 years |  |  |  |  |  |  | 5050 | 1 |  | Obj funct. |  | [NAME] | 1st constr | 2nd constr
EUR | Investment Grade Bonds |  |  | SPDR Portfolio High Yield Bond ETF | 1 to 2 years |  |  |  |  |  |  | 3345 | 1 |  |  |  | 0
EUR | Investment Grade Bonds |  |  | [NAME] High Yield Corporate ETF | 1 to 2 years |  |  |  |  |  |  | 1653 | 1
EUR | Investment Grade Bonds |  |  | [NAME] 2024 High Yield Corporate Bond ETF | 2 to 3 years |  |  |  |  |  |  | 2919 | 0
EUR | Investment Grade Bonds |  |  | Invesco BulletShares 2025 High Yield Corporate Bond ETF | 2 to 3 years |  |  |  |  |  |  | 2578 | 1
EUR | Investment Grade Bonds |  |  | FlexShares High Yield Value-Scored US Bond Index Fund | 3 to 6 months |  |  |  |  |  |  | 2476 | 1
EUR | Investment Grade Bonds |  |  | Fidelity High Yield Factor ETF | 2 to 3 years |  |  |  |  |  |  | 4282 | 1
EUR | Investment Grade Bonds |  |  | Invesco Global Short Term High Yield Bond ETF | 2 to 3 years |  |  |  |  |  |  | 4174 | 1
EUR | Investment Grade Bonds |  |  | Principal Active Income ETF | 6 to 12 months |  |  |  |  |  |  | 4155 | 1
EUR | Investment Grade Bonds |  |  | Franklin Liberty Senior Loan ETF | 2 to 3 years |  |  |  |  |  |  | 3337 | 0
EUR | Investment Grade Bonds |  |  | Goldman Sachs Access High Yield Corporate Bond ETF | 2 to 3 years |  |  |  |  |  |  | 1670 | 1
EUR | Investment Grade Bonds |  |  | iShares US & Intl High Yield Corp Bond ETF | 2 to 3 years |  |  |  |  |  |  | 5104 | 1
EUR | Investment Grade Bonds |  |  | WisdomTree U.S. High Yield Corporate Bond Fund | 1 to 2 years |  |  |  |  |  |  | 4200 | 1
EUR | Investment Grade Bonds |  |  | WisdomTree Interest Rate Hedged High Yield Bond Fund | 2 to 3 years |  |  |  |  |  |  | 422 | 1
EUR | Investment Grade Bonds |  |  | iShares High Yield Bond Factor ETF | 2 to 3 years |  |  |  |  |  |  | 4659 | 1
EUR | Investment Grade Bonds |  |  | RiverFront Strategic Income Fund | 1 to 2 years |  |  |  |  |  |  | 6657 | 0
EUR | Investment Grade Bonds |  |  | High Yield ETF | More than 3 years |  |  |  |  |  |  | 4136 | 1
EUR | Non Investment Grade Bonds |  |  | iShares BB Rated Corporate Bond ETF | 1 to 2 years |  |  |  |  |  |  | 2478 | 1
EUR | Non Investment Grade Bonds |  |  | iShares Interest Rate Hedged High Yield Bond ETF | 2 to 3 years |  |  |  |  |  |  | 4150 | 1
EUR | Investment Grade Bonds |  |  | ProShares High Yield-Interest Rate Hedged ETF | More than 3 years |  |  |  |  |  |  | 5898 | 1
EUR | Investment Grade Bonds |  |  | VanEck Vectors International High Yield Bond ETF | 1 to 2 years |  |  |  |  |  |  | 3311 | 1
EUR | Investment Grade Bonds |  |  | [NAME] 2026 High Yield Corp Bond ETF | More than 3 years |  |  |  |  |  |  | 415 | 1
EUR | Investment Grade Bonds |  |  | Nuveen ESG High Yield Corporate Bond ETF | 1 to 2 years |  |  |  |  |  |  | 4955 | 1
EUR | Investment Grade Bonds |  |  | iShares International High Yield Bond ETF | More than 3 years |  |  |  |  |  |  | 4213 | 1
EUR | Investment Grade Bonds |  |  | [NAME] High Yield Bond ETF | More than 3 years |  |  |  |  |  |  | 2519 | 1
EUR | Investment Grade Bonds |  |  | KFA Dynamic Fixed Income ETF | 2 to 3 years |  |  |  |  |  |  | 3374 | 1
EUR | Investment Grade Bonds |  |  | PGIM Active High Yield Bond ETF | More than 3 years |  |  |  |  |  |  | 4144 | 1
EUR | Investment Grade Bonds |  |  | iShares iBonds 2023 Term High Yield & Income ETF | More than 3 years |  |  |  |  |  |  | 1655 | 0
EUR | Investment Grade Bonds |  |  | WBI Bull|Bear Global Income ETF | 2 to 3 years |  |  |  |  |  |  | 2466 | 0
EUR | Investment Grade Bonds |  |  | iShares iBonds 2022 Term High Yield & Income ETF | 2 to 3 years |  |  |  |  |  |  | 3307 | 1
EUR | Investment Grade Bonds |  |  | [NAME] High Yield Beta ETF | More than 3 years |  |  |  |  |  |  | 4101 | 0
EUR | Investment Grade Bonds |  |  | Highland iBoxx Senior Loan ETF | More than 3 years |  |  |  |  |  |  | 244 | 0
EUR | Investment Grade Bonds |  |  | iShares iBonds 2021 Term High Yield & Income ETF | More than 3 years |  |  |  |  |  |  | 2517 | 1
EUR | Investment Grade Bonds |  |  | [NAME] 2027 High Yield Corporate Bond ETF | More than 3 years |  |  |  |  |  |  | 240 | 1
EUR | Investment Grade Bonds |  |  | IQ S&P High Yield Low Volatility Bond ETF | More than 3 years |  |  |  |  |  |  | 3301 | 0
EUR | Investment Grade Bonds |  |  | Agility Shares Dynamic Tactical Income ETF | More than 3 years |  |  |  |  |  |  | 4129 | 1