How do you track your trades ?

T

Tintin92

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.
 
Quote from lescor:

I haven't seen anything that can come close to Excel once you are good at unlocking what the program can do.

More...

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
 
Quote from 5yrtrader:

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

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.
 
Quote from Samson77:

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

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...
 
Quote from newbunch:

I do everything in Excel.

And I use IB's DDE to get quotes in Excel.
More...
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
 
You must log in or register to reply here.
Back
Top