From the course: Excel for Investment Professionals

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Setting up time series data on a stock

Setting up time series data on a stock - Microsoft Excel Tutorial

From the course: Excel for Investment Professionals

Start my 1-month free trial Buy for my team

Setting up time series data on a stock

“

- [Instructor] Perhaps the most basic task that you may face when analyzing investments is just putting together pricing data on a stock. Let's take a look at how this is done. Now there's a lot of different sources out there for historical data on stocks, but one of my favorites, just because it's free and readily available, is Yahoo! Finance. So you can go to finance.yahoo.com and then type in the ticker symbol for the company you're looking for. In this case I'm going to use Microsoft. So we do that and it brings us to this page, the Microsoft stock "homepage." Now, we're looking for historical data. There's a variety pieces of information here, I'm certainly not going to explain all of it, but what we're mostly interested in right now, for our purposes, is grabbing historical data. Let's pretend that we're looking for daily stock price data over the last five years. Okay? So we're going to take the data from March 6, 2014 through March 6, 2019, and we're looking for this…

Contents