456
edits
Changes
Jump to navigation
Jump to search
<br>To create a symbol using [[File:Excel DDE.png|600px|right]]:1. Open the Universal DDE as data feed settings.:2. Create an Excel book, e.g. '''Book1.xls''' and save it to the '''My documents''' folder on your PC.:3. In Excel set the Data Source see [[Operating_Symbol_List#Adding Symbolcoordinates to '''R1C1''' format (sclick on Office Button -> Excel options -> Formulas -> Working with formulas -> Activate R1C1 reference style) . The cell coordinates will change from, e.g. A1 to Symbol ListR1C1 that is “Row 1, Column 1”.:4. The formula for the prices and volumes in Universal DDE settings should be as follows: ::'''=EXCEL|Adding Symbol(s) 'Book1.xls'!*C1''':::Where * is the reserved place for R1, R2, R3,...RN that should be your symbol names.:5. Add your instruments manually and name them R1, R2, R3,...RN so that when they are added in place of * to Symbol list]] section the formula, a complete cell address is formed.:6. When you create a chart for more detailed informationone of the instruments it will reference the corresponding cell according to the formula.
<br>To use several DDE servers at once You should clone the Universal DDE and assign new settings. <br>See [[<span style="color: red;">'''LINK'''</span> /103_Data_Sources.html name="5"; |Cloning Data Sources]] section for more detailed information.
environment.
Please see the [http://msdn.microsoft.com/library/en-us/winuilibrary/WinUIwindows/WindowsUserInterfacedesktop/DataExchange/DynamicDataExchange/AboutDynamicDataExchangems648774(v=vs.85).asp aspx Developer's website] for more detailed information on DDE. <br>{|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #cccccc"|-|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #cccccc"|'''Pro'''|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #cccccc"|'''Con'''|-|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #cccccc"|Widest choice of data sources|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #cccccc"|Lack of historical quotes|-|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #cccccc"|Data preprocessing with Excel <br>or other programs possible, <br>additional features such as <br>bad tick filtering and <br>creating synthetic symbols|style="border-collapse: collapse; border-width: 1px; border-style: solid; border-color: #cccccc"|Average stability and performance|}
<br>
* Rapid creation, editing and application of DDE Templates
* Testing the functionality of a DDE server or a newly created template
* Support for various server types. Some DDE servers contradict the Microsoft specifications. <br>For maximal user convenience the program has a set of deeply customizable options (not described here). <br>If you're not able to receive data from a required DDE server, please write to [mailto:support@tssupport.com support@tssupport.com] and our support service will aid you as soon as possible
* Automatic reconnection in case the connection to the DDE server is lost
* The program receives ticks only and assigns the current system time to them. Sometimes the tick's real time may differ from the assigned one due to delay
* The Status Bar is not displayed on the chart as there aren't enough fields to chart it
== Setting up ==
# On the '''Tools''' menu, click '''Data Sources'''.
# Select '''Universal DDE''' and click '''Settings'''.
# Indicate a template name in '''Template''' (up to 20 symbols characters long).
# Indicate the DDE Links in the corresponding sections (the sections include '''Trade''', '''Bid''' and '''Ask'''. The '''Price''' and '''Volume/Size''' must be indicated in each section; if '''Volume/Size''' cannot be used (e.g for Forex), indicate '''Price''' instead. Since for every price the program queries for a volume, this field will never be empty as the program will be waiting for volume data to form a new tick.
# Before creating DDE links in '''Universal DDE''' make sure they are functional in Excel. <br>After that, copy the link to the corresponding field in '''Universal DDE''' and replace the static symbol name with the asterisk symbol '''*'''. <br>For instance, replace =WINROS|LAST!MSFT with =WINROS|LAST!*. After that the program will automatically use the symbol name for which the given template is used. Do the same for all fields.
# To make sure that the created template is functional, click '''Test'''. Enter the symbol name in '''Symbol''' and click '''OK'''. <br>If the DDE Server is running, the template is properly created and the queried symbol is accessible, you'll see the current value for each field and the number of updates. If quotes do not arrive, check the template and symbol name. <br>If fixing them does not resolve the problem, please send an e-mail to [mailto:support@tssupportmulticharts.com support@tssupportmulticharts.com] and indicate the DDE Server, symbol and template names, confirm that an identical template functions in Excel and share any other information you deem important. To create a symbol using Universal DDE as the Data Source see [[Operating_Symbol_List#Adding Symbol(s) to Symbol List|Adding Symbol(s) to Symbol list]] section for more detailed information. To use several DDE servers at once you should clone the Universal DDE and assign new settings. See [[Operating_Data_Sources#Cloning Data Sources|Cloning Data Sources]] section for more detailed information. ==Setting up Universal DDE for Excel==
<br>
[[Category:Built-in_Data_Sources]]
