Download Finviz Data into Excel

This Excel spreadsheet downloads stock quotes for 6855 companies from using VBA. The stock quotes includes over 65 pieces of financial data, including PE ratios, market capitalization, EPS, moving averages, earnings dates, average true range, and much more.

Beneish M-Score

Determine if a company has manipulated earnings with the Beneish M-Score. It’s simply a mathematical formula which uses data from a company’s financial reports.

Altman Z-Score

The Altman Z-Score is an empirical model that predicts the probability of corporate bankruptcy. This article introduces this valuable predictor of financial distress, and offers a calculation spreadsheet.