Customized finance worksheets with automated webscraping updates. Data for Summary, Profiles, Income Statement, Balance Sheet, Cashflow, Price, Analysis, Earnings, Dividends, Options and much more
Save time with automated finance worksheets and Excel templates for reports, budgets, and analysis.
Finance Worksheets Automation | Automate Your Financial Data
Saudi Arabia Stock Data Extractor

What:
Automatically retrieves up-to-date financial data for Saudi Arabian stocks using Yahoo Finance and organizes the information in an Excel sheet, enabling easy analysis, tracking, and comparison of market performance.
Used Modules:
yfinance, xlwings
Overview:
This tool automatically retrieves up-to-date financial data for Saudi Arabian stocks from Yahoo Finance and organizes it into an Excel sheet, making it easy to analyze, track, and compare market performance.
Why It Matters:
- Automates stock data collection for accurate, real-time insights
- Provides structured Excel outputs for analysis
- Saves time and reduces manual tracking errors
Technologies Used:
Python, Yahoo Finance API, Xlwings, Excel Automation
Portfolio Highlight:
This project demonstrates how automation and financial data scraping can turn complex stock market information into actionable insights, helping investors and analysts make informed decisions quickly.
Bhutan Stock Data Automation
What:
Get finance-data from a website and output the stock-data from Buthan in a google sheet
Used Modules:
selenium, gspread, bs4

Overview:
This tool retrieves financial data from a website and outputs stock information from Bhutan directly into a Google Sheet, making it easy to track and analyze market performance in real time.
Why It Matters:
- Automates stock data collection for accuracy and efficiency
- Provides live, structured data in Google Sheets for easy access
- Saves time compared to manual data entry
Technologies Used:
Python, Web Scraping, Google Sheets API
Portfolio Highlight:
This project showcases how automation and cloud-based data integration can turn financial website information into readily available, actionable insights for investors and analysts.
Financial Overview (s)

What:
Provide financial data from stock-titles from yahoo finance and gurufocus
Used Modules:
yfinance, selenium, xlwings
Revenue Stock Data
What:
Collect data for stocks with focus on revenue data for past years and quarters
Used Modules:
yfinance, xlwings, StockCrawler

Stock Viewer

What:
Read data for stocks and update an excel-sheet for measures like PriceSales, PriceBookValue, EV/EBIDTA, EV/EBIT
Used Modules:
selenium, bs4, yfinance, xlwings, StockCrawler
Marketbeat
What:
Read data for stocks from a txt-input file using proxies and output the data in a csv-file
Used Modules:
selenium, bs4, csv, buyproxies.org

Stockanalysis

What:
Read data for stocks from a txt-input file using proxies and output the data in a csv-file
Used Modules:
selenium, bs4, csv, buyproxies.org
Yahoo Finance – Financial Data
What:
Read data for stocks from a txt-input file and output the data in a csv-file
Used Modules:
csv, yahooquery

Check Signal

What:
Check for specific signals like P/E, P/B, EPS, DebtToEquity, ReturnOnEquity, HeldByInsiders for different stocks
Used Modules:
xlwings, yahooquery
Finance Data
What:
Provide data for different stocks for Income Statement, Balance Sheet and CashFlow Statement
Used Modules:
xlwings, yahooquery

Stock Signals EMA, SMA, Stochastic, Supertrend

What:
Read actual stock data and provide different signals for price, ema, stochastic, supertrend
Used Modules:
yfinance, yahooquery, xlwings, pandas
Stock-Info From BarChart (s)
What:
Read information from stocks like Sales, NetIncome, Cashflow, etc. and output to excel
Used Modules:
selenium, bs4, xlwings

finance worksheets automation, Excel finance templates, automate financial reports
Finanz-Tabellen automatisieren, Excel Finanzvorlagen, Finanzberichte automatisieren