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
- 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
- American Airlines Group announces webcast of fourth-quarter and full-year 2023 financial results • GlobeNewswire Inc. • 01/11/2024 03:00:00 PM
- Wall Street Highlights: Tesla’s Competition with BYD, JPMorgan Stocks Achieve New Records, and More • IH Market News • 01/03/2024 10:41:49 AM
- Boeing 737 MAX Planes Inspected For Loose Bolts, FAA Says -- 2nd Update • Dow Jones News • 12/28/2023 06:00:00 PM
- Boeing 737 MAX Planes Inspected For Loose Bolts, FAA Says -- Update • Dow Jones News • 12/28/2023 05:11:00 PM
FEATURED POET and MultiLane Collaborate to Develop High-Speed Pluggable Transceivers for AI Networks • Mar 27, 2024 10:52 AM
Endexx Corporation (EDXC) Leverages Global Market Trends and Legislative Reforms to Spearhead Growth in the Cannabis and Plant-Based Wellness Sectors • EDXC • Mar 27, 2024 3:01 PM
Applied UV, Inc. Announces Pricing of $2.76 Million Registered Direct and Private Placement Priced at the Market Under Nasdaq Rules • AUVI • Mar 27, 2024 2:51 PM
Maybacks Global Entertainment Opens 23 More Stations in Important Major Cities • AHRO • Mar 27, 2024 9:00 AM
NxGen Brands Inc. Forecast to Deliver 140% Growth in Q1 2024 • NXGB • Mar 27, 2024 7:30 AM
Kona Gold Beverages, Inc. Strategic Advancements: Covert LLC Introduces Federally Legal D9 Gummies and Revamps Innovative eCommerce Platform, Propelling Toward $12 Million Annual Revenue Goal • KGKG • Mar 26, 2024 8:30 AM