Stream Is Annual High Function (fn_00014): Real-Time Tracking of 12-Month Highs

The QM_Stream_IsAnnualHigh function (fn_00014) is designed to tell you, in real time, if a given stock or financial instrument is trading at its highest price level within the past 12 months. Whether you’re monitoring a handful of names or an extensive portfolio, this function ensures your Excel spreadsheet flags any symbol hitting a new annual high. By leveraging MarketXLS’s real-time data feed, traders and analysts gain instant insight without leaving Excel.

Why Use This Function?

• Quickly Identify New Highs: Stay informed the moment a stock or currency pair reaches a 12-month peak.
• Simplified Analysis: No need to trawl through historical price data; the function performs this check automatically.
• Automated Decision-Making: Combine with Excel’s conditional formatting, macros, or alerts to trigger notifications when a symbol hits a fresh annual high.
• Instant Validation: Built-in error-handling (e.g., "NA", license errors, etc.) gives you immediate feedback on invalid inputs or data-feed issues.
• Versatile for Many Markets: Works with recognized symbols (e.g., “AAPL”, “GOOG”, “EURUSD”), making it suitable for equities, ETFs, or currencies.
• Real-Time Updates: As market conditions change, so do the cell values—keeping you in the loop at all times.

How to Use in Excel

=QM_Stream_IsAnnualHigh(symbol)

1. In any cell, type “=QM_Stream_IsAnnualHigh(…)”.
2. Specify a valid ticker symbol as text (e.g., "AAPL").
3. Press Enter.
4. If Apple is at its highest price over the last 12 months when you fetch the data, the formula returns TRUE; if not, FALSE.
5. The function re-checks data with each Excel recalculation or workbook refresh.

• Important: Ensure you have a valid MarketXLS license and properly configured real-time data feed. Invalid licenses or configurations will result in an error message.

Parameters Explained

Example Usage

Basic Examples

1. Direct Symbol Entry
   • In cell A1:
   =QM_Stream_IsAnnualHigh("AAPL")
   • Returns TRUE if Apple is at a fresh annual high, otherwise FALSE.

2. Using a Cell Reference
   • Suppose A2 has "MSFT". In B2:
   =QM_Stream_IsAnnualHigh(A2)
   • This allows quick symbol changes in A2 without editing the formula in B2.

3. Handling Invalid or Blank Symbols
   • If A3 is " " (whitespace) or a misspelled ticker (e.g., “INVALIDSYM”):
   =QM_Stream_IsAnnualHigh(A3)
   • Likely returns "NA" (symbol not recognized) or an error message.

Advanced Scenarios

1. Monitoring Multiple Symbols in a Portfolio
   • In cells A1:A5, list "AAPL", "GOOG", "TSLA", "AMZN", "MSFT".
   • In B1:B5:
   =QM_Stream_IsAnnualHigh(A1)
   =QM_Stream_IsAnnualHigh(A2)
   … and so on.
   • Quickly scan which stocks are hitting new highs. Combine with conditional formatting to highlight TRUE cells in green.

2. Integrated Trading Strategy
   • Use QM_Stream_IsAnnualHigh alongside volume or RSI data in adjacent columns to determine if a breakout aligns with volume trends or overbought/oversold levels.
   • Automate trade signals (via macros) if the cell returns TRUE and volume is above average.

3. Combining with Alert Triggers
   • Build an Excel macro that sends an email whenever QM_Stream_IsAnnualHigh("AAPL") = TRUE.
   • Ideal for traders who need instant notice of key price movements without manually checking.

4. International Markets & Currencies
   • Evaluate "EURUSD" or other currency pairs if supported by your data feed.
   • The function normalizes input strings using ConvertSyntaxString, accommodating various naming conventions.

Common Questions and Troubleshooting

1. “Why am I getting an error instead of TRUE/FALSE?”

   • Check that your MarketXLS license is valid (the function returns a licensing error if it isn’t).
   • Ensure your data subscription is properly configured in MarketXLS settings.

2. “Why do I see 'NA' showing up in my cell?”

   • The function returns "NA" if the symbol validation fails. Make sure the ticker is spelled correctly, and that your data feed supports it.
   • Also confirm you didn’t pass an empty or whitespace-only string.

3. “Could the function show TRUE outside trading hours?”

   • Real-time quotes may not update if markets are closed. Depending on your data feed (delayed or real time), the function might reflect the last known price.

4. “What if I track hundreds of symbols at once?”

   • Large-scale usage can slow Excel recalculations or generate many data requests. Consider organizing symbols across multiple worksheets or limiting usage to key watchlists.

5. “How do I confirm it checks a full 12-month range?”

   • The backend references up to one year of historical data. If data is incomplete, the result might be inaccurate. Always ensure the data source delivers consistent history.

By understanding these considerations, you’ll smoothly integrate QM_Stream_IsAnnualHigh into your Excel workflows. This function’s powerful real-time check for new annual highs empowers traders, investors, and analysts to react faster and make more informed decisions—all within the familiar interface of Excel.