IDEAS home Printed from https://ideas.repec.org/a/inm/orinte/v38y2008i4p289-299.html
   My bibliography  Save this article

Optimal Trading of ETFs: Spreadsheet Prototypes and Applications to Client-Server Applications

Author

Listed:
  • Andrew Kumiega

    (Center for Professional Development, Illinois Institute of Technology, Chicago, Illinois 60616)

  • Ben Van Vliet

    (Stuart School of Business, Illinois Institute of Technology, Chicago, Illinois 60661)

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.

Suggested Citation

  • Andrew Kumiega & Ben Van Vliet, 2008. "Optimal Trading of ETFs: Spreadsheet Prototypes and Applications to Client-Server Applications," Interfaces, INFORMS, vol. 38(4), pages 289-299, August.
  • Handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:289-299
    DOI: 10.1287/inte.1080.0359
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/inte.1080.0359
    Download Restriction: no

    File URL: https://libkey.io/10.1287/inte.1080.0359?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Barry C. Smith & Ross Darrow & John Elieson & Dirk Guenther & B. Venkateshwara Rao & Faker Zouaoui, 2007. "Travelocity Becomes a Travel Retailer," Interfaces, INFORMS, vol. 37(1), pages 68-81, February.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Ben Li & Xiaolong Guo & Liang Liang, 2024. "Optimal pricing decision and capacity allocation of opaque selling in airline revenue management," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 23(4), pages 356-368, August.
    2. Thomas Fiig & Remy Guen & Mathilde Gauchet, 2018. "Dynamic pricing of airline offers," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 17(6), pages 381-393, December.
    3. Mao, Zhaofang & Liu, Wei & Feng, Bo, 2019. "Opaque distribution channels for service providers with asymmetric capacities: Posted-price mechanisms," International Journal of Production Economics, Elsevier, vol. 215(C), pages 112-120.
    4. Ben Vinod, 2016. "Evolution of yield management in travel," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 15(3), pages 203-211, July.
    5. Collins, Andrew T. & Hess, Stephane & Rose, John M., 2013. "Choice modelling with search and sort data from an interactive choice experiment," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 56(C), pages 36-45.
    6. Andrew Collins & John Rose & Stephane Hess, 2012. "Interactive stated choice surveys: a study of air travel behaviour," Transportation, Springer, vol. 39(1), pages 55-79, January.
    7. Stacey Mumbower & Laurie A. Garrow, 2014. "Data Set —Online Pricing Data for Multiple U.S. Carriers," Manufacturing & Service Operations Management, INFORMS, vol. 16(2), pages 198-203, May.
    8. Hotle, Susan L. & Castillo, Marco & Garrow, Laurie A. & Higgins, Matthew J., 2015. "The impact of advance purchase deadlines on airline consumers’ search and purchase behaviors," Transportation Research Part A: Policy and Practice, Elsevier, vol. 82(C), pages 1-16.
    9. Thomas Fiig & Oriana Goyons & Robin Adelving & Barry Smith, 2016. "Dynamic pricing – The next revolution in RM?," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 15(5), pages 360-379, October.
    10. Kinshuk Jerath & Serguei Netessine & Senthil K. Veeraraghavan, 2010. "Revenue Management with Strategic Customers: Last-Minute Selling and Opaque Selling," Management Science, INFORMS, vol. 56(3), pages 430-448, March.
    11. Adam Bockelie & Peter Belobaba, 2017. "Incorporating ancillary services in airline passenger choice models," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 16(6), pages 553-568, December.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:orinte:v:38:y:2008:i:4:p:289-299. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.