Sorry I’m new to vba and need help about creating VBA code for xlStockOHLC chart to new worksheet.
I have a ticker worksheet (Symbol) with a list symbol on column A (eg, A7,A8, A9 and so on), the existing code will select from A7 symbol (eg, Appl) and download historical data (column A,B,C,D,E,F respectively to Date, Open, Hi, Low, Close, Volume) into new worksheet and name after the symbol (eg. Appl). Follow by the new chart creation code should able to add new chart (into GG120) to this new worksheet. The existing code will loop until all symbols (+ chart creation) complete.
However I’m not able to create new chart, label, nor adding series after the new symbol worksheet created with all my historical data downloaded successfully, can anyone help on the code to add xlStockOHLC chart into this new worksheet?
Thank you.
I have a ticker worksheet (Symbol) with a list symbol on column A (eg, A7,A8, A9 and so on), the existing code will select from A7 symbol (eg, Appl) and download historical data (column A,B,C,D,E,F respectively to Date, Open, Hi, Low, Close, Volume) into new worksheet and name after the symbol (eg. Appl). Follow by the new chart creation code should able to add new chart (into GG120) to this new worksheet. The existing code will loop until all symbols (+ chart creation) complete.
However I’m not able to create new chart, label, nor adding series after the new symbol worksheet created with all my historical data downloaded successfully, can anyone help on the code to add xlStockOHLC chart into this new worksheet?
Thank you.
