Forum Discussion

saihaan's avatar
saihaan
Copper Contributor
Apr 12, 2021

Excel Candlestick Chart Up Bars

I am using the stock history function to call stock data for the past 6 months and then create a candlestick chart. The problem is the chart doesn't have up bars only down bars. However, when I use another api to call the stock data, I get the up bars. I am wondering if the problem is the headers of the external api, adjusted close, and excel's stock history function, close. 

    • Boki_B's avatar
      Boki_B
      Copper Contributor

      JonPeltier

       

      Hi Jon,

      why my Candlestick Chart Bars look like this? It really doesn't look as Candlestick Bars. Please help. I am using Microsoft 365 Basic.

       

       

       

       

       

Resources