Compose an Investment Portfolio
 Sunday, 03 May 2009 20:01 This is an example for the Trading Simulator. Suppose you have \$ 400000 and you want to invest this on the stock market. You decide to invest in real estate, commodities, bonds and technology shares. From each of these categories you buy shares in the two best companies. This means that 8 different shares will be bought. You don't invest all your money on the same day: each stock has buying opportunities to wait for. First you buy the bonds, then the real estate funds, then the commodities and then technology funds. Meanwhile there is a good moment to sell the bonds again. Instead of bonds you decide to invest in utilities. One of the real estate funds gives you some dividend. And the interest rate on your cash balance has changed as well: from 6 to 7%. After two years you want to know the total value of your portfolio and the total value of each category. So you enter share prices for each of the shares on the end date combined. The contents of the field below are the exported list of transactions. These data can be imported into the calculator by cutting and pasting them into the field in tab HTML Input and then clicking on the button.
Start date: 2009-02-01
End date: 2011-02-01
Cash Balance: 400000.0000
Date
YYYY-MM-dd
Interest (%)Credit/Debit
2009-02-01 6.0000 credit
2010-02-01 7.0000 credit
Category Ticker Interest date Costs Price Input
technology Soft 2011-02-01 10 true
real estate V2 2011-02-01 10 true
commodities oil 2011-02-01 10 true
bonds O2 2011-02-01 10 true
utilities N2 2011-02-01 10 true
CategoryTicker Interest Date Price known Number amount Price Spread Costs
bonds O1 2009-03-01 true 50.0000 990.0000 1.0000 10.0000
bonds O2 2009-02-16 true 50.0000 1010.0000 1.0000 10.0000
real estate V1 2009-07-01 true 1000.0000 50.0000 0.1000 10.0000
real estate V2 2009-08-10 true 800.0000 62.0000 0.1000 10.0000
commodities oil 2009-11-03 true 2000.0000 25.0000 0.0500 10.0000
commodities steel 2009-12-02 true 2500.0000 20.0000 0.0300 10.0000
technology Soft 2010-02-01 true 500.0000 100.0000 0.3000 10.0000
technology Chips 2010-02-01 true 600.0000 80.0000 0.2500 10.0000
bonds O1 2010-04-01 false 2450.0000 0.0000
bonds O2 2010-04-01 false 2600.0000 0.0000
bonds O1 2010-04-10 true -50.0000 991.0000 1.0000 10.0000
bonds O2 2010-05-01 true -50.0000 1009.0000 1.0000 10.0000
real estate V1 2010-05-03 true 10.0000 53.0000 0.0000 -530.0000
utilities N1 2010-05-10 true 1020.0000 48.0000 0.0400 10.0000
utilities N2 2010-05-10 true 2000.0000 24.0000 0.0180 10.0000
technology Chips 2011-02-01 true 0.0000 70.0000 0.0000 0.0000
technology Soft 2011-02-01 true 0.0000 105.0000 0.0000 0.0000
real estate V1 2011-02-01 true 0.0000 55.0000 0.0000 0.0000
real estate V2 2011-02-01 true 0.0000 57.0000 0.0000 0.0000
commodities steel 2011-02-01 true 0.0000 21.0000 0.0000 0.0000
commodities oil 2011-02-01 true 0.0000 24.0000 0.0000 0.0000
utilities N1 2011-02-01 true 0.0000 50.0000 0.0000 0.0000
utilities N2 2011-02-01 true 0.0000 26.0000 0.0000 0.0000
These transactions each trigger a provision of \$ 10. The computation also tracks hidden costs due to the spread, the difference between bid and ask price. In this example these costs are very small compared to the invested amount.