Read / Write to Metastock Data from Excel

MarkVincent

Junior member
Messages
10
Likes
0
Hi all,

Looking to use Metastock for visual analysis and Excel for more complex trading analysis. I would like to use the same data in MS format.

For this i need to read MS data from within Excel PLUS... i would like to update the same data from withing Excel... easier from within a worksheet. I am sure this has all been done and i have see a few tools in Delphi - but looking for best / most reliable.

Thx.

Mv
 
Don't know if this helps.....but something from Metastock community help area....

This is under help in metastock....

"One of the great features found in many programs designed for Windows 95 or later is the ability to create links between programs using OLE (object linking and embedding). For example, you could create an OLE link between MetaStock and Excel. Data that exists in the Excel spreadsheet could be plotted in MetaStock. If the data changes in Excel, the changes will also be made in MetaStock because of the OLE link. (Note that Excel 7.0 can only handle a Paste Link of about 1,000 records. Excel 97 and later versions don't have this limitation).

OLE links are created by copying data from one OLE compatible Windows application and then pasting it (using the Paste Special command in the Edit menu) to the other application. When using the Paste Special dialog, be sure to look at the helpful messages at the bottom of the dialog. These instructions will guide you through the process of creating the link.

If you right click on an indicator in MetaStock that has been paste linked from another application (i.e., Excel, Lotus 123, etc.), two options appear in the shortcut menu—Update Link and Open Link.

Use the Update Link command to refresh the indicator in MetaStock with the data from the server application (i.e., Excel, Lotus 123, etc.). Choose Open Link to open the server application so that you can edit the data in the server application.

Note that links to a real-time chart in MetaStock can adversely affect MetaStock's performance, especially if intense calculations are involved. A warning message appears if you attempt to create an OLE link to a real-time chart.

More:

To create an OLE link between an indicator in a MetaStock chart and an Excel spreadsheet
To link data in an Excel spreadsheet to MetaStock
To link a chart in MetaStock to a Word document
OLE Tips"
 
thanks Zambuck for your note.

We are looking at a few options. OLE was never my thing - but you can never rule out anything.

Br Mv
 
Top