Replies to post #35024 on American Airlines Group Inc (AAL)

[JLS]

I want you to change that.

The easiest way for you to get something that works is for you to use what I have, not what you want.

The most commonly accepted way of arranging stock data is to have the date column be the first column to the left of all data and also to the left of any calculations made from the data. For that reason, the date data should remain in Column E. The best way to define a chart is with the OFFSET() function. All OFFSET functions will be related to the date column. If the date column is to the left of all other columns then the OFFSET() function will be easier to write and read because all offset values will be positive numbers and to the right. You'll see that in the table image below.

The formulas below are everything you need to produce an SR stock chart using candles and moving averages which the SR chart will use providing you enter them into the chart definition. There is a way to turn the moving averages ON or OFF, but we'll leave that for later.

There is a name in the top row of that table that you haven't seen. It is Study_End. Change that to the number 30. Another name is SR_CandleOffset. Change that to the number 1. Those names are for features that I have that you won't have because they aren't directly related to SR values. I use names instead of the numbers I gave you as that gives flexibility regarding issues unrelated to SR charts.

Another name is SR_Weeks. You've already named that cell (at C8) and created (I hope) a drop-down.

Create another drop-down at C9, SR Price Basis. Use the two values: "Closing" and "Opening". There are only two choices. Name C9 as SR_Basis. The list for that drop-down is Opening, Closing -- exactly as I typed it here. It's choice allows calculating SR values using either Opening prices or Closing prices. That will show up in formulas I give you after the stock chart is done.

Below is everything you need for the SR stock chart. Enter those things into your name manager. Use them to make a candlestick chart.

If you are unfamiliar with the Excel OFFSET function, search the internet. Or, better yet, there should be an fx next to your Excel formula bar. Click on that fx, then a help window should show up with an alphabetical list of functions. Find OFFSET then click on it.