Support Board
Date/Time: Wed, 27 Nov 2024 08:41:22 +0000
[Programming Help] - Spreadsheet System for Trading - Store Highest Value from single cell
View Count: 286
| [2023-09-11 23:41:14] |
| thebeej - Posts: 7 |
|
I would like to be able to store the lowest value per bar from J10 (Open Profit/Loss) in a different column so I can reference it for a study. For example Trade 1 has a max open loss of -250, Cell P3 would show -250. Then if trade 2 occurs 10 bars later and shows a max open loss of -300 during that bar, Cell P3 would show -300, cells P4-P13 would show 0, and P14 would show -250. Note that I would like it to reference the lowest value within the bar, not the value at bar close. This would let me reference column P for a study to show max open loss per bar so I can easily identify where the trading system is getting into trouble. Is this possible? Thanks, BJ |
| [2023-09-12 00:00:37] |
| Sawtooth - Posts: 4120 |
|
Is this possible?
In a word, no.It's not possible in a spreadsheet study to capture an intrabar value. Cell J10 is dynamic and its value cannot be made persistent. It would be nice if one of the Trading:.... studies captured the Open P/L but, again, it's not possible to make an intrabar value persistent. What you want to do would require a custom ACSIL study. |
| [2023-09-12 02:16:59] |
| thebeej - Posts: 7 |
|
Ah im sorry to hear that. Thanks for the response, appreciate your time.
|
To post a message in this thread, you need to log in with your Sierra Chart account: