456
edits
Changes
Jump to navigation
Jump to search
no edit summary
See [[Operating_Data_Sources#Cloning Data Sources|Cloning Data Sources]] section for more detailed information.
==Setting up Universal DDE for Excel==
: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 was 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]]
