Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

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

Written by  Shubham Shah on 
Tue May 28 2024
 about MarketXLS
Understanding and Using RTI Functions for Real-Time Stock Data Analytics in Excel - MarketXLS

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 - MarketXLS

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.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement "your own" investment strategies in Excel with thousands of MarketXLS functions and templates.
MarketXLS provides all the tools I need for in-depth stock analysis. It's user-friendly and constantly improving. A must-have for serious investors.

John D.

Financial Analyst

I have been using MarketXLS for the last 6+ years and they really enhanced the product every year and now in the journey of bringing in AI...

Kirubakaran K.

Investment Professional

MarketXLS is a powerful tool for financial modeling. It integrates seamlessly with Excel and provides real-time data.

David L.

Financial Analyst

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel.

Lloyd L.

Professional Trader

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord