Quantower
Quantower Website
  • Welcome to Quantower Help
  • 🚀Getting Started
    • What's new
    • Installation
    • First start
    • Platform update
    • Quantower Beta
    • Quantower Account
    • Quantower Licenses
    • ⚖️License Comparison
    • Backup & restore manager
    • Reset settings to default
    • Payment FAQ
    • “Coinpayments” payment
    • Binance fresh account
    • Referral Program
    • You have found a bug. What’s next?
  • ⚙️General Settings
    • Quantower Main Toolbar
    • Workspaces
    • Single Panel
    • Link panels
    • Binds
    • Group of panels
    • Templates
    • Set as Default
    • Symbols lookup
    • Table management
    • Alerts
    • General settings
    • Custom hotkeys
    • Setup Actions & Advanced filters
    • 📢Notifications center
  • 🔗Connections
    • Connections manager
    • Connection to Binance Futures
      • Errors with Binance connection
    • Connection to CQG (AMP Futures)
      • Errors with CQG
    • Connection to OANDA
    • Connection to FXCM
    • Connection to cTrader
      • How to connect to FxPro via Quantower
      • How to connect to Pepperstone via Quantower
      • How to connect to IC Markets via Quantower
    • Connection to Rithmic
      • Rithmic Issues
    • Connection to Topstep
    • Connection to Interactive Brokers
      • Errors with Interactive Brokers
    • Connection to Bybit
    • Connection to OKEx
    • Connection to MetaStock
    • Connection to IQFeed
  • 💡Analytics Panels
    • Chart
      • Chart Overview
      • Chart Types
        • Tick Bars
        • Time aggregation
        • Renko
        • Heiken Ashi
        • Kagi
        • Points & Figures
        • Range bars
        • Line break
        • Volume Bars
        • Reversal Bars
      • Chart Settings
        • View settings
        • Data Style
        • Time Scale
        • Price Scale
        • Visual Trading
          • Positions
        • Order Entry
        • Quick Ruler
        • Info Window
        • Volume Bars
        • Hotkeys
      • Chart overlays
      • Technical indicators
        • Channels
          • Range Marker
          • Donchian Channel
          • High Low Indicator
          • Round Numbers
          • Highest High
          • Lowest Low
          • Bollinger Bands
          • Bollinger Bands Flat
          • Price Channel
          • Fair Value Gap (FVG)
          • Keltner Channel
          • Moving Average Envelope
        • Moving averages
          • Demand Index
          • Exponential Moving Average
          • FYL Indicator
          • Linearly Weighted Moving Average
          • McGinley Dynamic Indicator
          • Modified Moving Average Indicator
          • Pivot Point Moving Average Indicator
          • Regression Line Indicator
          • Simple Moving Average Indicator
          • Smoothed Moving Average Indicator
          • Guppy Multiple Moving Average Indicator
          • Trend Breakout System Indicator
          • Triple Exponential Moving Average Indicator
        • Oscillators
          • Delta Divergence Reversal
          • Aroon Indicator
          • Moving Average Convergence/Divergence
          • Awesome Oscillator
          • Accelerator Oscillator
          • %R Larry Williams
          • Momentum
          • Rate of Change
          • Relative Strength Index (RSI) Indicator
          • Relative Spread Strength (RSS)
          • Balance of Power (BOP)
          • Commodity Channel Index
        • Trend
          • Bionic Candle
          • Average Directional Movement Index (ADX) Indicator
          • Ichimoku Cloud Indicator
          • Directional Movement Index (DMI) Indicator
          • ZigZag
        • Volatility
          • Average True Range
          • Standard deviation
        • Volume
          • COT High/Low
          • Depth of Bid / Ask
          • Delta Flow
          • Delta Rotation
          • Level2 indicator
          • Abnormal Volume
          • Abnormal Trades
          • Volume Impulse
      • Drawing tools
      • Volume Analysis Tools | Volume Profiles | Footprint chart | VWAP
        • Cluster chart
        • Volume profiles
        • Time statistics
        • Time histogram
        • Historical Time & Sales
      • Power Trades
      • VWAP | Volume Weighted Average Price
      • Anchored VWAP
    • Watchlist
    • Time & Sales
    • Price Statistic
    • DOM Surface
    • Option Analytics
    • TPO Profile Chart
  • 💵Trading Panels
    • Chart Trading
    • Crypto Order Entry
    • Multiple Order Entry
    • Order Entry
      • Order entry for Bybit
      • Order Entry for CQG
      • Order Types
      • Order placing strategies
        • Local SL/TP
    • DOM Trader
      • DOM Trader Settings
        • View Settings
        • DOM Trader Columns
        • Order Entry
        • VWAP Settings
        • Positions Bar
        • Hotkeys
      • DOM Trader Columns
      • How to set up Dom for scalping
    • Copy Trading
    • Market depth
    • Trading simulator
    • Market Replay
    • FX Cell
    • Backtest & Optimize
    • Strategies manager
  • 💼Portfolio Panels
    • Positions
    • Working Orders
    • Trades
    • Orders History
    • Synthetic Symbols
    • Historical Symbols
  • 📊Information Panels
    • Account performance
    • Account info
    • Crypto balances
    • Symbol Info
    • Currencies Exposure
    • Event Log
    • RSS (News panel)
    • Reports
  • 📌Miscellaneous
    • Futures Rollover
    • History Exporter
    • Symbol Mapping Manager
    • Sessions manager
    • Live Support
    • Market Heat map
    • Stat matrix
    • Exchange times
    • Quote Board
    • Browser
    • Excel and RTD function
      • Changing RTD Throttle Interval in Excel
    • Quantower Telegram Bot
    • 🎨Themes editor
  • 🤖Quantower Algo
    • Introduction
    • Install for Visual Studio 2022
    • Strategies manager
    • Backtest & Optimize
    • Debugging in VS 2022
    • Simple Indicator
    • Simple strategy
    • Input Parameters
    • Built-In indicators access
    • Custom indicators access
    • Level2 data
    • Access Volume analysis data from indicators
    • Indicator with custom painting (GDI)
    • Access Chart from indicator
    • Using markers with indicators
    • Using Clouds in Indicator
    • Adding a custom indicator to Watchlist
    • Downloading history
    • Access to trading portfolio
    • Trading operations
    • Example: Simple Moving Average
    • Access to crypto account and balances
    • Access to advanced aggregations
    • Access to symbol/account additional fields
    • Strategy runner (deprecated)
  • 💫Customization
    • Localization
  • ⁉️FAQ
    • General Errors
Powered by GitBook
On this page
  • How to activate the RTD function in Quantower platform
  • How to get the instrument data from Quantower?
  • 1. Getting data through copying a formula
  • 2. Getting data through writing a formula
  • Examples of the most popular RTD formulas with description
  • 1.GetSymbolInfo - information about a specific symbol
  • 2. GetAccounInfo - information about a particular account
  • 3. GetMarketData - Bid, Ask, Last, Open, High
  • 4. GetLevel2Data - Level2
  • 5. GetHistory - history for the specified symbol
  • Frequently Asked Questions
  • How to check argument separator?
  1. Miscellaneous

Excel and RTD function

How to export Real-Time data to Excel

Last updated 1 year ago

Starting from version 1.39 Quantower supports Real-Time Data (RTD) for sending data and other market information to Microsoft Excel®. This feature opens up many opportunities for creating custom displays and other ways to manage your workflow better.

RTD is a newer protocol that offers several advantages over DDE, including more flexibility and better performance and reliability.

We prepared the spreadsheet that outlines the basic syntax of RTD formulas with details of more complex formulas. A collection of popular RTD formulas is included, which you can copy and paste into your spreadsheet. .

Here is the General Syntax for getting symbol info via RTD function:


How to activate the RTD function in Quantower platform

For the function to work properly, Quantower platform and Excel must have the same version — 64-bit or 32-bit

  1. Launch Excel and open the Task Manager to check the version of Excel (32-bit or 64-bit). The platform should have the same version to work with the RTD function correctly.

Also in the settings, there are two important settings:

  • Custom RTD formula name — depending on the language of your operating system, the name of the RTD function in Excel may be called differently. The original name of the function in the English version of Excel is RTD, but for the Russian version it's called "ДРВ".

Important! The archive must be extracted to any convenient location on your PC and should not be deleted. All current and future updates of Quantower will use these files.

  1. After unpacking the archive, run 'register.cmd' as an administrator. It's important to ensure that Excel is closed during this process!

  1. Once you've completed the previous steps, you can launch Excel and begin using the RTD function with Quantower.


How to get the instrument data from Quantower?

1. Getting data through copying a formula

The easiest way to get data to Excel is to copy the necessary data through the panel context menu. For example, after activating RTD, an additional item in the context menu will appear in the Watchlist panel — Copy RTD Formula.

  • Select a necessary symbol or multiple symbols, right-click and select Copy RTD Formula. You can copy formulas for specific columns or for all columns.

  • Go to Excel and paste the copied formulas. Now the data will be updated automatically.

2. Getting data through writing a formula

When retrieving instrument data using RTD, you need to specify the ID of the instrument and the properties you want to retrieve.

RTD formula uses the following basic structure:

=RTD("TradingPlatform";"";"Param1";"Param2";"Param3";....")

The second parameter is the name of the external server running the RTD Server. As the Quantower RTD Server always runs locally, you must omit a value for the second parameter or supply an empty string (“”). However, you must account for the parameter in the formula.

Examples of the most popular RTD formulas with description

Examples of the most popular RTD formulas are described below with description of the basic syntax by the example of Binance exchange. Using them, you can get exactly the data you need for analysis and paste into your spreadsheet. You can also download these examples from this Excel file.

1.GetSymbolInfo - information about a specific symbol

Provides access to specific symbol information such as Description, ExchangeName, NettingType and others. You can simply copy/paste this formula for use in Excel files or get it directly from the Symbol Information panel for the selected symbol. Right-click on the panel and select the menu option: "Copy RTD Formula" -> "Value".

=ДРВ("tradingplatform";"";"GetSymbolInfo";"1INCHBTC";"Name";"Binance Spot")

=ДРВ("tradingplatform";"";"GetSymbolInfo";"1000LUNCBUSD";"Name";"Binance USDT-M Futures")

=ДРВ("tradingplatform";"";"GetSymbolInfo";"1INCHUSDT_SPOT";"Name";"Bybit")

=ДРВ("TradingPlatform";"";"GetSymbolInfo";"10000NFTUSDT_SWAP";"Name";"Bybit")

=ДРВ("TradingPlatform";"";"GetSymbolInfo";"BTCUSDT";"SymbolType";"Binance Spot")

Options

Options

Description

"TradingPlatform"

Quantower RTD server name. You can use it in all formulas.

"GetSymbolInfo"

Name of method

"BTCUSDT"

The ID of the symbol for which you want to get data. You can get it from the SymbolInfo panel.

"SymbolType"

Specifies the type of data you want to receive. For example: Name, Description.

"Binance USDT-M Futures"

The name of the connection you want to use to search for the desired character. You can leave this parameter blank if you only have one connection.

2. GetAccounInfo - information about a particular account

Provides access to specific account information such as name, balance, NettingType, and others. You can simply copy/paste this formula for use in Excel files or get it directly from the Account Information panel for the selected account. Right-click on the pane and select the menu option: "Copy RTD Formula" -> "Value".

=ДРВ("tradingplatform";"";"GetAccountInfo";"binance";"Balance";"Binance USDT-M Futures")

=ДРВ("tradingplatform";"";"GetAccountInfo";"binance";"DOTavailableBalance";"Binance USDT-M Futures")

=ДРВ("tradingplatform";"";"GetAccountInfo";"binance";"hedgeMode";"Binance USDT-M Futures")

=ДРВ("tradingplatform";"";"GetAccountInfo";"3111865";"Balance";"Bybit")

=ДРВ("tradingplatform";"";"GetAccountInfo";"3111865";"openPositions";"Bybit")

=ДРВ("tradingplatform";"";"GetAccountInfo";"3111865";"Id";"Bybit")

3. GetMarketData - Bid, Ask, Last, Open, High

=ДРВ("tradingplatform";"";"GetMarketData";"1INCHUSDT_SPOT";"Last";"Bybit")

=ДРВ("tradingplatform";"";"GetMarketData";"10000NFTUSDT_SWAP";"Last";"Bybit")

=ДРВ("tradingplatform";"";"GetMarketData";"BTCUSDT";"Last";"Binance Spot")

=ДРВ("tradingplatform";"";"GetMarketData";"1000LUNCBUSD";"Last";"Binance USDT-M Futures")

=ДРВ("tradingplatform";"";"GetMarketData";"1INCHUSDT_SPOT";"ChangePercentage";"Bybit")

=ДРВ("tradingplatform";"";"GetMarketData";"10000NFTUSDT_SWAP";"ChangePercentage";"Bybit")

=ДРВ("tradingplatform";"";"GetMarketData";"1INCHBUSD";"ChangePercentage";"Binance Spot")

=ДРВ("tradingplatform";"";"GetMarketData";"1000LUNCBUSD";"ChangePercentage";"Binance USDT-M Futures")

Options

Description

"TradingPlatform"

Quantower RTD server name. You can use it in all formulas.

"GetMarketData"

Name of method

"BTCUSDT"

The ID of the symbol for which you want to get data. You can get it from the SymbolInfo panel.

"Bid"

Specifies the type of data you want to receive. For example: Bid, Ask, Last, Open, High

"Binance USDT-M Futures"

The name of the connection you want to use to search for the desired character. You can leave this parameter blank if you only have one connection.

4. GetLevel2Data - Level2

Provides access to Tier 2 data for a specific symbol. You can simply copy/paste this formula and use it in your Excel files.

 =ДРВ("tradingplatform";"";"GetLevel2Data";"BTCUSDT";"BidSize";"0";"Binance Spot")

=ДРВ("tradingplatform";"";"GetLevel2Data";"BTCUSDT";"BidSize";"0";"Binance USDT-M Futures")

=ДРВ("tradingplatform";"";"GetLevel2Data";"BTCUSDT_SPOT";"BidSize";"0";"Bybit")

=ДРВ("tradingplatform";"";"GetLevel2Data";"10000NFTUSDT_SWAP";"BidSize";"0";"Bybit")

Options

Options

Description

"TradingPlatform"

Quantower RTD server name. You can use it in all formulas.

"GetLevel2Data"

Name of method

"BTCUSDT"

The ID of the symbol for which you want to get data. You can get it from the SymbolInfo panel.

"BidSize"

Указанный тип данных, которые вы хотите получать. Например: Bid, Ask, BidSize, AskSize.

"0"

The sequence number of the level in the Depth of Market. Starts with 0.

"Binance USDT-M Futures"

The name of the connection you want to use to search for the desired character. You can leave this parameter blank if you only have one connection.

5. GetHistory - history for the specified symbol

Returns the history for the specified character, aggregation and date range. You can simply copy/paste this formula and use it in your Excel files.

=ДРВ("tradingplatform";"";"GetHistory";"BTCUSDT";"1Day";"Low";"10Day";"0";"Last";"Binance Spot")

=ДРВ("tradingplatform";"";"GetHistory";"BNBUSDT";"1Minute";"Close";"30Minute";"0";"Last";"Binance USDT-M Futures")

=ДРВ("tradingplatform";"";"GetHistory";"BTCUSDT";"5Minute";"Open";"300Minute";"0";"Last";"Binance USDT-M Futures")

=ДРВ("tradingplatform";"";"GetHistory";"ADAUSDT";"1Hour";"Low";"24Hour";"0";"Last";"Binance Spot")

=ДРВ("tradingplatform";"";"GetHistory";"BTCUSDT_SPOT";"1Hour";"Low";"24Hour";"0";"Last";"Bybit")

=ДРВ("tradingplatform";"";"GetHistory";"10000NFTUSDT_SWAP";"1Hour";"Low";"24Hour";"0";"Last";"Bybit")

Options

Options

Описание

"TradingPlatform"

Quantower RTD server name. You can use it in all formulas.

"GetHistory"

Name of method

"BTCUSDT"

The ID of the symbol for which you want to get data. You can get it from the SymbolInfo panel.

"1Day"

Aggregation type: 1 day, 3 days, 5 minutes, etc. Available aggregates:Tick, Second, Minute, Hour, Day, Week, Month, Year.

"Close"

Specifies the type of data you want to receive. For example: Open, High, Low, Close, Volume, Bid, Ask.

"10Day"

Required history range: 10 days, 300 minutes, etc. Available ranges: Minute, Hour, Day, Month, Year.

"0"

The index of the bar / tick in the returned history array. 0 means the newest bar.

"Last"

Bid, Ask, Last history type. Leave the field empty to get the default history for the specified character.

"Binance USDT-M Futures"

The name of the connection you want to use to search for the desired character. You can leave this parameter blank if you only have one connection.


Frequently Asked Questions

How to check argument separator?

For Windows 10:

  • go to Start >type Control Panel and press enter > Region

  • click Additional Settings

  • for List Separator check the argument. It must be the same as in RTD settings.

Go to the of the platform, then to the Excel RTD section, and tick off "Enable Microsoft Excel RTD"

Custom argument separator — the separator that participates in the formula. It depends on the localization of your operating system. Get to know .

For the RTD function to work correctly, you need to download and extract the 'tradingplatform.rtdserver.zip' archive as an administrator. You can find the file at .

You may notice that the data is updated with some delay. This is a throttling interval that is set by default in Excel (2000 milliseconds). If you want to .

📌
General Settings
https://updates.quantower.com/misc/RTD/tradingplatform.rtdserver.zip
increase the speed of updating data, read the instructions on how to do it
how to check argument separator in your system
Download the sample file
Activation of RTD function in Quantower
Run the "register.cmd' file as an administrator
Boadcasting real-time data to Excel