A curated collection of Agent Skills for working with PYXLL, to help AI agents write and understand code using the PyXLL Excel add-in.
99
90%
Does it follow best practices?
Impact
100%
1.56xAverage score across 17 eval scenarios
Advisory
Suggest reviewing before use
A quantitative trading desk maintains a daily P&L spreadsheet where trade records are stored on a worksheet called "Trades". Data begins at cell B3 (with column headers in row 3) and extends across 5 columns, with a variable number of data rows below. At the bottom of the data there is a totals row, and one column to the right of the last data column is a summary cell the team calls the "corner total."
The operations team needs a standalone Python script (not a PyXLL add-in — a script run from the command line) that:
r"C:\data\trades.xlsx")$B$3:$F$25) for inclusion in a log messageThe script should print the data region address and the corner total value to the console.
Produce a single Python script file named trade_log_processor.py. The script should be complete and runnable (it may reference a placeholder workbook path). Do not require any packages beyond pywin32 and the Python standard library.