Streamline Your Analysis with the x_day_high Function

The x_day_high function in MarketXLS is designed to help you quickly find the highest share price (day high) of a chosen symbol within a specified number of days. Whether you’re tracking a stock, ETF, Indian equity, or even certain mutual funds, this function simplifies your daily analysis by fetching data directly into your Excel worksheets. You can easily compare performance, spot trends, and make timely decisions—all without leaving Excel.

Why Use This Function?

• Quickly locate the highest trading price of a symbol within a specified daily range.
• Ideal for trend analysis, especially if you want to confirm recent breakout highs or analyze resistance levels.
• Useful for various asset types (e.g., US Equities, Indian Equities, Mutual Funds, Crypto), giving you flexibility across markets.
• Minimizes manual research by automatically pulling historical high values, saving you both time and effort.
• Simplifies building more advanced trading models or portfolio trackers in Excel, since the function integrates seamlessly with other formulas and data.

How to Use in Excel

=x_day_high(Symbol, days)

1. Enter the function into any cell in Excel.
2. Replace Symbol with the ticker symbol of the asset you want to analyze (e.g., "AAPL" for Apple).
3. Replace days with the number of days to look back from the current date (e.g., 30).
4. Press Enter to return the highest day high over that specific interval.

Note:
• Make sure you have an active MarketXLS license. Otherwise, you may see an “NA” result.
• If an invalid symbol or an unexpected days parameter is used, you may also get “NA.”
• Larger values for days will look further back in price history.

Parameters Explained

Example Usage

Basic Examples

1. Find the highest price of Apple in the last 30 days:
   =x_day_high("AAPL", 30)
   This returns the maximum daily high for Apple within the past 30 calendar days.

2. Check a tech stock over the last week:
   =x_day_high("MSFT", 7)
   Returns the highest MSFT day-high over the last 7 days.

3. Indian Equity Example:
   =x_day_high("TCS.IN", 10)
   Retrieves the maximum day-high for TCS over the last 10 days in the Indian market.

Advanced Scenarios

• Combine with Other Excel Functions:
=IF(x_day_high("AMZN", 14) > 130, "Above Threshold", "Below Threshold")
This example checks if Amazon’s 14-day high has surpassed $130, enabling you to automate alerts or triggers.

• Portfolio-Based Decision Tool:
=x_day_high(A2, B2)
Where A2 has a ticker symbol and B2 has a numeric lookback value. This setup is excellent for quickly scanning multiple symbols and customized timeframes.

• Comparative Analysis Across Multiple Stocks:
In a table of symbols, use x_day_high in parallel columns to see each stock's peak prices over a uniform or varied number of days. This is especially handy if you want to compare performance or detect potential breakout points across an entire watchlist.

Common Questions and Troubleshooting

• Why am I getting “NA” for a valid ticker?
  ? You might be using a ticker that isn’t supported or your license might be invalid. Double-check the symbol spelling and confirm your subscription is active.

• My function is showing “Refreshing.” What does that mean?
  ? MarketXLS occasionally updates or refreshes data in the background. Once the data is ready, the function value should update automatically.

• Does this work for mutual funds or crypto?
  ? Yes, if your data subscription includes mutual funds or crypto. The function attempts to detect and return data based on the symbol type. If no data is found, you may see “NA.”

• Can I use negative or zero days as input?
  ? A negative or zero value for days can lead to an invalid query and return “NA.” To avoid errors, always use a positive integer.

With x_day_high, you can seamlessly fetch the highest price of your chosen ticker over the past “x” days. Save time, improve your analysis, and make data-driven decisions more confidently—all within Excel using MarketXLS. By leveraging its simple syntax and flexible parameters, you’ll be better equipped to track market behavior for stocks, funds, and more.