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
Stock Pattern Detection & Alert System
What:
Check for candle patterns like Hammer, PinBar, Marubozu, Bullish Enfulfing, TeweeterBottom for stocks output in an excel-sheet and send alerts on telegram
Used Modules:
yfinance, xlwings, pandas_ta, telethon

Overview
This solution analyzes stock data to detect key candlestick patterns such as Hammer, Pin Bar, Marubozu, Bullish Engulfing, and Tweezer Bottom. The identified patterns are automatically logged in an Excel sheet and trigger real-time alerts via Telegram.
Why It Matters
- Automates technical analysis of stock charts
- Identifies trading signals instantly
- Enables fast decision-making with real-time alerts
Technologies Used
Python, Financial Data APIs, Pattern Recognition Logic, Excel/Xlwings, Telegram API
Portfolio Highlight
This project demonstrates how automated market analysis and alerting systems can turn raw stock data into actionable trading signals, improving speed, accuracy, and responsiveness for traders and analysts.
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.
Stock Market Data Aggregation Tool

What:
Provide financial data from stock-titles from yahoo finance and gurufocus
Used Modules:
yfinance, selenium, xlwings
Overview
This solution collects financial data for stock tickers from Yahoo Finance and GuruFocus, consolidating key metrics such as price, market cap, P/E ratio, and more. The data is structured for analysis, comparison, and decision-making.
Why It Matters
- Automates financial data collection from multiple sources
- Provides accurate, up-to-date stock metrics
- Saves time for investors and analysts while reducing manual errors
Technologies Used
Python, Web Scraping, API Integration, Excel/Xlwings
Portfolio Highlight
This project demonstrates how financial data automation can turn dispersed stock information into structured, actionable insights, enabling informed investment and market analysis decisions.
Revenue-Focused Stock Data Collection
What:
Collect data for stocks with focus on revenue data for past years and quarters
Used Modules:
yfinance, xlwings, StockCrawler

Overview
This solution collects historical revenue data for stocks, including annual and quarterly figures, and organizes it into a structured dataset for analysis and comparison.
Why It Matters
- Automates the collection of key financial metrics
- Provides clear insights into company performance over time
- Saves time compared to manual research and data compilation
Technologies Used
Python, Web Scraping / API Integration, Excel/Xlwings
Portfolio Highlight
This project demonstrates how automated financial data collection can turn dispersed stock revenue information into actionable datasets, supporting investment analysis, reporting, and decision-making.
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