By using wcxd.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

60 Things That Excel Can Do

Feature 25 - Create a file that Reports Top Counterparties to Regulators

I used Excel/VBA as a tool to develop and automate a report that

Ran a database query to retrieve data on the top 15 Counterparties by Exposure

Looked up special codes called LEI

Create PDF output for the report

Created XML custom format for the report

Sent Email for Sign-off from Managing directors

Uploaded the output to a file server for long term storage