Market Share?

Manage
1

Is there any way of getting at a company’s market share with P123 data? If not I ask that it be added - I think it’s increasingly important in this “winner-take-all” economy.

Thx,
Ed

2

How about SalesQ vs Industry or sub industry?

3

Hmm. I think the easiest way would be something like this:

GICS(10)
FRank("MktCap",#previous)>=90

But that’s almost a trivial answer, and it’s not very good. (You can also replace market cap with sales, and it is an equally bad kludge.)

Here’s the thing: Companies will sometimes do more than one thing, and those other activities may or may not be related to their industry classification.

When I was at Value Line in the 1990s, I was one of the apparel analysts. Most of my companies were in basic apparel (underwear), and so I was following the stocks in the apparel industry pretty closely. As well as Sara Lee, the baking company, which owned Hanes at the time.

For another, more modern example, consider Amazon. It’s in the Internet & Direct Marketing Retailer industry (of course it is), but its Amazon Web Services division provides B2B server hosting, and many, many sites use it. A quick search shows that Amazon had a 37% market share in the infrastructure-as-a-service market in 2013, and it’s probably gone up since. It would be one of the shining stars of the Software & Services subsector, but it’s not in there. It’s not even in the IT sector.

I think that makes the trivial bit up there the best that we can do.

4

OK, sounds like we need additional data.

5

How do you define market share? I’ve seen some groups define it as a % revenue share of a given market, but others define it as % profit.

For example, Apple is a small slice of the smart phone market on a revenue basis, but the far-and-away leader in terms of profit share.

Why not:
setVar(@RevenueSharePct, SalesTTM/FSum(“SalesTTM”, #Industry) )

6

That’ll work, thanks.

7

The formula shared by Primus does not work : setVar(@RevenueSharePct, SalesTTM/FSum(“SalesTTM”, #Industry) )

I think is because there is no “sales” data for Industry.

Does anyone have and idea of how could get the market share in terms of revenue or EBIT or any income metric)?

Thank you ver much in advance

8

The formula still works. Why do you say it doesn’t? If you want a percentage figure you could multiply it by 100.

9

I must be doing something wrong. I set up the formula but the results always come out “1.00” for all the companies. I attach an image of the formula and another of the result of a screener where the formula information is shown.

Formula: https://ibb.co/YW0kSC6
Screener results: https://ibb.co/NFsskLV

10

I’m not sure why you’d put SetVar in a custom formula, but on the face of it this doesn’t make sense. If you want to use a custom formula, leave out the SetVar and just use SalesTTM/FSum(“SalesTTM”, #Industry). If you want to use it in a screen and see the result, use ShowVar rather than SetVar. SetVar is useful for using the result in a subsequent line without showing it.

11

Oh, yes. You are right. I was making that mistake. Sorry and thank you for your help.