Table of Contents
Spreadsheet Requirements
- Wisesheets Subscription: Required to load financial data. Install the add-in and log in.
- Microsoft 365 (Excel Version): Model built on Microsoft 365 Excel. Other versions may be incompatible.
Getting Started
- Download Model: Download "Automated Stock Analysis Spreadsheet" ZIP file from the Customer Dashboard.
- Save Zip File: Save the ZIP file to your computer.
- Extract the Folder: Right-click ZIP file --> Extract All --> Selection location --> OK.
- Unblock Excel (If Prompted): Right-click file --> Properties --> Check "Unblock" (under "General" tab).
- Open the Model and Enable VBA Macros: Open Model and enable Excel VBA Macros (if prompted).
- Install Wisesheets: Excel ribbon: Home --> Add-ins --> Get Add-ins --> Search/Add "Wisesheets."
- Open and Login to Wisesheets: Excel ribbon: Home --> Wisesheets. Log in with your account.
- Refresh the Model: OVERVIEW tab: Input any stock ticker supported on Yahoo Finance.
