-2

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.

braX
  • 9,702
  • 5
  • 16
  • 29
Ed Lee
  • 3
  • 2
  • 1
    SO is not a code writing service. "I want this thing, somebody make it for me" is not an appropriate question for this forum. – mypetlion Nov 07 '18 at 17:14
  • Are you looking for python packages to read .csv and .xls? Are you looking to write to Excel? – mauve Nov 07 '18 at 17:16
  • We also need to know how is the data stored in the Excel. Separate sheets? Columns? or Aggregated, to make any sense. – Brijesh Apr 20 '20 at 14:48

1 Answers1

1

I recommend you check out pypi for the python package index. Some useful packages you should look into are Pandas, MatPlotLib, and xlrd. If you have a specific question about code that you're working on, please come back and ask.

mauve
  • 2,406
  • 1
  • 12
  • 28