Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 06 May 2024 22:57:34 +0000
Understanding Spreadsheet Formula Examples
View Count: 1892
| [2018-05-05 09:07:23] |
| User172040 - Posts: 70 |
|
Hi, I'm learning the spreadsheet formulas and just need to put words to the formulas in order to understand it better. Under Multiple Exit Automated Trading Example (Spreadsheet Systems, Alerts and Automated Trading: Multiple Exit Automated Trading Example ) you display the following code: =IF( ABS(J8) = 5, 2, IF( ABS(J8) = 3, 3, 0)). In order for me to understand this, how do I word this? Something like IF Position Quantity (J8) = 5 contracts, then (what does the 2 represent?) AND IF Position Quantity (J8) = 3 contracts, then (what does the 3 represent), then (what does the 0 represent?) If you give worded examples of spreadsheet formulae, can you kindly direct me in the right direction. Date Time Of Last Edit: 2018-05-06 22:15:46
|
| [2018-05-05 14:49:00] |
| Sawtooth - Posts: 3993 |
|
"If the absolute value of J8 equals 5, then 2, else if the absolute value of J8 equals 3, then 3, else 0" This formula goes in J26, which is the Order Quantity, so the outputs of 2, 3, and 0 are the conditional order quantities. J8 is the Position Quantity and it will be positive if in a long, or negative if in a short, so the absolute value is used to always return a positive number. |
| [2018-05-13 07:05:26] |
| |
|
The documentation has been updated in this regard.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to 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: