Tuesday, October 08, 2019 5:40:37 PM
I just got back from a trip I made to town.
I realize column's R through U have no dates. The dates belong in column number 5, which is E. Why column E? Because it is the leftmost column of all other historical columnized data. Being a reference for all date-related inputs and calculations, the date column should be to the left of all other columns which reference those dates as that makes their formulas easier to understand (as all Offset calculations are at least in the same direction, and there are a lot of Offset equations you will write).
I believe that within a recent post I suggested that you import dates to the SR_CP sheet (column E) from a data sheet that you plan on always having. And I recall suggesting that data should be from $SPX (which Yahoo calls ^GSPC). That symbol tracks the whole market, not just a few sectors within the market.
In fact, you should also download data from any sector ETF which reflects a stock you may be trading; for instance, download data for ^SOX (or SMH) if you are trading any stock within the semiconductor sector. You should always want to know how your chosen stock is doing within its sector and also how it is doing relative to the whole market.
Those two suggestions above are important.
Considering the above suggestions, you should always have three symbols to track: Stock, that stock's Sector, and the Whole Market.
So, as I already suggested, use $SPX to track the whole market, and use that as your source for dates. Read those dates into Column# 5 (which is column "E") of the SR_CP sheet.
You wrote, "=sum(AAL!A29)".
Sorry to say this, but you have a lot to learn. But given the desire, learning is easy.
Try this out instead: "=(AAL!A29)". Your formula is summing something with nothing.
Don't worry about what others may think when you ask a question. Leave the worrying to those who refuse to ask.
Recent AAL News
- 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
- Form SC 13G/A - Statement of acquisition of beneficial ownership by individuals: [Amend] • Edgar (US Regulatory) • 02/12/2024 09:45:40 PM
- American Airlines Group to webcast Investor Day presentation • GlobeNewswire Inc. • 02/01/2024 05:00:00 PM
- American Airlines reports fourth-quarter and full-year 2023 financial results • GlobeNewswire Inc. • 01/25/2024 12:00:00 PM
- Wall Street Highlights: Nokia’s Margins Surprise, FAA Halts Boeing Production Expansion, and More • IH Market News • 01/25/2024 11:25:22 AM
Bantec Reports an Over 50 Percent Increase in Sales and Profits in Q1 2024 from Q1 2023 • BANT • Apr 25, 2024 10:00 AM
Cannabix's Breath Logix Alcohol Device Delivers Positive Impact to Private Monitoring Agency in Montana, USA • BLO • Apr 25, 2024 8:52 AM
Kona Gold Beverages, Inc. Announces Name Change to NuVibe, Inc. and Initiation of Ticker Symbol Application Process • KGKG • Apr 25, 2024 8:30 AM
Axis Technologies Group and Carbonis Forge Ahead with New Digital Carbon Credit Technology • AXTG • Apr 24, 2024 3:00 AM
North Bay Resources Announces Successful Equipment Test at Bishop Gold Mill, Inyo County, California • NBRI • Apr 23, 2024 9:41 AM
Epazz, Inc.: CryObo, Inc. solar Bitcoin operations will issue tokens • EPAZ • Apr 23, 2024 9:20 AM