+ Reply to Thread
Results 1 to 5 of 5

Graphic to show open ,high, low, close and last trade of the day.

  1. #1
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Graphic to show open ,high, low, close and last trade of the day.

    I have literally no idea of how to build this, so I am showing you a picture of what I am trying to accomplish.

    I want to create a horizontal line that has the low of the day at the left end and the high of the day at the right.

    I want to have a little black vertical bar showing where the market opened with its price below it.

    The last traded price is above the line with a little arrow pointing to where it is on the line. Note that if the last trade goes below the open of the day its now (Lower or red) on the day and if it goes over the open its now higher (higher or green).

    Thank you so very much for your help!
    Attached Images Attached Images

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Graphic to show open ,high, low, close and last trade of the day.

    This requires pretty convoluted set up in Excel.

    Using variant of bullet chart process from link.
    https://peltiertech.com/bullet-charts-in-excel/

    You can set up something like below.
    0.JPG

    See attached workbook for set up.
    Attached Files Attached Files
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Re: Graphic to show open ,high, low, close and last trade of the day.

    This is really amazing thank you so much for attempting it.

    I have uploaded the file you have here with a few changes i have made but also have a request.

    I have removed both the wording for high and low (i will make them text boxes) and moved the close (last) to the bottom and turned it into an arrow.

    The issue i am having is that there is an area to the right or the green bar (it does not use the entire line) so if i have 10 of these is a row the ends dont line up. Is there anyway to make it fixed?
    Attached Files Attached Files

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Graphic to show open ,high, low, close and last trade of the day.

    Use Axis option to set Min/Max value to desired amount.

    Exact value will depend on your data set.

  5. #5
    Registered User
    Join Date
    11-06-2019
    Location
    ALASKA
    MS-Off Ver
    2016
    Posts
    6

    Re: Graphic to show open ,high, low, close and last trade of the day.

    please explain how to do this

+ 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] Volume-Open-High-Low-Close
    By William... in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-09-2017, 11:45 AM
  2. Volume-Open-High-Low-Close
    By William... in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-09-2017, 05:46 AM
  3. [SOLVED] Open high low close chart with range increasing with column
    By rajre in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-18-2014, 11:30 AM
  4. elliminating series overlap on volume-open-high-low-close chart
    By luv2glyd in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-27-2012, 03:36 AM
  5. Open, High, Low, Close yahoo stock data required
    By Humming in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2012, 07:07 AM
  6. Deriving close-high-low-open
    By db8r in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2009, 09:53 AM
  7. [SOLVED] Excel should have an open/close high/low chart for stock market u.
    By Harold Hommes in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2005, 01:06 PM

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