V. 19:12 (28-29): Sidebar: Input for y-axis translator macro by Frank Suler
Product Description
Sidebar: Input for y-axis translator macro by Frank Suler
INPUT FOR Y-AXIS TRANSLATOR MACRO
The y-axis translator allows you to plot any variable with any other variable on the same chart. This is perhaps the most useful of all aids in developing and comparing indicators. See the attached macro listing (sidebar Figures 1 and 2). To translate a column of “A” values of range A1-A2 into “AB” values of range AB1 to AB2, you have to take the values from a column of ABn values where ABn=(An+C)*X, in which C=(AB2*A1-AB1*A2)/ (AB1-AB2), a translation constant, and X=AB1/(A1+C), a scale factor constant. ( Zero values are not allowed for the four inputs A1, A2, AB1, and AB2.) The derivation of C and X is straightforward: If A varies from A1 to A2 and is translated to values AB1 to AB2, then:
1 (A1+C)*X=AB1 and 2 (A2+C)*X=AB2, must be true
Solve (1) and (2) for X:
INPUT FOR Y-AXIS TRANSLATOR MACRO
The y-axis translator allows you to plot any variable with any other variable on the same chart. This is perhaps the most useful of all aids in developing and comparing indicators. See the attached macro listing (sidebar Figures 1 and 2). To translate a column of “A” values of range A1-A2 into “AB” values of range AB1 to AB2, you have to take the values from a column of ABn values where ABn=(An+C)*X, in which C=(AB2*A1-AB1*A2)/ (AB1-AB2), a translation constant, and X=AB1/(A1+C), a scale factor constant. ( Zero values are not allowed for the four inputs A1, A2, AB1, and AB2.) The derivation of C and X is straightforward: If A varies from A1 to A2 and is translated to values AB1 to AB2, then:
1 (A1+C)*X=AB1 and 2 (A2+C)*X=AB2, must be true
Solve (1) and (2) for X:
FOR THOSE ORDERING ARTICLES SEPARATELY:
*Note: $2.95-$5.95 Articles are in PDF format only. No hard copy of the article(s) will be delivered. During checkout, click the "Download Now" button to immediately receive your article(s) purchase. STOCKS & COMMODITIES magazine is delivered via mail. After paying for your subscription at store.traders.com users can view the S&C Digital Edition in the subscriber's section on Traders.com.
| Take Control of Your Trading. |
| Professional Traders' Starter Kit |
| All these items shown below only $299.99! |
| Click Here to Order |