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.
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
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