have you tried double clicking the drag cross?
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?
have you tried double clicking the drag cross?
Just tried it, but does the same as clicking and dragging - only calculates percentage change from the previous day, not the zero day.
Here is the actual data in case that helps...
Capital Markets data 2012-2013.xlsx
is this what you have in C10 ?
=($B10/$B$9)-1
if not what do you have ?
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!
Bookmarks