Index Options Extract Converter

Client

Investment Bank

Problem

Analysts were required to extract data from a database to a text file, enrich the data and export it in another format for another system to import.
The process was manual and time consuming.

Solution

The solution was an Excel template to automate the process.
This displayed a screen allowing analysts to:

  • select options for retrieving the data,
  • enriching it with customisable business rules,
  • View the data live (option changes refresh instantly) before finally exporting the data in the new fie format to the destination system.

Technology

Excel, VBA

* 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.

>