Excel Add-ins That Actually Work
Most Excel financial add-ins are bloated nonsense with UIs that haven't been updated since 2008. Sharkys Machine 1st Edition exists in that same crowded graveyard, but it earns its keep through sheer functionality rather than flash. It's a stock screening and analysis tool for Excel, built by someone who actually trades and understands what metrics matter. The interface looks like it belongs in Windows XP era. Don't let that fool you. I picked up the 1st Edition around 2014 after trying half a dozen other screening tools. The thing that kept me was the Screener module, which pulled ticker data from online sources and ran financial statement ratios against user-defined criteria. Most competitors required you to download CSVs manually, paste them into sheets, and hope your formulas didn't break. Sharkys Machine handled the data pull itself.
Sharkys Machine 1st Edition How It Actually Works
The installation process is straightforward. You download the .xla file, place it in your Excel Add-ins folder, and enable it through File > Options > Add-ins. Once loaded, you get a custom ribbon or toolbar depending on your Excel version. The main modules are Screener, Watchlist, Backtest, and the Fundamentals panel. Here's the workflow most people skip reading about: open the Screener, type in your filter conditions like Price/Sales below 2 and Debt/Equity under 0.5, hit run, and it pulls data from financial databases and returns a ranked list. The results populate directly into your spreadsheet. From there you can add columns for things like insider buying activity or short interest if you've configured the data sources properly. The Watchlist module tracks your chosen stocks and updates prices on a timer you set. Backtest lets you test a strategy against historical data, though the engine is fairly basic compared to dedicated backtesting platforms. It'll tell you if a set of criteria would have worked over the past few years, but don't expect Monte Carlo simulations or transaction cost modeling.
What Beginners Get Wrong About This Tool
The biggest issue I see is people treating the Screener output as gospel without checking the data source. The add-in pulls from whatever financial data API you configure, and some of the free sources have lagged or incomplete records. I ran a scan for small-cap value stocks once and got results that looked reasonable until I cross-referenced with the actual company filings. Two of the tickers had been delisted months earlier. The screener included them anyway because its database hadn't caught up. Another common mistake is not understanding how the backtest engine handles dividends and splits. It adjusts prices for splits by default, but dividend reinvestment is something you need to manually toggle. If you run a backtest without enabling DRIP and your strategy involves holding dividend-paying stocks over long periods, your returns will be systematically understated. I lost about three weeks trying to figure out why my backtest results were 4% lower than my manual calculations before I found that setting buried in the options menu. The Fundamentals panel is genuinely useful but poorly documented. It shows balance sheet, income statement, and cash flow data for individual tickers in a tabular format that's much cleaner than what you'd get from scraping Yahoo Finance manually. The trick is learning the shortcut keys. Default shortcut for pulling fundamentals on a highlighted ticker is F9, which conflicts with Excel's recalc command. I remapped it to Ctrl+Shift+F and haven't looked back.
Get the Full Details
Practical Limitations You Need to Know
Sharkys Machine 1st Edition has hard constraints. It maxes out at around 5,000 tickers in the screener before performance degrades noticeably on a typical machine. If you're screening the entire universe of US stocks plus international holdings, you'll need to split your scans into chunks. The add-in doesn't error gracefully either. It just hangs for several minutes and then returns incomplete results, which is worse than a clear timeout message. Data refresh rates depend entirely on your configured sources. The free tier sources usually refresh once per day, sometimes with a delay of 24 to 48 hours for less liquid stocks. If you're doing intraday work, this tool isn't going to help you. You'd be better off using something like TradeStation or even TradingView's screener for real-time data. The backtest module only supports simple strategy types. Buy when condition X is met, sell when condition Y triggers. There's no support for multi-condition entry logic, trailing stops, or position sizing algorithms beyond fixed fractional allocation. For a stock picker who just wants to validate whether a value investing approach worked historically, it's adequate. For anything more sophisticated, you're going to need Python and pandas.
Another thing nobody warns you about: the Watchlist doesn't sync across multiple Excel workbooks. If you open the same workbook on two different computers, each instance maintains its own watchlist state. I figured this out the hard way after updating my watchlist on my desktop and then driving home and wondering why my laptop screen showed outdated holdings.
Where It Shines Despite Everything
The core value proposition is simple. If you're an individual investor who already works primarily in Excel and doesn't want to pay for Bloomberg Terminal or expensive screening platforms, Sharkys Machine 1st Edition gives you about 70% of that capability for a fraction of the cost. The screening criteria it supports cover most retail-level strategies: P/E, P/B, P/S, debt ratios, revenue growth, earnings growth, dividend yield, beta, and market cap filters. I use it every Monday morning to refresh my watchlist. The whole process takes about 12 minutes from opening Excel to having a ranked list of candidates that meet my criteria. Doing the equivalent manually with free web sources would take me closer to 45 minutes, and I'd still miss data points because I'd give up partway through. The add-in also includes a few proprietary scoring systems that rank stocks on composite scores combining multiple fundamental metrics. They're not genius-level insights, but they save time if you're starting from scratch and need a screening baseline before you apply your own filters.
Getting It Running Without Losing Your Mind
Install in a directory path that doesn't contain special characters or spaces. I learned this when my IT department's default folder structure included parentheses in the path, and the add-in failed to load every single time with no error message explaining why. Move it to C:\ExcelAddins\ and everything works fine. Set your data source before you do anything else. The default configuration points to a source that requires registration. If you don't have an account set up, the screener will return empty results and most people assume the tool is broken. Configure it to use whatever free source you have credentials for, or register for one if you're serious about using this regularly. Back up your Excel templates that use Sharkys Machine functions. The add-in injects custom functions into your workbook, and if you ever move to a different machine or reinstall Office, those functions won't exist in the new environment until you reload the add-in. Workbooks with unresolvable custom functions show #NAME? errors, and recovering the original setup can be frustrating if you didn't document where you got the .xla file.
I still use this add-in years later because it does one narrow job well enough that the friction of switching to something newer isn't worth it. That's probably the most honest review you'll get. It's not elegant, it's not fast, and it has quirks that will annoy you. But for stock screening in Excel without spending hundreds a month, it's one of the better options that still exists.
