Price Per Sales (TTM) Formula in Excel

Price Per Sales (TTM) is a valuable metric in Excel that helps compare a company’s stock price to its total sales over the trailing 12 months. By using MarketXLS, you can quickly pull real-time or delayed data for this ratio directly within Excel—allowing you to make more informed investment decisions.

Understanding Price Per Sales (TTM)

• The Price Per Sales (TTM) metric indicates the amount investors are willing to pay for each dollar of the company’s sales in the last 12 months.
• It’s a key performance ratio often used in fundamental analysis to assess whether a stock is undervalued or overvalued.
• Analysts and investors use this ratio to compare companies of similar size within the same industry.

? Pro Tip: Lower Price Per Sales values can sometimes indicate more attractive valuations—but always verify other fundamentals and market conditions.

Syntax and Parameters

Below is the basic syntax for using the PricePerSales function in Excel with MarketXLS:

=PricePerSales(Symbol)

Return Value

• Typically returns a numeric ratio indicating how many dollars of stock price per dollar of trailing twelve-month sales.
• Returns "NA" if the symbol is invalid or if there is an issue with your MarketXLS license or network connection.

?? Note: This function requires an active internet connection and a valid MarketXLS license to retrieve real-time or delayed data.

Examples and Usage

Basic Example

Pulling the Price Per Sales (TTM) ratio for Microsoft:

=PricePerSales("MSFT")

Indices, Options, and Crypto Examples

• Get the ratio for the S&P 500 Index:

=PricePerSales("^SPX")

• Check Price Per Sales for a Microsoft call option:

=PricePerSales("@MSFT 110122C00020000")

• Retrieve the metric for Bitcoin (BTC/USD):

=PricePerSales("BTCUSD:DEFAULT")

Cell References for Symbol

• Referencing a cell that contains the symbol:

=PricePerSales(A2)

(Where A2 might have the text "MSFT")

Common Questions

1. What happens if my symbol is invalid or spelled incorrectly?

   • The function returns "NA". Ensure the symbol matches a valid listing.

2. Why am I seeing “NA” even for a valid symbol?

   • Check your internet connection and MarketXLS license status. A license or data connectivity issue can cause “NA.”

3. Is there any performance concern with using PricePerSales extensively?

   • Functions that fetch live data can slow spreadsheets if used on many cells. Use them strategically or consider caching your results.

4. Can I use this function for quick comparisons across multiple stocks?

   • Yes. Create a list of symbols, use PricePerSales in adjacent cells, and quickly compare the returned ratios side by side.

? Pro Tip: Combine different MarketXLS functions (like MarketCapitalization or EPS) alongside PricePerSales to gain deeper insights into a company’s valuation.