account →

RealTimeData (RTD) server to Microsoft Excel

To install a RTD Server to provide ZTrade data to excel follow these steps:


1. Download the file: ZTradeRTDv5.zip


. Open the zip file and copy the folder to C:\Program Files\Common Files\


3. Open the folder C:\Program Files\Common Files\ZTrade, right click on the file ZTradeRTDRegister.cmd and select Run as Administrator.


4. From ZTrade Plus app click on Settings and then click on Start RTD Server.


You can select Auto Start to enable automatic RTD Server start at next login.



Available RTD Fields

The syntax for Excel (Greek Version) is:


=RTD("ztrade.rt";;"zt";"ALPHA.gr";"Last")


=RTD("ztrade.rt";;"zt";"FTASE2012.xr";"Last")


and for the English version of Excel:


=RTD("ztrade.rt",,"zt","ALPHA.gr","Last")


=RTD("ztrade.rt",,"zt","FTASE2012.xr","Last")


*The third partameter, "zt", is declaring the type of version for the ZTrade application, if you have ZTrade by securities firm, replace it with the 2 letters of your securities firm: ci, cl, de, ec, el, eu, ma, me, na, pe, pr, sa, so.


**The market extension ".gr" can be ommitied if that's your default market in your app.

The date

Date

The last price

Last Price

The Open price

Open

The maximum price

High

The minimum price

Low

The volume

Volume

The turnover

Turnover

The change

Change

The percentage of the change

ChangeP

The number of transactions

CountT

The VWAP price

Vwap

The projected price

Projected

The projected size

ProjectedSize

Open Interest

OpenInterest

Number of shares

Shares (in million)

Market Capitalization

MarketCap (in million)

Performance of 1 week

Perf1w

Performance of 1 month

Perf1m

Performance of 3 months

Perf3m

Performance of 6 months

Perf6m

Performance of 52 weeks

Perf1y

Performance of 1/1

PerfYtd

Maximum price of 52 weeks

Pr52H

Minimum price of 52 weeks

Pr52L

Ask price

Ask

Ask size

AskSize

Bid price

Bid

Bid size

BidSize

Second ask price

Ask2

Second ask size

AskSize2

Second bid price

Bid2

Second bid size

BidSize2

Third ask price

Ask3

Third ask size

AskSize3

Third bid price

Bid3

Third bid size

BidSize3

Fourth ask price

Ask4

Fourth ask size

AskSize4

Fourth bid price

Bid4

Fourth bid size

BidSize4

Fifth ask price

Ask5

Fifth ask size

AskSize5

Fifth bid price

Bid5

Fifth bid size

BidSize5

Markets and symbol suffixes:

If you ask information for a market different than the default market in your app, you should add a dot (.) and the market code used to indicate that market (e.g. "FTASE1912.xr").

Market

Suffix

Example

Stock Market Athens

.gr

ΕΥΔΑΠ.gr

Stock Market London

.gb

VOD.gb

Stock Market New York

.us

BAC.us

Currencies and Indeces

.wi

EURUSD.wi

Stock Market XNEXT

.wr

XXX.CN.wr