# Updating a stock price on an Excel sheet?

**URL:** <https://boards.straightdope.com/t/updating-a-stock-price-on-an-excel-sheet/549154>\
**Category:** Factual Questions\
**Created:** [August 4, 2010, 3:32pm UTC](https://boards.straightdope.com/t/updating-a-stock-price-on-an-excel-sheet/549154 "2010-08-04T15:32:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![emacknight](https://avatars.discourse-cdn.com/v4/letter/e/3ec8ea/32.png) [@emacknight](https://boards.straightdope.com/u/emacknight)\
**Post date:** [August 4, 2010, 3:32pm UTC](https://boards.straightdope.com/t/updating-a-stock-price-on-an-excel-sheet/549154/1 "2010-08-04T15:32:00Z")

</div>

I’d like to have an Excel spread sheet that can keep track of a specific stock price, for simplicity let’s say Apple, ticker symbol AAPL

Is there a way to do that? It doesn’t need to be up to the minute, I’d be happy with the previous day’s close.

I realize there are at least two issues involved: 1) getting the stock price, 2) calling that data in Excel. I figured someone that knows html (xtml?) would be able to get the price data from [Yahoo](http://finance.yahoo.com/q?s=AAPL), then it’s just a matter of calling it in Excel.

Thanks

---

<div class="post-metadata">

**Author:** ![emacknight](https://avatars.discourse-cdn.com/v4/letter/e/3ec8ea/32.png) [@emacknight](https://boards.straightdope.com/u/emacknight)\
**Post date:** [August 4, 2010, 3:40pm UTC](https://boards.straightdope.com/t/updating-a-stock-price-on-an-excel-sheet/549154/2 "2010-08-04T15:40:14Z")

</div>

Oops, turns out this is insanely easy. Click on the “data” tab, then click “From Web”

A little screen will pop up where you can view the page with the data on it

> **[Apple Inc. (AAPL) Stock Price, News, Quote & History - Yahoo Finance](https://finance.yahoo.com/quote/aapl?ltr=1)**
>
> Find the latest Apple Inc. (AAPL) stock quote, history, news and other vital information to help you with your stock trading and investing.

The next feature is kind of neat, the page will have little yellow arrows indicating data you can pull. If you scroll down a bit it will have an arrow next to the current stock data. Click that arrow then “insert.”

It will ask you where to insert the data, so you should know that before hand.

I think the next step once it’s in is to click the “refresh” button under “data” to update it.