Excel US Stock Data Fetcher

I want to turn Excel into a lightweight dashboard that fetches key fundamentals for any US-listed company I enter. Beyond what Excel provides natively, the sheet needs to pull items such as free cash flow, long-term debt, EPS, and other basic line-items that appear for free on services like Yahoo Finance or Alpha Vantage.

The data should refresh in two ways—automatically on a schedule and manually with a button—so I can choose between hands-off updates or ad-hoc pulls whenever I’m in the mood to analyse a new ticker. Whether you use Power Query, VBA, Office Scripts, or a mix, the final workbook must stay portable, require no paid API keys, and let me add additional metrics later with minimal fuss.

Deliverables
• An unlocked .xlsx/.xlsm containing:
– a clear input field for tickers
– an output table that fills with the requested metrics
• Well-commented code or queries so I can extend the metric list on my own
• A short in-file guide that shows how to adjust the refresh schedule and trigger the manual update

Acceptance criteria
– Entering a valid US ticker and hitting Refresh populates the table within seconds
– Scheduled updates run without manual intervention
– The workbook operates solely on free, publicly available data sources