WB ... also, it's not just the calculating range but the period used in all of the calculations must be variable ... so you need to know how to use the OFFSET command in Excel so that your selected cell-range in the LR algorithm can change on the fly. Actually, maybe that's what you are calling the "calculating range".
You'll know if you programmed it right by seeing the LR bars change direction more rapidly. Also, make sure your graphs are re-scaling automatically correctly.
good luck !!