Stocks

4 lessons in order

Learn how to get live stock prices in Excel using built-in data types, web sources, Stock Connector add-in, and VBA with Alpha Vantage API.

Learn how to calculate beta in Excel using SLOPE, LINEST, COVARIANCE.P, VAR.P, and regression analysis with simple step-by-step methods.

Learn how to calculate alpha in Excel using single portfolio and market returns, and analyze historical data for accurate results.

Learn how to track a stock portfolio in Excel, retrieve live data, calculate returns, create charts, and summarize results with ease.