1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
Script started on Wed 21 Jan 2004 08:00:37 PM CST
edd@homebud:~> setup_beancounter
Creating beancounter database
** Running: createdb beancounter
CREATE DATABASE
Creating beancounter database tables
Filling beancounter database tables with DJIA stocks
** Running: beancounter --dbsystem PostgreSQL --dbname beancounter addindex DJIA AA AXP T BA CAT C KO DIS DD EK XOM GE GM HPQ HD HON INTC IBM IP JNJ MCD MRK MSFT MMM JPM MO PG SBC UTX WMT
Filling beancounter (sample) portfolio
** Running: beancounter --dbsystem PostgreSQL --dbname beancounter addportfolio CSCO:50:USD NT.TO:100:CAD SIEGn.DE:10:EUR CGEP.PA:50:EUR
Filling beancounter with stock info and most recent prices for DJIA stocks
** Running: beancounter --dbsystem PostgreSQL --dbname beancounter addstock AA AXP T BA CAT C KO DIS DD EK XOM GE GM HPQ HD HON INTC IBM IP JNJ MCD MRK MSFT MMM JPM MO PG SBC UTX WMT
Filling beancounter with historical prices for example portfolio stocks
** Running: beancounter --dbsystem PostgreSQL --dbname beancounter backpopulate --prevdate '1 year ago' --date 'yesterday' CSCO NT.TO SIEGn.DE CGEP.PA
adding CSCO from 20030121 to 20040120
adding NT.TO from 20030121 to 20040120
adding SIEGN.DE from 20030121 to 20040120
adding CGEP.PA from 20030121 to 20040120
Filling beancounter with historical fx prices for EUR and CAD
** Running: beancounter --dbsystem PostgreSQL --dbname beancounter fxbackpopulate --prevdate '1 year ago' --date 'yesterday' EUR CAD
backpopulating EUR (using ^XEU) from 20030121 to 20040120
backpopulating CAD (using ^XCD) from 20030121 to 20040120
Running portfolio pl report on (sample) portfolio
** Running: beancounter --dbsystem PostgreSQL --dbname beancounter plreport --date 'yesterday'
===============================================================================
Profit / loss from 21 Jul 2003 to 20 Jan 2004 abs, rel change
-------------------------------------------------------------------------------
ALCATEL USD 437.31 7.74 852.39 13.53 415.08 94.92%
CISCO SYSTEMS USD 896.50 17.93 1443.00 28.86 546.50 60.96%
NORTEL NETWORKS USD 301.75 4.25 702.00 9.00 400.25 132.64%
SIEMENS N USD 524.55 46.42 851.26 67.56 326.71 62.28%
-------------------------------------------------------------------------------
Grand Total USD 2160.11 3848.65 1688.54 78.17%
===============================================================================
Running portfolio riskreport on (sample) portfolio
** Running: beancounter --dbsystem PostgreSQL --dbname beancounter risk --date 'yesterday'
===============================================================================
Portfolio Risk on 20 Jan 2004 going back to 21 Jul 2003
-------------------------------------------------------------------------------
Name Position 1% Profit/Loss Volatility VaR margVaR
===============================================================================
ALCATEL USD 852.39 -5.1% -43 40.2% -50 -33
CISCO SYSTEMS USD 1443.00 -4.4% -62 30.8% -65 -43
NORTEL NETWORKS USD 702.00 -6.8% -47 58.1% -59 -37
SIEMENS N USD 851.26 -4.4% -37 26.6% -33 -20
-------------------------------------------------------------------------------
Portfolio level USD 3848.65 27.6% -155
-------------------------------------------------------------------------------
Portfolio VaR is 4.0% of assets, or 74.8% of VaR sum of -208
===============================================================================
VaR calculations use a 99% confidence level and 1-day horizon. Marginal VaR is
the change to the portfolio VaR attributable to adding this position. Computing
the 1% quintile of the return distribution, which can be viewed as a non-para-
metric VaR estimate, requires at least 100 observations.
===============================================================================
Done.
edd@homebud:~> exit
Script done on Wed 21 Jan 2004 08:01:18 PM CST
|
