Support Board
Date/Time: Fri, 07 Feb 2025 20:50:45 +0000
Post From: incorrect position opening in Spreadsheet System for Trading
| [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
|