Australian (ASX) Stock Market Forum

Excel Spreadsheet

Jump to new
G

gregcourageous

Joined
19 April 2007
Posts
81
Reactions
0
Hello All

Does anyone have a nicely formated template for adding every trade you make? i made myself one but its not the best.

Cheers
 
Heres one that i found on the net. I've modified mine from this, but its a good start.
 

Attachments

  • TradeRecordsTemplate.xls
    72 KB · Views: 847
Hi,

Heres one that i set up, might need a few changes here or there to suit.
 

Attachments

  • stocks.xls
    78.5 KB · Views: 709
professor_frink said:
And here's one more:)
Click to expand...
Nice Professor!

I have the expectancy #'s on mine too. The only thing I've added is a running expectancy, i.e. the expectancy of the last x number of trades to keep an eye on any divergences from the total.

fwiw
 
wayneL said:
Nice Professor!

I have the expectancy #'s on mine too. The only thing I've added is a running expectancy, i.e. the expectancy of the last x number of trades to keep an eye on any divergences from the total.

fwiw
Click to expand...

Sounds good. How would I go about doing that:confused:

I've spent half of today reworking my futures one so it will break my trades down into each weekday, with all of the usual stats to go with it. Man what a pain that was:banghead:

Getting some pretty interesting results though:)
 
professor_frink said:
Sounds good. How would I go about doing that:confused:

I've spent half of today reworking my futures one so it will break my trades down into each weekday, with all of the usual stats to go with it. Man what a pain that was:banghead:

Getting some pretty interesting results though:)
Click to expand...
A make some additional columns offscreen to tally up running wins, losses etc and then a column for the running expectancy.

When I get some time I'll make up some dummy data and post the .xls here
 
wayneL said:
A make some additional columns offscreen to tally up running wins, losses etc and then a column for the running expectancy.

When I get some time I'll make up some dummy data and post the .xls here
Click to expand...

Cheers Wayne, it would be most appreciated:)
 
Hi,

Here's one that I developed myself.

It relies on a series of IF statements and monitors all sorts of stats for yr trading activity. It made need to be modify to suit, but i can assist in that process.

I've left some phatom trades in the sheet so you can play around with, but if anyone has questions just ask here or PM me.

Cheers
Muzz
 

Attachments

  • Trading Spreadsheet sample.xls
    69.5 KB · Views: 689
Hi Damuzzdu,

wow that looks pretty cool, will spend a bit of time going over it when i get the chance. looks like you've put alot of thought into it!

could just about start a new thread with software and ideas that ASF members have created or are thinking of, I'm working on little things all the time and i bet lots of others are. Anyone one interested?

cheers
 
I'm trying to cut and paste the table from COMSEC into my excel spreadsheet but I can't make excel recognise the numbers so that I can make calculations.
There has to be a smart way to do this.... Has anyone come across this and hopefully solved the problem??

TIA

Baz
 
.xls files are Microsoft Excel Spreadsheets, You need Microsoft Excell which comes with Microsoft Office
 

Similar threads

T
ICT Network Groups
Replies
0
Views
800
TRH
T
S
Share some knowledge about day trading the ASX as a mentor
Replies
6
Views
2K
Assasin
Assasin
mullokintyre
2025 Full Year Stock Tipping Competiton
6 7 8
Replies
159
Views
8K
Sdajii
Sdajii
S
Has anyone been able to time ETF’s for a long period?
Replies
4
Views
487
investor13
investor13
TiminOz
The dynamics of money and TIME: crimping cashflow for a period
Replies
3
Views
719
TiminOz
TiminOz
Top