Tuesday 6 September 2011

Week of 2011 SE 02

SPY fell 0.1% this week, while my account fell 1.2% to its lowest level ever!  Once again the “relief rally” is cancelled.  I bet that gold would go down, but it went up.  I bet that DRETF and TNA would go up, but they went down.  I need a more reliable trading paradigm.  See MACD-based trades below.

Euro news: Next Wednesday, the Constitutional Court of Germany will rule on whether it is permissible for Germany+France to bail out Greece, given that the Lisbon treaty says ”countries may not assume other countries’ debts”.  If they say no, the Euro is dead.

Daily % gain
size
owned
Max % lossResults
Symbol  since Fri Mon Tue Wed Thu Fri Beg End
 
RWM  JL01 3.0  
30
63
 
-0.1  
20
63
 
-0.5  
20
63
 
-0.3  
20
63
 
1.0  
21
63
 
3.2  
26
67
 
AUp30  JL01 -0.6  
 0
0
 
-0.6  
 0
0
 
-0.5  
 0
0
 
-0.5  
 0
0
 
-0.7  
 0
0
 
-0.6  
 0
0
 
SEp34  AU08 -1.3  
 0
0
 
-1.2  
 0
0
 
-0.9  
 0
0
 
-1.0  
 0
0
 
-1.3  
 0
0
 
-1.2  
 0
0
 
SEp31  AU30 -0.5  
0.4
 
-0.6  
0.3
 
-0.7  
0.1
 
-0.6  
0.1
 
IAU  JL25 5.6  
22
 
3.5  
 0
 
+2.6%
SEp17  AU11 -2.2  
 0
 
-2.1  
 0
 
−2.1%
RPRX  JL25 -30.4  
 2
 
-23.8  
 2
 
-22.2  
 2
 
-24.7  
 2
 
-23.5  
 2
 
-21.8  
 2
 
−7.7 −7.7
NOp  JL25 7.7  
1.0
 
16.0  
1.4
 
5.8  
1.0
 
6.4  
1.0
 
6.1  
1.0
 
15.0  
1.4
 
SCHA  AU23 0.6  
44
39
 
2.4  
47
46
 
2.4  
36
52
 
2.5  
30
52
 
1.3  
30
34
 
0.1  
30
34
 
−3.6 +0.4 +0.6%
DGZ  AU29 -0.3  
 4
 
-4.0  
 4
 
-2.8  
 4
 
-2.9  
 4
 
-6.1  
 0
 
−2.4 −2.4 −3.0%
DRETF  AU29 -0.5  
 8
 
-0.9  
 8
 
-1.4  
 8
 
-1.4  
 8
 
-1.8  
 8
 
−2.8 −2.8 −2.8%
TNA  AU31 -0.9  
15
42
 
-3.5  
15
42
 
-7.8  
14
42
 
−5.6%
SPY 0.0 2.9 3.1 3.6 2.5 -0.1
me 0.0 -0.2 -0.3 -0.5 -1.2 -1.2

RWM: On Monday the shares I sold last week were settled.  Bought more on Friday to prepare for the Big Drop if it happens this weekend.
      On Tuesday I bought another put, since I had expected a relief rally.  Looks like the put will expire worthless at the end of next week.  It is the nearly-invisible red line on the pie chart.

SCHA: Bought more Monday and Tuesday.  Previously-sold shares settled Tuesday and Wednesday.  Sold more on Thursday.  Sold all on Friday.  I need a better system for deciding when to buy and sell!

DGZ: I thought gold would go down, but it went up.

DRETF: I thought real estate would go up, but it went down.

TNA: Tried to catch the bottom on Wednesday, but missed on the first try.  Sold and bought some more at lower price.  Went down again.


MACD-based trades

Over the past year, on and off, I have been trying to figure out how to use MACD to get reliable profits.  I might finally have something!

Basic rules:
  • Always buy blocks of the same dollar value, regardless of gain/loss from previous round (no compounding, more shares at lower prices).
  • Use PPO(q,s,p), which is MACD(q,s,p) ÷ price so the numbers represent %change.
  • Apply PPO to IWM, because it has a lot of volume and thus is hard for the bad actors to manipulate.  Do the actual buys/sells using SCHA because it has no trading commissions.  Generally, SCHA tracks the ups and downs in IWM quite well.
  • Re-evaluate PPO at end of each period (hourly, daily, or weekly).
  • Buy (if not already bought) when PPO > ϵ, the “epsilon” parameter.
  • Sell (if not already sold) when PPO < ϶, the “negative epsilon” parameter.
  • Emergency sale when price < peak × (1-trailing), the trailing stop.
  • Do not buy if price fell during this period.  Do not sell if price rose during this period.  [This avoids “stupid moves” where the stock has changed direction but PPO hasn’t noticed yet.]
  • Do not buy if price < SMA(n).  [This rule actually reduces profit slightly, but avoids another class of ”stupid move” that leads to occasional large losses.]
Here are simulated results for last 12 months.  The “profit” is expressed as a fraction of the block size.
InputsOutputs
PeriodPPO(q,s,p)ϵ϶trailingSMA(n)Wins:LossesProfit
Hourly5,30,100.15%0.05%5%2028:2026%
Daily5,25,120.10%0.05%7%105:319%
Weekly5,30,101.00%-1.00%8%101:022%

The ”weekly” rule says I should have bought at the open on October 3, 2010 and sold at the open on May 22, 2011 for a 22% profit!  At no time during those seven months did SCHA’s price ever fall more than 8% below its peak so far.  A nice, effective rule—but very rarely active. Over the last three years it would have triggered only five times, with four wins and one loss for an overall gain of 27%, during a period when the market lost 9%.  It says (and I think it is correct) that I should not own SCHA right now.

The ”daily” rule is apparently the most popular among traders, but it seems to have the most problems.  Its overall profit score is the lowest.  It requires that I buy and sell precisely at 4 PM (profits would be even lower if I used the next day’s opening price).  Worst of all, it says I should own SCHA as of today!  I don’t think so.  Perhaps I should just not use the daily rule.

The ”hourly” rule has seven times as much data to work with as the daily rule, so it does a better job.  It says I should have bought SCHA on August 26th at 1PM and sold August 31st at 12PM (5.5% gain) and not own any right now, which seems right. The main problem with the hourly rule is that it requires me to check the market every hour on the hour, all day every day.  Since this is unrealistic, I have adjusted the simulation to assume that I will not buy/sell based on the PPO for the first hour of each day (before I get out of bed) or the last hour of the day (requires sniping that 4PM price).  Oddly enough, skipping those hours improves profit slightly!  Other hours will have to be skipped because it’s just too inconvenient to check the market every hour of every day.  I am not sure yet how much profit will be lost that way.

If this thing actually works with SCHA, the next move would be to apply it to TNA, which tracks the same ups and downs as IWM but leveraged 3× (before fees).  Here are some comparative gain charts:
PeriodStartEndIWMTNATrade time
Weekly2010-07-012011-09-0122%66%Monday 9:30AM
Daily2010-07-012011-09-0121%65%
51%
Same day 4PM
Next day 9:30AM
Hourly2011-06-012011-09-0116%40%Top of the hour
Looks great!  The problem is that if I screw up and get losses when the simulation says I should have had gains, the losses will be tripled.  I think I’ll stick with SCHA until this system proves itself.

No comments:

Post a Comment