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

RankValue Function for Stock Valuation Analysis

The RankValue function (fn_01349) helps you seamlessly retrieve a single numeric score indicating a stock’s valuation metrics within your Excel spreadsheet using MarketXLS. It’s ideal for quickly gauging whether a stock may be undervalued or overvalued, drawing from broad factors such as P/E ratio, P/B ratio, dividend yield, and more. This saves time when you need a concise, data-driven value insight without manually searching through multiple data sources.

Why Use This Function?

  • Quickly retrieve a combined value score for a given stock symbol in Excel.
  • Ideal for preliminary screening—helps identify potentially undervalued or overvalued stocks.
  • Integrates smoothly into existing spreadsheets, enabling reporting and modeling.
  • Updates leverage MarketXLS’s caching mechanism to reduce repeated calls, enhancing performance for large portfolios.
  • Automatically returns “NA” if an invalid symbol or an error occurs; no guesswork needed.
  • Perfect for both individual investors conducting due diligence and professional analysts managing diverse watchlists.

How to Use in Excel

=RankValue("AAPL")
  1. In any Excel cell, type =RankValue(""), followed by a valid US stock Symbol in quotes.
  2. Press Enter to retrieve a numeric score.
  3. MarketXLS will handle licensing checks and data retrieval behind the scenes.

If the function is pending data or the service is refreshing, it may temporarily return “Refreshing.” If it cannot find valid data or an invalid symbol is provided, you'll see “NA.”

Parameters Explained

Parameter Description Example Values Notes
Symbol The ticker symbol (as a string) for which you want the rank/value score. "AAPL" Must be a valid stock ticker. If invalid or data is unavailable, the function returns "NA".

• There are no additional optional parameters.
• Ensure the symbol is correct to avoid "NA" responses.

Example Usage

Basic Examples

  1. =RankValue("MSFT")
    • Returns a numeric value representing Microsoft’s “value” relative to various fundamental metrics.
    • A quick way to compare MSFT’s rank with other stocks in your sheet.

  2. =RankValue("TSLA")
    • Useful for rapidly checking Tesla’s valuation score.
    • Combine with conditional formats to highlight high or low scores.

Example with a cell reference: • Assuming cell A2 has the symbol “GOOGL”: =RankValue(A2)

Advanced Scenarios

• Combining with IF statements for rapid evaluations: =IF(RankValue("AMZN")>10, "Potentially Undervalued", "Monitor Further")

• Using with watchlists:

  • Create a list of symbols in column A (e.g., A1:A10).
  • In column B, input =RankValue(A1) and drag down for each row.
  • Instantly compare multiple stocks’ value scores side by side.

• Integrating with other fundamental and technical MarketXLS functions (e.g., retrieving dividend yields, P/E ratios, or chart-based signals) to build comprehensive dashboards or screening tools.

Common Questions and Troubleshooting

  1. Why am I getting “NA”?
    • The Symbol may be invalid or unrecognized. Double-check spelling and availability.
    • Licensing issues or server errors could also produce “NA.” Verify your MarketXLS license status.

  2. Why does the function sometimes return “Refreshing”?
    • This occurs when data is being fetched or updated. The RankValue function uses caching and waitlist mechanisms; once data is ready, the final numeric score will appear.

  3. Does RankValue measure only one metric like P/E or P/B?
    • No. The external calculation may combine multiple fundamental factors—like P/E, P/B, and others—to produce a single numeric “score.” Exact calculation is performed on MarketXLS servers and your local Excel only shows the final returned value.

  4. Can I use it for non-US market symbols?
    • Typically, it’s optimized for major US exchanges. If no data is found for international symbols, you'll likely get “NA.”

  5. Are there any performance concerns with large watchlists?
    • MarketXLS implements caching to help mitigate performance issues, but a very large spreadsheet with hundreds of symbols may require patience while data loads.

By leveraging RankValue in Excel with MarketXLS, you gain a quick snapshot of a stock’s valuation standing. Whether you manage a personal watchlist or a professional portfolio, RankValue makes it easy to stay informed on potential investment opportunities.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Value Score and Other Financial Formulas
How does MarketXLS work?