+ Reply to Thread
Results 1 to 3 of 3

Calculating percentage change of a cell that updates on refresh

  1. #1
    Registered User
    Join Date
    08-23-2017
    Location
    England
    MS-Off Ver
    2010
    Posts
    5

    Question Calculating percentage change of a cell that updates on refresh

    I understand you can calculate percentage change by using, for example, =(A1/A2)-1 where A1 is the first months income and A2 is the second months income -

    On my spreadsheet however I have a cell that takes data from an online currency site which I manually refresh. Is there any way I can have a cell that will calculate the percentage change upon refresh? For example if the cell was $60 and then updated to $95 when refreshed, another cell would be populated with 58.33%?

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,007

    Re: Calculating percentage change of a cell that updates on refresh

    If your sheet takes data from the online currency site using VBA then just modify the VBA to produce a history (even if it's just old value and new value) of the previous values which will allow you to calculate the percentage change.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    08-23-2017
    Location
    England
    MS-Off Ver
    2010
    Posts
    5

    Re: Calculating percentage change of a cell that updates on refresh

    Quote Originally Posted by Special-K View Post
    If your sheet takes data from the online currency site using VBA then just modify the VBA to produce a history (even if it's just old value and new value) of the previous values which will allow you to calculate the percentage change.
    It doesn't unfortunately, I'm importing the data using the Web Query / Data ->From Web function to another sheet and then importing the relevant cell from that sheet

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Create comment that updates based off cell change
    By earthandbody in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-21-2017, 09:06 AM
  2. Calculating percentage with only one given cell
    By Eazio in forum Excel General
    Replies: 14
    Last Post: 08-02-2016, 07:50 AM
  3. [SOLVED] How to refresh change without click cell?
    By putritersenyum in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2016, 11:16 AM
  4. Replies: 6
    Last Post: 04-05-2014, 07:17 PM
  5. [SOLVED] Using VBA to change a pivot table filter, refresh the report and set up a refresh delay
    By Bonnister in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-18-2012, 10:43 AM
  6. Refresh pivot tables on cell change
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2011, 07:04 AM
  7. [SOLVED] SQL - Auto Refresh Upon Cell Value Change
    By Elliot J in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-12-2005, 06:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1