Bastion Terminal: List of Spreadsheets and Visualizations
All current tools available in the Bastion Terminal
👉🖥️ Bastion Excel Terminal
1. Stock Dashboards (Guide)
This file helps you quickly assess a company’s financial trends, valuation, and which investment strategies it fits. It includes all S&P 500 stocks (excluding REITs), plus around 100 global stocks from my watchlist that are not in the S&P 500. I continue to add new companies that interest me.
1.1 GEAR: Growth + Efficiency at Reasonable Price Strategy
This dashboard shows trends in profitability, efficiency, and valuation. The overall score is based on seven factors, each rated from 1 to 10. The higher the score, the better the stock fits the GEAR investment style.
1.2 Dividend Growth Strategy
This sheet highlights trends in dividend changes, growth rate, and dynamics of profit and free cash flow. The score reflects how well a company fits the profile of a growing dividend stock with a margin of safety.
1.3 Quarterly Snapshot
This dashboard helps you track short-term financial trends from recent earnings.
1.4 Key Chart
A one-page view of 16 core indicators of a company’s financial health.
1.4.1 Key Charts – Growth
1.4.2 Key Charts – Valuation
1.5 Key Stats
Over 30 metrics tracking the company's current financials and valuation. It also includes a sortable table ranking the stock across different factor-based strategies. This gives a quick sense of what the business is and which investment styles it may suit.
2. Strategy Builder (Guide)
A tool to find stocks that meet specific criteria or fit certain investment strategies. The universe is much larger than in the dashboards — around 1,400 U.S. stocks and 1,600 global stocks.
2.1 Screener / Builder
The core screener lets you filter and select stocks based on strategy-specific inputs.
2.2 Key Stats
This file includes the same company stats table as in the dashboards, but for all 3,000 stocks in the full universe.
3. HeatMap (Guide)
This tool allows you to create a list and view company rankings based on a single selected metric.
3.1 HeatMap – Basic (100 stocks)
3.2 HeatMap 500 – Extended version
🔜 4. Coming Soon: Portfolio Analytics
I’m working on a dashboard that will let you analyze portfolios based on different strategies. I plan to use it to update my portfolio.
Bastion Terminal
📥 Want access to the spreadsheets? Subscribe here: