Selfprogrammed account statement... ideas needed

T

Tom Frey

Hi,

I just started to program something to track my trades, account statements, equity graphs, winner/loser ratio, etc. .. all this stuff.

I intend to use a MySQL database therefore and writing the interface in PHP.
This shall get very detailed so I hope you can help me a bit what i shall track and store in the database.

The basic things of course are:
Equity, winners/losers, holding time winners/losers, avg. win/loss, number of trades, percentage in which time trades take place.

I hope you can give some ideas for what is worthwhile to track ... i once saw a very nice account statement from realtick or so .. maybe someone can provide me with a screenshot of those so i get some ideas.

thx

Tom
 
I am doing this in Access/VB. I have a table containing the basics for each trade: time and price of entry and exit. Any other info can be built upon that.
Why do you choose MySQL/PHP? If you want a server strength platform without busting your budget, that seems the only choice. But Access is good enough and I don't want to learn a new platform.
 
Hi,

sorry maybe this was a bit mistakable. Sure in the database there only has to be stored "trade entry, exit, price, qty, stock.
But i also want to add another table in which i can store all the results (e.g. win/loser ratio etc.) so this hasn't to be updated whenever the php script is used but only when a new trade is entered into the db. This is due to performance issues.
I chose using php/mysql as i'm pretty skilled in it and can easily program this ;)
 
yes, that's not the problem .. this can be easily done with php ..

i was just interested in some ideas for professional account statements what statistics they provide
 
Tom,

I am also interested in doing something like this, but am really not an expert programmer. Is Access the way to go or could I also do this in Excel?
 
you can do it with either excel or access.

But i'd rather have the trades in a self written database and with php the way i let display my account statement, draw graphs, adjust things, etc. is unlimited.
 
Tom,

There are so many things that one would be interested in.

Here are a few:

1) Percentage of winners long an short
2) Length of time in winning/losing trades
3) Percentage winners/losers at given time of the day
4) TICK, TRIN, TIKI and spoos/PREM at time of trade, perhaps an Index
5) Reason for trade
6) Make sure you have a way to have a set of trades be logically tagged as one trade. For example, basket traders and Pair traders wouldn't necessarily care about each individually, but the logical trade as a whole. Also allow a reason for trade (5 above) be applicable to a "basket" trade.

There are literally a dozens of things that would be useful...

nitro
 
You must log in or register to reply here.
Back
Top