Yahoo Finance to Google Sheets Data Automation
Budget: $250 – $750 USD
Automated Stock Fundamental Data Pull from Yahoo Finance to Google Sheets
תיאור קצר:
I’m looking for an experienced developer to build a Google Sheets solution (Apps Script or API-based) that automatically pulls fundamental financial data from Yahoo Finance for multiple stocks.
The goal is to populate several Google Sheets tabs with real-time and historical data, structured clearly and ready for analysis.
The script must extract:
Annual fundamentals (TTM)
Quarterly financial data (Q1–Q4)
Analyst forecasts and ratings
Institutional holders data
ESG scores (if available)
Sector and ticker for each stock
A total of 45+ unique data fields, sorted into 6 organized sheets
Requirements:
Script should work with hundreds/thousands of stock symbols
All data pulled from Yahoo Finance (no paid API)
Handle missing/undefined fields gracefully
Include calculated fields where needed (e.g., EV/Revenue)
Ability to auto-refresh/update manually via menu/button
All columns and sheet structures will be provided (you’ll get an exact spec)
Optional bonus:
UI dropdown to trigger update by stock list
Error handling/logging
Dynamic ticker list support from sheet
תיאור קצר:
I’m looking for an experienced developer to build a Google Sheets solution (Apps Script or API-based) that automatically pulls fundamental financial data from Yahoo Finance for multiple stocks.
The goal is to populate several Google Sheets tabs with real-time and historical data, structured clearly and ready for analysis.
The script must extract:
Annual fundamentals (TTM)
Quarterly financial data (Q1–Q4)
Analyst forecasts and ratings
Institutional holders data
ESG scores (if available)
Sector and ticker for each stock
A total of 45+ unique data fields, sorted into 6 organized sheets
Requirements:
Script should work with hundreds/thousands of stock symbols
All data pulled from Yahoo Finance (no paid API)
Handle missing/undefined fields gracefully
Include calculated fields where needed (e.g., EV/Revenue)
Ability to auto-refresh/update manually via menu/button
All columns and sheet structures will be provided (you’ll get an exact spec)
Optional bonus:
UI dropdown to trigger update by stock list
Error handling/logging
Dynamic ticker list support from sheet