I've been attempting to find a formula (Exploration) the will show the relative performance of a Stock vs an Index or other indicator. I've searched the AB Library , files section and Yahoo AB group but no luck. If someone has such a formula/exploration It would be most appreciated if you would post or pass along. Below is a spreadsheet of what I'm tying to achieve. It is for 20 bars of the Nasdaq100 (^NDX) vs some of the stocks in that list. Thanks for any ideas or help you may offer.
Dick H. Sym PR PR-20 Diff$ %Diff % STKvsIDX ^NDX 1972.54 1997.02 -$24.48 -1.23% AAPL $185.64 $188.16 -$2.52 -1.34% -0.11% ADBE $41.74 $40.44 $1.30 3.21% 4.44% ADSK $39.9 $39.67 $0.23 0.58% 1.81% AKAM $36.33 $37.94 -$1.61 -4.24% -3.01% ATVI $33.8 $30.9 $2.90 9.39% 10.62% YHOO $26.4 $25.26 $1.14 4.51% 5.74%
