Add a list of stock tickers to Excel, then use live market data formulas to populate your screening columns automatically - no copy and paste from websites.
Most formulas just require a stock ticker/symbol:
=EPF.Yahoo.Price("AAPL")=EPF.Yahoo.DayChangePercent("AAPL")=EPF.Yahoo.52WeekHigh("AAPL")=EPF.Yahoo.MarketCap("AAPL")=EPF.Yahoo.PERatio("AAPL")=EPF.Yahoo.Sector("AAPL")
Build an S&P 500 stock screener in Excel with live Yahoo Finance data.
Add a list of stock tickers to your spreadsheet, then use Yahoo Finance formulas such as =EPF.Yahoo.Price("AAPL") and =EPF.Yahoo.MarketCap("AAPL") to populate screening columns. Press Refresh Sheet, then filter and rank stocks using Excel tables and filters. See the Stock Screener tutorial for a full walkthrough.
Yes. Excel Price Feed pulls live market data directly into your spreadsheet using standard Excel formulas. There is no need to copy and paste prices or company data from websites.
Live prices, market capitalisation, sector, industry, P/E ratio, dividend yield, 52-week high and low, day change and many other summary metrics. See the Yahoo Finance stock formula reference for the full list.
Live price, market cap, sector, P/E ratio and 52-week range formulas such as =EPF.Yahoo.Price("AAPL"), =EPF.Yahoo.MarketCap("AAPL") and =EPF.Yahoo.PERatio("AAPL"). See the Yahoo Finance formula reference for stocks and key financial ratios.
No. Yahoo Finance is included with Excel Price Feed at no extra cost and does not require a Yahoo account or API key.
Yes. Follow the Stock Screener tutorial to build an S&P 500 screener in Excel with live Yahoo Finance data, filters and visualisations.