currency
curr_id description
CHF Swiss Franc
USD United States Dollar
EUR European Montetary Union EURO
(3 rows)
bank
bank_id description
YSB Your Swiss Bank
(1 row)
summary_fund_cv
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
(2 rows)
share_purchase_cjv
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
(2 rows)
share_redemption_cjv
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
(2 rows)
fund_income_cjv
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  
(4 rows)
reinvested_fund_income_cjv
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
(0 rows)
summary_cjv
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  
(6 rows)
summary_cg_fifo_cjv
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
(2 rows)
summary_cg_acb_cjv
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
(2 rows)
DROP CREATE
summary_fund_income_pcjv
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
(10 rows)
DROP CREATE
summary_cg_fifo_pcjv
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
(8 rows)
DROP CREATE
summary_cg_acb_pcjv
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
(8 rows)
DROP CREATE
detailed_summary_cg_acb_pcjv
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
(10 rows)