Excel Candlestick Chart Up Bars

%3CLINGO-SUB%20id%3D%22lingo-sub-2267081%22%20slang%3D%22en-US%22%3EExcel%20Candlestick%20Chart%20Up%20Bars%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2267081%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20the%20stock%20history%20function%20to%20call%20stock%20data%20for%20the%20past%206%20months%20and%20then%20create%20a%20candlestick%20chart.%20The%20problem%20is%20the%20chart%20doesn't%20have%20up%20bars%20only%20down%20bars.%20However%2C%20when%20I%20use%20another%20api%20to%20call%20the%20stock%20data%2C%20I%20get%20the%20up%20bars.%20I%20am%20wondering%20if%20the%20problem%20is%20the%20headers%20of%20the%20external%20api%2C%20adjusted%20close%2C%20and%20excel's%20stock%20history%20function%2C%20close.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2267081%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2323205%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Candlestick%20Chart%20Up%20Bars%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2323205%22%20slang%3D%22en-US%22%3EA%20screenshot%20of%20your%20data%20would%20help...%3C%2FLINGO-BODY%3E
Visitor

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. 

1 Reply
A screenshot of your data would help...