Windows has a free OCR engine. I pointed it at my broker's position grid.

说明与用途

该工具使用Windows内置OCR、图像放大和标题解析，将经纪人位置网格截图自动转换为实时Excel工作簿，并每5分钟刷新价格。

问题

Options traders manually update Excel sheets with strike, quantity, premium, and scenario data, which is tedious and error‑prone.

结果

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.

工作流

• 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

证据

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.

来源