RTI_LowestPrice_in_X_Mins: Retrieve the Lowest Price in the Last X Minutes

The RTI_LowestPrice_in_X_Mins function enables you to quickly and accurately obtain a stock’s lowest trading price for the last X minutes in real time, directly within Excel. By leveraging MarketXLS and a connected data seller (like Zerodha or AngelOne), you can stay up-to-the-minute on stock movements without leaving your spreadsheet.

Why Use This Function?

• Ideal for intraday traders who need the lowest price in a user-defined number of minutes.
• Helps you react to market movement quickly during volatile trading sessions.
• Useful for setting alerts, analyzing short-term price fluctuations, and refining entry/exit strategies.
• Streamlines your workflow by providing rapid, real-time lowest price data within Excel—no manual checks required.

How to Use in Excel

=RTI_LowestPrice_in_X_Mins("SYMBOL", minutesAgo)

• "SYMBOL" is the stock ticker symbol (e.g., "AAPL").
• minutesAgo is the integer specifying how many minutes back from the current moment to examine for the lowest price.

After you enter this formula in a cell, MarketXLS retrieves real-time data (from configured data sellers) and displays the lowest price that occurred within that minute-based window.

Parameters Explained

Example Usage

Basic Examples

1. Return the lowest price for Apple in the last 5 minutes:
   =RTI_LowestPrice_in_X_Mins("AAPL", 5)
   • Examines real-time data from the previous 5 minutes.

2. Check the current lowest price for Microsoft in the last 15 minutes:
   =RTI_LowestPrice_in_X_Mins("MSFT", 15)
   • Provides a quick snapshot of MSFT’s price movement within a 15-minute window.

Advanced Scenarios

1. Combine with Other Functions
   • Use RTI_LowestPrice_in_X_Mins alongside other MarketXLS RTI functions (like RTI_HighestPrice_in_X_Mins) to form a quick high-low pair analysis:
   =RTI_HighestPrice_in_X_Mins("TSLA", 10) - RTI_LowestPrice_in_X_Mins("TSLA", 10)
   This quickly calculates Tesla’s trading range over the last 10 minutes.

2. Trading Strategy Integration
   • If the lowest price in the last 30 minutes is less than a specific threshold, trigger a potential buy signal. Integrate with Excel’s conditional formatting or alerts to be notified automatically.

3. Tracking Multiple Symbols
   • Create a watchlist by placing multiple RTI_LowestPrice_in_X_Mins formulas in a table for various stocks, each with different minutesAgo parameters to match your trading strategy.

Common Questions and Troubleshooting

1. Why am I seeing “No data seller is configured”?
   • Ensure you have at least one active data seller (Zerodha or AngelOne) in MarketXLS settings.

2. Can I use negative or zero for minutesAgo?
   • This will typically return invalid or unexpected results. Always provide a positive integer to ensure valid data.

3. Why do I get “Insufficient parameters”?
   • Verify you entered both arguments correctly. You must specify symbol and minutesAgo.

4. What if the symbol is not recognized?
   • The function may remain blank or show an error. Check that your symbol matches the data seller’s format (e.g., correct ticker spelling).

5. License or RTD Issues?
   • MarketXLS checks your license validity first. If it’s invalid or expired, you may see a related message or “ERR”. Make sure your MarketXLS license is active.

By using RTI_LowestPrice_in_X_Mins in Excel, you gain immediate insights into a stock’s intraday low for a specified time window. Combine it with other real-time analytics from MarketXLS to create robust, data-driven strategies directly in your spreadsheet.