Stock Price Example
Source for the stock price data file:Yahoo! Finance
The Download to Spreadsheet command creates a .csv file
Example file google.csv opened with Wordpad
An Easy Shortcut
Using the Data tab
The Dialog using the From Text option
Excel Will Assist You…
Here’s the result
Using a Macro to Read Data
Reversing the Data
Stock Price Technical Analysis
Moving Averages
Close vs Moving Average
Your Assignment
Above and Beyond