Support Board
Date/Time: Mon, 10 Mar 2025 10:37:36 +0000
Post From: Angle of a Moving Average - Spreadsheet study
| [2022-03-17 15:02:59] |
| User837393 - Posts: 143 |
|
Hello, I'm trying to calculate the angle on the slope of MA in a spreadhseet study on a Renko Chart. The moving avergae itself looks nice and clean. To calculate the angle I'm refering myself to the 10 last point of that MA with the following formula : = ATAN((ID6.SG1@13 - ID6.SG1@3)/10)*180/PI Where ID6.SG1 is the output of the MA. Why the result values of the calculation are always in the order of -2 ; -3 or +2 ; +3... It never outputs angles of e.g. 70 degree or 45 degree... I know that the Spreadsheet Angle study output e.g. 78 degrees. I'm not sure what I'm doing wrong in the application of the formula. |