Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Basic Normalized Net Income Per Share in Excel

This function helps you quickly retrieve the Basic Normalized Net Income Per Share figure (BNORMNETINCPS) for a specified stock ticker symbol, along with a particular fiscal Year, Quarter, or on a trailing twelve months (TTM) basis. With MarketXLS, you can seamlessly bring fundamental data into your Excel spreadsheets, enabling deeper financial analysis for better investment decisions.

Why Use This Function?

  • Quickly fetch “Basic Normalized Net Income Per Share” figures from a reliable data source.
  • Simplify stock analysis by combining the data with other Excel formulas.
  • Examine historical performance by specifying different fiscal years and quarters.
  • Compare normalized net income trends quarter-over-quarter or year-over-year.
  • Use trailing twelve months (TTM) data to understand the most recent performance without waiting for year-end results.

How to Use in Excel

=hf_basic_normalized_net_income_share(Symbol, Year, Quarter, [TTM])

• Enter the formula into any cell in Excel that has the MarketXLS add-in installed.
• Replace the arguments (Symbol, Year, Quarter, TTM) with your desired values.
• If you leave Quarter blank, it defaults internally (the add-in sets Quarter to "1" by definition, but if Quarter is passed in empty code-wise, it sets Quarter to "2"). To avoid confusion, always specify Quarter or TTM explicitly.
• The function returns the Basic Normalized Net Income Per Share or “NA” if no data is available or if the symbol is invalid.

Parameters Explained

Parameter Description Example Values Notes
Symbol The stock ticker symbol you want to retrieve data for "MSFT", "AAPL", "TSLA" Must be a valid symbol. If invalid, the function returns "NA".
Year The fiscal year for which you want to retrieve Basic Normalized Net Income PS "2022", "2021" If you enter an unsupported year or invalid format, the function may return "NA".
Quarter The specific quarter (1-4). Optional if TTM is specified "1", "2", "3", "4" If omitted or empty, it is handled internally. However, specifying it reduces ambiguity.
TTM Optional. "TTM" (without quotes) retrieves the trailing twelve months figure "TTM" If set, the function focuses on the trailing 12-month period instead of a single quarter.

Example Usage

Basic Examples

  1. Retrieve the most recent quarter’s Basic Normalized Net Income Per Share for MSFT in 2022 (assuming Q4 is the most recent): =hf_basic_normalized_net_income_share("MSFT", "2022", "4") Explanation: Looks up MSFT for the 4th quarter of 2022.

  2. Retrieve TTM data for AAPL in 2023:
    =hf_basic_normalized_net_income_share("AAPL", "2023", , "TTM")
    Explanation: Fetches the trailing twelve months (MRT) figure for AAPL for 2023. Quarter is left blank.

  3. Retrieve Basic Normalized Net Income Per Share for TSLA in 2021 Q1:
    =hf_basic_normalized_net_income_share("TSLA", "2021", "1")
    Explanation: Calls up TSLA’s Basic Normalized Net Income Per Share for the first quarter of 2021.

Advanced Scenarios

• Analyzing Quarter-Over-Quarter Changes:

  • Put multiple formulas across adjacent cells for consecutive quarters: Q1, Q2, Q3, Q4. Then create Excel formulas to calculate growth or percentage changes automatically.

• Comparing Different Companies:

  • Place multiple ticker symbols in a list (e.g., A2:A10). Reference the cell for each symbol in the “Symbol” parameter to analyze Basic Normalized Net Income Per Share across a watchlist of stocks in one go.

• Integration with Excel Charts and Forecasts:

  • Automate historical data retrieval for multiple years and plot trends in an Excel chart. Combine with other fundamental metrics to forecast potential performance.

• TTM Data for Rolling Roadmaps:

  • Use the "TTM" parameter regularly to keep your performance metrics fresh. Capture the data in a timeline to spot whether performance is consistently improving.

Common Questions and Troubleshooting

• What if the function returns "NA"?

  • Indicates the symbol may be invalid, data is unavailable, or your MarketXLS subscription level may not support this metric. Check your inputs and subscription plan.

• Do I need to provide both Quarter and TTM?

  • No. If you’re retrieving trailing twelve months data, simply use "TTM" in the last parameter and leave Quarter blank. If you only need a specific quarter, just specify Quarter 1 through 4.

• Why do I get "NA" for some quarters even though the symbol is valid?

  • The underlying dataset might not have that exact quarter’s data yet, or the company recently changed its fiscal cycle. Try verifying the reporting periods or consider using TTM.

• Can I reference cells for the parameters instead of typing them in directly?

  • Absolutely. For instance: =hf_basic_normalized_net_income_share(A2, B2, C2, D2) where A2, B2, C2, D2 contain the symbol, year, quarter, and TTM indicator, respectively.

By leveraging this function, you can streamline your fundamental analysis and reduce tedious data entry or manual lookups. Combine results with other MarketXLS functions to build robust financial dashboards and make more informed trading or investment decisions.