Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 02 May 2024 02:39:44 +0000
Open Position Data in Spreadsheet
View Count: 1384
| [2017-09-27 18:02:40] |
| knoxville1915 - Posts: 38 |
|
Good afternoon, Is there a way to get the open position average price within a spreadsheet study (not for trading)? Thanks! Date Time Of Last Edit: 2017-09-27 18:04:46
|
| [2017-09-27 18:20:02] |
| |
|
No, this is not supported. We could add it though, but the concern is that if we add that we would end up overwriting certain cells being used by other users who do not expect this data.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-09-27 19:08:57] |
| knoxville1915 - Posts: 38 |
|
I see, that is fine, I can transfer my spreadsheet into a spreadsheet for trading. On a formula column, is there a way for the historical rows (Row 4 and below) to be non updating? That is, to retain the value it had when the bar closed? |
| [2017-09-27 20:02:57] |
| |
|
Row 4 and below do retain the value when the bar has closed. You can also use another column on the Sheet, that is not one of the Formula Columns. This information here might also be helpful: Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [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?
|
| [2017-09-27 20:46:08] |
| |
|
We are not really sure how to accomplish that. In general this concept is not straightforward to accomplish in a Spreadsheet.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-09-28 00:58:57] |
| Sawtooth - Posts: 3989 |
|
The only column J values that are retained at bar close are those in the various Trading: ... studies. J9 is not one of them. You might be able to calculate the Position Average Price, then create a persistent variable of it in a Formula Column beginning in the referenced bar. This solution has many caveats, and would be complex at best. |
| [2017-09-28 01:06:16] |
| knoxville1915 - Posts: 38 |
|
Thank you all, I managed to piece together ACSIL code from the various study files to recreate the functionality I was looking for. It was a little daunting, but I'm excited to continue exploring its possibilities! It's about time, I've hitherto been over relying on spreadsheets. |
To post a message in this thread, you need to log in with your Sierra Chart account: