Hello, How do you track your trades ? Paper, web of your broker, Excel, software ? Have you try several means? Which one do you keep? Are you happy with the solution you keep? If you use a software, which one is it? Are you happy with it ? Regards Tintin92
I haven't seen anything that can come close to Excel once you are good at unlocking what the program can do. Pretty much anything you want or can imagine, Excel can do it.
That is the key though isn't it ! I have tried to figure it out on my own for hours at a time but always get frustrated I even bought excel for dummies buti guess I'm not dum enough because that book still didn't help. Any sugggestions on a good book to really learn it.
Is there a way to hook up excel to a quote provider, like esignal or CQG and track your p/l while manually entering your open positions? 5yr
Check out ESQuotes. www.esquotes.com A great app that retrieves real-time quotes for Excel. No data fees, and a one time small charge for the application, which is a series of spreadsheets. Use the blank page and create your own formulas for portfolio tracking.
Depending on your level of frustration - and learning how to create cell formulas and links really isn't that difficult - you might want to tell these people what you want, and get a bid from them for doing it for you. They're very fast. I've used them for some custom work in the past. http://www.fastlivehelp.com/
Excel has an excellent help file. I've learned every shred of info I know by trying to make it do things and just combing through the help file and trial and error. If you already have Esignal, you can link several fields to excel with dde. Just type in dde in esignal help and it explains it. I track hundreds of symbols in spreadsheets fed by Esignal.
custom java program which allows me to parse trades from my execution platform and input them into a mysql database. it also parses clearing sheets to match up the orders. its still a work in progress...
nb - thx for the heads up. i'm pretty decent with Excel, but am not a coder. i was able to setup Excel for IB in just a few minutes. here are a couple of useful links for IB users interested in doing the same: http://www.interactivebrokers.com/php/webhelp/Interoperability/DDE_Excel/syntax.htm http://www.interactivebrokers.com/en/software/api/Interoperability/DDE_Excel/Sample_Spreadsheet.htm http://www.interactivebrokers.com/en/software/api/Interoperability/DDE_Configure_TWS.htm http://www.interactivebrokers.com/cgi-bin/apiNormControl.pl?ib_entity=llc hth take care omni