Let’s imagine you want to compare metrics from several companies. How do you go about it?
Of course, you can run a search for each company you need. But if you have 10 or more companies and as many metrics, that’s 100 search queries that you‘d have to run. That’s a lot.
Luckily, we’ve created a handy solution and now we are presenting it to you. It’s a system of groups that allows you to group companies, assign a name to this list, and then get desired metrics for each company with only one query.
Just list the companies you want, name it, and then run searches for desired metrics using this name. It’s simple as that.
(AAPL_REPORT; GOOGL_REPORT; MSFT_REPORT) AS MyCompanies
Here’s how to do it step-by-step:
Type an opening “(“.
Start typing a company’s ticker or name.
From suggestions, select the one with ticker+Report; groups are highlighted blue, so it’s easy to spot one.
List your companies separated by “;”
Type a closing “)”, then type “ as “ + any name; we called it Alias.
The system will understand that you entered alias and will ask you to confirm it by pressing Enter; proceed as suggested; the alias will be created and moved to a new line.
When searching, enter your alias followed by a dot and select metrics you need.
Send off the query as usual and it will return all metrics for all the companies tied to that alias.
That’s not all. We can also add formulas to aliases, but we’ll talk about this in the next post.
What to read next…
OMG - It's ODM! (new search feature)
Calculate your own ratios!