+ Reply to Thread
Results 1 to 5 of 5

Continuous changing cell values - record highest and lowest values in seperate cells

  1. #1
    Registered User
    Join Date
    03-02-2013
    Location
    Sandton, South Africa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Continuous changing cell values - record highest and lowest values in seperate cells

    Hallo,

    I maintain a spreadsheet that records, per share code, the daily share price which changes on a continuous basis. For every share code, I want to record the highest and lowest historic share price in 2 seperate cells.

    I need help to make the above possible. I don't have any coding background.

    I attach a spreadsheet as an example of my current setup.

    I will appreciate any help.

    Thank you
    Attie
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Continuous changing cell values - record highest and lowest values in seperate cells

    where do you keep the historical price ?

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Continuous changing cell values - record highest and lowest values in seperate cells

    pl see attached file.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-02-2013
    Location
    Sandton, South Africa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Continuous changing cell values - record highest and lowest values in seperate cells

    Quote Originally Posted by etaf View Post
    where do you keep the historical price ?
    Hey there,

    I do not store the historic prices. The cells in column C gets over ridden by new values each day. I need a function in VB that would evaluate the latest number in column C and compares it with the values in the highest and lowest columns and then subsequently update the highest or lowest value.

    Thanks for your help.

    Attie

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Continuous changing cell values - record highest and lowest values in seperate cells

    you will need a macro so that before the daily update it maintains a record of the price on another sheet - sorry my vba isnow old and rusty, others will need to answer

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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