Universal DDE: Difference between revisions
From MultiCharts
→Setting up Universal DDE for Excel
Abeloglazova (talk | contribs) |
|||
(One intermediate revision by one other user not shown) | |||
Line 39: | Line 39: | ||
==Setting up Universal DDE for Excel== | ==Setting up Universal DDE for Excel== | ||
[[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''' |