Tuesday, October 08, 2019 8:25:05 PM
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.
Recent AAL News
- Nvidia Profits Set to Challenge Historic High Market; GE Aerospace Announces New Hires, and More News • IH Market News • 05/22/2024 10:37:09 AM
- Producer Price Inflation Data May Weigh On Wall Street • IH Market News • 05/14/2024 01:05:30 PM
- Dow Snaps Eight-Day Winning Streak After Lackluster Session • IH Market News • 05/13/2024 08:34:54 PM
- Perficient Stock Soars 52.9% Post-Acquisition; Luminar Declines 10% Amid Workforce Cutbacks, and Other News • IH Market News • 05/06/2024 12:09:00 PM
- U.S. Futures Drop in Pre-Market Trading as Tech Stocks Plunge After Meta Issues Gloomy Forecast • IH Market News • 04/25/2024 11:53:54 AM
- American Airlines Reports First-Quarter 2024 Financial Results • GlobeNewswire Inc. • 04/25/2024 11:00:00 AM
- SriLankan Airlines Leverages UATP Merchant Status to Accelerate Growth and Reduce Payment Costs • PR Newswire (US) • 04/10/2024 12:00:00 PM
- American Red Cross welcomes American Airlines as its newest Mission Leader • PR Newswire (US) • 04/04/2024 12:03:00 PM
- FedEx Soars 13% with Profits Above Forecasts, Nike Hit by China Slowdown, and Latest News • IH Market News • 03/22/2024 01:07:53 PM
- American Airlines to present at 2024 J.P. Morgan Industrials Conference • GlobeNewswire Inc. • 03/05/2024 03:00:00 PM
- AMD Hits Regulatory Roadblock, GitLab’s Stock Tumbles on Disappointing Earnings, and Latest News • IH Market News • 03/05/2024 11:05:08 AM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/29/2024 10:23:51 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/26/2024 09:06:58 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/26/2024 09:06:09 PM
- Goldman Sachs Reconsiders Fed Cuts, LUNR Surges Over 40% in Pre-Market, and More • IH Market News • 02/23/2024 01:03:59 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/22/2024 10:06:38 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/22/2024 10:05:59 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/22/2024 10:04:49 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/22/2024 10:04:06 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/22/2024 10:02:14 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/22/2024 10:01:21 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/21/2024 09:23:06 PM
- Form 4 - Statement of changes in beneficial ownership of securities • Edgar (US Regulatory) • 02/21/2024 09:21:40 PM
- UATP Receives Patent Approval for Innovative New Payment Technology • PR Newswire (US) • 02/15/2024 02:19:00 PM
- Form SC 13G/A - Statement of acquisition of beneficial ownership by individuals: [Amend] • Edgar (US Regulatory) • 02/13/2024 09:58:48 PM
Branded Legacy, Inc. Unveils Collaboration with Celebrity Tattoo Artist Kat Tat for New Tattoo Aftercare Product • BLEG • May 22, 2024 8:30 AM
"Defo's Morning Briefing" Set to Debut for "GreenliteTV" • GRNL • May 21, 2024 2:28 PM
North Bay Resources Announces 50/50 JV at Fran Gold Project, British Columbia; Initiates NI 43-101 Resources Estimate and Bulk Sample • NBRI • May 21, 2024 9:07 AM
Greenlite Ventures Inks Deal to Acquire No Limit Technology • GRNL • May 17, 2024 3:00 PM
Music Licensing, Inc. (OTC: SONG) Subsidiary Pro Music Rights Secures Final Judgment of $114,081.30 USD, Demonstrating Strength of Licensing Agreements • SONGD • May 17, 2024 11:00 AM
VPR Brands (VPRB) Reports First Quarter 2024 Financial Results • VPRB • May 17, 2024 8:04 AM