I am trying to create multiple candlestick charts for given date ranges which I have a list of in Excel. I have OHLC daily price data and need to use this data to create roughly 1100 charts.
I would like these charts to be in a printable format after they have been created.
Also, I would like horizontal lines on each chart, as specified prices.
Any help would be much appreciated.