Still not 100% sure I follow, but perhaps create the group with all the amuse*_area series, then loop through the series in that group, extract the numbers, and then create groups for the buckets. Roughly: group mygroup amuse*_area group mygroup12 group mygroup35 for !i mygroup.@count %j = mygroup.@...
I'm not sure I follow exactly, but I think the way to go is to create groups using the group wildcard constructor, and then use the @rsum function to generate the sums. So, for example, if you want to create a sum of all the series who match the pattern "amuseXX_area", you'd have: group my...
The EViews implementation of X-13 allows you to assign a workfile series as a user-variable in the X-13 pre-adjustment regression. You can create at calendar variable similar to those built in to X-13, but supporting you specific calendar. Recommend reading the X-13 documentation to see how they def...
Sounds like the Python code is creating a file that isn’t 100% compliant with the xlsx file format. Excel is able to handle the lack of compliance better than EViews is.
Easiest fix might be to save as csv from Python instead.