This can also be done using Master Merchant. It will export the sales and purchases of everyone in the guild, as well as their current rank, for the timeframe specified by the guild roster (last week, prior week, 10 days, etc)
Co-GM, Angry Unicorn Traders: PC/NA
"Official" Master Merchant Tech Support
and Differently Geared AF @sylviermoone