Forum Discussion
saihaan
Apr 12, 2021Copper Contributor
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.
- A screenshot of your data would help...
- Boki_BCopper Contributor
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.