Support Board
Date/Time: Fri, 07 Feb 2025 18:12:04 +0000
[Programming Help] - incorrect position opening in Spreadsheet System for Trading
View Count: 536
| [2020-06-11 12:54:18] |
| ULADZIMIR VALASACH - Posts: 38 |
|
I'm testing a simple strategy in Spreadsheet System for Trading: buy if the price exceeds Auto Retracement/Projection, Period High of the previous bar (top orange indicator). Formula is: Buy Entry = J14>AA4 Why is the purchase happening here (see Attachment)? Because the condition did not happen! Date Time Of Last Edit: 2020-06-11 12:55:05
|
p3.png| [2020-06-11 15:00:55] |
| Sawtooth - Posts: 4173 |
|
You must us an absolute reference to J14: =$J$14>AA4 |
| [2020-06-11 19:17:56] |
| ULADZIMIR VALASACH - Posts: 38 |
|
Thank you very much - you helped me a lot! Where did you get the information? |
| [2020-06-11 19:43:58] |
| ForgivingComputers.com - Posts: 996 |
|
Where did you get the information?
If you are not familiar with Excel, there are absolute and relative references. When you copy a cell with relative references (=J14) down one row, =J14 will become =J15. If you put a $ in front of the row or column, it will keep the original row and/or column value, so =J$14, when copied down one row, stays =J$14. Since rows 4 on down are copies of row 3, and you always want to use the value in J14, you need to fix it so it doesn't change when copied. That is what the absolute reference does. More info here: Working with Spreadsheets: Relative and Absolute References Date Time Of Last Edit: 2020-06-11 19:46:09
|
| [2020-06-12 10:36:18] |
| ULADZIMIR VALASACH - Posts: 38 |
|
I did not know - thank you very much for the clarification !!
|
To post a message in this thread, you need to log in with your Sierra Chart account: