Using Spreadsheets For Test Data With veriFIX
During my time testing trading software using veriFIX I have devised ways to inject instrument codes or ISINs into tests. My favourite being an excel spreadsheet and a database driver. Whilst available ISINs can be gleaned from SecurityList messages and MarketData, I prefer during my testing to keep a record of all available instruments in the system. Conversely I like to know about all data in my test environments. For this example I will show how to set up veriFIX to read ISINs from a spreadsheet. (This can be extended to include prices, order types and much much more). For this you will need: veriFIX Microsoft Excel CSV JDBC Driver 1- Download the CSV JDBC driver jar from here https://sourceforge.net/projects/csvjdbc/ 2- Place the CSV JDBC driver jar into the lib folder in your veriFIX program folder 3- Add location of CSV JDBC driver to class path e.g C:\Itiviti\VeriFIX 6.5\lib\csvjdbc-1.0-31.jar; (instructions on how to do this can be found on the internet) ...