curr_id | description |
---|---|
CHF | Swiss Franc |
USD | United States Dollar |
EUR | European Montetary Union EURO |
bank_id | description |
---|---|
YSB | Your Swiss Bank |
Fund ID | Bank ID | curr_id | abbrev | name | wht | s_adj | derived | date | Total Number of Shares | Total Cost Basis | Average Cost Basis per Share | Total Market Value |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | YSB | EUR | Eur Eq | European Equity Fund | 0.35 | f | 2002-03-01 | 50 | 1051.00 | 21.0200 | 1100.00 | |
2 | YSB | USD | Eur Eq | European Equity Fund | 0.35 | f | 1 | 2002-03-01 | 50 | 1019.32 | 20.3864 | 951.50 |
curr_id | abbrev | Fund ID | date | Price per Share | Number of Shares | Basis Adj. per Share (fees?) |
---|---|---|---|---|---|---|
EUR | Eur Eq | 1 | 2000-02-01 | 20 | 100 | 0.25 |
USD | Eur Eq | 2 | 2000-02-01 | 19.46 | 100 | 0.2433 |
curr_id | abbrev | Fund ID | date | Price per Share | Number of Shares | Basis Adj. per Share (fees?) |
---|---|---|---|---|---|---|
EUR | Eur Eq | 1 | 2002-03-01 | 22 | 50 | 0.4 |
USD | Eur Eq | 2 | 2002-03-01 | 19.03 | 50 | 0.3461 |
curr_id | abbrev | Fund ID | Revenue Type | Distributed by Fund Manager? | Record Date | Income per Share | Pay Date |
---|---|---|---|---|---|---|---|
EUR | Eur Eq | 1 | DIV | f | 2000-12-01 | 0.27 | |
EUR | Eur Eq | 1 | DIV | f | 2001-12-01 | 0.30 | |
USD | Eur Eq | 2 | DIV | f | 2000-12-01 | 0.24 | |
USD | Eur Eq | 2 | DIV | f | 2001-12-01 | 0.27 |
curr_id | abbrev | Fund ID | date | price_ps | Number of Shares | Basis Adj. per Share (fees?) | Revenue Type | Distributed by Fund Manager? | Record Date | Income per Share | Pay Date |
---|
curr_id | abbrev | row_id | Fund ID | date | Price per Share | Number of Shares | Basis Adj. per Share | action | Sale Date | Other Basis Adj. per Share | Simple Cost Basis per Share | price | Simple Cost Basis | Total Number of Shares | Sale Price | Capital Gain, FIFO Method | Total Cost Basis | Average Cost Basis per Share | Average Basis of These Shares | Capital Gain, ACB Method | Long Term / Short Term |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EUR | Eur Eq | 1771618 | 1 | 2000-02-01 | 20 | 50 | 0.25 | BUY | 2002-03-01 | 0.57 | 21.22 | 1000.00 | 1061.00 | 50 | 1100.00 | 39.00 | 1061.00 | 21.2200 | 1051.00 | 49.00 | LTCG |
EUR | Eur Eq | 1771619 | 1 | 2000-02-01 | 20 | 50 | 0.25 | BUY | 0.57 | 20.82 | 1000.00 | 1041.00 | 100 | 2102.00 | 21.0200 | ||||||
EUR | Eur Eq | 1771620 | 1 | 2002-03-01 | 22 | 50 | 0.4 | SELL | 50 | 1100.00 | 1051.00 | 21.0200 | 1051.00 | 49.00 | |||||||
USD | Eur Eq | 1771621 | 2 | 2000-02-01 | 19.46 | 50 | 0.2433 | BUY | 2002-03-01 | 0.51 | 20.5594 | 973.00 | 1027.97 | 50 | 951.50 | -76.47 | 1027.97 | 20.5594 | 1019.32 | -67.82 | LTCG |
USD | Eur Eq | 1771622 | 2 | 2000-02-01 | 19.46 | 50 | 0.2433 | BUY | 0.51 | 20.2133 | 973.00 | 1010.67 | 100 | 2038.64 | 20.3864 | ||||||
USD | Eur Eq | 1771623 | 2 | 2002-03-01 | 19.03 | 50 | 0.3461 | SELL | 50 | 951.50 | 1019.32 | 20.3864 | 1019.32 | -67.82 |
curr_id | abbrev | Fund ID | date | Number of Shares | Sale Date | Sale Price | Simple Cost Basis | Capital Gain, FIFO Method | Long Term / Short Term |
---|---|---|---|---|---|---|---|---|---|
EUR | Eur Eq | 1 | 2000-02-01 | 50 | 2002-03-01 | 1100.00 | 1061.00 | 39.00 | LTCG |
USD | Eur Eq | 2 | 2000-02-01 | 50 | 2002-03-01 | 951.50 | 1027.97 | -76.47 | LTCG |
curr_id | abbrev | Fund ID | date | Number of Shares | Sale Date | Sale Price | Average Basis of These Shares | Capital Gain, ACB Method | Long Term / Short Term |
---|---|---|---|---|---|---|---|---|---|
EUR | Eur Eq | 1 | 2000-02-01 | 50 | 2002-03-01 | 1100.00 | 1051.00 | 49.00 | LTCG |
USD | Eur Eq | 2 | 2000-02-01 | 50 | 2002-03-01 | 951.50 | 1019.32 | -67.82 | LTCG |
curr_id | year | abbrev | sum(Net Income) |
---|---|---|---|
EUR | 2000 | Eur Eq | 27.00 |
EUR | 2000 | 27.00 | |
EUR | 2001 | Eur Eq | 30.00 |
EUR | 2001 | 30.00 | |
EUR | 57.00 | ||
USD | 2000 | Eur Eq | 24.00 |
USD | 2000 | 24.00 | |
USD | 2001 | Eur Eq | 27.00 |
USD | 2001 | 27.00 | |
USD | 51.00 |
curr_id | year | abbrev | Sale Date | Long Term / Short Term | sum(Number of Shares) | sum(Sale Price) | sum(Simple Cost Basis) | sum(Capital Gain, FIFO Method) |
---|---|---|---|---|---|---|---|---|
EUR | 2002 | Eur Eq | 2002-03-01 | LTCG | 50 | 1100.00 | 1061.00 | 39.00 |
EUR | 2002 | Eur Eq | 50 | 1100.00 | 1061.00 | 39.00 | ||
EUR | 2002 | 50 | 1100.00 | 1061.00 | 39.00 | |||
EUR | 50 | 1100.00 | 1061.00 | 39.00 | ||||
USD | 2002 | Eur Eq | 2002-03-01 | LTCG | 50 | 951.50 | 1027.97 | -76.47 |
USD | 2002 | Eur Eq | 50 | 951.50 | 1027.97 | -76.47 | ||
USD | 2002 | 50 | 951.50 | 1027.97 | -76.47 | |||
USD | 50 | 951.50 | 1027.97 | -76.47 |
curr_id | year | abbrev | Sale Date | Long Term / Short Term | sum(Number of Shares) | sum(Sale Price) | sum(Average Basis of These Shar | sum(Capital Gain, ACB Method) |
---|---|---|---|---|---|---|---|---|
EUR | 2002 | Eur Eq | 2002-03-01 | LTCG | 50 | 1100.00 | 1051.00 | 49.00 |
EUR | 2002 | Eur Eq | 50 | 1100.00 | 1051.00 | 49.00 | ||
EUR | 2002 | 50 | 1100.00 | 1051.00 | 49.00 | |||
EUR | 50 | 1100.00 | 1051.00 | 49.00 | ||||
USD | 2002 | Eur Eq | 2002-03-01 | LTCG | 50 | 951.50 | 1019.32 | -67.82 |
USD | 2002 | Eur Eq | 50 | 951.50 | 1019.32 | -67.82 | ||
USD | 2002 | 50 | 951.50 | 1019.32 | -67.82 | |||
USD | 50 | 951.50 | 1019.32 | -67.82 |
curr_id | year | abbrev | Sale Date | date | Long Term / Short Term | sum(Number of Shares) | sum(Sale Price) | sum(Average Basis of These Shar | sum(Capital Gain, ACB Method) |
---|---|---|---|---|---|---|---|---|---|
EUR | 2002 | Eur Eq | 2002-03-01 | 2000-02-01 | LTCG | 50 | 1100.00 | 1051.00 | 49.00 |
EUR | 2002 | Eur Eq | 2002-03-01 | 50 | 1100.00 | 1051.00 | 49.00 | ||
EUR | 2002 | Eur Eq | 50 | 1100.00 | 1051.00 | 49.00 | |||
EUR | 2002 | 50 | 1100.00 | 1051.00 | 49.00 | ||||
EUR | 50 | 1100.00 | 1051.00 | 49.00 | |||||
USD | 2002 | Eur Eq | 2002-03-01 | 2000-02-01 | LTCG | 50 | 951.50 | 1019.32 | -67.82 |
USD | 2002 | Eur Eq | 2002-03-01 | 50 | 951.50 | 1019.32 | -67.82 | ||
USD | 2002 | Eur Eq | 50 | 951.50 | 1019.32 | -67.82 | |||
USD | 2002 | 50 | 951.50 | 1019.32 | -67.82 | ||||
USD | 50 | 951.50 | 1019.32 | -67.82 |