Laser Question

Discussion in 'Trading Software' started by aristo1010, Sep 15, 2010.

  1. Hi, I have been testing out Laser with their demo and I am wondering if there is a way to export data into excel. What I would like to do is export my positions I get into with Laser and then export it into excel so I can track over the day.
    I know I can link Laser to excel but I can't get it to update my positions automatically. Does anyone know of a way I can do this maually. Thanks.
     
  2. you can do this with tradelink and the genesis api.

    Code:
    
    public class MyResponse : ResponseTemplate
    {
      override void Reset()
     {
          // at startup open trade file
          System.IO.StreamWriter sw = new System.IO.StreamWriter("mytrades.csv");
          sw.AutoFlush = true;
     }
      override void GotFill(Fill f)
     {
        // convert fill to CSV format so readable in excel
        string csv = string.join(",",Util.Trade(f));
        // write to file
        sw.WriteLine(csv);
            
    } 
    }
    
    tradelink is free and open source

    http://tradelink.googlecode.com
     
  3. you can just go... file >> Print Summary
    and then if you want your trades go to File >> Print trades. Save it into a notepad, and then open it up in excel