VOL. XCIV, NO. 247
★ FINANCIAL TOOLS & SERVICES DIRECTORY ★
PRICE: 5 CENTS
Excel‑first market data & analytics add‑in with 1,000+ functions. Default data is 15‑min delayed (QuoteMedia); real‑time streams and intraday history available with data add‑ons. Web screener, ETF database/overlap tools, options chains & Greeks, and portfolio templates (incl. Efficient Frontier). Direct order‑ticket functions for Thinkorswim, Tradier, Orion, plus IBKR integration via TWS API. No public data API for redistribution; personal use license.
Key features
- Excel add‑in works on Windows, Mac, and Excel Online; updates delivered automatically for Mac/Excel Online/Office 365 users.
- Built‑in real‑time streaming quotes (with exchange agreements) and default 15‑minute delayed market data; EOD history ~15+ years; intraday historical up to 1‑minute for ~1 year.
- Options analytics: live option chains & Greeks, IV tools, order‑flow functions, strategy P&L templates; options symbology converter.
- Portfolio & research templates: Efficient Frontier, correlation/volatility/drawdowns, fundamentals and historical statements via hf_* functions.
- Web screener with hundreds of metrics; stock ranks (Value/Quality/Technical); spreadsheet builder to generate ready‑made workbooks.
- Broker/trading connections: Thinkorswim, Tradier (single & multi‑leg), Orion (single‑leg), Interactive Brokers (via TWS API).
- Macro & ETF data: FRED economic series, ETF holdings/overview and overlap tools; CSV/Excel‑friendly outputs.
- Status page for service health; ChatGPT‑powered in‑product assistance (XLSolve AI / function search).
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.