VOL. XCIV, NO. 247
★ FINANCIAL TOOLS & SERVICES DIRECTORY ★
PRICE: 5 CENTS
Spreadsheet add‑on for Excel & Google Sheets delivering fundamentals, key metrics, analyst estimates, live/historical prices, dividends, ETF/fund fields, options chains/greeks (Elite), plus a built‑in screener and a broker sync (‘Portfolio Connect’) via SnapTrade. Uses Yahoo‑style tickers and emphasizes standardized statements; options data requires the Elite plan. ‘Live’ prices are provided through the add‑ins (not a standalone REST API). For broker syncing, connections are handled by SnapTrade (SOC 2 Type II).
Key features
- Excel & Google Sheets add‑ins with custom functions: =WISE() for fundamentals/estimates/segments and =WISEPRICE() for live & historical prices/dividends; =WISEOPTIONS() for option chains and greeks (Elite).
- ‘Statement Dump’ pulls 19Y annual or 72 quarters of IS/BS/CF plus key & growth metrics; optional ‘SEC as reported’ view for US filers.
- Built‑in Screener (Elite): filter by market cap, dividend yield, sector, industry, exchange; ‘Get List’ and ‘Get Data’ modes.
- Coverage across major global exchanges (US, Europe, APAC, LatAm, Middle East, Africa) and OTC; supports ETFs and mutual funds.
- Portfolio Connect: sync holdings/transactions from 30+ brokers via SnapTrade; daily refresh; IRR/Sharpe/factor‑style views and wash‑sale/tax‑loss hints.
- No Wisesheets‑side daily quota; typical Google limits apply (e.g., ~20k requests/day for standard Google accounts, ~100k for paid).
- Template library, Function Builder, one‑click Refresh Live Data and Refresh Errors utilities.
Suggest an edit
Information
About Me
Hey! Thanks for stopping by. I'm an independent investor with a soft spot for coding and the stock market - especially value investing (as you can probably tell from the tools I've collected here, haha). Hopefully you'll find something useful or interesting along the way.
Find me here:
- Twitter / X: @Jera_Value
- Substack: Jera Value
Got questions or suggestions? I'm all ears!
Missing a Tool?
Discovered a gem I don't have here yet? Drop the link below and I'll check it out ASAP. Tagging me on X works too! Can't wait to see what you've found!
Starred Tools
These are my top picks. Tools I've tested thoroughly and found to be excellent. They do their job really well, and I use them a lot. If you're not already familiar with them, I highly recommend checking them out.
Tested Tools
These are tools I've tried and found to be solid, but not standout. Think of them as passing an initial quality screen: worth exploring, though not all will be exceptional.
Curation & Accuracy
This directory blends AI‑assisted discovery with human curation. Entries are reviewed, edited, and organized with the goal of expanding coverage and sharpening quality over time. Your feedback helps steer improvements (because no single human can capture everything all at once).
Details change. Pricing, features, and availability may be incomplete or out of date. Treat listings as a starting point and verify on the provider’s site before making decisions. If you spot an error or a gap, send a quick note and I’ll adjust.