This is a mobile optimized page that loads fast, if you want to load the real page, click this text.

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

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

Getting some pretty interesting results though
 
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
 
In excel use paste special instead of paste and then select unicode text.
 
.xls files are Microsoft Excel Spreadsheets, You need Microsoft Excell which comes with Microsoft Office
 
You must log in or register to reply here.

Similar threads

T
ICT Network Groups
Replies
0
Views
952
TRH
T
Retirement-Semi Retirement, (Tech/a personal study) implementation and discussion
2 3 4
Replies
63
Views
12K
tech/a
S
Share some knowledge about day trading the ASX as a mentor
Replies
6
Views
3K
Assasin
  • Locked
  • Sticky
May 2025 Stock Tipping Competition Entry Thread!
2 3
Replies
50
Views
3K
Joe Blow
2025 Full Year Stock Tipping Competiton
15 16 17
Replies
329
Views
28K
Captain_Chaza