How to convert excel individual cell values to percentage change values over time
Posted
by
cgalloway
on Super User
See other posts from Super User
or by cgalloway
Published on 2013-11-09T08:39:44Z
Indexed on
2013/11/09
9:59 UTC
Read the original article
Hit count: 171
microsoft-excel
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 time period. 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?
© Super User or respective owner