Hi All-
I've taken up a job that requires excel skills that are foreign to me. I am hoping to see if someone can help me with some of this or translate what it means.
I am to take weekly returns of a certain stock date from last 5 years, which I have and compare it to the S&P index. Basically, I am to do the following, now the term rebasing may or may not be familiar to some as it is finance concept. But hoping if you can at least explain me the scaling part, where it asks to scale the stock to 100???? Thank you much.
I assume the scaling is for the purpose of creating the time series graph, but how do I achieve that?
"Translate all stock prices to the same scale, starting at 100, and plot a single time series graph with the re-based stock prices on the
left-hand scale and the index (not re-based) on the right hand scale."
I've taken up a job that requires excel skills that are foreign to me. I am hoping to see if someone can help me with some of this or translate what it means.
I am to take weekly returns of a certain stock date from last 5 years, which I have and compare it to the S&P index. Basically, I am to do the following, now the term rebasing may or may not be familiar to some as it is finance concept. But hoping if you can at least explain me the scaling part, where it asks to scale the stock to 100???? Thank you much.
I assume the scaling is for the purpose of creating the time series graph, but how do I achieve that?
"Translate all stock prices to the same scale, starting at 100, and plot a single time series graph with the re-based stock prices on the
left-hand scale and the index (not re-based) on the right hand scale."
