Version 0.10.2 of ade has been released!
https://git.sr.ht/~savoy/ade/refs/0.10.2
---
Significant bugs and some small features added in this release.
Bugs fixes:
- With the change from directly accessing raw cursors in pyodbc to using
sqlalchemy, add_hierarchy() was still attempting to pull a DataFrame
with a raw cursor and .fetchall(). The fix allows new numbers to be
added to the local database.
- Although lists of PivotArgs were allowed in the report schema, there
were instances throughout the codebase that hadn't been updated to
accept those changes. Multiple pivots per query are now possible.
- Automatic adhoc formatting for pivot tables has been updated to
include compatibility with multiple columns.
New features:
- Included with the updates for PivotArgs is a new attribute `query`.
With it, slices to the Output DataFrame can be used instead of the
original DataFrame.
- When sending a compiled report to a file, unused tabs will be deleted
prior to saving.
- "rolling_twelve" is a new report configuration keyword replacement.
This keyword will be replaced by the the year-month 12 months prior to
the most recent close.