|
Some Design and Data Organization Tips
Unfortunately, many market professionals try to pull out portions of page data in separate
cells with DDE formulas nested within Excel’s text parsing formulas. Using this
approach creates an error prone, impossible-to-maintain mess. If you want to
perform calculations on page-based data, we suggest that you keep the real-time
page data in a single column on a separate worksheet. The formulas to perform
the parsing should be put in cells adjoining the single column of real-time
data. Make sure you label the columns with the parsed information and assign a
name to the cell with the parsed information.
An example of what we mean is shown below:
|
