+ Reply to Thread
Results 1 to 2 of 2

Calculate percentage change of data in a single cell that updates every 5 minutes

  1. 04-19-2021, 05:25 PM #1
    1kingston
    1kingston is offline
    Registered User
    Join Date
    04-19-2021
    Location
    Toronto, Canada
    MS-Off Ver
    2019
    Posts
    1

    Calculate percentage change of data in a single cell that updates every 5 minutes

    The data in column E updates every 5 minutes. Ideally I'd like to just be able to calculate the percentage change of the current value and previous value, and display it in another cell. From what I've been told, this isn't possible. So that's why I'm posting this question here because I think a macro can help solve this.

    Every 5 minutes, Can I copy the current value of E2 into F2, and have the previous E2 value move to G2, then calculate the percentage change of G2 and F2 in another cell?

    The sheet I'm attaching has 5 rows so far, but I'd like to do the same for probably at least 30 rows if possible.

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-26-2021, 01:19 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Calculate percentage change of data in a single cell that updates every 5 minutes

    Here is my take on it. I assume that you will have the query set up to refresh every 5 minutes.

    I took the liberty of renaming the sheet and the table to something more manageable.

    I set up a change event so when any information changes in the table column with the quote, the current data from that quote gets transferred to the next column. This becomes the last quote for the next update.

    Change Event Code
    Please Login or Register  to view this content.
    Copy Code

    Please Login or Register  to view this content.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate N-Day Percentage Change and N-Day High/Low based on N value in separate cell?
    By Elijah in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 08-14-2018, 05:10 AM
  2. [SOLVED] Converting total minutes into hour and minutes in a single corresponding cell
    By paradise2sr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2017, 02:44 AM
  3. Calculating percentage change of a cell that updates on refresh
    By Jakers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-31-2017, 09:13 AM
  4. Plotting data in graph from single cell that updates from web
    By jamiecozens in forum Excel General
    Replies: 3
    Last Post: 10-03-2016, 06:31 PM
  5. [SOLVED] Combine few columns and rows into single one and calculate percentage
    By sarat47 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-17-2013, 10:13 PM
  6. Calculate percentage change of cell
    By flat_pro in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2013, 01:51 PM
  7. populate a range based on a cell value that updates every 30 minutes
    By rh2705 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-01-2012, 12:49 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1