Converting Excel To METASTOCK

Description

GETTING STARTED WITH METASTOCK Part 11:

Converting Excel data to Metastock formatConverting Excel files to Metastock files can be frustrating. The problem usually is related to the date structure, format and hidden formulas. Some traders create synthetic Excel files using market data. These include advance_decline data, new high-new low data, or data used to track an individual portfolio average. Excel has very limited charting abilities when compared with Metastock so there is an advantage in turning the Excel data into a Metastock file. For more advanced users, this process also provides a way to set up a DDE link with live data coming into an Excel spreadsheet that is linked to a Metastock file which is updated. The same direct links can be used to develop Excel based indicators which are displayed on a Metastock data file. This might include plotting the equity curve calculated in an Excel spreadsheet directly over the appropriate price chart. The steps below are used for establi