Bond Attributes Manager

Client

Investment Bank

Problem

Attributes of (financial) Bonds were broadly required for reporting, profit reporting and regulatory compliance.
This client needed a way to manage the Bonds’ data which was currently spread across multiple spreadsheets.

Solution

The solution was to migrate all the data to a central database.
The data was accessible to some 80+ analysts via an Excel Add-In which allowed analysts to view, edit and extract all data.
The add-in controlled who had permission to edit values.
All changes were subject to a full audit trail.
Data could be quickly extracted to Excel for further analysis.
This solution reduced the operational risk inherent in storing this data in uncontrolled spreadsheets.

Technology

Excel, VBA, SQL Server

* To respect client confidentiality, identifiers including client logos and names have been removed from all screenshots and descriptions. Displayed names and values are fictional.

PROFESSIONAL PROJECT PORTFOLIO

Get this FREE Portfolio of VBA Projects

Get this beautiful portfolio of Excel VBA projects for ideas and inspiration.

Over 30 pages of smart solutions using Excel, Word, Outlook, MS Access and VBA.

Click the Download button to get instant access to this project summary as a PDF you can print or share.

BENEFIT FROM EXPERIENCE

Save time, money & stress

Get one-on-one access with an experienced Excel consultant who's ready to solve your business critical Excel, VBA, Formula or Macro problems.

Let me take care of everything for you and take advantage of 20+ years of Excel & VBA development experience.

>