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

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.

Verelq News |
19.06.2024

alexistogel

alexistogel

alexistogel

link alexistogel

alexistogel rtp

link alexistogel

situs alexistogel

alexistogel

alexistogel gacor

alexistogel rtp

alexistogel macau

alexistogel

link alternatif alexistogel

alexistogel

bandar alexistogel

situs alexistogel

bandar alexistogel

alexistogel terpercaya

alexistogel gacor

alexistogel terpercaya

alexistogel

alexistogel

alexistogel

situs alexistogel

alexistogel toto

alexistogel

alexistogel togel slot

slot gacor alexistogel

alexistogel gampang menang

alexistogel online

alexistogel

alexistogel 4d

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

agen togel online

alexistogel 4d

alexistogel slot

alexistogel

alexistogel terpercaya

alexistogel

alexistogel

Slot Dana

Situs Toto Macau

bandar toto macau

Slot Gacor

شرط بندی پرسپولیس شرط بندی استقلال شرط بندی روی تراکتورسازی تبریز شرط بندی روی سپاهان شرط بندی رئال مادرید بارسلونا شرط بندی شرط بندی psg سایت شرط بندی جام جهانی شرط بندی جام جهانی 2026 سایت شرط بندی جام جهانی 2026 بازی انفجار رایگان سایت انفجار ضریب بالا بهترین سایت شرط بندی فارسی شرط بندی بدون فیلتر شرط بندی بازی رولت شرط بندی پوکر شرط بندی مونتی شرط بندی سنگ کاغذ قیچی شرط بندی بلک جک کرش رویال بت پاسور شرط شرط بندی تخته نرد آنلاین انفجار 2 بت شرط بندی بازی اسلات شرط بندی بازی پوپ سایت سامان بت ریور پوکر 2024 سایت 4030bet ورود به بازی انفجار دنس بت شرط بندی انفجار دنس آموزش بازی پوکر سایت شرط بندی 123 بهترین شرط بندی بهترین سایت شرط بندی انفجار اپلیکیشن بازی انفجار دانلود بازی انفجار انفجار بازی ربات بازی انفجار کازینو آنلاین ایرانی انفجار پولساز ورود به بازی انفجار بازی انفجار با شارژ 10 تومن سایت bet betyek وان ایکس برو آدرس سایت بت یک سایت دوست دختر اونلی فنز فارسی پیدا کردن دوست دختر ورود به ریور پوکر پدرام مختاری پویان مختاری نازنین همدانی مونتیگو داوود هزینه بیوگرافی آیسان اسلامی بیوگرافی دنیا جهانبخت سایت رسمی حسین تهی بیوگرافی کوروش وانتونز سایت آرتا وانتونز رها وانتونز بیوگرافی ربکا قادری سحر قریشی بیوگرافی تتلو بیوگرافی مهدی طارمی الناز شاکردوست سایت عادل فردوسی پور بیوگرافی نیلی افشار بیوگرافی محمدرضا گلزار سایت armin2afm بیوگرافی شادمهر عقیلی بیوگرافی سردارآزمون بیوگرافی علیرضا بیرانوند بیوگرافی رامین رضاییان وریا غفوری بیوگرافی علی دایی بیوگرافی پوریا پوتک مدگل سایت حصین بیوگرافی صدف طاهریان فرشاد سایلنت بیوگرافی آریا کئوکسر بیوگرافی sogang بیوگرافی میا پلیز بیوگرافی مهراد هیدن سایت رسمی سهراب ام جی بیوگرافی علیرضا جی جی بیوگرافی بهزاد لیتو اشکان فدایی بیوگرافی رضا پیشرو بیوگرافی گلشیفته بیوگرافی هیپ هاپولوژیست بیوگرافی سارن بیوگرافی آدام مرادی بیوگرافی محمد هلاکویی بیوگرافی علی حسنی سایت رسمی علی حسنی بیوگرافی ساسی خواننده بیوگرافی ابی باربد معصومی حسینی فایننس بیوگرافی امیرحسین نام آور بیوگرافی امین فردین بیوگرافی فرزاد وجیهی سایت سیب بت سایت jetbet آدرس جدید بت فوروارد وان ایکس بت سایت abt90 بازی انفجار سایت شرط بندی فاز بت بهترین سایت شرط بندی انفجار ورود به آلپاری آلپاری فارکس آدرس بروکر آلپاری بدون فیلتر ثبت نام در بروکر آلپاری فارسی صرافی کوکوین ربات فارکس بهترین سایت تتر

alexistogel toto online

bandar alexistogel

alexistogel bandar gacor

alexistogel link

alexistogel online

alexistogel bandar togel

link alternatif alexistogel

alexistogel

alexistogel

alexistogel

alexistogel daftar

alexistogel toto macau

alexistogel bandar macau

alexistogel slot

alexistogel agen slot

situs alexistogel

alexistogel

alexistogel

alexistogel

alexistogel

alexistogel bandar slot

alexistogel

Alexistogel Toto Macau

bandar alexistogel

slot alexistogel

alexistogel bandar togel

alexistogel

alexistogel slot

alexistogel

daftar alexistogel

alexistogel online

rtp alexistogel

alexistogel slot

alexistogel gacor

link alternatif alexistogel

alexistogel login

alexistogel

alexistogel slot dana

agen togel online

bandar togel online

alexistogel rtp

alexistogel slot

alexistogel daftar

slot online dana

situs slot online

alexistogel

bandar togel online

slot online terpercaya

togel slot online

agen slot online gacor

rtp live slot online

bandar slot online

bandar slot online gacor

agen slot online

daftar bandar togel slot

bandar togel online

togel slot hari ini

link alternatif togel slot

rtp slot online gacor

slot online gacor

alexistogel terpercaya

rtp slot gacor

tips slot maxwin

togel slot gacor

prediksi togel

game slot gacor

trik slot online

prediksi togel jitu

daftar togel slot online

slot online gacor

trik slot bonus

prediksi togel

RTP LIVE

Bandar Toto Macau

Situs Slot Gacor

bandarbola855 resmi

bandarbola855 gacor

bandarbola855 slot

link bandarbola855

bandarbola855 rtp

bandarbola855 link

bandarbola855 bandar

bandarbola855

bandarbola855 slot

bandarbola855 terpercaya

bandarbola855 slot

bandarbola855 daftar

bandarbola855 link

bandarbola855

bandarbola855

bandarbola855

iosbet

iosbet

link iosbet

slot online iosbet

iosbet link login

slot iosbet

iosbet gacor

iosbet

slot iosbet

agen iosbet

bandar iosbet

iosbet

iosbet link

iosbet

iosbet

iosbet

iosbet

liatogel

login liatogel

liatogel totomacau

Slot Gacor

alexistogel alexistogel