Analyze Financial Data in Excel #01: Connect to web w/ Power Query
In the first part of this series on stock market analysis using the Excel Power BI add-ins, we create a direct connection to Apple's (AAPL) historical stock prices in Yahoo Finance. The connection is created with Power Query. We then upload the data to the Power Pivot data model.
Use the following link to access Apple's historical prices from Yahoo Finance:
http://finance.yahoo.com/quote/AAPL/h...