Results 1 to 6 of 6

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    have you tried double clicking the drag cross?

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

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

    Capital Markets data 2012-2013.xlsx

  5. #5
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    is this what you have in C10 ?

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

    if not what do you have ?

  6. #6
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •