account →

DDE Data Exchange with Microsoft Excel or OpenOffice Calc

To update the Excel with data from ZTrade Plus you should follow the below steps:


1. Please download the file: jddev1.zip


2. Copy the below file jdde.dll to C:\Program Files\Java\jre1.8.0_181\bin
(The file jre1.8.0_181 may have a different number depending of the Java version that you have installed.)


3. From ZTrade Plus app click on Setting and then on the windows that open select Start DDE Server.


4. If the loading fails, your computer may not have install the VC15 redistributable from Microsoft and it should be installed.


Download vc_redist.x64.exe , install it and redo the process to start DDE, if you have JAVA 32 bit installed.


You can select automatic start for the DDE so a manual start won't be needed.


α. Copy the file jddev1.zip το jdde32.dll in C:\Program Files (x86)\Java\jdk1.8.0_181\bin (The file jre1.8.0_181 may have a different number depending of the Java version that you have installed.)


β.Download the https://aka.ms/vs/15/release/vc_redist.x86.exe and install it and retry the start of DDE. When the DDE server starts the button "Start DDE Server" changes to "Stop DDE".


Available DDE Fields

The syntax for EXCEL is:


=ZT|ALPHA!Close


the syntax for OpenOffice is:


=DDE("ZT";"ALPHA";"Close")


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:

There is no suffix needed to the default market set in your App. If the symbol is for a different Market, then you should add a dot (.) and the suffix for the corresponding market. Διαθέσιμες αγορές:

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

Copying Stock List from ZTradePlus to Microsoft Excel or OpenOffice Calc

To copy a stock list from a column as seen as in ZTrade Plus you should:


For Microsoft Excel:


Press Ctrl + Shift + C by first haivng clicked on any point in a list of ZTrade Plus and then in Excel by pressing 'Paste' or by pressing Ctrl + V.


For OpenOffice Calc:


Press Ctrl + Alt+ C by first haivng clicked on any point in a list of ZTrade Plus and then in OpenOffice Calc by pressing 'Paste' or by pressing Ctrl + V.