Using Dummy Price arrays

[Herman van den Bergen <psytek@xxxxxxxx>]

Hi,

To overcome certain MS limitations you can copy price, indicator, equity
arrays, or data from other sources, to excel and combine the data into a
single dummy price array (of the type: Date,Open,High,Low,Close,Volume)
using the Downloader. You end up with a standard formatted MS price array
where each data column can hold a totally unrelated array or value. Next
you convert this data to a dummy "security" that you can call up as a MS
chart. 

For example you could let the Open column hold your Long Equity from a
system test, the Close your Short Equity, and the Volume your Both Equity.
You could even put binary values in the Low and High columns - some scaling
may be neccessary to prevent MS error messages produced when the Low and
High don't meet normal expectations.

Some advantages:

1) You can now write Indicators that use values from up to five underlying
data arrays/sources instead of just one (or two in the case of Correlation)
2) Now you can develop a MS trading system to work on ANY data
3) You can mow drop your Experts on Indicators and equities
4) It can simplify MS formulae writing

This procedure enables you to perform analysis in ways that were not
possible before. While it may appear complicated it only takes a few
minutes to do build a dummy array onces you have mastered copying MS data
to Excel and have learned to use the DownLoader. For routine applications
you can write a macro to massage the data in Excel.

Hint: This is a prerequisite procedure to developing an EOD Equity Feedback
based Trading system ;-)

Good luck,
Herman.