Shares Owned Formula in Excel

The Shares Owned formula in Excel (with MarketXLS) helps you quickly identify the number of shares held by the promoters of a company. By leveraging this function, you gain insights into the ownership structure of a stock, enabling more informed investment decisions. This powerful Excel function integrates seamlessly with MarketXLS to provide real-time data.

Understanding Shares Owned

• Purpose and Use Cases
  The SharesOwned function returns the number of shares held by the promoters of the company. This is particularly useful for investors who want to understand insider holdings and overall confidence in the company.

• Key Benefits

  • Quickly retrieve promoter shareholding data without leaving Excel
  • Compare promoter holdings across multiple symbols
  • Integrate the data into your existing financial models

• When to Use
  Use SharesOwned when evaluating a company's ownership structure, especially if promoter/institutional holding is a factor in your investment strategy.

Syntax and Parameters

Below is the syntax for using SharesOwned in Excel:

=SharesOwned(Symbol)

• Return Value
  The function returns a numeric value representing the number of shares held by the promoters of the specified company. If the symbol is invalid or the data is unavailable, it returns NA.

?? Note: Ensure you have a valid license for MarketXLS to avoid receiving error messages like "NA".

Examples and Usage

1. Basic Example

   =SharesOwned("MSFT")

   Retrieves the promoter shareholding for Microsoft Corporation.

2. Index Symbol

   =SharesOwned("^SPX")

   Although primarily intended for stocks, this usage shows how you can input an index symbol. Returns “NA” if data is not relevant.

3. Options Symbol

   =SharesOwned("@MSFT 110122C00020000")

   When used with option symbols, the function may return “NA” if promoter shareholding data is unavailable.

4. Crypto Symbol

   =SharesOwned("BTCUSD:DEFAULT")

   For cryptocurrencies, the function will typically return “NA”, as there are no promoter holdings associated with such digital assets.

? Pro Tip: Combine SharesOwned with other MarketXLS functions like Sector, Industry, or MarketCapitalization to gain a broader view of a company's profile.

Common Questions

1. What if I enter an invalid symbol?
   If the symbol is invalid, or if the data is not found, the function automatically returns NA.

2. Are there any performance considerations?
   Since SharesOwned relies on web queries, it may be slower than simple Excel calculations. Ensure a stable internet connection to minimize delays.

3. How often is the data updated?
   Data is typically cached for performance. For the most accurate real-time figures, ensure you refresh or recalculate your Excel workbook as needed.

4. Can I reference a cell for the symbol formula?
   Yes, you can reference a cell containing the symbol, for example:

   =SharesOwned(A2)

   This approach makes it easier to dynamically retrieve data for multiple symbols.

5. What if my MarketXLS license is invalid or expired?
   The function will return “NA” along with an error message. Renew or validate your license to regain full functionality.