DDEChartUpdater V1.3 - Trading
Contents
1. CABG Volume Total cAO7 GDAXI cS DES 00340 CAY DEBB AG Y cba DE cf DE515100 cbc DES19 008 cd DESTS2 00 che DERR2S AD cHbF DEF 10000 cO18 DES14000 cO11 DE555200 cHi2 DESS1 0065 CH ERS A212 5 cHia DESss7Sa 8 015 D0E761440 cO1 DESTES88 COT DES B48 43 DDE SPY DDESpy can display DDE information in a window or on your debugging terminal or it can save the displayed information in a file for later use You use the Output menu to select where DDESpy sends output If you choose the File command you can specify the name of an output file or choose the No File button After you have chosen the File command DDESpy asks you for an output filename every time you restart it This prompt can be turned off by reopening the File dialog box and choosing the No File button From the Output menu you can also choose to send your output to either a debug terminal or to the DDESpy window If you choose a window you can clear the display window using the Clear Screen command You can use the Mark command to add marker text to the display for example before a DDE event to make it easier to find the event in the output file It is important to start DDESpy before you start the program creating the DDE items topics Use the items topics that are displayed in the main window of DDESpy and enter the in the Symbol gt Add dialog Registration and Price Information Product price 49 95 EURO Thi2. Example ATML 02 22 02 7 550001 7 18 7 400001 Input File Detail Settings You should choose which character would be used as the field delimiter That character pertains to all columns and data in the file You can select the Date field format in your ASCII source There are different formats supported Example 1 YYYY MM DD means that the year is expressed as a four digit number and that the three fields are separated by a character Example 2 MMDDYY means that the year month and day are expressed as a two digit numbers each no characters separate the fields Check the Remove zeros at the begin of the date box to remove all leading zeros of the date Example The date 000101 1 January 2000 will be written to the ASCII file as 101 You also have to enter a file name of the ASCII file Do not enter a directory in this text box The files will be stored in the directory you have specified in the Symbol List dialog You can use the Auto Name tags to create dynamic ASCII files You can use following tags lt USER gt Name of the user that is logged in lt PC gt Name of the computer where DDEChartupdater is running lt DATE gt Current date YYYYMMDD lt TIME gt Current time HHMMSS lt SYMBOL gt Security symbol lt NAME gt Security name DDEChartupdater will automatically parse and replace the tags with the current user name PC name date time security symbol security name download symbo
3. rrada slashes Options L dali hest Forni la Forthi Porthos sahen Took L da heet Your list may differ from the above topic list Make sure that you have selected the correct sheet name and double click on it Or press the OK button Now you have to specify the cell where the close record is stored Let us assume that the record is stored in the cell C4 C means that the record is stored in the third column 4 means that the record is stored in the 4 row Therefore the DDE item is R4C3 R stands for row C stands for column The DDE item must be expressed in language of the Excel version If you use a German Excel version you have to use Z4S3 Z stands for Zeile S stands for Spalte Use L4C3 for French or W4KC for Polish More examples If the record is stored in the cell F10 you have to use following DDE Item R10C6 Cell A1 DDE Item R1Ci Cell D20 DDE Item R20C4 Cell H37 DDE Item R37C8 x DDE Topic Bookl Sheet J DDE ltem CA4 El cwe Please repeat the steps from 5 to 7 if you want to use open high etc prices Click on OK to close the Symbol Configuration dialog Click on DDE gt Start to start collecting quotes If a value in an Excel cell changes DDEChartUpdater will display the new value in the main window and update the MetaStock SierraChart files immediately How to use the DDESPY EXE utility You can use
4. with data feeds that are not supported originally The program connects to external programs providing real time quotes via Windows DDE DDEChartUpdater stores the data in MetaStock or in SierraChart format The charts of MetaStock SierraChart will be refreshed automatically More features of DDEChartUpdater e You can download data from any source in DDE format directly to MetaStock or SierraChart format This widens the selections of possible data vendors by several orders of magnitude e You can use as many data vendors as you want So you can easily combine the advantages of these venders by just configuring the DDEChartUpdater e Can store quotes in ASCII files and updates them in real time Read the Getting Started chapter to get a general idea of DDEChartUpdater Getting Started Main Window The main window displays all symbols that will be updated via DDE You can add remove symbols by using the Symbol menu An Error log window is displayed on the bottom of the main window So you are always up to date if an error occurred b p DDE ChartUipdater g programme ddechartupdaterdow chg wm RTO Cul 8516 43 ee ARTO INTC 18 821 14 4815 Connectng to DDE servers 14 4 15 Done Staring collecting quotes Main Window of DDEChartUpdater Understanding DDE Dynamic Data Exchange Dynamic Data Exchange is a feature of Windows that allows two programs to share data or send commands directly to each
5. DDESpy DDESPY EXE to monitor dynamic data exchange DDE activity in the operating system Output Monitor Task b4c Time Task fxb4ac Task Oxb4c Task Bxebac Task Gxb4c Task fxb4ac Task fxb4Sc Task Oxbac Task kbit Task rbit Time Time Time Time Task fixb4ac Task Oxb4c Task Oxbac Task Oxb4c 4 Time Track About 15098921 Time 215098941 Time Time Time Time Time Time Time Time 115782874 Time 15098944 15098941 15098947 15098941 15098944 15102876 15102876 15102876 15102876 15102876 215102870 Time 151027876 Time Time Time Time Time 115102876 Time Time 15102876 15102876 15102876 15102876 15102876 15107876 15102876 15102886 String String String String String String String String String String String String String string String String String String String String String String String string Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Handle Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created Created cHba RTQ CAI Time 002 Bid C0063 ASk chh Close HOS Volume
6. other DDE can be thought of as a direct conversation between two application programs In most cases one application is providing some form of data either text or graphics to another application The application that is the source of the data is called the server and the application that is receiving the data is called the client Each data item that a server application can provide has a unique identifier consisting of three parts a DDE Application Name a DDE Topic and a DDE Item Name The DDE Application Name is almost always the executable filename for the server application without the EXE extension The DDE Topic typically identifies a group or category of data in the server application and each data item that a server can provide has a unique DDE Item Name Thus the Application Name Topic and Item Name identify the exact source of the data in a server application that is to be linked Similar to a telephone number with the three parts Area Code Exchange and Number DDE links are always initiated in the client application The client initiates a DDE link by broadcasting a message containing a DDE Application Name A DDE Topic and optionally a DDE Item to all other applications currently running If a server application is running that can provide the data it responds to the DDE initiate and the Windows operating system opens a link between the two applications Fortunately most Windows programs that support DDE insulat
7. DDEChartUpdater V1 3 Copyright C 2006 Trading Tools com mailto info trading tools com User manual Table of contents Table of contents iii caticiae EDEL eae ad Oia cela es 2 Welcome me mior keel eet ani eh ia eta la Gee Bec aati OG en E Rv ace a 3 Getting Startend mie rec edee dele viabvcedu nia vite nie tv eucd wade vile Wedd eddy a ta vies EE A a TAAN 4 Main Wind OW cessione aa a naaa onena AEEA EANAN EDEA ANKEN vai baci TAREA EY 4 Understanding DDE Dynamic Data Exchange ssssssssssssrrrrsssrrrrrnrssrrrrrrnnserrrrrnnss 4 Adding SYMBO S yenn eaaa a EE Ar Aaa eg E na DAAE el Aa alias 5 Options Dialga EET EET ANANE EAEN E ANAE NENNE EA ATA ENAA ARA 6 ASGIT File Format Dialogissa a a a Eee nere 6 T toria b anae dese tatisancdeadsawap coisaadeoesaug touches OTA OENAR ORDNETE DEKART NERA ENEAS 8 Connecting to an Excel Workbook via DDE ssssssssssssrsssrrrsrrrrsrrnnerrnurrrnnerrnnerrnnrrnnens 8 How to use the DDESPY EXE utility ssessssrsssssnrernesnsnrrennesnorrennnesnorrennnennorrennsenron 11 Registration and Price Information ccceceee eee eee eee eee e eee eee eas 12 Order FORM seoan iaaa Ea cov AAAA EEIE NANANA EEDE A EAEE ENANA NA EANAN EATEN ANAA 13 CONTATE Ei e TEE Be A TANT AN AENT A AENT NEN ey 15 Disclaimer Of Warranty vnen osaa oai aaa iani REAA AA TIAA EAA ORENA DEDNA EEEE 16 Welcome DDEChartUpdater allows you to use MetaStock http www equis com or SierraChart http www sierrachart com
8. HE SOFTWARE EVEN IF TRADING TOOLS COM HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES SOME STATES DO NOT ALLOW LIMITATION OR EXCLUSION OF LIABILITY FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES SO THE ABOVE LIMITATION MAY NOT APPLY TO YOU ALL SOFTWARE PRODUCTS CONTAIN SOME ERRORS AND INACCURACIES YOU UNDERSTAND THIS AND FULLY ASSUME ALL RISKS AND CONSEQUENCES RELATING TO SOFTWARE ERRORS OR ERRORS THAT MAY RESULT FROM THE USE OF INACCURATE DATA IN CONJUCTION WITH THE SOFTWARE IN ALL EVENTS YOU AGREE THAT THE MAXIMUM LIABILITY OF TRADING TOOLS COM TO YOU RELATING TO ANY CLAIM YOU MAY HAVE IN ANY MANNER RELATING TO THE SOFTWARE OR THE USE CONDITION OPERATION EFFECTIVENESS OR QUALITY THEREOF WHETHER BASED IN CONTRACT TORT OR ON OTHER GROUNDS OR THEORIES AND REGARDLESS OF THE CIRCUMSTANCES SHALL NOT EXCEED THE TOTAL AMOUNT ACTUALLY PAID BY YOU TO TRADING TOOLS COM TO LICENSE THE SOFTWARE 7 TO THE MAXIMUM EXTENT PERMITTED BY LAW TRADING TOOLS COM DISCLAIMS ALL WARRANTIES EITHER EXPRESS OR IMPLIED INCLUDING BUT NOT LIMITED TO WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR USE OR PURPOSE 8 If you do not agree with the terms of this license you must remove DDEChartUpdater files from your storage devices and cease to use the product MetaStock is a registered trademark of EQUIS International http www equis com Thank you for choosing DDEChartUpdater
9. Otherwise the topic item lists are empty and you have to enter them manually It is very important that you select a valid time format If the time of the server providing Every application is using a different DDE Topic and DDE Item If you do not know the topic item names of the external program you have to contact the vendor of this program Note You can use the DDESpy program to find out DDE Topics and DDE Items The program will calculate the Open High and Low prices for each interval if you select the Automatically calualte open high low prices The OHL prices will be display in the main window and will be written to the MetaStock SierraChart files E g If you select the Interval 5 Minutes DDEChartUpadter will collect all Ticks during this time period and calculates the Open High and Low prices Options Dialog Click on the Options menu to display the Options dialog options i x Options L IF Automatically close DDEChartUpdater at 20 xl oo o clock HH MM IV Open MetaStock automatically when DDEChartUpdater starts Location of MSWIN EXE file C Program Files Equis MetaStock Mswin exe Options dialog You can specify a time when DDEChartUpdater should be closed automatically DDEChartUpdater can start the MetaStock program for you You only have to enter where the MSWIN EXE file is located ASCII File Format Dialog Click on Options gt Define ASCII File Forma
10. and City State postal code Country Phone Fax E Mail How would like to receive the registration key E mail fax postal mail How would you like to pay the product price of EURO 49 95 Credit card wire transfer Euro Cheque cash Credit card information if applicable Credit card Visa Eurocard Mastercard American Express Diners Club Cardholder Card No Date of Expiration Date Signature Contact We provide support via email You can email your questions comments or bug reports to info trading tools com Normally all emails are answered throughout the 24 hour day Please keep the following tips in mind Software Problems It is easier to solve a software problem if you send us details that are as specific as possible when inquiring about software problems Also tell us the operating system you are using Data Problems Again details that are as specific as possible is necessary in order to resolve any data problems quickly Please specify the stock name and the date in question when reporting a data problem Specifying what you think is wrong is also useful Web http www trading tools com Disclaimer of Warranty Please note that by using DDEChartUpdater you are accepting the conditions of the Software Licence and Disclaimer of Warranty given below IMPORTANT READ CAREFULLY DDEChartUpdater is shareware program This means 1 Al
11. e the user from the low level details of establishing DDE links and simply allow you to specify the Application Name Topic and Item Name for a specific piece of data and the link is then automatically established for you by your application program Adding Symbols Click on the Symbol gt Add menu to add a new security The Symbol Configuration dialog will be displayed Symbol Configuration Stock informabon Name MSFT Symbol MST Periodicity Intreceay z interval Vick MetaStock drectoy C MetaStock O SeraChat a isisisS a addes OO 6 ODE settings DDE sewe name RTO al Tank ATOITimelDE519000 0 ud Time format of the DDE HHMMSS Close ATOMCloselDE51S000 zi Volume RTO S sf i Automahealy calculate open high low prices Poon fe l High or S nh F Low pma cf M Use this MeteStocksSiereaCha ASC directory for all securities in this Est Symbol Configuration dialog In the first frame you can specify the name and symbol of the security Also make sure that you select a valid periodicity interval If you do not want to store quotes in SierraChart format you have to set leave the SierraChart directory text box empty The same applies to the MetaStock and the ASCII directory In the second frame you can specify the DDE settings Click on the button to get a list of topics items that are currently available It is important that the external program is running
12. l copyrights are exclusively owned by Trading Tools com 2 Once registered the user is granted a nonexclusive license to use DDEChartUpdater on one computer i e a single CPU for any legal purpose at a time The registered DDEChartUpdater software may not be rented or leased 3 To register you must fill out the registration form For more information please refer to the Help files To purchase go to http www trading tools com order htm 4 You may not use copy emulate clone rent lease sell modify decompile disassemble otherwise reverse engineer or transfer the licensed program or any subset of the licensed program except as provided for in this agreement Any such unauthorized use shall result in immediate and automatic termination of this license and may result in criminal and or civil prosecution 5 Trading Tools com reserves the right to change the price for the program or any service without prior notice Trading Tools com does not refund the purchases of shareware programs which have trial period 6 NO LIABILITY FOR CONSEQUENTIAL INCIDENTAL OR INDIRECT DAMAGES TOTAL LIABILITY CAPPED IN NO EVENT SHALL TRADING TOOLS COM BE LIABLE FOR ANY SPECIAL INCIDENTAL INDIRECT OR CONSEQUENTIAL DAMAGES WHATEVER INCLUDING WITHOUT LIMITATION DAMAGES FOR LOSS OF PROFITS LOSS OF BUSINESS INFORMATION BUSINESS INTERRUPTION OR OTHER PECUNIARY LOSS ARISING OUT OF THE USE OR INABILITY TO USE THE SOFTWARE OR ANY ERRORS IN T
13. l or symbol list name The string lt SYMBOL gt _ lt DATE gt CSV will be changed to MSFT_20011029 CSV Tutorial Connecting to an Excel Workbook via DDE Let us assume that you have an Excel workbook that will be updated with real time quotes automatically Following steps are necessary to access these quotes with DDEChartUpdater 1 Start Excel and open the workbook providing the quotes 2 Start DDEChartUpdater To display the Symbol Configuration dialog click on Symbol gt Add Enter the symbol name and the directory where you want to store the quotes of this stock 3 Click on the button that is located next to the DDE server name text box DDE settings DDE server name pA 4 The Select DDE Server Name dialog will appear DDEChartUpdater will list all running applications that are supporting DDE Doubleclick on the Excel entry The dialog will close automatically Now you have successfully specified the server name 5 Now you can specify the Excel cell where the close record is stored Click on the button that is located next to the Close record text box The DDE Settings dialog will appear DDE Settings i gt ix 6 Excel uses the sheet name as DDE Topic You can either enter the sheet name manually or using the button to select the sheet names from a list 10 Select DDE Topic x Pook Sheets Book Sheets DownloadectL wla Sheetl
14. s copy of DDEChartUpdater is available for a 14 days evaluation period If you decide to continue using the program you need to register the program by using one of the methods described below By registering the software you are able to continue using it legally and are supporting our efforts to continually develop innovative products to best serve your needs If you order via credit card you receive the fully registered version of DDEChartUpdater within 5 minutes Click on the link below to make your order on a secure web site You can pay via credit card wire transfer cash or check http shareiti element5 com register html productid 182291 Alternatively you can order via phone fax or postal mail Please print out the order form Benefits of Registering e No restrictions on the number of starts e Free technical support provided by email Questions usually answered same day Order Form Please print out the following form and fax or mail it to element 5 AG Sharelt Vogelsanger Strasse 78 50677 Koeln Germany Phone 49 221 2407279 Fax 49 221 2407278 Email register shareit com US customers may also order by calling 1 800 903 4152 9am 5pm No technical support can be given at this number US check and cash orders can be sent to our US office at Sharelt Inc PO Box 844 Greensburg PA 15601 0844 USA Order form for DDEChartUpdater Program No 182291 Last name First name Company Street
15. t to display following dialog Here you can define the format of the ASCII files ASCII File Format Supported Feki and Column Assignments Date M Time W Open W High M Low Close fe Volume Hamel Symbol Custom text Usea custom comma sign I Write t digis after the comma Erelose labek in quotation marks Detal Sethngs taich column deimebe character do pou want to use Tab Spacels f Other character Date format MMDD rY Remove zeros at the begin of the date Tima format HH MM SS File name cNAME gt lt SYMBOL gt bt ASCII File Format dialog Supported fields and column assignments You use the check boxes to declare which fields you want DDEChartupdater to create in your ASCII file For each checked item you must declare in which column that data field is found DDEChartupdater does not permit multiple assignments to the same column The Date field and the Close field are not optional the ASCII file must have a Date column and a Close column You can also specify the number of digits that are displayed after the comma Check the Use a custom comma sign box to use a different comma sign as you have specified in the Control Panel Regional country settings If you do not check this box the default comma sign will be used Check the Enclose labels in quotation marks box if you want that a quotation mark is set before and after the date time name and symbol
Download Pdf Manuals
Related Search