Login Page - Create Account

Support Board


Date/Time: Thu, 16 Jan 2025 02:53:05 +0000



Post From: Open Position Data in Spreadsheet

[2017-09-27 20:10:27]
knoxville1915 - Posts: 38
I mean when the formula is referencing a live/updating cell such as those in column J. Let's say, for example, I was wanting to keep a record of Position Average Price as it was when the bar closed. If I reference (=J$9), all rows in that formula column update as the average price cell updates. I was wondering if there is a way to retain the value of a column J cell as it was when the bar closes?