Excel and RTD function
How to export Real-Time data to Exel
Start 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 better manage your workflow.
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 more complex formulas. Included is a collection of popular RTD formulas, which you can simply copy and paste into your own spreadsheet. Download the sample file.
Here is the General Syntax for getting symbol info via RTD function:
For the function to work properly, Quantower platform and Excel must have the same version — 64 or 32 bit
Launch Excel and after open the Task Manager to check the version of Excel (32-bit or 64-bit). The platform should have the same version in order to work with RTD function correctly.
Go to the General Settings of the platform, then to section Excel RTD and tick off "Enable Microsoft Excel RTD"
Activation of RTD function in Quantower
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 "ДРВ".
- Custom argument separator — the separator that participates in the formula. It depends on the localization of your operating system. Get to know how to check argument separator in your system.
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.
Boadcasting real-time data to Excel
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 increase the speed of updating data, read the instructions on how to do it.
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 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.
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 | 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. |
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")
=ДРВ("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. |
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. |
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. |
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.
Last modified 3mo ago