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

cgalloway

New member
Joined
Nov 9, 2013
Messages
4
Reaction score
0
Points
0
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

New member
Joined
Jan 17, 2013
Messages
832
Reaction score
0
Points
0
Location
British Columbia
Excel Version(s)
Excel 2010
have you tried double clicking the drag cross?
 

cgalloway

New member
Joined
Nov 9, 2013
Messages
4
Reaction score
0
Points
0
Just tried it, but does the same as clicking and dragging - only calculates percentage change from the previous day, not the zero day.
 

NoS

New member
Joined
Jan 17, 2013
Messages
832
Reaction score
0
Points
0
Location
British Columbia
Excel Version(s)
Excel 2010
is this what you have in C10 ?

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

if not what do you have ?
 

cgalloway

New member
Joined
Nov 9, 2013
Messages
4
Reaction score
0
Points
0
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!
 
Top