Abstract
This paper presents an application of an Excel spreadsheet-development methodology used by quantitative analysts and traders in financial markets. The spreadsheet used regression and Excel's Solver to determine the optimal investment of a firm's risk capital. The proprietary methodology used to develop real-time trading tools and its repetitive design structure allowed the firm to become a market-maker exchange traded fund (ETF) rapidly. By adhering to the methodology, the firm's documentation of user requirements, data inputs, calculations, and user interfaces, and a full prototype using Excel, made incremental growth possible and provided a solid foundation for conversion into coded software. Rapid development gave the firm the opportunity to derive revenue from market-making activities in new investment products; these would become a major source of revenue. This methodology, which the authors presented in 2001 at the International Conference on Software Quality in Pittsburgh, Pennsylvania, and its implementation led to the development of a complete trading-system development methodology.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
