Support Board
Date/Time: Thu, 13 Feb 2025 07:59:11 +0000
Post From: Spreadsheet Help: How to sum instances by day
| [2020-10-30 20:30:14] |
| Atlatyl - Posts: 19 |
|
I'm importing targets from a Daily chart into a 10 range bar chart, and trying to get whether or not the upside target or downside target are hit *for that day* on the 10 range bar spreadsheet. No problem to do this on the Daily spreadsheet....My problem is I get multiple instances on the 10 range bar column as it chops around the target. How do I either collate those instances into just 1 per each day going back any number of days; or stop collecting the "hit" data after the first hit for the day? Once I have this, I can add indicators/conditions to get stats on which target is likely to be hit for the day. For example.. if I apply a 10SMA to the 10 range bar chart, and I have a 10 range bar close under the SMA as a trigger, and the 10SMA is heading south..., I want to see how many times out of 30 days that hits my lower target. Hope this makes sense? Thanks in advance : ) |
 ____Targets.jpg / V - Attached On 2020-10-30 20:28:52 UTC - Size: 162.53 KB - 254 views Attachment Deleted. |