Spreadsheet: 881911d1730141383-how-to-select-data-in-chart-for-certain-columns-only-book2-msolver-
Sheet: New PORT

S/N | Source | VALUE | Annualized Return | % of Portfolio | LT Interest % | Monthly Interest | Category | Region | Duration | Risk | Column1 | Column2
1 | A |  | 1.6 |  | 0.11 |  | Options | US | Long | High |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Sum of VALUE |  | Row Labels | Sum of VALUE
 | Dividends | 29400 | 0.05 |  | 0.055 |  | Dividends | Germany | Long | Medium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cash | 85843 |  | Cash | 0.07438954812465964
2 | C |  |  |  |  |  | Options | US | Medium | High |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CPF | 392871 |  | CPF | 0.3404528751474571
3 | D |  | 2 |  | 0.1 |  | Crypto | US | Medium | V High |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CPFOA Investing | 72417.5 |  | CPFOA Investing | 0.06275532194025768
4 | OA | 54814 | 0.025 |  | 0.025 |  | CPF | Germany | Long | Zero |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crypto | 287526.8751004512 |  | Crypto | 0.2491641055463814
5 | SA | 266557 | 0.04 |  | 0.04 |  | CPF | Germany | Long | Zero |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dividends | 29400 |  | Dividends | 0.02547735650973281
6 | MA | 71500 | 0.04 |  | 0.04 |  | CPF | Germany | Long | Zero |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Endowment | 30000 |  | Endowment | 0.02599730256095185
7 | H | 18077 | 0.018 |  | 0.018 |  | Cash | Germany | Immediate | Zero |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Options | 97267.90000000001 |  | Options | 0.08429010085894695
9 | J | 47582 |  |  | 0.02 |  | Cash | Germany | Immediate | Zero |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Property | 84564.6 |  | Property | 0.0732817164048623
10 | K | 20184 | 0.04 |  | 0.0348 |  | Cash | Germany | Immediate | Zero |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SRS | 74075 |  | SRS | 0.06419167290675026
11 | SRS | 32018 | 0.1 |  | 0.08 |  | SRS | HK | Long | Medium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 1153965.875100451 |  | Grand Total | 1
 | SRS |  | 0.0603 |  | 0.0587 |  | SRS | Germany | Long | Medium
12 | SRS | 32129 | 0.09 |  | 0.016 |  | SRS | World | Long | Low
13 | CPFOA | 47371 | 0.09 |  | 0.0094 |  | CPF | US | Long | Low
14 | CPFOA | 24743 | 0.09 |  | 0.016 |  | CPF | World | Long | Low
 | CPFOA | 303.5 | 0.09 |  | 0.016 |  | CPF | World | Long | Low
15 | R | 30000 | 0.03 |  | 0.03 |  | Endowment | Germany | Long | Low
16 | S | -5000 |  |  |  |  | Options | Germany | Short | Zero
17 | T |  |  |  |  |  | Property | Germany | Long | Zero
 | Net Worth
 | Excluding CPF
 | USD Exchange Rate | 1.35
 | Column1 | Column2 | Column3
 | CPF
 | CPFOA Investing
 | Options
 | Crypto
 | Cash
 | Endowment
 | SRS
 | Dividends
 | Property
 | Total
 | Immediate
 | Short
 | Medium
 | Long
 | RISK
 | Zero
 | Low
 | Medium
 | High
 | V High
 | Region
 | Germany
 | US
I | HK
I | World
I
Total Portfolio Progress |  | 1000
Date | Hundred K (Update Here) | Portfolio | Net Change | % Change (MTM) | % Change (YTD)
2020-12-29 00:00:00 | 921
2021-01-21 00:00:00 | 1060
2021-04-14 00:00:00 | 1160
2021-07-04 00:00:00 | 1140
2021-09-06 00:00:00 | 1290
2021-10-17 00:00:00 | 1313
2021-10-20 00:00:00 | 1388
2021-10-25 00:00:00
2021-10-26 00:00:00 | 1430
 | 452k at 4 Feb
 | [NAME] at 2 Aug
 | 536k at 23 Aug
 | 539k at 2 Sep
 | 550k at 16 Oct
 | [NAME] at 20 Dec
 | 550k at 31 Dec
 | 558k at 9 Feb 2020
 | 604k
 | 633k at 17-May-20
 | 663k at 11-Jun-2020
 | 664k at 11-Jul-2020
 | 727k at 01-Aug-2020
 | [NAME] at 29-Aug-2020
 | 827k at 23-Nov-2020
 | 856k at 29-Nov-2020
 | 921k at 29-Dec-2020
 | 1.06M at 21-Jan-2021-01-21 (includes HDB from this point)
 | 1.16M at 14-Apr-2021
 | 06-Feb-2021 Transferred USD58.1K from IBKR to Crypto
 | 1.14M at 04-July-2021
 | 1.29M at 06-September-2021
 | Sources of income
1 | Work Salary
2 | Rental
3 | Dividends / Interest from CPF and Endowus Funds
4 | Options Active Income
5 | [NAME]
6 | Amazon Active to Passive Income