Retrieving the Highest Price with QM_High

The QM_High function (fn_00048) in MarketXLS lets you quickly access the latest "high" price for a given stock symbol, directly within Excel. Whether you’re tracking common stocks or other instruments supported by QuoteMedia, QM_High provides a seamless way to keep your spreadsheets updated with the relevant market data. By integrating daily high prices into your Excel workflow, you can make more data-driven investment decisions with ease.

Why Use This Function?

• Save Time on Data Entry: Automates fetching of the high price for various symbols without manual lookups.
• Real-Time Updates (as configured): Quickly see when data is refreshing or if you need to manually refresh.
• Stock Screening: Filter or highlight stocks reaching new highs in your spreadsheet.
• Easy Integration: Combine with other MarketXLS functions and Excel formulas for deeper analyses.
• Straightforward Handling of Special Cases: The function gracefully handles license issues, invalid symbols, and refreshing states.

How to Use in Excel

Use the function just like any other Excel formula:

=QM_High("MSFT")

• Enter the function in the cell where you want the data to appear.
• Replace "MSFT" with any valid US stock symbol to fetch that company’s high price.
• If the data is still being refreshed, you will temporarily see "Refreshing."
• If the symbol is invalid or the data is unavailable, you will see "NA."

This simple approach returns the "high" price from QuoteMedia based on your MarketXLS data subscription and refresh settings.

Parameters Explained

There is only one parameter: the ticker symbol. Make sure the symbol is spelled correctly and is a valid US stock or ETF that QuoteMedia recognizes.

Example Usage

Basic Examples

1. =QM_High("AAPL")
   • Retrieves the daily high price for Apple Inc.
   • If data is cached and valid, the cell fills immediately; otherwise, you may see "Refreshing" until the data is updated.

2. =QM_High("GOOG")
   • Fetches the high price for Alphabet’s Google shares.
   • If your license or data subscription is invalid, you might see an error message or "LicenseIsNotValidErrorMessage."

3. =QM_High("MSFT")
   • Grabs Microsoft’s high price.
   • If the symbol is not recognized, the function returns "NA."

Advanced Scenarios

• Comparing Multiple Symbols
=QM_High("AAPL") - QM_High("MSFT")
Use a subtraction operation to compare the difference in daily highs between Apple and Microsoft in a separate cell.

• Building Watchlists
Combine QM_High with other MarketXLS functions (e.g., QM_Last, QM_Volume) to create an automatic watchlist of daily metrics for multiple stocks on one sheet.

• Refresh and Analysis
If you see "Please Refresh," simply trigger a data refresh (based on your MarketXLS settings) to populate or update the high value with the latest available data.

Common Questions and Troubleshooting

• "Why am I seeing 'NA' for a known symbol?"
? MarketXLS might not have recognized the exact ticker syntax (e.g., "AAPL " with an extra space). Ensure the symbol is correct and the subscription covers that instrument.

• "The cell just says 'Refreshing' indefinitely."
? This indicates data is currently being fetched. Try a manual refresh if it persists, or check your internet connection and MarketXLS settings.

• "I’m getting a message about license configuration or 'ERR'."
? Verify that your MarketXLS license is active and valid. If an exception occurred, MarketXLS logs can provide more details.

• "How often does QM_High update?"
? Data refresh depends on your MarketXLS refresh intervals and subscription plan. You can trigger manual refreshes as needed.

By using the QM_High function, you have a streamlined way to pull in the daily high price of your chosen symbols, enabling smarter and faster decision-making in Excel. Make sure your MarketXLS setup is properly licensed and configured, and your results will flow in automatically as you track the latest market moves.