Support Board
Date/Time: Sun, 24 Nov 2024 16:40:13 +0000
[Programming Help] - Counting Trades Vs Signals in The Spreadsheet
View Count: 186
| [2024-05-29 14:56:45] |
| alexo2022 - Posts: 47 |
|
I have a trading system that gets into trade every time the market touches a certain line. I've also setup to not enter multiple trades while I'm in a trade. I want to count how many time I got a trade using this line, the problem is that while in a trade and if there's a signal it activates the buy entry, and is counts also as a trade although it's not actual trade. My question is how can I count only the trades that actually happen, vs the trades that were mixed with other trades that not really occurred. For example during the trading day the data could be: 3 trades 9 trades with signals. |
| [2024-05-29 15:05:32] |
| Sawtooth - Posts: 4119 |
|
What are you doing to count all signals?
|
| [2024-05-29 17:11:39] |
| alexo2022 - Posts: 47 |
|
I have study for signal, and I have a column that count if signal and buy entry column = 1, then count 1.
|
| [2024-05-29 22:13:39] |
| Sawtooth - Posts: 4119 |
|
You could compare that column's count with cell J52
|
| [2024-05-30 02:24:17] |
| alexo2022 - Posts: 47 |
|
ok, and what if I have 2 lines, and I want to know how many trades were from lime 1, and how many from line 2. |
| [2024-05-30 02:50:16] |
| Sawtooth - Posts: 4119 |
|
I want to know how many trades were from line 1, and how many from line 2.
There is no easy way to do that. It may not be possible.You'd have to use two Formula Columns to count entries at prices near each line. |
| [2024-05-30 04:26:14] |
| alexo2022 - Posts: 47 |
|
Can you give me example ?
|
| [2024-05-30 12:45:23] |
| Sawtooth - Posts: 4119 |
|
It wouldn't be based on actual entries, but on entry signals. If the signal is n ticks from a line, then count it. If the lines are close together, you may not be able to differentiate entries. |
To post a message in this thread, you need to log in with your Sierra Chart account: