Support Board
Date/Time: Tue, 04 Nov 2025 03:36:33 +0000
[Programming Help] - Variable not keeping constant..
View Count: 622
| [2020-02-27 04:44:04] |
| User917679 - Posts: 76 |
|
I would like to reference a constant(J9) in my trading formula, but when I run it to test, the spreadsheet cycles through J10,J11,J12 etc. instead of staying with the J9 value... How do I keep the code I write in my K-Z columns perpetually referencing the J9 cell? Date Time Of Last Edit: 2020-02-27 04:45:02
|
| [2020-02-27 13:12:42] |
| Sawtooth - Posts: 4285 |
|
Use an absolute reference: $J$9 Working with Spreadsheets: Relative and Absolute References |
| [2020-02-28 17:21:30] |
| User917679 - Posts: 76 |
|
Alright that worked great, but now with this same $J$9 in question, Is is possible to keep the average price (j9) of a previously opened position in memory from that opened duration? Because it always goes to what the avg price is with the current opened position right? So, is there a memory of what the avg. fill price was for each position? EDIT: I think I found a solution in the studies actually - "Trading: Position Average Price" Date Time Of Last Edit: 2020-02-29 01:33:09
|
To post a message in this thread, you need to log in with your Sierra Chart account: