Workshop Portfolio

Foolish Workshop
Cost of Screens,
Part 1:

External Cost Factors

By Moe Chernick (moebruin)

EL SEGUNDO, CA (Oct. 12, 1999) -- One of the things many mechanical investing fans forget to consider when choosing a strategy are the costs of the strategy. With commissions as low as $5 a trade, it's easy to forget that costs can be significant, especially for small investors using strategies that call for frequent trading.

When looking at screen returns such as the Workshop Returns we quote in this area or historical backtested returns here or anywhere else, an investor needs to consider what the return would be after accounting for the costs and taxes that would affect him or her personally. In this article, I will go over the techniques I use to get the after-cost returns for screens I am considering. In my next article, I will go through some specific examples.

The return an individual investor would have received from a strategy follows the following formula:

Actual Return = (Return - Costs) * (1 - Tax Rate)
where Tax Rate = Marginal Federal Tax Rate + Marginal State/Local Tax Rate

For a tax-free account such as an IRA, the tax rate is zero and thus you only worry about returns and costs.

The costs that everyone pays but that are not included in published returns are round-trip trading costs and the spread.

The round-trip trading cost is the amount it costs you to buy and sell the stock. For example if your broker's commission is $10 per trade, then the round-trip trading cost is $20 -- $10 when you buy the stock and $10 when you sell it. The commission actually understates the cost slightly because with each sale there is a small SEC fee but since the fee is very small we will ignore it here.

The more frequently ignored factor is the spread. If you go to an online broker to place an order, you will usually see three prices listed. They are:

a) Last Trade Price
b) Ask Price
c) Bid Price

If you put in a market order to buy a stock, your shares will be bought at the current "Ask" price. The Ask price is literally the "asking" price; that is, the lowest specified price currently on the books for which someone is willing to sell that particular stock. The Bid and Ask prices are established by brokers who "make a market" for that specific stock based on supply and demand and the limit orders that have been entered into the system. It can change moment to moment, of course, as buy orders come in. When there are enough buy orders to fill all of the Ask orders, the price will move up to the next lowest specified price which becomes the new Ask price.

If you put in a market order to sell, the opposite happens. Your stock will be sold at the current Bid price, the highest price for which someone has said they will buy the stock. It's just like an auction.

Now, suppose you could trade commission-free. If you placed market orders to buy shares and sell them immediately, you would lose money even if the "price" of the stock didn't change. That's because the Ask price you bought at will always be a bit higher than the Bid price that you can sell for. Think about it -- if there were a bid on the books as high as the lowest asking price, the trade would have already been executed.

When comparing actual returns to reported returns, you need to consider the cost of the spread because the backtested results do not buy at the Ask and sell at the Bid like you would do. Instead we use whatever the closing price was on the day in question. (That's the only option for most backtested strategies and the easiest way to do current returns.)

Here is a quick quiz. Which price is the closing price:

a) The Bid price b) The Ask price c) Neither the Bid price not the Ask price d) Any of the above.

The correct answer is "d." The closing price can be either the Bid price or the Ask price as well as any other price, even one higher than the Ask price or lower than the Bid price, or anywhere in between. The closing price is just the price of the last trade.

Let's look at two examples of the spread from Monday, October 4. The first stock we will look at is a small stock, Numac Energy (AMEX: NMC). Numac as of 10/1/99 was the #1 stock on the PEG13 screen, which has become a favorite monthly trading strategy on the message board. Numac's closing prices were as follows:

Last Trade: 3 15/16
Ask: 4
Bid: 3 13/16

The other example I'll use is Intel (Nasdaq: INTC) which was the #1 stock on the Spark Screen:

Last Trade: 77
Ask: 77
Bid: 76 15/16

So if October 4 was the day the PEG13 screen was going into the record books, Numac would be priced at 3 15/16 ($3.9375). However, if you had been the one that made that last purchase, you would have paid $4.00 a share. If you had been selling, you would have received only $3.8125 a share.

With Intel you can see the last trade and the Ask price were the same, but if you were selling, you would have gotten 1/16 ($0.0625) less. That's the spread

Also, notice the difference between the spread for a large, frequently traded stock like Intel and a small stock like Numac. For Intel the spread is $0.0625 (or 0.08%, a pittance). However, for Numac the difference between the spread is a whopping 4.7% (3/16 = $0.1875 and $0.1875 / $4.00 = 4.7%). What this means is that if you were to buy Numac today and sell it a month later, even if the Bid and Ask prices were exactly the same, you would have lost 4.7% without even considering the commissions.

So you can see that, depending on the stock, the spread can be fairly insignificant or an extremely big part of the cost.

How should one account for this cost? The problem is that the closing price we use to calculate returns can be completely unrelated to the spread. The law of averages says that the closing price will reflect the spread about half the time. In other words, the close will be the Ask when our model is buying or the Bid when it is selling. But, only about half the time will they more or less match up like that. So it's reasonable to assume that only about half of the cost of the spread will be reflected in our published returns.

What value should be used to correct for this? It depends on the type of stocks the screen invests in. The higher the trading volume of the stock, the lower the spread. And the higher the price of a stock, the lower the percentage that is lost to spread. So, for example, a screen like Keystone that selects large-cap stocks might only lose about 0.2% or less to the spread. The Relative Strength screens select from a more mixed universe of stocks so I'd go with a factor of around 0.25%. On the other hand, a screen like PEG can include many small stocks, or no small stocks at all. (Numac is an extreme case.) A spread factor of 0.5% is probably a realistic average number to use for this type of screen.

Half a percent? Really? Isn't this much ado about nothing? If you're trading annually, probably. BUT if you are trading more frequently, especially if you are trading monthly with a fairly small portfolio, those spreads add up and compound. By the end of the year those costs can have a significant affect on your return. We will look at that on Thursday.

Until next time, Fool On!

New Rankings | Workshop Returns


Workshop Portfolio


9/28/01 as of ~5:30:00 PM EDT

Ticker Company Price
Change
Daily Price
% Change
Price
AETAETNA INC NEW0.943.36%28.94
BABOEING CO(1.04)(3.02%)33.36
CATCATERPILLAR INC1.112.53%44.91
COGCABOT OIL & GAS 'A'0.693.59%19.90
DDDU PONT (EI) DE NEMOURS0.992.74%37.14
DGXQUEST DIAGNOSTICS(0.45)(0.73%)61.42
EKEASTMAN KODAK0.421.31%32.49
GMGENERAL MOTORS1.393.38%42.55
LHLABORATORY CORP AMER HLDG(NEW)1.141.42%81.21
MOPHILIP MORRIS COS(0.76)(1.55%)48.24
NEWPNEWPORT CORP0.261.90%13.97
NVRNVR INC(0.54)(0.38%)140.41
PKXPOHANG IRON & STEEL ADS1.097.51%15.61
PVNPROVIDIAN FINANCIAL1.075.64%20.04
QCOMQUALCOMM INC(0.40)(0.84%)47.16
RJRRJ REYNOLDS TOBACCO HLDGS(0.69)(1.19%)57.31
SLESARA LEE CORPUnchg.Unchg.21.09
UNFIUNITED NATURAL FOODS0.563.18%18.15
WMIWASTE MANAGEMENT(0.01)(0.04%)26.74

Overall Return -- total % Gained (Lost)
  Day Week Month Year
To Date
Since
Inception
(12/24/1998)
Workshop1.30%7.32%(12.02%)(20.66%)(18.91%)
Comparable S&P 500n/an/an/an/a(19.07%)
S&P 500 (DA)1.95%7.48%(8.33%)(21.22%)(14.88%)
NASDAQ2.02%4.71%(17.46%)(39.68%)(31.41%)
DJIA (DA)1.68%7.07%(11.07%)(17.86%)(2.22%)

Internal Rate of Return -- Annualized Rate of % Gained (Lost)
  Since Inception (12/24/1998)
Workshop(17.62%)
vs. S&P 500(17.63%)

Trade Date # Shares Ticker Cost/Share Price Total % Ret
1/8/0126MO40.9448.2417.82%
1/8/0122RJR50.1057.3114.39%
1/8/0167UNFI16.4518.1510.34%
12/24/9824CAT43.0844.914.24%
1/8/018NVR136.63140.412.77%
1/8/0140WMI27.4426.74(2.54%)
1/8/0150SLE22.5421.09(6.42%)
1/8/0161PKX17.8315.61(12.46%)
1/8/0115DD48.8337.14(23.95%)
1/8/0129AET38.1728.94(24.19%)
1/8/0139COG28.7519.90(30.79%)
1/8/0114QCOM75.5447.16(37.57%)
1/8/018LH134.6981.21(39.70%)
12/27/9918GM73.2642.55(41.92%)
1/8/0118BA59.5333.36(43.96%)
1/8/019DGX114.4961.42(46.35%)
12/27/9920EK65.0932.49(50.08%)
1/8/0120PVN55.5020.04(63.89%)
1/8/0115NEWP74.9613.97(81.36%)

Trade Date # Shares Ticker Total Cost Current Value Total Gain
1/8/0126MO$1,064.50$1,254.24$189.74
1/8/0122RJR$1,102.25$1,260.82$158.57
1/8/0167UNFI$1,102.12$1,216.05$113.93
12/24/9824CAT$1,034.00$1,077.84$43.84
1/8/018NVR$1,093.00$1,123.28$30.28
1/8/0140WMI$1,097.50$1,069.60($27.90)
1/8/0150SLE$1,126.88$1,054.50($72.38)
1/8/0161PKX$1,087.75$952.21($135.54)
1/8/0115DD$732.50$557.10($175.40)
1/8/0129AET$1,107.00$839.26($267.74)
1/8/0139COG$1,121.37$776.10($345.28)
1/8/0114QCOM$1,057.62$660.24($397.39)
1/8/018LH$1,077.50$649.68($427.82)
1/8/0118BA$1,071.50$600.48($471.02)
1/8/019DGX$1,030.44$552.78($477.66)
12/27/9918GM$1,318.62$765.90($552.73)
12/27/9920EK$1,301.75$649.80($651.95)
1/8/0120PVN$1,110.00$400.80($709.20)
1/8/0115NEWP$1,124.37$209.55($914.83)
 
Cash: 
Total: 
$10.80
$15,681.03
 

Key
• S&P 500 (DA) = dividend adjusted. Dividends have been added to the total return of the index.
• DJIA (DA) = dividend adjusted. Dividends have been added to the total return of the DJIA.

Note
Note: The Workshop Portfolio was launched on December 24, 1998, with $4,000 which was invested in the Foolish Four strategy. Approximately $15,000 was added on January 8, 2001, to support five additional mechanical strategies. At that time approximately $1000 was transfered out of the Foolish Four strategy to bring the Foolish Four into balance with the other strategies. (That's why the Foolish Four's overall return is not consistent with stock values.) Such rebalancing will take place each year among the strategies so that each will start out with approximately the same value at the begining of the year. No more cash additions are planned. The first four tables above show the overall performance of the portfolio. Below that we also track the performance of each component strategy. All transactions are announced publicly before being made, and returns are compared daily to the S&P 500 and the Dow. (Dividends are included in the yearly, historic and annualized returns.) Stocks are chosen using strategies developed by the Workshop community.