5-15-50 moving averages

[yclept]

To create tables and place some data in them, you need the <table>, <tr> and <td> WML tags. A table (<table>) has a number of rows (<tr>) and each row has a number of cells (<td>). Data is placed in table cells. The markup structure should be like this:


<table>
<tr>
<td>Data is placed here</td>
</tr>
</table>


The columns attribute of the <table> tag specifies the number of columns of a table. It is a mandatory attribute. The columns attribute value must match the number of <td></td> tag pairs in a row. For example, if the columns attribute value is 3, then each <tr></tr> must contain three <td></td> tag pairs.

The following WML example demonstrates how to create tables and place data in table cells:

<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.3//EN" "http://www.wapforum.org/DTD/wml13.dtd">

<wml>
<card id="page1" title="Table in WML">
<p>
<table columns="3">
<tr>
<td>Cell A</td>
<td>Cell B</td>
<td>Cell C</td>
</tr>

<tr>
<td>Cell D</td>
<td>Cell E</td>
<td>Cell F</td>
</tr>
</table>
</p>
</card>
</wml>

[yclept]

Well, I've gotten along perfectly well so far in my life without learning HTML -- bought a book on it yea-many-moons ago when the web was new, but gave it up as not being something I needed in my life. Doesn't look like that can continue if I want to post tables here.

The other problem is that the program I use to run the VBA for moving averages is on the old machine, which has Excel; this new machine is running Open Office and I've not rewritten the code to download prices and generate the graphs; I guess I can log into this website with the old machine and paste results. MSN was never smart enough to know that two different machines were logged in as the same user. I don't know if that will be true at proboards. I often forget which machine is logged in where, and thus am likely to have them both logged into the same site on occasion.
I'll mess with this HTML as time allows, but if it's too much to deal with this thread may not get reproduced over here. I reckon everyone knows how to generate the graphs themselves by now, if not, here's a link: stockcharts.com/h-sc/ui?s=$COMPQ&p=D&yr=0&mn=8&dy=0&id=p75161896904

[lovetobike]

it seems silly that it takes that much effort to post something from an excel sheet

I guess you could attach the excel sheet and we can download it.

[lovetobike]

	DOW	INDX	SPY
5-dayAvg	11,532	2352	1150
15-dayAvg	10,352	983	2
50-dayAvg	10,352	983	2

Here is a start. Note: I made up the numbers.

[lovetobike]

Yclept -

I created an excel sheet that will allow you to enter the new numbers for each of the indexes and then all you have to do is copy and paste what is in the excel sheet into this space and you'll have your table. Once you look at the sheet you'll see that I just put the code in individual columns and the values that I want in the cells of the table in the columns beside it. It won't look pretty when you paste it in the message but it turns out fine when you post it.

I've attached the excel sheet.

Index	5 sma	15 sma	50 sma
dji	10530	10468	10278
sp500	1125	1116	1095
compx	2289	2246	2176
ndx	1875	1836	1782

Attachments:

Table Generator for Proboardssma.xls.jpg (14 KB)

[yclept]

Test:

Index	5 sma	15 sma	50 sma
dji	10530	10468	10278
sp500	1125	1116	1095
compx	2289	2246	2176
ndx	1875	1836	1782

[yclept]

Well, that works fine. And I even got to see how all that HTML stuff needed to be put into a spreadsheet in order to make it work, and without having to delve into the mysteries of HTML.
Thank you. Actually it looks like I can just take a regular spreadsheet and add columns to fill in the mark-up language stuff and I'll be able to post most any table. Not as simple as the old cut and paste, but much easier to read.

[Deleted]

the excel sheet works fine ... i still like charts... add $indu or nasdaq if you like
stockcharts.com/h-sc/ui?s=$SPX&p=D&yr=0&mn=6&dy=0&id=p64959899448

[rovo]

re: Spreadsheets
What are the [tr] in the sheet? I'm looking at the sheet posted by lovetobike

[rovo]

I'll try this and see what happens.
Nothing in the table posted

Player	L or S	Symbol	$ Open	$ Close	% Close
Will 1	L	AIG	$52.56	$55.76	6.09%
Tyfighter3	L	BEXP	$26.40	$27.38	3.71%
Yclept	L	KAZ	$0.869	$0.895	2.99%
D. I.	L	UMDD	$155.38	$159.49	2.65%
rovo	L	TQQQ	$149.00	$151.23	1.50%
SlowbutSure	L	AAPL	$321.60	$325.16	1.11%
soycapital	L	TEF	$68.24	$68.69	0.66%

[rovo]

going to try to sort ....

Player	L or S	Symbol	$ Open	$ Close	% Close
Bluerobin	L	UGI	$31.83	$31.40	-1.35%
Burgertm	L	AUO	$10.37	$10.23	-1.35%
uncle.23	L	VMW	$89.530	$88.380	-1.28%
Mod E	S	FUQI	$6.37	$6.45	-1.26%
LivingInCali	L	TLT	$93.75	$93.12	-0.67%
clarkrl2	L	CELG	$59.54	$59.45	-0.15%
architecto25	L	IDT	$27.07	$27.17	0.37%

That seems to be a solution but it is not very clean.

[rovo]

I've figured out a way to allow sorting and or posting of same size tables without a lot of nonsense. I know Yclept post a lot of different data but the format is always the same.
Use a regular spreadsheet space for the data. Sort, rearrange or change the data as one normally would. Have a second space in the spreadsheet with all the formatting required to post it to this message board. The data in the formatted sheet uses the cell#s from the first sheet. Copy the formatted block of cells to this message board.

[rovo]

Yclept, I'm sorry to have made such a mess of your thread.

[yclept]

[red]Rovo,[/red]

[purple]No sweat, there are features we have to sort out about how to post on this forum[/purple] -- [blue]might as well be on this thread as any other.[/blue]


UBB Codes
These codes remind me of the old Wordstar mark-up formats.

Colors:
[blue]Make me blue.[/blue]
[red]Make me red.[/red]
[green]Make me green.[/green]
[yellow]Make me yellow.[/yellow]
[purple]Make me purple.[/purple]
[orange]Make me orange.[/orange]
[pink]Make me pink.[/pink]
[skyblue]Make me skyblue.[/skyblue]
[lime]Make me lime.[/lime]
[navy]Make me navy.[/navy]
[gold]Make me gold.[/gold]
[silver]Make me silver.[/silver]

Text size:
[huge]huge text[/huge]
large text
[small]small text[/small]
[tiny]tiny text[/tiny]

Font face:
[times]times font[/times]
[arial]arial font[/arial]
[courier]courier font

Font style:
bold
italic
underline
^superscript
_subscript

Text layout

center

quote

It looks like we have blue red green yellow purple orange pink and navy to work with for colors.
The text size codes don't seem to work. The font style codes do seem to work.

[lovetobike]

Rovo - [tr] allows the table to go to the next row. I'm guessing you've figured that out by now.

[rovo]

Yup. I figured it out (I think).
I'm going to post two tables to see if it works perfectly with the sort funtion.

Player	L or S	Symbol	$ Open	$ Close	% Close
Will 1	L	AIG	$52.56	$55.76	6.09%
Tyfighter3	L	BEXP	$26.40	$27.38	3.71%
Yclept	L	KAZ	$0.869	$0.895	2.99%
D. I.	L	UMDD	$155.38	$159.49	2.65%
rovo	L	TQQQ	$149.00	$151.23	1.50%
SlowbutSure	L	AAPL	$321.60	$325.16	1.11%
soycapital	L	TEF	$68.24	$68.69	0.66%
BenchMark	L	QQQQ	$54.59	$54.89	0.55%
architecto25	L	IDT	$27.07	$27.17	0.37%
clarkrl2	L	CELG	$59.540	$59.450	-0.15%
LivingInCali	L	TLT	$93.75	$93.12	-0.67%
Mod E	S	FUQI	$6.37	$6.45	-1.26%
uncle.23	L	VMW	$89.53	$88.38	-1.28%
Burgertm	L	AUO	$10.37	$10.23	-1.35%
Bluerobin	L	UGI	$31.83	$31.40	-1.35%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.000	$0.000	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.000	$0.000	0.00%
x	0	0	$0.00	$0.00	0.00%

[rovo]

now sort by alpha on the names:

Player	L or S	Symbol	$ Open	$ Close	% Close
architecto25	L	IDT	$27.07	$27.17	0.37%
BenchMark	L	QQQQ	$54.59	$54.89	0.55%
Bluerobin	L	UGI	$31.830	$31.400	-1.35%
Burgertm	L	AUO	$10.37	$10.23	-1.35%
clarkrl2	L	CELG	$59.54	$59.45	-0.15%
D. I.	L	UMDD	$155.38	$159.49	2.65%
LivingInCali	L	TLT	$93.75	$93.12	-0.67%
Mod E	S	FUQI	$6.37	$6.45	-1.26%
rovo	L	TQQQ	$149.00	$151.23	1.50%
SlowbutSure	L	AAPL	$321.600	$325.160	1.11%
soycapital	L	TEF	$68.24	$68.69	0.66%
Tyfighter3	L	BEXP	$26.40	$27.38	3.71%
uncle.23	L	VMW	$89.53	$88.38	-1.28%
Will 1	L	AIG	$52.56	$55.76	6.09%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.000	$0.000	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.00	$0.00	0.00%
x	0	0	$0.000	$0.000	0.00%
Yclept	L	KAZ	$0.87	$0.90	2.99%

[rovo]

the second sort did fair but the problem was with the sorting, not the posting. To make it easier I going to have to have a fixed size table (like above) so I don't have to screw with all the [] stuff every week.

[writer88]

I've taken the liberty of copying your basic spreadsheet and will use it as a template for my Women in Red Racers and Women in Red Savers charts.

You're amazing!

[rovo]

writer88, Does the above comment mean I can visit the WIR dorm without being stoned?

[writer88]

...sure, Rovo, just tread respectfully.

[yclept]

Index	5 sma	15 sma	50 sma
dji	11559.3400	11,476.0400	11,277.3800
sp500	1257.2520	1,244.1890	1,210.2260
compx	2666.9680	2,639.7590	2,557.6510
ndx	2231.6060	2,216.4490	2,163.1800

Nobody panic! Nothing has changed with respect to the crossing averages. The indices I follow simultaneously crossed upward on 9/17, and have remained so since then. I just figured it's close enough to the end of the year that this was as good a place as any to draw a line in the sand and say "On this day, it was so."
NASA is still analyzing data to determine the exact number, however it's clear the Chilean earthquake of last February has shortened our day, probably by 1.26 microseconds. It's hard to say what effect, if any, this is having on these moving averages and their crossovers.

[yclept]

Pick your poison! Portfolio track started on 9/17/10 (using high prices of the day for entry; $10,000 starting position for each ticker. 9/17 (as mentioned above) was the last time the 5-15-50 moving averages crossed to full-buy status. Obviously 3X the Russell was the place to be. I find it interesting that 3X Financials didn't even double lowly QQQQ.

Symbol	Last	Change	%Change	Volume	Position	Bought	Value	Net	%Change
TNA	74.95	0.6	0.80%	2899327	233	09/17/10	$17,463.37	$7,439.70	74.22%	3XRussel
QQQQ	54.65	-0.13	-0.24%	17867334	208	09/17/10	$11,367.92	$1,347.80	13.45%	Nas 100
UPRO	204.56	-1.05	-0.51%	321328	67	09/17/10	$13,705.58	$3,692.13	36.87%	3XS&P
QLD	81.91	-0.47	-0.57%	1204368	157	09/17/10	$12,860.46	$2,824.30	28.14%	2XQQQQ
SSO	47.98	-0.13	-0.27%	3099272	257	09/17/10	$12,330.86	$2,339.41	23.41%	2XS&P
DDM	54.36	-0.14	-0.27%	285183	218	09/17/10	$11,850.48	$1,839.46	18.37%	2XDow Ind
UWM	43.72	0.22	0.50%	722493	335	09/17/10	$14,646.20	$4,629.40	46.21%	2XRussel
FAS	27.69	-0.27	-0.99%	9257327	440	09/17/10	$12,184.91	$2,176.71	21.74%	3XFinancial
TQQQ	149.3	-1.07	-0.71%	52473	97	09/17/10	$14,483.07	$4,437.54	44.17%	3XQQQQ
Total							$120,892.88	$30,726.48	34.07%

[yclept]

74% in a little over three months. Now that's what I call a nice gain!

[Deleted]

"TNA up 74% in a little over three months. Now that's what I call a nice gain!"

thanks for sharing!!!

[2kids10horses]

yclept,

I remember you from the old Flair's days!

Anyway, I was able to find a link to the old 5/15/50 thread on MSN Money, and I read the thread from Jan 2010 to present.

For the past couple of years, I've just been trading ETFs, not messing with individual issues. I do the long and short QQQs, SPYs and Russel 2000s. I like the leveraged ETFs, and as you pointed out, that 3xRussel 2000 is a rocket ship! (I use URTY.) Of course, the disadvantage with the leveraged ETFs is the negative compounding that occurs if the trade goes against you.

My question for you, since you track the major indexes, why do you bother with individual stocks? Doesn't it make sense to just trade the index ETFs using your 5/15/50 system?

[yclept]

Here's an update on the above portfolio:

Symbol	Last	Change	%Change	Volume	Position	Bought	Value	Net	%Change
TNA	78.59	1.65	2.15%	6556222	233	09/17/10	18313.8	8290.13	82.70%	3XRussel
QQQQ	57	0.42	0.75%	43867400	208	09/17/10	11856	1835.87	18.32%	Nas 100
UPRO	221.72	3.78	1.73%	932710	67	09/17/10	14855.91	4842.45	48.35%	3XS&P
QLD	89.12	1.25	1.43%	3120679	157	09/17/10	13993.41	3957.25	39.42%	2XQQQQ
SSO	50.68	0.63	1.27%	8974173	257	09/17/10	13024.75	3033.31	30.35%	2XS&P
DDM	56.41	0.48	0.85%	640439	218	09/17/10	12299.55	2288.54	22.86%	2XDow Ind
UWM	45.24	0.65	1.45%	1282677	335	09/17/10	15155.4	5138.6	51.29%	2XRussel
FAS	31.45	1.29	4.31%	28984160	440	09/17/10	13842.4	3834.2	38.31%	3XFinancial
TQQQ	169.13	3.59	2.16%	159562	97	09/17/10	16405.6	6360.07	63.31%	3XQQQQ
Total							129746.85	39580.44	43.89%

[2kids10horses]

OK, so it looks like you're doing the index ETFs now. I was commenting on your past activity as posted last summer. The ETFs you are playing are similiar to those I'm using.

Continued good luck to both of us! I appreciate you efforts to show the cross overs.

[yclept]

2kids10horses,
Sorry, I don't remember the name. Were you someone else on the Supermodels board?

I do use ETFs, though I've seldom had the guts to hold them for very long (especially the leveraged ones). I'm not holding anything but some QQQQ right now -- unleveraged, I have more guts! As the above table shows, the period from the last full cross upwards to now would have been an amazing time to hold any of the above, especially the most highly leveraged ones.

I tend to use tickers that I screen for fundamental undervalued status as vehicles more often than the ETFs. I believe the undervaluation gives me a margin of safety that the indices and leveraged indices themselves cannot in the sense that it's hard for something to fall off the floor. This, of course, opens me up to individual stock negative issues especially if my fundamental evaluation is wrong or the data it's based upon is fallacious. The index-based ETFs obviously mitigate that danger through automatic diversification.
Of course, the leveraged ETFs since they use instruments not necessarily associated with the underlying tickers (futures, options, etc.) offer their own poisonous risk -- one really doesn't know at all what one owns when it comes to them. That and they are designed to multiply the daily movement of the underlying indices without any promise of longer term multiples of same. In fact, if one catalogs the long and short of a mirror pair of leveraged ETFs over a longer period of time (which I have done on several occasions), one finds that the sum of the results loses ground to the index itself. Which means if one is on the wrong side of the market direction, one is losing more than one would be gaining if one had been on the right side.
Through many retrospective studies, I have come to have faith in the moving average crossovers as a decent market timing method, though many knowledgeable people here and elsewhere do not. And, of course, there are many who say they don't believe the market can be timed at all -- Buffet being one, though I think his actions speak louder than his words! I guess one has to study it as best one can and then just make a leap of faith as to which side of the debate one wants to follow.
The other aspect to be considered is, as a market timer, I have to balance the amount of whipsaw I'm willing to tolerate versus lag losses I will incur when the market (and lagging signal) really turns. After many spreadsheet studies, I've settled on Vic Lee's original 5-15-50 signal as being as good as any. A faster signal lets one lose less on a real change in direction, but suffers more whipsaw losses on false signals. A slower signal avoids many of the whipsaws, but suffers more lag loss when the market really turns and one is still waiting for the signal. Again, one pays one's money and one takes one's choice.
With the leveraged ETFs, the above timing liabilities are magnified -- again, one doesn't want to be on the wrong side of those things very often if one wants to avoid disaster. Obviously, Clearstation is still tracking this model portfolio for me and when the market turns down again (which it inevitably will) we will have a chance to see how much of the above gains have to be given back while waiting for the signal to turn. I fear it will not be a pretty sight, but with the gains it's seen since inception, it can afford significant lag loss, and may experience similar outlandish gains when it switches to the short side equivalents of the above instruments. It all depends upon the length of time the signal (and market) maintain the then current direction. Reckon we'll see!

[yclept]

To clarify the above after reading your last post: