American Airlines Group Inc (AAL)

[JLS]

You have two date columns.

You only need one. It is conventional to put dates in the farthest left data column (relative to other chart data columns). That will make all your Offsets to other data positive.

If you start deviating from what I give you then you may experience problems with your final result: which is to get a Sup/Res chart. If you have problems because of deviations you've made, don't expect any help from me. It works best if I'm the only one that makes mistakes, as I'll be able to fix those. When you get this whole thing working then you can make all the changes you want.

Therefore, I suggest you use the dates in Column #5, which Excel labels as E. If you do that, then you can use all the Offset equations in the link below to create your candlestick chart (including moving averages if you choose to include those). I'm also suggesting you change the color of your candlestick shadows, as they are currently too dark and don't show up on your posted chart.

http://tinyurl.com/y2c6eg8b

Assign all the following names and formulas:

C7 = Name as: SR_Range ...... DropDown: 1.50%,1.20%,0.80%,0.60%,0.40%,0.30%,0.20%,0.15%,0.10%,0.05%
C8 = Name as: SR_Weeks ...... DropDown: 6,8,10,12,14,15,16,17,18,19,20,22,25,30,35,40,45
C9 = Name as: SR_Basis ...... DropDown: Closing, Opening

C20 = Name as: SR_Symbol ...... Make a DropDown list of symbols to choose from (I select a symbol from two lists on the sheet but you will need more code to do that). This is a link showing parts of those two lists: http://tinyurl.com/y6pc8te7

C21 = ... leave blank for now ...
C22 = Name as Limit_Hi ...... formula = 1+SR_Range/2
C23 = Name as Limit_Lo ...... formula = 1-SR_Range/2
C24 = Do not name but install formula: SR_Range*INDIRECT("'"&SR_Symbol&"'!E"&Study_End) ...... For Study_End use the number 30 instead of the label (as that defines the top row or most recent historical data on the symbol data sheets, and which should also be row 30). For me, it's a variable so that I can end SR charts on any date prior to the most recent date.

TempMiniChart = SR_Range*INDIRECT("'"&SR_Symbol&"'!E"&Study_End)

C_Window = "SR_CP!$F39:$F"&Oldest_Record
Oldest_Record is the row number of the earliest historical data for any symbol when doing SR calculations, which would be 301 for my historical data sheets that I use every day (but another program can go out many years).