The Complete Investor Bootcamp

Gather vast data from free sources like Yahoo! Finance, then analyze stock prices, company financials, and related news to gain a competitive edge as a retail investor.

Navigate Yahoo Finance to research stocks with ticker symbols, view current price and daily change, and analyze customizable charts with interval options and volume versus average.

Analyze market cap and beta to assess risk, study the price-to-earnings ratio, trailing earnings per share, dividends and yields, ex-dividend dates, and one-year estimates, and download prices with Yahoo! Finance.

Learn to download analysis-ready historical stock prices from Yahoo! Finance into Excel. Choose the date range and data frequency, and use the adjusted close price for analysis.

Learn to fetch historical stock prices in Google Sheets using Google Finance for Microsoft and Apple. Export the data to Excel and link Google Sheets for live updates.

Format an Excel worksheet for clarity by applying a white fill, setting Arial 9, adjusting first column to 1.25, and creating a bold, dark blue title labeled 'formatting a worksheet'.

Learn to access a company's financials beyond price data by using investor relations pages and SEC filings, downloadable as Excel, and prepare data for analysis.

Discover the difference between owning stock and investing in index funds, learn how diversification lowers risk, and why a long-term, passive approach often beats active stock picking.

Explore famous stock indexes: Dow Jones Industrial Average, S&P 500, Wilshire 5000, Nasdaq Composite, Nikkei, and MSCI ACWI, and learn how they measure market performance and guide portfolio construction.

Explore how to calculate rates of return by distinguishing asset types, understanding holding period return and total return, and comparing arithmetic and geometric mean returns with compounding.

Learn to compute the holding period return, the average return, and the geometric mean return for a stock in Excel using adjusted close prices from Yahoo Finance.

Learn to assess asset returns by calculating mean, variance, and standard deviation, using population and sample formulas. Explore covariance and correlation to understand how two assets move together.

Learn how to compute variance and standard deviation of returns in Excel, using var and stdev for sample data, and interpret volatility to compare investment risk.

Learn to compute covariance and correlation between Apple and CM's energy in Excel using monthly adjusted close prices; interpret a positive covariance and a 0.19 correlation to assess diversification benefits.

Learn how to compute portfolio return using weights and asset returns; understand portfolio variance via covariance and correlation, illustrated with an Amazon and Facebook example.

Compute two-asset portfolio return and risk in Excel using weighted averages, variance, covariance, and correlation, with annualization rules illustrated by Apple and CM's energy.

Explore risk aversion and how risk averse, risk neutral, and risk seeking investors choose investments by balancing return and risk across assets.

Explore how risk aversion, utility functions, and indifference curves guide portfolio choices by balancing return, risk, and the risk aversion coefficient.

Diversify across asset classes - stocks, bonds, and cash equivalents - to reduce risk and cushion portfolios in downturns. Review performance from small-cap to large-cap stocks and bonds, and the power of compounding.

Distinguish historical from expected returns and assess how skewness, fat tails, and liquidity influence investment risk, before calculating mean, variance, and covariance of asset returns.

Explore how the correlation coefficient shapes portfolio variance and risk across plus one, zero, and minus one correlations, using a two-asset example to illustrate diversification benefits.

Learn how diversification reduces risk by combining assets with imperfect correlations, forming an expanding investment opportunity set that widens the risk-return frontier across asset classes.

Explore the minimum variance frontier and global minimum variance portfolio to understand lowest-risk options for a given return, and how the efficient frontier and capital allocation line guide risk-averse choices.

Build the minimum-variance portfolio and the efficient frontier in Excel using 11 two-stock portfolios. Compute returns and standard deviations, plot the frontier, and identify efficient versus inefficient points.

Learn how the capital allocation line blends a risk-free asset with the optimal risky portfolio to optimize return. Apply the two fund separation theorem to this approach.

Identify the optimal risky portfolio where the capital allocation line tangents the efficient frontier, maximizing the Sharpe ratio using Excel solver to adjust Apple and CMS Energy weights.

Construct the capital allocation line by combining the risk-free asset with the optimal risky portfolio, illustrating the two-fund separation, borrowing, and how weights shape return and risk.

Explore the two fund separation theorem and the capital allocation line to identify the optimal risky portfolio blended with the risk-free asset, guided by investor risk preferences.

Learn how the risk-free asset expands the opportunity set and, with the optimal risky portfolio, defines the capital allocation line and the two-fund separation theorem for tailored risk-return choices.

Explore the capital market line under CAPM, linking the risk-free asset and the market portfolio (e.g., the S&P 500), and illustrate lending, borrowing, and leverage along the market slope.

Differentiate systematic and unsystematic risk, showing that diversification can nearly eliminate unsystematic risk with 25–30 non-correlated stocks, while systematic risk remains unavoidable for all portfolios.

Explore return-generating models that estimate expected security yields using factors and betas. Learn macroeconomic and fundamental models, plus the Fama-French three-factor framework with market, SMB, and HML.

Calculate and interpret beta as a security's market risk relative to the market portfolio, using covariance and variance; identify defensive stocks with beta below 1 and aggressive stocks above 1.

Master regression analysis to connect dependent and independent variables, model a linear relationship, and forecast outcomes like housing prices from historical data.

Calculate beta in Excel using three methods: covariance over market variance, regression, and the slope function. Customize time frames, data frequency, and benchmark indices like the S&P 500.

Explore the capital asset pricing model (capm), which states that a security's expected return equals the risk-free rate plus beta times the equity premium, linking return to systematic risk.

Explore how the security market line graphically represents CAPM by plotting beta against expected return, with the risk-free rate on the y-axis and the market risk premium shaping the slope.

Learn how the capital asset pricing model links market risk to expected return, using the risk-free rate, market premium, and beta to price securities and construct portfolios.

Apply the capital asset pricing model to assess risk and return, compare expected versus required returns, and identify overvalued or undervalued stocks using the security market line.

Explore risk-adjusted performance with the Sharpe ratio and the M squared ratio, comparing excess return over the risk-free rate per portfolio's total risk and ranking portfolios against the market.

Examine the treynor ratio and Jensen's Alpha, using beta and systematic risk to assess portfolio performance and alpha as over- or underperformance relative to the market.

Compare and interpret portfolio performance using Sharpe, Treynor, M squared, and Jensen's Alpha, distinguishing total versus systematic risk to choose appropriate measures for diversified and non-diversified funds.

Explore debt and equity securities, including bonds with face value and coupons, and equity features like common and preferred stock, voting rights, dividends, and optional convertibility.

Explore how dual class voting structures concentrate power, as Berkshire Hathaway's Class B shares and Facebook illustrate, with 10 votes per share and capital raised without diluting influence.

Explore private and public equity, including private placements, leveraged buyouts, venture capital, mezzanine funding, and exit options such as IPOs.

Explore non-domestic stocks by comparing direct investing with depository receipts—ADR, GDR, and global registered shares—while examining currency risk, liquidity, and regulatory considerations.

Explore how equity returns include dividends, capital gains, and foreign exchange gains. See how currency movements and reinvested dividends shape risk and total returns across different share types.

Learn how equity financing supports liquidity, going concern, and regulatory compliance while enabling organic growth through asset purchases, research and development, stock option incentives, inorganic growth via mergers and acquisitions.

Compare the book value of equity with market value to assess if a stock is overvalued or undervalued; book value reflects retained earnings, market value reflects investor expectations.

Compute return on equity (ROE) to gauge how well management uses capital, using net income over average common equity, and compare with price to book ratio for sustainable performance.

Learn how the cost of capital sets the minimum return investors require, reflecting opportunity costs and the financing mix of debt and equity, with CAPM and the dividend discount model.

Explore industry and company analysis to identify competitive advantages, understand market conditions, and guide stock selection, valuation, and portfolio performance attribution through top-down and sector rotation insights.

Classify companies by products or services, by business cycle sensitivity, and by statistical similarities. Explore examples from the IT sector, media, and utilities, and understand the limits of cluster analysis.

Explore commercial industry classification systems such as GICS, ICB, and Russell Global Sectors, and how multi-level structures from sub industry to sector enable comparison and valuation.

Understand how governmental classification systems organize firms by economic activity with six-digit codes and five aggregation levels. See how manufacturing examples illustrate cross-country consistency and contrast with commercial systems.

Explore how firms are categorized as cyclical or non-cyclical based on business cycle sensitivity, with defensive and growth subtypes and real‑world examples; learn about limitations of labeling across economies.

Form comparable peer groups by selecting firms with similar industry, business activities, and demand sources. Use these comparisons to benchmark valuation and uncover price-to-earnings deviations.

Learn to gather information, analyze industry trends, forecast scenarios, and assess competitive edges using Porter's five forces, life cycle stages, and economies of scale to inform investment decisions.

Learn to analyze competition using Porter's five forces, including rivalry among competitors, threat of new entrants and substitutes, and buyer and supplier power, to build forward-looking industry strategies.

Explore how entry barriers shape pricing power and profitability, using examples from Visa and MasterCard, airlines, and restaurants to show price elasticity and market competition.

Explore how industry concentration shapes pricing power, price coordination, and market share, with examples from Google, Apple, Pepsi, and Coca-Cola, and the roles of differentiation and brand loyalty.

Understand how industry capacity affects pricing power and competition, with capacity fixed short-run and adjustable long-run. Examine examples from airlines, semiconductors, shipping, and firms like Microsoft and Tesla.

Explore the industry lifecycle model, tracing five stages from embryonic to decline and how evolution shapes profitability. Analyze stages to guide investment decisions and competitive strategy.

Explore barriers to entry and high concentration in branded pharmaceuticals and soft drinks, and how brand loyalty, patents, and regulation shape pricing and market stability.

Explore how external influences shape profitability by examining macroeconomic factors, technology shifts, demographics, government policy, and social trends, and their effects on demand, investment, and industry growth.

Analyze a firm's financial condition, products, services, and competitive strategy to identify responses to external threats and opportunities; compare low cost leadership and differentiation to guide equity investments.

Explore how the financial system, via markets and intermediaries, transfers assets and risks with stocks, bonds, currencies, and derivatives, to save, borrow, raise equity, manage risks, and allocate capital efficiently.

Cover six purposes of the financial system: saving for retirement, borrowing at low cost, issuing equity, hedging risk with derivatives, exchanging assets, and information-based trading.

Explain how saving moves money to the future and borrowing moves money to the present, and define the equilibrium interest rate as the balance of money supplied and demanded.

Classify assets into real, intangible, and financial types—covering securities, derivatives, currencies, and their markets, including spot and forward, primary and secondary, money market and capital market.

Explore debt and fixed income securities, equity, and pooled investment vehicles, including bonds, notes, common stock, preferred stock, warrants, convertible bonds, T-bills, CDs, and repos.

Explore major pooled investment vehicles—mutual funds, ETFs, hedge funds, and open end and closed end funds—and learn NAV per share, fund structure, diversification benefits, high watermark, and redemption terms.

Explore currencies issued by central banks, including reserve currencies like the dollar and euro. Understand the foreign exchange market's liquidity and turnover, and how access levels shape bid-ask spreads.

Learn how derivative contracts derive value from underlying assets, covering forwards, futures, swaps, options, and credit default swaps, and explore hedging, liquidity, and counterparty risk.

Explore real assets—physical investments like precious metals, commodities, and real estate—and compare direct ownership to REITs or mining stocks, noting unique properties, costs, inflation hedging.

Explore financial intermediaries, from brokers and exchanges to alternative trading systems and custodians, and learn how they match orders, disclose information, and enable IPOs, M&A, and large trades.

Explain how dealers trade on their own account to provide liquidity and profit from spreads, sometimes acting as broker dealers, while securitization pools assets into tranches and securities.

Explore depository institutions like banks and credit unions that raise and lend capital through deposits and loans, earning from the interest rate spread and connecting depositors with borrowers.

Explore how insurance companies manage risk by pooling diversified policyholders and transferring risk through premiums. Understand underwriting policies that address moral hazard, adverse selection, exclusions, and fraud.

Explore how arbitragers profit from price differences across markets, provide liquidity, and use replication and hedging to exploit pricing discrepancies with options and stocks.

Facilitate trade settlement by acting as a mediator between buyers and sellers, mitigate counterparty risk, and provide escrow and margin assurances, while custodians safeguard securities and collect dividends.

Explore the difference between long and short positions, including bullish versus bearish outlooks, hedging with futures, and how call and put options shape ownership and risk, a zero sum game.

Learn how short selling works: borrow and sell securities, profit if prices fall, and close by repurchasing, noting collateral, short rebate rates, and payments in lieu of dividends or interest.

Discover how margin accounts create leverage by borrowing cash to buy securities, amplifying both potential profits and losses, while understanding initial and maintenance margin requirements and the broker loan rate.

Calculate the leverage ratio and its inverse relation to initial margin to assess risk and magnified gains, considering margins, dividends, interest, and commissions.

Explore how maintenance margin and initial margin protect brokers from losses, using the formula and an example to show how price moves trigger margin calls for long and short positions.

Learn the basics of trading orders, including bid and ask prices, bid-ask spread, best bid and offer, and how to place buy or sell orders with size and execution instructions.

Learn how market and limit orders affect trade certainty and price, and explore aggressively priced, behind-the-market, and iceberg orders with display size, including all-or-nothing.

Learn validity instructions for stock orders, including day orders, good till cancelled, immediate or cancel, good on open/close, and stop orders with stop sell and stop buy triggers.

Understand clearing instructions that tell brokers and exchanges how to clear and settle trades, including prime broker roles and custodial services, plus long versus short sales and share borrowing.

Explore how the primary market creates securities via IPOs and seasoned offerings to raise capital, while the secondary market lets investors trade already issued securities on NYSE and Nasdaq.

Explore how initial public offerings work, from pre marketing and book building to underwriting and best effort offerings, including price setting and investor demand.

Explore four primary market options—private placements, shelf registrations, dividend reinvestment plans (drips), and rights offerings—and learn how secondary market liquidity reduces the cost of capital.

Explore secondary market structures by comparing call markets and continuous trading, focusing on trading sessions, execution mechanisms, and market information systems, including liquidity, auction prices, and hybrid openings.

Explore execution mechanisms that drive trading: compare quote-driven OTC markets, order-driven exchanges with price priority and order precedence, and brokered markets, and understand uniform, discriminatory, and derivative pricing rules.

Discover how investors get updated about trading opportunities through real-time quotes and orders, the roles of pre-trade and post-trade transparency, and why dealers favor opaque markets with wider bid-ask spreads.

Explore the characteristics of a well-functioning financial system, including complete markets, operational efficiency, and informational efficiency, to enable capital allocation, risk sharing, and liquidity.

Regulators enforce competence standards, curb insider trading, and require reliable financial reporting and minimum capital to protect unsophisticated investors and maintain market liquidity.

Explore how security market indexes function as indicators, representing a hypothetical portfolio of constituent securities like the S&P 500, and how their values and returns are calculated from price changes.

Explain price return and total return indices, how dividends affect total returns, and how to compute index value and single-period returns using prices, weights, and a divisor.

Explore how total index return combines price growth with dividends or distributions, and compute it by either index percentage change or weighted averages of securities' total returns.

Calculate price return and total return index values across multiple periods by geometrically linking period returns, using an inception value and period returns, and illustrate with dividends and multi-period examples.

Learn how to construct and manage an index by defining the target market, selecting securities, assigning weights, and setting rebalancing frequency and review cycles.

Explore price weighting for index construction, its calculation and divisor adjustments, with Dow Jones example, and preview equal weighting, market capitalization weighting, float-adjusted market capitalization weighting, and fundamental weighting methods.

Explore the equal weighting method for constructing an index, assigning equal weights to each security and rebalancing to maintain parity. It highlights simplicity, market cap bias removal, and rebalancing costs.

Explore market capitalization weighting, a value weighting method where each stock's weight equals its market cap divided by the index total, highlighting larger firms and momentum implications.

Explore float-adjusted market-cap weighting by defining market float and free float, and learn to compute weights with the formula, using the S&P 500 as a reference.

Apply fundamental weighting by using cash flow, earnings, and dividends to set stock weights independent of price, highlighting a value tilt toward undervalued stocks.

Calculate the price-weighted index value and return using a divisor, derive weights from prices, and compute holding period, price return, and total returns including dividends and stock splits.

Learn how a market capitalization weighted (value weighted) index assigns weights by company size, calculates the divisor, price returns, and total returns from a three-stock example.

Learn how an equal-weighted index assigns one third of the index value to each security, calculating holding period, price, and total returns with dividends.

Explore index rebalancing, including how weights drift in equally weighted indexes and when to rebalance quarterly or monthly, and examine reconstitution and its varying frequency.

Trace market indexes from the Dow to the S&P 500 and MSCI benchmarks, and explore their use as benchmarks, proxies, and CAPM inputs for active and passive portfolios.

Classify equity indexes into broad market, multi-market, sector, and style types, with examples like Wilshire 5000 and MSCI World, including growth versus value and large to small cap.

Examine fixed income index types and why they are harder to construct and replicate than equity indexes, due to a larger asset universe, varying coupons, maturities, and liquidity constraints.

Explore how alternative investment index types, including commodities, real estate, and hedge funds, are constructed, highlighting weighting methods, futures versus actual assets, and performance biases.

Explore major index types across equities, bonds, real estate, and hedge funds. Include the Dow Jones, Nikkei 225, Morgan Stanley Capital International All Country World Index, and Morningstar style indexes.

Explore the efficient market hypothesis, how information quickly updates security prices to reflect intrinsic value. Learn why passive investing dominates in efficient markets while active strategies target short-term inefficiencies.

Compare market value and intrinsic value to see how efficiency affects prices. Investors exploit deviations when intrinsic value exceeds market price, using valuation models such as discounted cash flow.

Explore how market efficiency varies with the number of participants, information availability, and trading costs, and how arbitrage, short selling limits, and regulation shape price accuracy.

Explore the three forms of market efficiency—weak, semi-strong, and strong—and how prices reflect past data, public information, and private information per Fama's efficient market hypothesis.

Explore the implications of market efficiency on technical analysis, fundamental analysis, and portfolio management, including weak and semi strong forms, prices reflect public information, and opportunities in emerging markets.

The lecture examines market anomalies challenging the efficient market hypothesis, explains data mining pitfalls, and emphasizes sound statistical methodology and hypothesis testing to identify persistent opportunities and abnormal returns.

Explore time series deviations and calendar anomalies, including the January effect, turn of the month, day-of-week, weekend, and holiday patterns, plus factors like tax loss selling and window dressing.

Examine momentum and overreaction anomalies that challenge weak form market efficiency, highlighting contrarian bets on past losers and the persistence of short-term winners amid long-run corrections.

Explore cross-sectional anomalies with the size and value effects, revealing how small caps produced higher risk-adjusted returns than large firms, and how the Fama–French three-factor model tests these premiums.

Explore rare market anomalies beyond time series and cross-sectional patterns, including closed-end fund discounts, earnings surprises, and IPO underpricing, and assess their profitability.

Explore behavioral finance, examining how loss aversion, overconfidence, information cascades, and herd behavior influence pricing anomalies and market efficiency.