|
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.
Pay attention.
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?
Pay attention!
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.
|
| ^DJI HOLD | | ^IXIC HOLD | | AA SELL | | AIG BUY | | AXP BUY | | BA BUY | | C SELL | | CAT BUY | | DD HOLD | | DIS SELL | | F BUY | | GE BUY | | HD HOLD | | HON BUY | | HPQ HOLD | | IBM BUY | | INTC HOLD | | JNJ HOLD | | JPM HOLD | | KO HOLD | | MCD HOLD | | MMM HOLD | | MO BUY | | MRK BUY | | MSFT BUY | | PFE BUY | | PG SELL | | T SELL | | UTX BUY | | VZ SELL | | WMT HOLD | | XOM HOLD |
|
I've modified the original spreadsheet so you can get a Buy, Hold, Sell signal for a gaggle of stocks.