American Airlines Group Inc (AAL)

[JLS]

Here's what I can do.

I don't want to sell anything, but I am willing to walk you through the process of setting up an Excel sheet that will produce a Sup/Res chart alongside a stock chart.

If you want to do this minimal task, you'll end up with two worksheets -- one sheet for raw stock data for one symbol, and a second sheet which will contain the two charts (a standard stock chart with a second chart, the Sup/Res chart, placed adjacent to the stock chart). This chart sheet will also contain a few columns which will be used to make the calculations for the SR sheet.

As a minimum you will have to know how to download bulk stock data onto your hard drive. I do historical data backfill automatically (for 100 stock symbols) using a stock data downloader called YLoader, and it does the job of backfilling 18-months of historical data onto my hard drive (for all 100 symbols) within a few seconds. Then I have code within Excel which imports that data into Excel, one sheet for each stock symbol. First-level calculations (for various indicators) is done on each symbol sheet, then higher level operations on each of the symbols is done on separate sheets -- for instance, there is a separate sheet for doing theoretical options calculations.

You could download historical data for one stock at a time by using Yahoo ...
https://finance.yahoo.com/quote/AAL/history?p=AAL

That will get you one year of historical data. You can also download older data then append that data to the first set of data to get two years of historical data.

Once you have the historical data, you don't have to do that every day. All you have to do is download (or manually insert) the most recent day's data and append that to the bulk history data. Again, I do that automatically by pressing a button within Excel, then it downloads all of the current day's data for 100 symbols and appends that data to existing historical data, and that takes a couple seconds.

So, do that for one symbol, then I'll give you a few formulas that will calculate the Sup/Res result. One of those formulas will be a 3-D formula which requires a special way of entering the formula so that Excel properly executes the 3-D calculation. Without that, you'll get nowhere.

The last thing you will need to know is how to create stock charts within Excel. If you don't know how to do that, there are online tutorials.

Don't understand? Ask questions.