Universal DDE: Difference between revisions
From MultiCharts
→Setting up Universal DDE for Excel
Abeloglazova (talk | contribs) |
|||
Line 41: | Line 41: | ||
[[File:Excel DDE.png|600px|right]] | [[File:Excel DDE.png|600px|right]] | ||
:1. Open the Universal DDE data feed settings. | :1. Open the Universal DDE data feed settings. | ||
:2. Create an Excel book, e.g. '''Book1.xls''' and save it to the ''' | :2. Create an Excel book, e.g. '''Book1.xls''' and save it to the '''Documents''' folder on your PC. | ||
:3. In Excel set the coordinates to '''R1C1''' format | :3. In Excel set the coordinates to '''R1C1''' format in File → Options → Formulas → in the Working with formulas 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: | :4. The formula for the prices and volumes in Universal DDE settings should be as follows: | ||
::'''=EXCEL|'Book1.xls'!*C1''' | ::'''=EXCEL|'Book1.xls'!*C1''' |