I've modified the original spreadsheet so you can get a Buy, Hold, Sell signal for a gaggle of stocks.
Once upon a time I generated a spreadsheet that did VDX and thought it was pretty neat and ...
>VDX? Sounds like some venereal disease.
Uh ... well, it's a mechanism for deciding whether to Buy, Hold or Sell a stock.
>Does it work?
Of course! It's infallible as are all Technical Indicators. Just follow its advice and make a $million.
>If you start with 2 $million.
It involves a competition between Bulls & Bears.
You Buy, Sell or Hold depending upon who's winning ... and it's quite intriguing.
>So you decided to drag it out again?
Exactly! After all, I did that some ten years ago when I was pretty schtoopid and ...
>And what's changed?
I decided to revisit that old ritual, playing with DOW stocks
The spreadsheet looks like this:
Click on the picture to download the spreadsheet.
Notice that the first Sell signal occurs in Dec/09, when XOM starts to drop.
It also uses Volume Weighting, so prices associated with greater volume have greater weight. That's the reason for the V in VDX.
>Is that good?
Of course! Don't you know anything?
Here are some examples: