ETFIndia
,

US Stock Market – Live Data – Stocks Analyzer

Download Excel template to analyze stocks in US Stock Market, on two different measures out of 16 measures. Choose an industry to analyze stocks. Choose specific stocks to compare.

US Market Industry Analyzer Excel Template
US Market Industry Analyzer

In this article, we will be discussing the US Market – Industry Analyzer template that you can use to analyze stocks.

The template can assist in

  • Analysis of the stocks across any two measures (out of 16 measures available) – for example, Price and Market Cap, Trading Volume and Price – in a scatter plot
  • Analysis of stocks in any specific industry – for example, Telecommunications industry, Pharmaceuticals industry, etc.
  • Comparing two or more specific stocks across various measures
US Stock Market Analyzer Excel Template

Download

Video Demo

How to use the template?

The template automatically creates a scatter plot of 529 stocks in the US Stock market, across two measures.

The user has the following 6 input controls to customize the chart.

US Stock Market Industry Analyzer Input controls
Input Controls

X Axis Measure

Y Axis Measure

Y Axis Measure selection
Measures drop down

The following 16 measures are available for analysis.

  1. Price
  2. Change
  3. Change (%)
  4. High
  5. Low
  6. Open
  7. Previous Close
  8. 52 week high
  9. 52 week low
  10. Employees
  11. Market cap
  12. P/E
  13. Beta
  14. Shares Outstanding
  15. Volume
  16. Volume average

Label

Toggle between Ticker Symbol and Name of the Stock)

Label Selection
Label selection

When you have a lot of stocks in the chart, the ticker symbol will be better to use as it will be less cluttered on the chart. When you have only a few stocks to analyze, the Name option is better as it clearly displays the company name. If you know your ticker symbols very well, then you can stick with the Ticker Symbol itself.

Exchange filter

Exhange filter
Exchange Filter

You can filter to specific exchange(s) if you would like.

Industry filter

Exchange and Industry filters
Industry Filter

You can select one or multiple industries for analysis

Ticker Symbol filter

Ticker Symbol filter
Ticker Symbol Filter

Finally, you can choose one or multiple stock ticker symbols.

Timezone

Last Trade Time Offset
Last Trade Time

On the top right you can see the maximum of the last trade time of these currencies.

The default time that Microsoft provides is UTC.  The offset is set to -7 hrs, to convert to pacific time zone.

You can modify this if you need the time in a different time zone.

Visit https://savvytime.com/converter/utc to view offset

How to refresh data?

How to refresh Stocks data
How to refresh Stocks data

Sample Analysis

You can use various combinations of these inputs to analyze the stocks according to your needs. Here are some samples of what can be done using this template.

  • Of all 529 stocks, Price vs Change %
US Stock Market Industry Analyzer Price vs Change
All Stocks – Price vs Change %
  • Pharmaceuticals industry – Price vs P/E
US Stock Market Industry Analyzer Pharma Industry
Pharma Industry – Price vs P/E
  • Passenger Transportation Services industry – Price vs Volume
US Stock Market Industry Analyzer Passenger Transport Industry
Passenger Transportation Services industry – Price vs Volume
  • Starbucks and McDonald’s – Price vs Employees
US Stock Market Industry Analyzer Starbucks vs Mc Donalds
Starbucks and McDonald’s – Price vs Employees
  • Mastercard and Visa – Employees vs Market Cap
US Stock Market Industry Analyzer Master Card vs Visa
Mastercard and Visa – Employees vs Market Cap

Requirements

To pull live Stock data from the services you would need Microsoft 365 Subscription Plans for PC and Web

How to add a new stock?

The stocks or the ticker symbols in the Dow Jones, S&P 500 and Nasdaq 100 are included. You can also add your own stocks and I will explain how that can be done easily. 

Unhide the hidden DATA sheet and follow this simple two-step process to add new stocks to analyze.

Steps to add new stock
How to add new stocks
  1. Extend the table to more rows as needed
  2. Enter stock symbol

If Excel does not recognize your stock symbol, it will pop up this data selector box.

Select-the-stock-from-the-list

You can select the stock you are interested in.

For more templates in this series, please visit indzara.com/stock-market-templates

Feedback

Please share your feedback on this template in the Comments below. If you find this useful, please share with your friends who may benefit from this content.

ETFIndia

2 responses

  1. Unbelievable work!

    Thank you!

    1. Indzara INDZARA team

      Thank you for sharing your valuable feedback.
      Best wishes.

Leave a Reply

Your email address will not be published. Required fields are marked *

Trays of papers, tasks and stock, sorted and checked off

One family of Indzara apps.

  • Indzara PEOPLE

    All plans are free for 14 days.

    Lifetime 50% OFF for our first 100 customers.

    Start free
  • Indzara PROJECTS

    All plans are free for 14 days.

    Lifetime 50% OFF for our first 100 customers.

    Start free
  • Indzara BUSINESS

    All plans are free for 14 days.

    Lifetime 50% OFF for our first 100 customers.

    Start free

Built by INDZARA

US Market Industry Analyzer Excel Template

US Stock Market – Live Data – Stocks Analyzer

Free

Terms and conditions

Launch offer

All plans are free for 14 days.

Enjoy the lifetime 50% OFF introduction offer for our first 100 customers.

Built by INDZARA

Terms and conditions