Understanding and Using RTI Functions for Real-Time Stock Data Analytics in Excel

Meet The Ultimate Excel Solution for Investors
- Live Streaming Prices Prices in your Excel
- All historical (intraday) data in your Excel
- Real time option greeks and analytics in your Excel
- Leading data in Excel service for Investment Managers, RIAs, Asset Managers, Financial Analysts, and Individual Investors.
- Easy to use with formulas and pre-made sheets

Understanding and Using RTI Functions for Real-Time Stock Data Analytics in Excel
Real-time Intelligence (RTI) functions in MarketXLS enable you to perform real-time stock data analysis directly within Excel. RTI Functions allow you to query and process real-time data points, perform technical analysis, and calculate indicators such as Open, High, Low, Close (OHLC), volume, etc. This article will cover each RTI_ function, explaining its arguments and functionality and providing example usage.
1. RTI_Stream_Value
Description:
RTI_Stream_Value retrieves a specified field’s value for a given symbol over a defined interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- lookback (Integer, Optional): The number of periods to look back. Default is 50 periods.
- field (String, Optional): The field to query. Default is “Last”.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function fetches the real-time value of the specified field for the given symbol and interval.
Example Usage:
=RTI_Stream_Value("AAPL", 5, 50, "Last", 0)
2. RTI_Open
Description:
RTI_Open calculates the opening price for a given symbol and interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function calculates the opening price as the first price in the specified interval.
Example Usage:
=RTI_Open("AAPL", 5, 0)
3. RTI_High
Description:
RTI_High calculates the highest price for a given symbol and interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function calculates the highest price in the specified interval.
Example Usage:
=RTI_High("AAPL", 5, 0)
4. RTI_Low
Description:
RTI_Low calculates the lowest price for a given symbol and interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function calculates the lowest price in the specified interval.
Example Usage:
=RTI_Low("AAPL", 5, 0)
5. RTI_Close
Description:
RTI_Close calculates the closing price for a given symbol and interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function calculates the closing price as the last price in the specified interval.
Example Usage:
=RTI_Close("AAPL", 5, 0)
6. RTI_Volume
Description:
RTI_Volume calculates the total volume traded for a given symbol and interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function calculates the total volume as the difference between the first and last volume in the specified interval.
Example Usage:
=RTI_Volume("AAPL", 5, 0)
7. RTI_Time
Description:
RTI_Time retrieves the time for a given symbol and interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function fetches the time of the specified data point for the given symbol and interval.
Example Usage:
=RTI_Time("AAPL", 5, 0)
8. RTI_RSI
Description:
RTI_RSI calculates the Relative Strength Index (RSI) for a given symbol and interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- lookback (Integer, Optional): The number of periods to look back. Default is 20 periods.
- field (String, Optional): The field to query. Default is “Last”.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function calculates the RSI of the specified field for the given symbol and interval.
Example Usage:
=RTI_RSI("AAPL", 5, 20, "Last", 0)
9. RTI_SMA
Description:
RTI_SMA calculates the Simple Moving Average (SMA) for a given symbol and interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- lookback (Integer, Optional): The number of periods to look back. Default is 20 periods.
- field (String, Optional): The field to query. Default is “Last”.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function calculates the SMA of the specified field for the given symbol and interval.
Example Usage:
=RTI_SMA("AAPL", 5, 20, "Last", 0)
10. RTI_EMA
Description:
RTI_EMA calculates the Exponential Moving Average (EMA) for a given symbol and interval.
Arguments:
- symbol (String): The stock symbol to query.
- interval (Integer, Optional): The interval in minutes for grouping data points. Default is 5 minutes.
- lookback (Integer, Optional): The number of periods to look back. Default is 20 periods.
- field (String, Optional): The field to query. Default is “Last”.
- index (Integer, Optional): The index of the data point to retrieve. Default is 0.
Functionality:
This function calculates the EMA of the specified field for the given symbol and interval.
Example Usage:
=RTI_EMA("AAPL", 5, 20, "Last", 0)
11. RTI_Price_At_Min
Description:
RTI_Price_At_Min retrieves the price at a specific minute.
Arguments:
- symbol (String): The stock symbol to query.
- time (String): The time in “HH:MM”
Functionality:
This function fetches the price of the specified symbol at the given time.
Example Usage:
=RTI_Price_At_Min("AAPL", "09:30")
12. RTI_Volume_At_Min
Description:
RTI_Volume_At_Min retrieves the volume at a specific minute.
Arguments:
- symbol (String): The stock symbol to query.
- time (String): The time in “HH:MM”
Functionality:
This function fetches the volume of the specified symbol at the given time.
Example Usage:
=RTI_Volume_At_Min("AAPL", "09:30")
13. RTI_Price_Change_From_Min
Description:
RTI_Price_Change_From_Min calculates the price change from a given minute.
Arguments:
- symbol (String): The stock symbol to query.
- time (String): The time in “HH:MM”
Functionality:
This function calculates the change in markdown price of the specified symbol from the given time.
Example Usage:
=RTI_Price_Change_From_Min("AAPL", "09:30")
14. RTI_Price_ChangePct_From_Min
Description:
RTI_Price_ChangePct_From_Min calculates the percentage change in price from a given minute.
Arguments:
- symbol (String): The stock symbol to query.
- time (String): The time in “HH:TT”
Functionality:
This function calculates the percentage change in the price of the specified symbol from the given time.
Example Usage:
=RTI_Price_ChangePct_From_Min("AAPL", "09:30")
15. RTI_Price_X_Min_Ago
Description:
RTI_Price_X_Min_Ago retrieves the price from a specified number of minutes ago.
Arguments:
- symbol (String): The stock symbol to query.
- minutesAgo (Integer): The number of minutes ago to query the price.
Functionality:
This function fetches the price of the specified symbol from the specified number of minutes ago.
Example Usage:
=RTI_Price_X_Min_Ago("AAPL", 10)
16. RTI_PriceChange_X_Min_Ago
Description:
RTI_PriceChange_X_Min_Ago calculates the price change from a specified number of minutes ago.
Arguments:
- symbol (String): The stock symbol to query.
- minutesAgo (Integer): The number of minutes ago to query the price change.
Functionality:
This function calculates the change in the price of the specified symbol from the specified number of minutes ago.
Example Usage:
=RTI_PriceChange_X_Min_Ago("AAPL", 10)
17. RTI_PriceChangePct_X_Min_Ago
Description:
RTI_PriceChangePct_X_Min_Ago calculates the percentage change in price from a specified number of minutes ago.
Arguments:
- symbol (String): The stock symbol to query.
- minutesAgo (Integer): The number of minutes ago to query the percentage price change.
Functionality:
This function calculates the percentage change in the price of the specified symbol from the specified number of minutes ago.
Example Usage:
=RTI_PriceChangePct_X_Min_Ago("AAPL", 10)
18. RTI_HighestPrice_in_X_Mins
Description:
RTI_HighestPrice_in_X_Mins retrieves the highest price in the last specified number of minutes.
Arguments:
- symbol (String): The stock symbol to query.
- minutesAgo (Integer): The number of minutes to look back for the highest price.
Functionality:
This function fetches the highest price of the specified symbol in the last specified number of minutes.
Example Usage:
=RTI_HighestPrice_in_X_Mins("AAPL", 10)
19. RTI_LowestPrice_in_X_Mins
Description:
RTI_LowestPrice_in_X_Mins retrieves the lowest price in the last specified number of minutes.
Arguments:
- symbol (String): The stock symbol to query.
- minutesAgo (Integer): The number of minutes to look back for the lowest price.
Functionality:
This function fetches the lowest price of the specified symbol in the last specified number of minutes.
Example Usage:
=RTI_LowestPrice_in_X_Mins("AAPL", 10)
Conclusion
RTI Functions in MarketXLS provide a powerful toolset for performing real-time stock data analysis directly within Excel. By utilizing RTI Functions, you can easily retrieve and analyze real-time stock data, calculate key technical indicators, and make informed investment decisions. RTI Functions are designed to be user-friendly and integrates seamlessly with Excel, enabling you to leverage real-time data for your stock analysis needs.
I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.