Login Page - Create Account

Support Board


Date/Time: Thu, 16 May 2024 19:22:23 +0000



Post From: Moving Average Angle/Slope display next to Name Label

[2018-12-05 14:55:44]
Sawtooth - Posts: 3997
A spreadsheet study can do this. I don't know of any other way.

Try this:

Add the Spreadsheet Study study:
-Set the Chart Region to 1
-Give it a name in the Spreadsheet Name field.
-Set the Number Of Rows to 2. (optional)

On the Subgraphs tab:
-Set the Draw Style of K(SG1) to Text and choose the color.
-Check 'Name Label' and choose its location.
Click OK and OK.

On the spreadsheet:
-Put this in cell K2:
=TEXT(VALUE(ID2.SG1@3),"0.###")
-Put this in cell K3:
=ID1.SG1@3

The formulas assume the Study Angle study is ID2 and the moving average is ID1.SG1. Edit as needed.
You can change the display format by editing the "0.###" in the K2 formula to your requirements.
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TEXT_Function