A common outcome when working with business clients is to make use of customised software applications to streamline information flows and to monitor performance. The FileMaker database system is designed for rapid development of customised business information systems. My philosophy is to “Teach a man to fish. Give a man a fishing rod. Don’t give a man a fish.” With FileMaker much can be achieved beginning with a basic system that is gradually improved and enhanced over time. I teach clients how to maintain their own systems to the extent that they prefer together with training sessions as required.
Whilst not a “gun coder”, I am an accomplished “citizen developer” mainly using FileMaker in conjunction with other well known apps such as Excel, various accounting, point of sale, web and similar applications. My forte lies in being able to model complex financial systems so that the user can try out different scenarios or more clearly understand possibilities or sensitivities to various events. I am also able to develop models of physical systems as I did for predicting solar powered water delivery profiles where input parameters included location, solar array stationary or tracking, solar radiation profiles, pump and motor performance, different bore hole depths or surface system head and other parameters. (This model was developed using Excel. These days I would use FileMaker.)
I bring to my clients proprietary apps such as my Business in Control Model (BIC Model) for forecasting, measuring actual vs budget and performance measurement via key performance factors. This app can be delivered to all platforms, Mac, Windows, iPad, iPhone and is usually customised to interface with my client’s accounting package regardless of type (in most cases) and can be modified to include special performance factors (other than the twelve that come with the package). The BIC Model can have multiple users who maybe working on their planning and performance as part of a working group.
For the past two years (since 2015) I have been working on a number of complex trading system models some of which use vast amounts of past data that need a powerful database package that can handle the processing load. Some of the apps developed for this work are explained in what follows.
- SPI Futures volume data management – desktop system;
- FOREX Matrix Studies looking at Price Variations within Pairs of Currencies – desktop system;
- Futures Spreads Trading System includes data manipulation for form pairs, creating frequency distributions, simulated trading and results measurement. User can set multiple variables to test different trading system concepts. Desktop system;
- Trader Daily Risk Management System for iPad (Futures and FOREX markets);
- Nikkei Range Bars Trades and Profit/Loss using calculated price levels to initiate trading decisions. Essentially a decision tree approach to simulate various trading scenarios that are tested over many years of past tick data. Desktop system. Possible future outcome will be an automated trading system.
I have also developed several apps for iPhone and iPad. In particular, a Membership database system for Residents 3000 a Melbourne based community group. This system is served from FileMaker Server supporting up to five users simultaneously. When the group has their monthly Forum event, attendees are booked in, memberships updated or simply check for current status and guests are recorded. Usually there are four people working on the system at the time of check-in. Three on iPhone and one on iPad. This system has been up and running for approximately two years and is served from FileMaker Server to desktop, iPhone and iPad.