Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 23:34:45 +0000
LOG question
View Count: 69
| [2024-04-24 17:46:38] |
| User411320 - Posts: 265 |
|
So I'm using LOG for price change of close written as =LOG(E3-E4) but keep #NUM! according to documentation " if either the given Number or Base is less than or equal to 0" i assume because some of the values are negative after subtraction? would taking the absolute fix this? I'm confused what I'm doing wrong
Date Time Of Last Edit: 2024-04-24 17:48:54
|
 Screenshot 2024-04-24 134015.png / V - Attached On 2024-04-24 17:46:29 UTC - Size: 0 B - 13 views |
| [2024-04-24 22:56:42] |
| John - SC Support - Posts: 31362 |
|
You can not take the log of a negative number. Taking the absolute value of the difference will resolve the error, but we are not sure what you are trying to accomplish, so we can not say if it will give you what you want. Be aware that you can set the vertical scale to be a logarithmic scale. Refer to the following: Chart Menu: Logarithmic Scale (Chart menu) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-04-25 12:22:06] |
| User411320 - Posts: 265 |
|
John, Yes taking the absolute worked. but before I proceed to take up your time on this issue. I need to try other measures, I'll get back to you |
To post a message in this thread, you need to log in with your Sierra Chart account: