Super Stock Picker Forum

About Strategies => How it works => Topic started by: Super Stock Picker on April 30, 2007, 01:59:06 PM



Title: Virtual $50,000 portfolio
Post by: Super Stock Picker on April 30, 2007, 01:59:06 PM
Here I propose to follow a virtual portfolio, as a real life example of the Ultimate Price Momentum v2 portfolio.

This portfolio starts on April, 30th with a capital of $50,000. Commissions are $9.95 per trade.

This portfolio will try to keep as close as possible from the ideal portfolio shown on the web site. The main constraint will be to keep the same weighting of the stocks weeks after weeks. Prices are recorded at the close of the session.

Nest posts will show the orders executed to build this virtual portfolio and will keep track of the recorded performances. Updates will be done weekly, on Mondays.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on May 01, 2007, 03:37:52 PM
So, in this first update, let's see how this $50,000 portfolio is created:

- On the inception date April 30th, two stocks were already on hold in the portfolio: VNX (-5.51%) and ABT (+14.39%).
- One stock is to be sold, but we don't care about this one here.
- And three stocks are new buys: TIM, RMX and BLE.

As proposed, we can allocate the amount to invest in those stocks by following our unbalanced weighting rule that takes into account the performance of the stocks since on hold in the portfolio.

Let's calculate the weights of each stock:
- VNX = 1 - 0.0551 = 0.9449
- ABT = 1 + 0.1439 = 1.1439
- TIM = 1
- RMX = 1
- BLE = 1

The total of weights being 5.0888, the amount to allocate to each stock is given by the following rule of three:
- VNX = $50,000 * 0.9449 / 5.0888 = $9,284.11
- ABT = $50,000 * 1.1439 / 5.0888 = $11,239.39
- TIM = $50,000 * 1 / 5.0888 = $9,825.50
- RMX = $50,000 * 1 / 5.0888 = $9,825.50
- BLE = $50,000 * 1 / 5.0888 = $9,825.50

With the $9.95 commission fee and the closing prices on that day being TIM $3.47, RMX $2.28, BLE $18.00, ABT $18.20 and VNX $12.52, it would give the following 5 positions:
- VNX: 740 shares @ $12.52, value $9,264.80, cost $9,274.75, perf -0.11%
- ABT: 617 shares @ $18.20, value $11,229.40, cost $11,239.35, perf -0.09%
- TIM: 2,828 shares @ $3.47, value $9,813.16, cost $9,823.11, perf -0.10%
- RMX:4305 shares @ $2.28, value $9,815.40, cost $9,825.35, perf -0.10%
- BLE: 545 shares @ $18.00, value $9,810.00, cost $9,819.95, perf -0.10%
- Cash: $17.49

Virtual portfolio value is then $49,950.25 from a $50,000 capital. It gives a performance of -0.10% since April 30th, 2007.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on May 07, 2007, 10:24:20 AM
The value of the reference portfolio (Ultimate Price Momentum v2 (http://www.superstockpicker.com/portfolio_Ultimate_Price_Momentum_v2.html)) on the day of the creation of this thread was 552.45 pts.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on May 08, 2007, 11:51:05 PM
Sorry for the delay, here are with data from yesterday, what was the update of this virtual portfolio for this week.

Calculation are a bit complex, and to help you to follow the figures, you will find attached the Excel sheet used to get to those results.

So, the orders for this monday are:

Ultimate Price Momentum v2
Action    Ticker     Name
Buy    ML     Mercator Minerals Ltd.
Sell    VNX     Verenex Energy Inc.

One buy order and one sell order will keep the number of open positions to five. Close prices for those two stocks are: VNX $12.96, ML $5.97.

First, we sell our 740 shares of VNX at $12.96. With the $9.95 commission fee, it gives us:
740 * $12.96 - $9.95 = $9,580.45
That closes our VNX position with the following figures:
VNX: final value $9,580.45, cost $9,274.75, final perf +3.30%

The attached Excel sheet gives the details of the calculations of the new weights of the stocks in the portfolio considering the new buy of ML and the 4 other stocks weighted proportionally to their performance since on hold in the portfolio.

We can then see, that for the 4 positions already open a small adjustment is theoretically needed. But as we keep the same number of positions in the portfolio, we will not do it, in order not to execute too small orders. The impact on the balancing of the portfolio will be minimal anyway. Full re-balancing of the portfolio will occur when a position will be added or subtracted to the portfolio.

Then, that means that we use the free cash to open the ML position as follows:
ML: 1,606 shares @ $5.97, value $9,587.82, cost $9,597.77, perf -0.10%
Remaining cash is $0.17.

Now, let's summarize the content of the portfolio. We have the following 5 positions, included the new ML one:
- ML: 1,606 shares @ $5.97, value $9,587.82, cost $9,597.77, perf -0.10%
- ABT: 617 shares @ $21.99, value $13,567.83, cost $11,239.35, perf +20.72%
- TIM: 2,828 shares @ $3.69, value $10,435.32, cost $9,823.11, perf +6.23%
- RMX: 4,305 shares @ $2.42, value $10,418.10, cost $9,825.35, perf +6.03%
- BLE: 545 shares @ $17.35, value $9,455.75, cost $9,819.95, perf -3.71%
- Cash: $0.17

Virtual portfolio value is then $53,464.99 from a $50,000 capital. It gives a performance of 6.93% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 591.55 pts from 552.45 pts. Its return is then 7.08%.


Title: Re: Virtual $50,000 portfolio
Post by: minuit on May 14, 2007, 08:12:59 AM
Hello,

Must be something I don't understand but the order of the May 14th is to buy PAE.

At the end of you last message, your cash was 0.17$ So how many shares of PAE do you buy, and with what cash ?
Thanx
Jo


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on May 14, 2007, 10:18:42 AM
Hello minuit,

You are right, we are issuing a buy order with no cash available.

That's because our portfolios are always fully invested, with no cash kept aside.

Now, we have to buy a new stock today. To know the exact number of shares, we will wait to know the close price of those stocks and we will calculate the new weights for each stocks.
Then, it will lead to sell part of the 4 stocks already on hold to free cash and allow us to buy the new PAE shares.

By the way, the same mechanism would apply if we would sell a stock and not buy another one. In that case, the cash generated by the sale would be reallocated in the other open positions.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on May 15, 2007, 02:35:26 PM
So, the orders for today are:

Ultimate Price Momentum v2
Action    Ticker     Name
Buy    PAE     Peace Arch Entertainment Group Inc

The attached Excel sheet shows the calculation done to find how much should be sold from each positions to free the cash needed to buy the new PAE position. The rule used to get to those numbers is that each stock should be weighted proportionally to its performance since on hold in the portfolio.

With the close prices of $5.97 for ML, $22.99 for ABT, $3.95 for TIM, $2.35 for RMX and $17.18 for BLE, we do the following sells:
- ML: 181 shares @ $5.97, value $1,070.62
- ABT: 150 shares @ $22.99, value $3,438.55
- TIM: 376 shares @ $3.95, value $1,475.25
- RMX: 573 shares @ $2.35, value $1,336.6
- BLE: 73 shares @ $17.18, value $1,244.19

So, with those sells and the cash that was remaining in the portfolio, it makes $8,565.38 available to buy the PAE shares as follows:
PAE: 3,228 shares @ $2.65, value $8,554.22, cost $8,564.15, perf -0.12%
Remaining cash is then $1.23.

So, that gives us the following portfolio, with 6 open positions:
- PAE: 3,228 shares @ $2.65, value $8,554.22, cost $8,564.15, perf -0.12%
- ML: 1,425 shares @ $5.97, value $8,507.25, cost $8,517.2, perf -0.12%
- ABT: 467 shares @ $22.99, value $10,736.33, cost $8,509.35, perf +26.17%
- TIM: 2,452 shares @ $3.95, value $9,685.4, cost $8,518.39, perf +13.70%
- RMX: 3,732 shares @ $2.35, value $8,770.2, cost $8,518.91, perf +2.95%
- BLE: 472 shares @ $17.18, value $8,108.96, cost $8,505.95, perf -4.67%
- Cash: $1.23

Virtual portfolio value is then $54,363.57 from a $50,000 capital. It gives a performance of 8.73% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 602.1 pts from 552.45 pts. Its return is then 8.99%.


Title: Re: Virtual $50,000 portfolio
Post by: bryanmcn on May 23, 2007, 07:51:24 AM
Will we be getting an update on this portfolio this week?


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on May 23, 2007, 09:29:07 AM
Yes, sure there will be an update.

But as Monday was a day off, the update of the Ultimate Price Momentum v2 portfolio happened yesterday instead. Add to that the fact that we are quite busy and it makes that you can expect the update of this thread today ;)


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on May 23, 2007, 04:38:50 PM
So, the orders for today are:

Ultimate Price Momentum v2
Action    Ticker     Name
Sell    ML      Mercator Minerals Ltd.
Buy    FNI     First Nickel Inc.

Please also note that on May 15th, TCM has replaced BLE in the portfolio (the company has changed its name).

Thus, the update is quite simple to do as one position is closed and another one open.

With the close price of $5.69 for ML, we close the position as follows:
ML: 1425 shares @ $5.69, value $8,108.25, cost $8,517.20, perf -4.80%

Then, the attached Excel sheet shows the theoretical weighted amounts for each positions. As we are just replacing one position by another, we will not do any rebalancing this week; the adjustments being so small.

So, by adding the result of the ML sale plus the cash that was remaining in the portfolio that makes a total of $8,109.48 to buy the FNI shares as follows:
FNI: 5259 shares @ $1.54, value $8,098.86, cost $8,108.81, perf -0.12%
Remaining cash is $0.67.

We have now the following 6 positions open in the portfolio:
- ABT: 467 shares @ $23.87, value $11,147.29, cost $8,509.35 , perf +31.00%
- TIM: 2452 shares @ $3.39, value $8,312.28, cost $8,518.39, perf -2.42%
- RMX: 3732 shares @ $2.16, value $8,061.12, cost $8,518.91, perf -5.37%
- TCM: 472 shares @ $16.76, value $7,910.72, cost $8,505.95, perf -7.00%
- PAE: 3228 shares @ $2.84, value $9,167.52, cost $8,564.15, perf +7.05%
- FNI: 5259 shares @ $1.54, value $8,098.86, cost $8,108.81, perf -0.12%
- Cash: $0.67

Virtual portfolio value is then $52,698.46 from a $50,000 capital. It gives a performance of 5.40% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 584.88 pts from 552.45 pts. Its return is then 5.87%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on May 29, 2007, 01:26:36 PM
Quite an easy update today as there are no change in the portfolio this week.
Obviously, no adjustments are to be done due to the small amounts it would imply.

Let's just update the portfolio performances then:
- ABT: 467 shares @ $24.55, value $11,464.85, cost $8,509.35, perf +34.73%
- TIM: 2,452 shares @ $3.52, value $8,631.04, cost $8,518.39, perf +1.32%
- RMX: 3,732 shares @ $2.00, value $7464.00, cost $8,518.91, perf -12.38%
- TCM: 472 shares @ $17.46, value $8,241.12, cost $8,505.95, perf -3.11%
- PAE: 3,228 shares @ $3.00, value $9,684.00, cost $8,564.15, perf +13.08%
- FNI: 5,259 shares @ $1.57, value $8,256.63, cost $8,108.81, perf +1.82%
- Cash: $0.67

Virtual portfolio value is then $53,742.31 from a $50,000 capital. It gives a performance of 7.48% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 596.59 pts from 552.45 pts. Its return is then 7.99%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: jeff on May 31, 2007, 12:07:30 AM
Congratulations! 7.48% for one month (since April 30) is a great return, especially for May. We all know that May is a usually a very volatile month. I think the big market TSX is up less than 5% for May. So superstockpicker beat the market again, like always. Keep doing the great job! We are all your followers.  :)


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on June 06, 2007, 01:17:41 PM
Hello,

A late update this week. Let's go back to Monday and update this thread with the data from that day:

So, the orders for this last Monday were:

Ultimate Price Momentum v2
Action    Ticker     Name
Sell    RMX    Rubicon Minerals Corporation
Sell    PAE    Peace Arch Entertainment Group Inc     
Sell    FNI     First Nickel Inc.
Buy    FNX    Fnx Mining Company

Let's then proceed to the three sales:
- RMX: 3,732 shares @ $1.85, value $6,894.25, cost $8,518.91, perf -19.07%
- PAE: 3,228 shares @ $2.63, value $8,479.69, cost $8,546.15, perf -0.99%
- FNI: 5,259 shares @ $1.51, value $7,931.14, cost $8,108.81 perf -2.19%

The attached Excel document gives the calculations done to find the new proportional allocation we use to find the size of each of the four remaining positions. The new FNX position will be open and the three other ones will be completed with smaller buys:
- FNX: 317 shares @ $37.19, value $11,789.23, cost $11,799.18, perf -0.08%
- ABT: 181 shares @ $23.39, value $4,233.59, cost $4,253.54, perf -0.23%
- TIM: 950 shares @ $3.93, value $3,733.50, cost $3,743.45, perf -0.27%
- TCM: 183 shares @ $18.83, value $3,445.89, cost $3,455.84, perf -0.29%

After those trades, the remaining cash of the portfolio is $63.74.

We have now the following 4 positions open in the portfolio:
- ABT: 648 shares @ $23.39, value $15,156.72, cost $12,752.89, perf +18.85%
- TIM: 3,402 shares @ $3.93, value $13,369.86, cost $12,261.84, perf +9.04%
- TCM: 655 shares @ $18.83, value $12,333.65, cost $11,961.79, perf +3.11%
- FNX: 317 shares @ $37.19, value $11,789.23, cost $11,799.18, perf -0.08%
- Cash: $63.74

Virtual portfolio value is then $52,713.20 from a $50,000 capital. It gives a performance of 5.43% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 585.40 pts from 552.45 pts. Its return is then 5.96%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on June 14, 2007, 11:23:33 AM
Late again this week... Let's go back to Monday and update this thread:

The order for this week was:
Ultimate Price Momentum v2
Action    Ticker     Name
Buy       HF         Hanfeng Evergreen Inc.

In order to buy this new position, and to keep the stock weighted proportionnaly to their performances as usual, we would need to sell parts of the open positions. To find those numbers, the attached Excel sheet has been used and here are the resulting sells:
- ABT: 148 shares @ $22.86, value $3,373.33, cost $2,912.64, perf +15.82%
- TIM: 671 shares @ $3.82, value $2,553.27, cost $2,415.60, perf +5.70%
- TCM: 655 shares @ $17.97, value $2,092.54, cost $2,136.42, perf -2.05%
- FNX: 317 shares @ $34.31, value $1,808.48, cost $1,971.07, perf -8.25%

And, then using the cash from those sells plus the remaining cash in the portfolio, we are able to open the new HF position as follows:
HF: 925 shares @ $10.68, value $9,879.00, cost $9,888.95, perf -0.10%

We have then $2.41 left in cash.

We have now the following 5 positions open in the portfolio:
- ABT: 500 shares @ $22.86, value $11,430.00, cost $9,840.00, perf +16.16%
- TIM: 2731 shares @ $3.82, value $10,432.42, cost $9,831.60, perf +6.11%
- TCM: 538 shares @ $17.97, value $9,667.86, cost $9,823.88, perf -1.59%
- FNX: 264 shares @ $34.31, value $9,057.84, cost $9,818.16, perf -7.74%
- HF: 925 shares @ $10.68, value $9,879.00, cost $9,888.95, perf -0.10%
- Cash: $2.41

Virtual portfolio value is then $50,469.53 from a $50,000 capital. It gives a performance of 0.94% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 561.45 pts from 552.45 pts. Its return is then 1.63%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on June 22, 2007, 03:23:36 PM
Late, late, late... Let's go back to Monday and update this thread:

The order for this week was:
Ultimate Price Momentum v2
Action    Ticker     Name
Sell      ABT         Absolute Software Corp
Sell      FNX         Fnx Mining Company
Buy       PSE         Pacific Stratus Energy Ltd.

So, we first sell the ABT and FNX positions as follows:
- ABT: 500 shares @ $23.25, value $11,615.05, cost $9,840.00, perf +18.04%
- FNX: 264 shares @ $34.69, value $9,148.21, cost $9,818.16, perf -6.82%

Then, we open the new PSE position and we add some more cash to the previously open ones to follow our allocation rule that weights the stocks proportionally to their performance recorded since on hold in the portfolio. The attached Excel sheet gives the exact calculations done to find the following buy transactions:
- TIM: 721 shares @ $4.15, value $2,992.15, cost $3,002.10, perf -0.33%
- TCM: 142 shares @ $18.47, value $2,622.74, cost $2,632.69, perf -0.387%
- HF: 237 shares @ $11.24, value $2,663.88, cost $2,673.83, perf -0.37%
- PSE: 834 shares @ $14.90, value $12,426.60, cost $12,436.55, perf -0.08%

And we have then $20.50 left in cash.

To summarize, we have now the following 4 positions open in the portfolio:
- TIM: 3452 shares @ $4.15, value $14,325.80, cost $12,833.70, perf +11.63%
- TCM: 680 shares @ $18.47, value $12,559.60, cost $12,456.57, perf +0.83%
- HF: 1162 shares @ $11.24, value $13,060.88, cost $12,491.99, perf +4.55%
- PSE: 834 shares @ $14.90, value $12,426.60, cost $12,436.55, perf -0.08%
- Cash: $20.50

Virtual portfolio value is then $52,393.38 from a $50,000 capital. It gives a performance of 4.79% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 583.05 pts from 552.45 pts. Its return is then 5.54%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on June 26, 2007, 10:02:12 AM
Pretty on time, this week!

So, the order for this week was:
Ultimate Price Momentum v2
Action    Ticker     Name
Buy       WPT        Westport Innovations Inc.

As a result of this buy order, we open a new position but also reallocate money among the various positions. The attached Excel document gives the exact calculations to find the figures leading to those sales:
- TIM: 678 shares @ $5.51, value $3,725.83, cost $2,532.11, perf +47.14%
- TCM: 117 shares @ $17.24, value $2,00713, cost $2,153.39, perf -6.79%
- HF: 203 shares @ $11.98, value $2,421.99, cost $2,177.99, perf +11.20%
- PSE: 142 shares @ $14.70, value $2,077.45, cost $2,125.75, perf -2.27%

And then, with the cash now available, we buy the new WPT shares as follows:
- WPT: 3,909 shares @ $2.62, value $10,241.68, cost $10,251.63, perf -0.10%

And we have then $1.37 left in cash.

To summarize, we have now the following 5 open positions in the portfolio:
- TIM: 2,774 shares @ $5.51, value $15,284.74, cost $10,319.28, perf +48.12%
- TCM: 563 shares @ $17.24, value $9,706.12, cost $10,314.16, perf -5.90%
- HF: 959 shares @ $11.98, value $11,488.82, cost $10,242.12, perf +12.17%
- PSE: 692 shares @ $14.70, value $10,172.40, cost $10,310.80, perf -1.34%
- WPT: 3,909 shares @ $2.62, value $10,241.68, cost $10,251.63, perf -0.10%
- Cash: $1.37

Virtual portfolio value is then $56,895.03 from a $50,000 capital. It gives a performance of 13.79% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 634.81 pts from 552.45 pts. Its return is then 14.91%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: bryanmcn on June 27, 2007, 04:57:09 AM
This virtual portfolio now trails the reference portfolio by percentage point or two. What is your opinion on the reason for that? Is it the trade commissions, the cash holding or the slightly different stock percentage holdings?


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on June 27, 2007, 11:38:53 AM
In the case of the $50,000 portfolio, the main reason why it looses ground to the reference portfolio is the trade commissions.
The stock's weightings are not exactly the same and may introduce another little skew though. And as far as cash is concerned, this position is almost always null or equal to a few dollars, so it is not a factor at all.

The size of the portfolio is then very important and it is good to see that a portfolio of that size has lost 1 point in almost 2 months. That would keep the difference with the reference portfolio still small at the end of the year.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on July 05, 2007, 01:51:59 PM
This week, let's go back to Tuesday and use the close prices of this session as Monday was the day off for Canada Day.

The order for this week was:
Ultimate Price Momentum v2
Action    Ticker     Name
Sell        TCM       Thompson Creek Metals Company Inc.

So, first we sell the TCM shares as follows:
TCM: 563 shares @ $17.40, value $9,786.25, cost $10,314.16, perf -5.12%

Now, we need to reallocate the cash coming form this sale between the 4 positions hold in the portfolio. The attached Excel Spread sheet gives the calculations needed to find the following figures. That gives the following 4 new buys:
- TIM: 532 shares @ $5.65, value $3,005.80, cost $3,015.75, perf -0.33%
- HF: 192 shares @ $12.13, value $2,328.96, cost $2,338.91, perf -0.43%
- PSE: 132 shares @ $14.41, value $1,902.12, cost $1,912.07, perf -0.52%
- WPT: 780 shares @ $3.19, value $2,488.20, cost $2,498.15, perf -0.40%

We are now left with $22.74 in cash.

To summarize, we have now the following 4 open positions in the portfolio:
- TIM: 3,306 shares @ $5.65, value $18,698.90, cost $13,335.03, perf +40.07%
- HF: 1,151 shares @ $12.13, value $13,961.63, cost $12,581.03, perf +10.97%
- PSE: 824 shares @ $14.41, value $11,873.84, cost $12,232.82, perf -2.93%
- WPT: 4,689 shares @ $3.19, value $14,957.91, cost $12,749.68, perf +17.32%
- Cash: $22.74

Virtual portfolio value is then $59,495.02 from a $50,000 capital. It gives a performance of 18.99% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 664.16 pts from 552.45 pts. Its return is then 20.22%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: investolator on July 11, 2007, 01:18:16 PM
Hello there, excellent site, can't wait to spend more time looking around.  About your portfolio's, many of the buys are odd lots, and sometimes difficult to excecute at a given price.  If we were trading for real, would you actually buy the odd lots or round them up or down.  Thanks and keep up the great work.


Title: Re: Virtual $50,000 portfolio
Post by: bryanmcn on July 11, 2007, 08:15:20 PM
I agree with you that trading in odd lots would be difficult. We (ok me) gave the administrators a hard time early this year saying that duplictaing the portfolio's performance would be difficult to do. They have proven us (ok me) wrong by trading in this virtual portfolio and getting close to the same performance. I'm pretty impressed and won't pick at the odd lot issue (but you do have a point).


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on July 11, 2007, 11:29:08 PM
Back to the close of Monday's session to update this thread:

The orders for this week were:
Ultimate Price Momentum v2
Action    Ticker     Name
Sell       HF        Hanfeng Evergreen Inc.
Sell       PSE       Pacific Stratus Energy Ltd.
Sell       WPT       Westport Innovations Inc.
Buy        VRS       Allen-Vanguard Corp.

First, we sell the 3 position as follows:
- HF: 1,151 shares @ $12.89 value $14,826.44, cost $12,581.03, perf +17.85%
- PSE: 824 shares @ $14.95, value $12,308.85, cost $12,232.82, perf +0.62%
- WPT: 4,689 shares @ $3.00, value $14,057.05, cost $12,749.68, perf +10.25%

Then, we proceed to two buy operations, one to open the new VRS position, and the other one to reallocate the dollars in the portfolio following our weighting rule. The attached Excel document shows the calculations done to find those figures:
- TIM: 2,746 shares @ $6.11, value $16,778.06, cost $16,788.01, perf -0.06%
- VRS: 3,051 shares @ $8.00, value $24,408.00, cost $24,417.95, perf -0.04%

And we hold $9.12 in cash.

To summarize, the following 2 positions are now open in the portfolio:
- TIM: 6,052 shares @ $6.11, value $39,977.72, cost $30,123.04, perf +22.76%
- VRS: 3,051 shares @ $8.00, value $24,408.00, cost $24,417.95, perf -0.04%
- Cash: $9.12

Virtual portfolio value is then $61,394.84 from a $50,000 capital. It gives a performance of 22.79% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 686.63 pts from 552.45 pts. Its return is then 24.29%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on July 22, 2007, 12:03:17 AM
Even that late, we can go back to Monday and update this thread with the close prices of this session:

The orders for this week were:
Ultimate Price Momentum v2
Action    Ticker     Name
Sell       VRS       Allen-Vanguard Corp.
Buy       CUQ      Churchill Corporation (The)

So, we sell our VRS position as follows:
VRS: 3,051 shares @ $7.69, value $23,452.24, cost $24,417.95, perf -3.95%

Then, we buy the new CUQ position and sell some TIM shares to keep in line with our weighting rule. The attached Excel sheet explains the calculation leading to those numbers:
Sell Tim: 615 shares @ $5.89, value $3,612.40, cost $3,072.65, perf +17.57%
Buy CUQ: 1,879 shares @ $14.40, value $27,057.60, cost $27,067.55, perf -0.04%

Then, the portfolio holds the following two positions:
- TIM: 5,437 shares @ $5.89, value $32,023.93, cost $27,086.21, perf +18.23%
- CUQ: 1,879 shares @ $14.40, value $27,057.60, cost $27,067.55, perf -0.04%
- Cash: $6.21

Virtual portfolio value is then $59,087.74 from a $50,000 capital. It gives a performance of 18.18% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 661.22 pts from 552.45 pts. Its return is then 19.69%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on July 26, 2007, 05:24:15 PM
Back to the close of Monday's session to update this thread:

The orders for this week were:
Ultimate Price Momentum v2
Action    Ticker     Name
Buy        SMX       Smtc Corporation

To free cash for this new buy and to comply with our allocation rule, we have to sell part of the two previously open positions. The details of the calculations to find the following figures are given in the attached Excel document. Here are then the 3 trades executed:
Sell TIM: 1,729 shares @ $5.70, value $9,845.35, cost $8,620.37, perf +14.21%
Sell CUQ: 597 shares @ $14.50, value $8,646.55, cost $8,606.75, perf +0.46%
Buy SMX: 2,530 shares @ $7.30, value $18,469.00, cost $18,478.95, perf -0.05%

So, we end up with the following 3 positions open in the portfolio:
- TIM: 3,708 shares @ $5.70, value $21,135.60, cost $18,475.79, perf +14.409%
- CUQ: 1282 shares @ $14.50, value $18,589.00, cost $18,470.75, perf +0.64%
- SMX: 2,530 shares @ $7.30, value $18,469.00, cost $18,478.95, perf -0.05%
- Cash: $19.16

Virtual portfolio value is then $58,212.76 from a $50,000 capital. It gives a performance of 16.43% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 649.50 pts from 552.45 pts. Its return is then 17.57%.

PS: The attached Excel document has been used to get to those figures.


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on August 01, 2007, 03:33:44 PM
Short update this week, as there are no new orders. We'll just update the value of the portfolio:

- TIM: 3,708 shares @ $5.60, value $20,764.80, cost $18,475.79, perf +12.39%
- CUQ: 1282 shares @ $12.00, value $15,384.00, cost $18,470.75, perf -16.71%
- SMX: 2,530 shares @ $5.53, value $13,990.90, cost $18,478.95, perf -24.29%
- Cash: $19.16

Virtual portfolio value is then $50,158.86 from a $50,000 capital. It gives a performance of +0.32% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 570.33 pts from 552.45 pts. Its return is then +3.24%.

PS: The attached Excel document has been used to get to those figures. (You need to be logged in the forum to get access to the attachment)


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on August 09, 2007, 02:43:12 PM
This week's update takes place with the close prices of Tuesday as the TSE was closed on Monday.

The orders were:
Ultimate Price Momentum v2
Action    Ticker     Name
Sell        SMX       Smtc Corporation
Buy        ALS        Altius Minerals Corp
Buy        DRX        Adf Group Inc.

So, we first start by selling the SMX shares as follows:
SMX: 2,530 shares @ $3.94, value $9,958.25, cost $18,478.95, perf -46.11%

Then, we buy the two new stocks to add to the portfolio and we rebalance the two other remaining positions. The attached Excel spreadsheet gives the exact calculations done to find the following figures:
- Sell TIM: 1,278 shares @ $7.04, value $8,987.17, cost $6,374.39, perf +40.99%
- Sell CUQ: 442 shares @ $11.95, value $5,271.95, cost $6,374.75, perf -17.30%
- Buy ALS: 636 shares @ $19.03, value $12,103.08, cost $12,113.03, perf -0.08%
- Buy DRX: 2,684 shares @ $4.51, value $12,104.84, cost $12,114.79, perf -0.08%

So, it gives the following portfolio, with 4 open positions:
- TIM: 2,430 shares @ $7.04, value $17,107.20, cost $12,101.4, perf +41.37%
- CUQ: 840 shares @ $11.95, value $10,038.00, cost $12,096.00, perf -17.01%
- ALS: 636 shares @ $19.03, value $12,103.08, cost $12,113.03, perf -0.08%
- DRX: 2,684 shares @ $4.51, value $12,104.84, cost $12,114.79, perf -0.08%
- Cash: $8.71

Virtual portfolio value is then $51,361.83 from a $50,000 capital. It gives a performance of +2.72% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 604.80 pts from 552.45 pts. Its return is then +9.48%.

PS: The attached Excel document has been used to get to those figures. (You need to be logged in the forum to get access to the attachment)


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on August 14, 2007, 04:04:56 PM
Short update again this week, as there are no new orders. We'll just update the value of the portfolio:

So, the 4 positions open in the portfolio are the following:
- TIM: 2,430 shares @ $7.44, value $18,079.20, cost $12,101.4, perf +49.40%
- CUQ: 840 shares @ $13.85, value $11,634.00, cost $12,096.00, perf -3.82%
- ALS: 636 shares @ $18.24, value $11,600.64, cost $12,113.03, perf -4.23%
- DRX: 2,684 shares @ $4.54, value $12,185.36, cost $12,114.79, perf +0.58%
- Cash: $8.71

Virtual portfolio value is then $53,507.91 from a $50,000 capital. It gives a performance of +7.02% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 631.24 pts from 552.45 pts. Its return is then +14.26%.

PS: The attached Excel document has been used to get to those figures. (You need to be logged in the forum to get access to the attachment)


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on August 24, 2007, 02:15:28 AM
Short (late) update again this week, as there is no new orders this week again. We'll just update the value of the portfolio:

So, the 4 positions open in the portfolio are the following:
- TIM: 2,430 shares @ $5.35, value $13,000.50, cost $12,101.4, perf +7.43%
- CUQ: 840 shares @ $13.28, value $11,155.20, cost $12,096.00, perf -7.78%
- ALS: 636 shares @ $16.62, value $10,570.32, cost $12,113.03, perf -12.74%
- DRX: 2,684 shares @ $4.02, value $10,789.68, cost $12,114.79, perf -10.94%
- Cash: $8.71

Virtual portfolio value is then $45,524.41 from a $50,000 capital. It gives a performance of -8.95% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as fallen to 26.38 pts from 552.45 pts. Its return is then -4.72%.

PS: The attached Excel document has been used to get to those figures. (You need to be logged in the forum to get access to the attachment)


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on October 25, 2007, 07:26:42 PM
Hello,

It is time for us to try to catch up with the late updates of the virtual portfolios.

So, let's start where we've left, on August 27, 2007.

On this day, the orders were:
Ultimate Price Momentum v2
Action    Ticker     Name
Buy        VRS         Allen-Vanguard Corp.

So, we buy the new VRS stock and we rebalance also the remaining positions to maintain the proper balancing. The attached Excel spreadsheet gives the exact calculations done to find the following figures:
- Sell TIM: 479 shares @ $6.12, value $2,921.53, cost $2,385.42, perf +22.47%
- Sell CUQ: 166 shares @ $13.60, value $2,247.65, cost $2,390.40, perf -5.97%
- Sell ALS: 126 shares @ $19.15, value $2,402.95, cost $2,397.78, perf +0.22%
- Sell DRX: 532 shares @ $4.07, value $2,155.29, cost $2,399.32, perf -10.17%
- Buy VRS: 1,017 shares @ $9.55, value $9,712.35, cost $9,722.30, perf -0.10%

A a result, we have the following 5 positions open in the portfolio:
- TIM: 1,951 shares @ $6.12, value $11,940.12, cost $9,715.98, perf +22.89%
- CUQ: 674 shares @ $13.60, value $9,166.40, cost $9,705.60, perf -5.56%
- ALS: 510 shares @ $19.15, value $9,766.50, cost $9,715.25, perf +0.53%
- DRX: 2,152 shares @ $4.07, value $8,758.64, cost $9,715.47, perf -9.85%
- VRS: 1,017 shares @ $9.55, value $9,712.35, cost $9,722.30, perf -0.10%
- Cash: $13.83

Virtual portfolio value is then $49,357.84 from a $50,000 capital. It gives a performance of -1.28% since April 30th, 2007.
Over the same period, the reference portfolio, Ultimate Price Momentum v2, as risen to 574.70 pts from 552.45 pts. Its return is then +4.03%.

PS: The attached Excel document has been used to get to those figures. (You need to be logged in the forum to get access to the attachment)


Title: Re: Virtual $50,000 portfolio
Post by: bryanmcn on October 25, 2007, 11:09:14 PM
This virtual portfolio is only a few days from being 6 months old. Your calculations say that the return is less than 6% but the reference V2 portfolio on the home page shows a return of 87%. You are over 900 points on the reference, not 583.
Can you explain?
Thanks


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on October 25, 2007, 11:30:25 PM
Hello bryanmcn,

The post above, #28, is an update in date of August 27th. We have a lot more posting to do before we catch up with today.

That's why, currently, the figures are skewed big time.


Title: Re: Virtual $50,000 portfolio
Post by: owler on December 30, 2007, 10:16:31 PM
I have two questions, first: Does this virtual portfolio update have a chance to be continued? And the dumb one: Where can I find the reference portfolio value in pts for a given time? I searched it in the portfolio tab unsuccessfully.

Thank's and happy new year to all of you!

Owler


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on December 31, 2007, 03:08:01 PM
Hello Owler,

Yes, we do plan to start again updating the virtual portfolios but due to time constraints, we are not sure when this could happen.

And your next question was not dumb at all. We have to make public the history files of each portfolios. But it is currently an xml file on our side, we may need to export it in a easier format, maybe csv, and link it from each portfolio's description page.

For the time being, here is attached the history xml file for the Ultimate Price Momentum v2 portfolio, updated on the 12/28/2007. (Remember that you need to be logged in the forum to get access to the attached files)


Title: Re: Virtual $50,000 portfolio
Post by: mircho52 on January 01, 2008, 06:52:11 PM
I am sorry to ask another possibly dumb question but what is the difference between pts and percentage?

Mircho


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on January 09, 2008, 10:13:23 AM
Hello mircho52,

The points are the (virtual) value of the portfolio whereas the percentage shows the increase of the portfolio's value since the beginning of a period.

If the portfolio value was 100 pts at the beginning of the period and ends up at a value of 200 pts, then the increase of 100 pts corresponds to a 100% increase.

So, to summarize, a portfolio at 200 pts is a 100% performance.


Title: Re: Virtual $50,000 portfolio
Post by: CoOlSlY on July 29, 2008, 09:41:58 AM
Let's see... I'm a bit new to this so maybe following is a bit more difficult for me *but*:

Let's say I decide to follow the Momentum4... There is actually 1 title... I decide to put for example, 50,000$.  When there is another stock, do I sell half of this "50,000$" or if the stock has gone up and is at 56,000$, half of the "new" amount?

So we now have two stocks, a third one comes in, do I make my figures again with the "original" 50,000$ so sell 1/3 of the two first stocks considering a value of 50,000$ or considering the "new" value? I see that you make some calculation before selling/buying with the stock performance but now sure I understand properly (even after reading the 3 pages...!)

Thank's


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on July 29, 2008, 09:25:00 PM
Hello,

In order to understand how to allocate the cash in our portfolios when there is more than one stock, you can read this post that explains how the money is allocated:
http://www.superstockpicker.com/forum/index.php?topic=3.0

Also, this thread will explain more how to do the reallocations:
http://www.superstockpicker.com/forum/index.php?topic=619.0

And this one gives a spread sheet that makes the calculations for you:
http://www.superstockpicker.com/forum/index.php?topic=641.msg1442#msg1442


Title: Re: Virtual $50,000 portfolio
Post by: bryanmcn on November 26, 2009, 07:06:34 AM
Can we get an update on the Virtual Portfolio?


Title: Re: Virtual $50,000 portfolio
Post by: Super Stock Picker on November 26, 2009, 12:29:48 PM
Hello Bryan,

Well, the Virtual portfolios have not been updated in a long time. Knowing that it was a manual process, it would be an immense task to update them today to close the gap with the time when we stopped the update in this thread.

So, we don't plan in the close future to have enough time to update the former portfolios.

Would you be interested in following a new virtual portfolio that would start from scratch? If yes, we may think to find a more automatic way to do it.


Title: Re: Virtual $50,000 portfolio
Post by: bryanmcn on November 26, 2009, 12:31:51 PM
Nov 26, 2009
A new portfolio would be better than nothing so yes.
If you can automate it can you post the results weekly?
Thanks
Bryan


Title: Re: Virtual $50,000 portfolio
Post by: jeff on November 27, 2009, 07:53:04 PM
or you may use silicon investor's portfolio to record the buy and sell,like one friend here in this forum told me some time ago. you can check the current holdings' performance, total market value, and profit/loss of each past trade. so we can view the increase or decrease of the virtual $50000 and the trading history any time we want. you just give us the passwort after you registered an account.

Thanks!

here is the link:
http://siliconinvestor.advfn.com/default.aspx


Title: Re: Virtual $50,000 portfolio
Post by: bhunji42 on January 26, 2010, 03:57:57 PM
I would be interested in a new virtual $5000 portfolio, since that's how much a new TFSA account can start with...


Title: Re: Virtual $50,000 portfolio
Post by: newinvestor1 on March 07, 2017, 03:44:32 PM
Hello,
I have a question on how the rate of return is calculated.
1. SSP assumes that all the money is fully invested.
2. Everytime there is a new buy signal or sell signal, the weight factors are recalculated based on each stock's performance and existing stocks are bought on the same day. So the buy price of the stock must change when you calculate the performance.

For example:
TCW stock was initially bought on 7th November 2016 (at the closing price on the same day) for $2.93 in Ultimate Price Momentum v3 (UPMV3). After 7th November, 2016, more than 5 sell signals are given (and few more buy signals are given) before 6th March 2017. For these sell and buy signals, there had to be re-balancing of the portfolio, causing to buy few more shares of TCW when these signals are given. The price of the TCW stock on these dates (for example: 14th November - sell IVN, 28th November-sell PIF and PIX) is definitely greater than initial price of $2.93. So as part of rebalancing, if more shares of TCW were bought, the average buy price of TCW would have been somewhere around $3.XX. But when I see the performance of TCW on 6th March, 2017 after sell signal is posted, I see the overall return as 57.68% (i.e., ((4.62/2.93) - 1 )*100). So TCW average buy price was considered at the original buy signal i.e., $2.93.   Doesn't this give wrong rate of returns for the overall portfolio?