SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Neural Nets - A tool for the 90's -- Ignore unavailable to you. Want to Upgrade?


To: F Robert Simms who wrote (167)7/8/1998 9:05:00 AM
From: Optim  Read Replies (1) | Respond to of 871
 
You can export data, indicators and charts from Metastock by selecting them (hold SHIFT key for more than one) and then choosing copy from the edit menu. Then you go into Excel and choose Paste Special from the Edit menu. Choose Paste As Link and select CSV as the format. That will import a column of numbers. You may want to select an area in Excel that has more rows than you are importing. This is so that as new data becomes available it is imported into the extra rows.

Once you build the worksheet you don't even need to load Metastock again. Excel will ask if you want to update the data when you load it. Choose yes and preprocess or export to ASCII.

You can also do the reverse, importing a column of Excel data back into Metastock to be plotted. This means if you import your neural signal from Profit (export it to ASCII) you can plot it beside your usual charts. You can also run system tests against it, or apply new indicators to the output.

Optim