How to convert individual cell values to percentage change values over time

[cgalloway]

I have two years of excel data showing daily share prices of a particular stock. I want to change those values to show percentage change (on a daily basis) from the zero date (ie the first day of the two year period). I know that the formula for showing daily percentage change would be (second day/first day -1) and that I can click and drag on that formula to extend over the rest of the two-year data. The formula I want would be, basically, (each day/first day-1). Is there an easy way to automate the script so I dont have to type it out 730 times?

[NoS]

have you tried double clicking the drag cross?

[cgalloway]

Just tried it, but does the same as clicking and dragging - only calculates percentage change from the previous day, not the zero day.

[cgalloway]

Here is the actual data in case that helps...

Capital Markets data 2012-2013.xlsx

[NoS]

is this what you have in C10 ?

=($B10/$B$9)-1

if not what do you have ?

[cgalloway]

You are right, this is the formula I was looking for. I was using =B10/B9-1. The $ sign was the magic ingredient. Excellent, and thanks for your help!