A Trading Database in Excel

A commodity trader approached us to create an Excel VBA database application to store and manage trading records.
Trading

A commodity trader approached us to create an Excel VBA database application to store and manage trading records. The objective of this app is to increase productivity of coal traders to create SELL trades, manage multiple BUY trades, and execute more accurately the delivery of coal trades.

During our initial meetings, we understood his requirements and designed these interface screens. The challenge was to understand the business logic of coal trades and translate that into worksheet designs.

The main menu screen
This screen to enter trading data

About Aeternus Consulting

Aeternus Consulting is a Microsoft Office consultancy and & digital creative agency. We specialise in Microsoft Office training, VBA application development, Business modeling in Excel, infographic designs, data visualizations and web UX UI.

Related Link: Aeternus Consulting Singapore

Leave a Reply

Your email address will not be published. Required fields are marked *