The Range Gauge tab will format the contents of each cell in the current column graphically based on a range between 0.0 and +1.0. This formatting type, therefore, should only be used on columns that contain cells with values that will oscillate between 0.0 and 1.0.
Range Gauge can be used in conjunction with the normalizeDynamic and normalizeFixed built-in study formulas in the Utility formulas section. With either normalizeDynamic or normalizeFixed you can normalize any input stream to a range of 0 to 1.0.
Once you apply this formatting to a column, adjust the Row Height and Column Width as necessary to achieve the look that you want.
Note: After formatting has been applied to the Grid you can double-click anywhere in the Grid to temporarily hide all formatting so that you can quickly view the underlying numbers. Double-click again and the formatting will return.
Range Gauge formatting page
| • | Range Frame Color: Use this color selector to set the color for the frame outline color. |
| • | Range Pos Color: Use this color selector to set the color for a positive range. |
| • | Range Neg Color: Use this color selector to set the color for a negative range. |
| • | Range Fill Color: Use this color selector to set the background or fill color for each cell. |
Click on the Cancel button or press the ESC key to cancel any changes and close the Format Column dialog.
Click on the Apply button to apply the changes and close the Format Column dialog.
Click on the Reset All button to remove all formatting settings for all columns.
Range Gauge formatting example
Note: Once you have applied formatting to the Grid, that formatting remains with the associated script. If you then modify the script by adding or removing columns, the formatting may need to be adjusted.
See also: