Support Board
Date/Time: Tue, 14 Oct 2025 20:16:56 +0000
Angle of line between position entry price and C
View Count: 81
| [2025-10-13 07:55:07] |
| User61168 - Posts: 458 |
|
Wondering if anyone has a solution to implement this via Simple Alert or spreadsheet formula study (I am not using any spreadsheet or ASCIL studies in my collection). I want to display a line from my position entry price to the current C (last trade price) and then display the Angle (in degrees) of this line in chart region2. I am unable to figure out how to make use of the "Study Angle" delivered study for this purpose mentioned here > Study Angle Any help would be greatly appreciated. |
| [2025-10-13 18:32:35] |
| John - SC Support - Posts: 42378 |
|
How are you drawing the line itself? That line would have to be in a study in order to be able to determine the angle using the Study Angle study.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-10-14 07:16:54] |
| User61168 - Posts: 458 |
|
Hi John, I need help with figuring out how to draw the line :- I am using a 1Min chart so every time posqty changes from 0 to >0 or <0, I can capture the entry price in spreadsheet formula. I could also capture the BARTIME in another spreadsheet formula. How can I draw a line with entry time, entry price and current price? |
| [2025-10-14 15:44:09] |
| John - SC Support - Posts: 42378 |
|
What you are trying to do is not going to be straightforward. We recommend using the "Spreadsheet System for Trading" to find a way to do this. In there you will have the entry price and the entry time, so you can establish the one point from those, and then the other point is the current close. You would then need to calculate the line position at each bar in between in order to display the line. But you could calculate the angle from those two points. Keep in mind that you will need to consider the relationship of bars to prices in order to come up with the type of angle you want. The display of a line on the screen does not correlate to the actual angle that you will calculate. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-10-14 15:52:45] |
| Sawtooth - Posts: 4276 |
|
Like John says, it can be done with the Spreadsheet System for Trading study. See attached for a screenshot of what it looks like. BTW, the Slope is calculated using the Slope function, not the Study Angle study. DM me if you want an example chartbook. |
 Line-EntryToC.png / V - Attached On 2025-10-14 15:52:40 UTC - Size: 25.32 KB - 4 views |
| [2025-10-14 19:06:41] |
| User61168 - Posts: 458 |
|
Thanks John and Tom. I really appreciate it. The idea I have in mind is much complicated involving triangulation with two additional lines from MAE to C and MFE to C. I will play around with Slope function to see if it meets my needs.
|
| [2025-10-14 19:10:33] |
| John - SC Support - Posts: 42378 |
|
Keep in mind that the slope is directly correlated to the angle. The formula is the following: angle = arctan(slope percentage / 100) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: