Support Board

Date/Time: Wed, 15 May 2024 00:16:54 +0000

Post From: incorrect position opening in Spreadsheet System for Trading

[2020-06-11 19:43:58] Link To Thread - Link To Post [Go To First Post]
bradh - Posts: 857
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