Universal DDE: Difference between revisions
From MultiCharts
→Setting up Universal DDE for Excel
Abeloglazova (talk | contribs) |
|||
(3 intermediate revisions by the same user not shown) | |||
Line 33: | Line 33: | ||
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 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 | To use several DDE servers at once 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. | 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> | <br> | ||
[[Category:Built-in_Data_Sources]] | [[Category:Built-in_Data_Sources]] |