Using Financial Data APIs: A Guide to Collection & Integration

on YouTube ↗01h 18m

" summary

Step-by-step demo that clones a GitHub repo, runs a Dockerized Jupyter notebook and uses Python/pandas to call five real APIs (openFigi, permID, Alpha Vantage, Financial Modeling Prep and GLEIF) to assemble a unified reference + market + fundamentals table for five tickers (AAPL, MSFT, GOOGL, AMZN, NVDA). The pipeline fetches ~100 days of prices per ticker (≈500 rows), pulls FIGI/PermID/LEI mappings, and ends with a 23‑column merged dataset; free tiers work but have coverage and rate limits.

AI-written summary · about

" chapters (10)

1. 0:00Introduction
2. 10:40Environment setup
3. 22:00Financial data APIs
4. 27:04Collecting reference data
5. 33:54FIGI identifiers
6. 42:10Perm ID and legal entities
7. 56:07Alpha Vantage market data
8. 1:01:23Fundamental data from FMP
9. 1:13:42Integrating datasets
10. 1:14:26Q&A

" related talks

• 23mIMF Data Discovery and CollectionIrina Klein · PyData Global 2022
• 25mBoost API Success: Key to Transparency & AccountabilitySwapnil Sapar · apidays New York 2023
• 23mCreating APIs That Data Scientists Will LoveRyan Day · apidays Paris 2024
• 21mAPI Design in FinTech: Challenges and Opportunities for next-gen APIs.Jeremy Glassenberg · apidays New York 2024
• 29mPython-Driven Portfolios: Bridging Theory and Practice for Efficient InvestmentsKalyan Prasad · PyData Global 2023
• 39mEmbedded Analytics through Data APIDionizas Antipenkovas · Big Data Conference Europe 2019
• 22mLeading the future: AI and APIs, a powerful duoMurali Sitaraman · apidays Munich 2025
• 23mAboard the Beagle: New species in the banking ecosystemsEric Horesnyi · apidays London 2019