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.
and then on the windows that open select Start DDE Server.