How to Get Stock Quotes in Excel

Open Microsoft Excel. First, select 'Start' from the main operating system menu. Next, choose 'Programs.' Then, click on 'Microsoft Office' in the programs menu. Finally, select 'Microsoft Excel' from the Microsoft Office menu.
Click on the 'Data' menu from the Microsoft Excel main menu screen. Then, choose 'Get External Data' from the data menu. A dialog box will appear with a list of established data sources. Finally, choose the data source labeled 'Investor Stock Quotes.'
Select the cell in the spreadsheet for the stock quote information input or choose the 'Create New Worksheet' option to place the stock quote in a new worksheet. After selecting either option, select 'OK' from the dialog box.
Type the stock ticker symbol into the next Microsoft Excel dialog box. If the user wants to update the stock quote in the future, choose 'Use this value/reference for future refreshes.' Also check the second check box if you would like the information to refresh on its own.
Save the Microsoft Excel file for future use. Select 'Save' from the main file menu, name the file and choose the appropriate place on the computer hard drive to save it.

How to Buy Kroger Stock (5 Steps)

Go to your favorite investment research site for a quote. Popular investment research sites include Yahoo! Finance, Google Finance, and MSN Money. While each website has its strengths and weaknesses, stock quotes for Kroger will be the same. The ticker symbol (exchange symbol) is KR. Input KR into the quote box for a current market price for the stock.
Research the stock on the investor relations section of the company's website. This website has contact information and stock price data as well. You can email Kroger's investor relations department at kroger.investors@kroger.com or call at 513-762-4366.
Determine the price at which you would like purchase Kroger stock by looking at the price chart over the past three years. This will help you to track highs and lows in stock prices. The goal is to buy low and sell high.
Determine how many shares you would like to purchase. If you have $5,000 to invest you can divide $5,000 by the current share price for Kroger for the maximum number of shares you can afford.
Place an order with your broker at BNY Mellon. BNY Mellon is the transfer agent and registrar for Kroger stock. You may be able to pay lower commissions if you purchase your Kroger shares through a BNY Mellon account (if you have one). If you do not have an account with BNY Mellon, place an order with your personal broker or through an online broker.