Windows has a free OCR engine. I pointed it at my broker's position grid.
Description and use
The tool automatically converts a broker’s position grid screenshot into a live Excel workbook using Windows’ built‑in OCR, image upscaling, header parsing, and periodic price refreshes.
Problem
Options traders manually update Excel sheets with strike, quantity, premium, and scenario data, which is tedious and error‑prone.
Outcome
The tool replaces manual Excel updates with an automated, privacy‑preserving workflow that uses only local Windows OCR, producing a live workbook with accurate, refreshed data.
Workflow
- Capture broker screenshot
- Upscale image 2x with bicubic interpolation
- Invoke Windows.Media.Ocr via PowerShell to OCR the image
- Parse header row to identify columns
- Recover missing option type (CE/PE) from sibling leg or live NSE price
- Auto‑detect lot size from quantity values
- Convert short Net Qty to positive SELL with Side column
- Populate workbook with strike ladder, live premiums, and scenario IF columns
- Set workbook to refresh live prices and spot every 5 minutes
Evidence
Windows ships an OCR engine - Windows.Media.Ocr, the same one the Photos app uses.
Upscale before you recognise. This was the single biggest accuracy win.
The version that ships reads the header row and only uses the columns that header actually spells out.
- Record date: 2026-10-26T08:11:23.722Z