How do I use something similar like LOOKUP on a piece of a sentence and pull the correlating values?

Question

Level 1

10 points

How do I use something similar like LOOKUP on a piece of a sentence and pull the correlating values?

For my trading dashboard I want to get insight of the win rate of different trading confluences and grouped confluences, but I'm already stuck in calculating the individual confluences.

Using COUNTIF(Confluence;"*Daily*") I manage to count each confluence. And I used LOOKUP when there was only 1 string of value in the confluence column.

How do I get a similar result like LOOKUP for "Daily", "Monthly" etc? So I can pull the value in the win/loss column from table one (Trade log) to my second table (Individual confluence results)?

And is there a way to automatically generate all possible confluence pairs in a third table?

Posted on Nov 18, 2024 10:56 AM

Reply

Answer 1

Top-ranking reply

Badunit

Level 7

28,216 points

Nov 18, 2024 12:46 PM in response to Steenkool

I don't understand your terminology but take a look at SUMIF.

When using wildcards, be careful you don't run into problems such as "bimonthly" being a match to *monthly* when you don't want it to be. There are none of these problems in what you posted, just pointing out a potential problem to be aware of.

Reply

Answer 2

Steenkool Author

Level 1

10 points

Nov 18, 2024 1:02 PM in response to Badunit

Oh wow.. Sorry 😅 Spend a lot of time trying to figure it out and totally overlooked SUMIF.. Thanks a lot 🥰

Reply