+ Reply to Thread
Results 1 to 3 of 3

How to add trendline to candlestick chart

  1. #1
    Registered User
    Join Date
    09-07-2016
    Location
    london
    MS-Off Ver
    2007
    Posts
    1

    How to add trendline to candlestick chart

    Hi,
    i need to add a trendline (SMA) based on the values in a separate column F to my candlestick chart:

    Clipboard02.jpg

    Is this somehow possible? The trendline needs to appear as a line graph on the candlestick chart. If i add the F column as series then it just messes up the existing candlesticks.

    http://www.megafileupload.com/k4z0/aapl.xlsx

    P.S. Attaching files does not work in this forum, tried with Opera & Chrome. The popup is blank and it is not possible to attach anything.
    Last edited by bupthebroker; 09-07-2016 at 07:56 AM.

  2. #2
    Forum Contributor
    Join Date
    08-17-2013
    Location
    Asia
    MS-Off Ver
    Excel 2010
    Posts
    219

    Re: How to add trendline to candlestick chart

    Why not trying some simple freeware ? I guess, locating Trend line for various Swing, inside excel could be tricky and not manageable. Think of file size, if you are monitoring multiples stocks like this in various sheets.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,233

    Re: How to add trendline to candlestick chart

    I have very limited experience with Excel's stock charts, but it seems that they have limited flexibility when you want to do something a little bit beyond what they are designed to do.

    I suspect that the best way around this is to learn how to build Excel's stock charts from scratch, rather then using the built in option. An OHLC always looked to me like a simple "box and whiskers" plot, which is basically a stacked column chart. Adding a line chart (to make a stacked column+line combination chart) should be straightforward. This should walk you through the process: http://peltiertech.com/excel-box-and...ams-box-plots/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. How to convert tick data into Candlestick chart
    By cherrychan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2018, 04:02 AM
  2. Adding Moving Average on Top of Candlestick chart on excel 2010
    By vb765 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-01-2013, 03:57 PM
  3. Bar Chart with Trendline
    By chriseverclear in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-28-2013, 06:58 PM
  4. Creating a Weekly Candlestick chart
    By IamNotaDoctor in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2013, 07:45 PM
  5. Replies: 0
    Last Post: 06-25-2012, 05:56 PM
  6. Place a trendline above the bar chart?
    By joelhuang in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-05-2011, 04:39 AM
  7. Adding a trendline to chart
    By controlfreak in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-23-2009, 05:49 AM
  8. Excel and Candlestick Chart?
    By Mike in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-07-2006, 03:40 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