• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Stocks in Excel

August 17, 2021 by Andrew Childress
Stocks data Excel

Markets go up, markets go down, but one thing is always the case: it's fun to track your stocks. Let's learn how to Review Stocks in Excel.

Markets go up, markets go down, but one thing is always the case: it’s fun to track your stocks. With the help of Excel’s built-in functions, you can monitor stocks in Excel easily. Connect directly to the data and pull every possible financial metric you may need.

How to Review Stocks in Excel

Let’s connect to stock data to review financial metrics and analyze the information.

Start by typing a stock symbol in a cell in your spreadsheet. This is the shortened, one to four character symbols that represent publicly traded companies. Use this page to search for stock symbols if you don’t know the one you have in mind.

Stocks data Excel

Then, switch to the Data tab on Excel’s ribbon. With the stock symbol cell selected, click on Stocks. Excel will convert the active cell to one that is connected to stock data. Notice the columns icon on the right side of the stock cell.

Click on this cell and you’re treated to a huge list of data you can pull in about the stock. That includes simple metrics like the price as well as more complex financial numbers like beta and P/E ratio, for example. For my example, I’m going to add the 52 week high, the highest stock price in a one year range.

choose field stock Excel

Now, let’s repeat the same step and add a new column, the current price, labeled Price. Remember: this data is connected and will update over time.

With this data in the spreadsheet, you can begin to work with it like normal numeric data. For my example, I’ll write a simple formula to compare the 52 week high versus the current price. It’s a simple subtraction formula to find how far off the 52 week high my stock is, shown in the example below.

Formula on stock in Excel

Make sure to spend time exploring all of the available metrics in this option. Keep adding more columns to show a complete set of stock screening information.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Autosum average in ExcelAutoSum in Excel
Next Post:Accrued Interest in Exceltyped accrued interest Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top