The Free Euronext Stock Portfolio Tracking Software

What

With PortfolioTracker you track and manage your stock portfolio of Euronext shares in realtime (15' delay). Assess your stock positions (price, daychange, gain, gain%, value, weight%) with one command. Portfolio changes are easy maintained in a text file.

Example of generated output:

2006-03-15 16:05
Tick    BuyDate    # B-Price   Price  D-1%    Value     Gain  Gain%    W%
CA   2006-02-28   25   41.44   43.08  0.68  1077.00    41.00   3.96 10.65
DELB 2002-02-28   18   56.00   58.40  2.55  1051.20    43.20   4.29 10.40
FORB 2006-02-28   30   29.92   29.48  0.03   884.40   -13.20  -1.47  8.75
FP   2006-02-28    5  211.50  215.00  0.75  1075.00    17.50   1.65 10.63
HEIA 2006-02-28   30   31.72   32.07 -0.56   962.10    10.50   1.10  9.51
PHIA 2006-02-28   35   27.33   27.07  2.23   947.45    -9.10  -0.95  9.37
RDSA 2006-02-28   40   25.80   25.77  0.00  1030.80    -1.20  -0.12 10.19
SOLB 2002-02-28   10   92.50   91.10 -0.22   911.00   -14.00  -1.51  9.01
UG   2006-02-28   22   48.95   50.70  1.87  1115.40    38.50   3.58 11.03
CASH                                        1057.34                 10.46
TOTAL                                      10111.69   111.69   1.12

PortfolioTracker is released in Open Source, it is written in Ruby, and runs on any major platform (windows, linux, mac).

PortfolioTracker is a twin project of QuotesViewer.

News

• 2006-03-16 Release 0.8 First public release

Download

Download the sources at SourceForge PortfolioTracker Download page.
PortfolioTracker requires Ruby, which can be downloaded from www.ruby-lang.org.

Installation

All platforms / source distribution: pftracker-0.8.zip

After installing Ruby just unzip the PortfolioTracker source distribution and you are ready to go.

Usage

Run PortfolioTracker

Execute the ruby script:

  ruby portfolioTracker.rb

On some platforms you can execute the script by clicking or double clicking on the file portfolioTracker.rb.

Input file "portfolio.pf"

Describe your stock portfolio in the file "portfolio.pf". The source distribution contains the following example:

 1| #[init]
 2| start_date: 2006-02-28
 3| start_value: 10000.00
 4| cash: 1057.34
 5| #[positions]
 6| # ticker:buy_date:no_of_shares:price_per_share
 7| # Carrefour
 8| CA   : 2006-02-28 :  25 :  41.44
 9| # Peugeot
10| UG   : 2006-02-28 :  22 :  48.95
11| # Total
12| FP   : 2006-02-28 :   5 : 211.50
13| # Philips
14| PHIA : 2006-02-28 :  35 :  27.33
15| # Royal Dutch Shell
16| RDSA : 2006-02-28 :  40 :  25.80
17| # Heineken
18| HEIA : 2006-02-28 :  30 :  31.72
19| # Fortis
20| FORB : 2006-02-28 :  30 :  29.92
21| # Delhaize
22| DELB : 2002-02-28 :  18 :  56.00
23| # Solvay
24| SOLB : 2002-02-28 :  10 :  92.50 

lines 1-4: Init section with fields:

• start_date: Date when you started with the portfolio, format "YYYY-MM-DD". Example 2005-08-02 is August 2, 2005.
• start_value: Value of your portfolio in Euros at start_date, format "0000000.00"
• cash: Current cash position in Euros in your portfolio, format "0000000.00"

lines 5-24: Positions section, every non-comment row describe one postion as follows: ticker : buyDate : nrOfShares : buyPrice with

• ticker: ticker code of the share. This mnemo can be found with QuotesViewer or on www.euronext.com.
• buyDate: date when you bought the shares, format "YYYY-MM-DD".
• nrOfShares: total number of shares in portfolio for that particular stock, format "000000"
• buyPrice: price at which you bought the shares, format "000000.00"
• If you buy the same stock on different days you can put one row per order or better one row with the average buy date, total nrOfShare, average buyPrice

lines 1, 5-7, 9, 11, 13, 15, 17, 19, 21,23: lines starting with '#' are comment lines and are not parsed by the tool. Use them for human readability.

Generated output

Format of the generated output:

  1| 2006-03-15 16:05
  2| Tick    BuyDate    # B-Price   Price  D-1%    Value     Gain  Gain%    W%
  3| CA   2006-02-28   25   41.44   43.08  0.68  1077.00    41.00   3.96 10.65
  4| DELB 2002-02-28   18   56.00   58.40  2.55  1051.20    43.20   4.29 10.40
  5| FORB 2006-02-28   30   29.92   29.48  0.03   884.40   -13.20  -1.47  8.75
  6| FP   2006-02-28    5  211.50  215.00  0.75  1075.00    17.50   1.65 10.63
  7| HEIA 2006-02-28   30   31.72   32.07 -0.56   962.10    10.50   1.10  9.51
  8| PHIA 2006-02-28   35   27.33   27.07  2.23   947.45    -9.10  -0.95  9.37
  9| RDSA 2006-02-28   40   25.80   25.77  0.00  1030.80    -1.20  -0.12 10.19
 10| SOLB 2002-02-28   10   92.50   91.10 -0.22   911.00   -14.00  -1.51  9.01
 11| UG   2006-02-28   22   48.95   50.70  1.87  1115.40    38.50   3.58 11.03
 12| CASH                                        1057.34                 10.46
 13| TOTAL                                      10111.69   111.69   1.12

line 1: Timestamp of the portfolio status, format "YYYY-MM-DD hh:mm"

line 2: header line for the stock postions

line 3-11: stock positions: one line per position with columns:

• Tick: ticker of the stock
• BuyDate: Date when you bought the stock
• #: number of shares in portfolio for that stock
• B-Price: BuyPrice of the shares
• Price: current price quotation for the stock
• D-1%: price change compared to day before
• Value: total value for that stock in your portfolio
• Gain: total gain (-loss) for that stock in your portfolio
• Gain%: percentage gain (-loss) for that stock compared to buyPrice
• W%: weigth in percentage for that stock in your portfolio

line 12: Cash and cash weight in your portfolio

line 13: Total value of your portfolio, gain in Euros, gain in %, compared to start_value of portfolio

Vision

The main development objectives for the PortfolioTracker application are:

• from a user point of view:
  • Simplicity: core application with few features
  • Easy creation and maintenance of your portfolio with a text file
• from a development point of view:
  • Simplicity
  • Open source, encouraging collaboration
  • Test-driven development with Eclipse Ruby plugin
  • Textual command line interface, easy configuration
  • Useful as building block in other stock management tools

Forums

The following discussion forums are setup on the SourceForge project page:

• Help Post your questions on the usage of PortfolioTracker here. Or help others by answering their questions.
  
• Open Discussion Discuss ideas on the future development of PortfolioTracker, design issues, proposing features, ideas on how you use PortfolioTracker, ...
  

Any feedback is welcome!