456
edits
Changes
Jump to navigation
Jump to search
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 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==
[[File:Excel DDE.png|600px|right]]
:1. Open the Universal DDE 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 coordinates to '''R1C1''' format (click on Office Button -> Excel options -> Formulas -> Working with formulas -> Activate R1C1 reference style). The cell coordinates will change from, e.g. A1 to R1C1 that is “Row 1, Column 1”.
:4. The formula for the prices and volumes in Universal DDE settings should be as follows:
::'''=EXCEL|'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 the formula, a complete cell address is formed.
:6. When you create a chart for one of the instruments it will reference the corresponding cell according to the formula.
<br>
[[Category:Built-in_Data_Sources]]
