I try to write a formula which compares stock with a another stock or an index by setting both stocks at a (index)value of 100 at a specific date (or a specific number of days ago).

The problem is that there is a Lastvalue function but not a Firstvalue(loaded) function, unless I did not look well into the help function. When such a function could be used, the left side of the graphic could be defined to start alway at 100 (at the first loaded date in a graphic). X:= c/"Firstvalue(c)"*100

Another way to create such a function is by asking (via the input function) how many days (X) to go back from the LastValue known. Then read the closing price etc. at that specific day, divide it each by the closing price and you get an idexed plot line of the security starting at Day X with 100.

Who can help me to sort this out?


Daydreamer.

Anton, you may be interested in the URSC tool-kit - it plots true Relative Strength % values between any two securities, starting either at x calendar days back or at a specific past date (user-defined). jose '-)