'Excel Candlestick chart using =STOCKHISTROY()
I cant find a way to make excel recognize different candle types while using the stock history function as a reference. I've looked up countless YouTube videos - none of which address the specific problem I'm facing.
Despite using Date, Open, Close, High, and Low, the only data series' displayed are High-Low Lines and Down Bars. (I changed the color of the candles to green, which is kinda irrelevant considering ALL candles are linked to one specific color, despite their respected open and close prices.)
The stock data shown in the image below, is what the graph is referencing from a separate sheet. The formula I am using is
=STOCKHISTORY(Graph!C2,TODAY()-graphdata_range,TODAY(),0,1,0,2,3,4,1,5)
Where 'Graph!C2' is the TESLA ticker shown in the upper left of the graph image, and 'graphdata_range' is the amount of days the user wishes to display in the graph.
I currently believe that technically all the data is stored in the cell containing 'Date', while everything else is a spill. This is because when I select any other piece of data within the table shown in the image above, the formula within the formula bar is greyed out. However I'm really hoping this isn't the cause of the issue.
Any help would be greatly appreciated - Thanks!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|


