816
edits
Changes
Jump to navigation
Jump to search
[[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 documentsDocuments''' folder on your PC.:3. In Excel set the coordinates to '''R1C1''' format (click on Office Button -> Excel options -> in File → Options → Formulas -> → in the Working with formulas -> Activate section check the '''R1C1 reference style)''' box. <br> 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'''
