Excel Spreadsheet Question

Discussion in 'Automated Trading' started by Dinolovin, Nov 19, 2007.

  1. I am trying to import data from a live feed (ie arca, nyse, brut data rom level II) to an excel spreadsheet. Can I do this? Do I need to use C++, C, or Java?

    Please help?
  2. ssmegner


    Excel has no immediate way to know the format of the data feed. You will have to get the data into a known file format to import. However of the data feed you are considering supports a OLEDB or web services interface you can have Excel pull the data directly. Otherwise you will likely have to write a shim layer to interact with the data feed on one side and one of the Excel API's on the other side.