Support Board
Date/Time: Wed, 27 Nov 2024 08:35:21 +0000
Post From: Spreadsheet System for Trading - Store Highest Value from single cell
| [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 |