Market Data & Web Scraping Beginner

Fetch Global Stock Balance Sheets, Income Statements & Cash Flows via Alpha Vantage API in Python

Pull quarterly and annual financial statements for US and international equities in Python using requests and Alpha Vantage REST API.

#requests#pandas

Problem Statement

Fundamental analysts need structured JSON financial reports across global stock tickers without building custom web scrapers.

Formula / Core Logic

Queries https://www.alphavantage.co/query?function=BALANCE_SHEET&symbol=... with API key.

Installation

pip install requests pandas

alpha-vantage-fundamental-financials-fetcher-python.py

import requests
import pandas as pd

.def fetch_alpha_vantage_balance_sheet(symbol='IBM', api_key='demo'):
    url = f'https://www.alphavantage.co/query?function=BALANCE_SHEET&symbol={symbol}&apikey={api_key}'
    data = requests.get(url, timeout=10).json()
    annual = data.get('annualReports', [])
    return pd.DataFrame(annual)