Microsoft Excel is a very popular tool for traders, advisers, researchers and brokers. This spreadsheet program has many uses in this field including:
The attractiveness of Excel is that is both powerful and well understood by a the above group of people. In addition, it supports add-ins which extend the capabilities of Excel and has a powerful internal development environment, (VBA) which allows it to be customised for specific applications.
MotifXL is an Excel add-in which incorporates our Websocket API and IQ API into Excel. This add-in gives Excel access to real-time security data from Motionite. In addition, snapshots of market data and trading data can be retrieved into spreadsheets. It also allows order requests to be directly sent to the market.
MotifXL makes this capabilities available in the following 2 ways:
Set IQ = CreateObject("MotifXL.IQServer") Command = "select * from security where SymbolCode = '1015.MYX[Demo]'" IQ.ExecuteIQCommand (Command) ColCount = IQ.GetColumnCount() For Col = 1 To ColCount Cells(1, Col) = IQ.GetFieldByIndex(1, Col) Next Col
MotifXL opens up huge potential for traders and researchers familiar with Excel and can greatly assist with workflows for advisers and brokerages.