DDEChartUpdater - Provides data feeds for MetaStock and SierraChart that are not supported originally

DDEChartUpdater allows you to use MetaStock or SierraChart with data feeds that are not supported originally. The program connects to external programs providing (real-time) quotes via Windows DDE. The application converts these quotes into MetaStock or SierraChart format. The charts of MetaStock/SierraChart will be updated automatically.

Main Features:

  • Can connect to any program supporting DDE
  • Charts will be updated automatically
  • You can download data from any source in DDE format directly to MetaStock or SierraChart format. This widens the selections of possible data vendors by several orders of magnitude.
  • You can use as many data vendors as you want. So you can easily combine the advantages of these venders by just configuring the DDEChartUpdater.

Download DDEChartUpdater now » DDEChartUpdater documentation (PDF) »

Tutorial how to make a connection to Excel using DDEChartupdater

Let us assume that you have an Excel workbook that will be updated with (real-time) quotes automatically. Following steps are necessary to access these quotes with DDEChartUpdater:

1. Start Excel and open the workbook providing the quotes.

2. Start DDEChartUpdater. To display the "Symbol Configuration" dialog, click on "Symbol->Add". Enter the symbol, name and the directory where you want to store the quotes of this stock.

3. Click on the "…" button that is located next to the "DDE server name" text box.

DDE Server name

4. The "Select DDE Server Name" dialog will appear:

Select DDE server

DDEChartUpdater will list all running applications that are supporting DDE. Doubleclick on the "Excel" entry. The dialog will close automatically. Now you have successfully specified the server name.

5. Now you can specify the Excel cell where the "close" record is stored. Click on the "…" button that is located next to the "Close record" text box. The "DDE Settings" dialog will appear.

DDE settings

6. Excel uses the sheet name as DDE Topic. You can either enter the sheet name manually or using the "…" button to select the sheet names from a list.

DDE topic

Your list may differ from the above topic list. Make sure that you have selected the correct sheet name and double click on it. (Or press the OK button)

7. Now you have to specify the cell where the close record is stored. Let us assume that the record is stored in the cell "C4". "C" means that the record is stored in the third column. "4" means that the record is stored in the 4th row. Therefore the DDE item is R4C3. ("R" means row, "C" means column) The DDE item must be expressed in language of the Excel version. If you use a German Excel version you have to use Z4S3 ("Z" means "Zeile", "S" means "Spalte") Use L4C3 for French or W4KC for Polish. More examples:
If the record is stored in the cell "F10" you have to use following DDE Item: "R10C6"
Cell: A1, DDE Item: R1C1
Cell: D20, DDE Item: R20C4
Cell: H37, DDE Item: R37C8

DDEChartUpdater settings

8. Please repeat the steps from 5 to 7 if you want to use open, high, etc. prices.

9. Click on "OK" to close the "Symbol Configuration" dialog.

10. Click on "DDE->Start" to start collecting quotes. If a value in an Excel cell changes, DDEChartUpdater will display the new value in the main window and update the MetaStock/SierraChart files immediately.