Excel Spreadsheet

[Kauri]

One I use for FX GSL position sizing...

 

[oldpos]

One I use for FX GSL position sizing...

Kauri,

thanks, Are you able to post an unprotected xls.

 

[Kauri]

Kauri,

thanks, Are you able to post an unprotected xls.

The protection password is wriiten at the top of the sheet... haven't got it in front of me at the moment but I think it is Kauri....
Cheers
.......Kauri

 

[CanOz]

Thanks Kauri, i filed that one!

Heres mine from open book plan.

 

[Kauri]

A spreadsheet I use for trading the GSL Indicies.....
Cheers
..........Kauri

 

[Kauri]

OOOPS, just realised the sheet I posted a week or so back for FX was my earlier trial one, attached here is the current correct one, hopefully without errors... sorry for any confusion...
Cheers
.......Kauri

 

[redcorvetteguy]

Here is one i am working on.

Do you think it has everything an accountant would need??

I just threw it some fake data to test it...

I have locked the worksheet (no password) so only the unlocked (clickable) cells need you to put info in.

I will eventually put code behind it for easy adding/removing of shares and rolling over financial years and such if/wen i get the time.


regards

Brendon

nice spreadsheet, how was the end result?

 

[Steve C]

Brilliant spreadsheet - does anyone know if expectancy is included in this spreadsheet? It seems to be the only thing missing, or is profit factor another name for expectancy?

Thanks,

Steve

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

 

[Steve C]

Brilliant spreadsheet - does anyone know if expectancy is included in this spreadsheet? It seems to be the only thing missing, or is profit factor another name for expectancy?

Thanks,

Steve

Edit - I have since read below they are slightly different.
http://m.futuresmag.com/2010/10/01/tradingrsquos-holy-grail-your-calculator

I am an excel beginner - would anyone mind adding in expectancy to the spreadsheet for me?

Greatly appreciated

Steve

 

[stevier95]

Im into medium to long term trading. How should i account for dividends? Can someone please provide a simple and easy to use spreadsheet template that allows me to account for dividends as well and shares acquired through a DRP.
Thanks in advance

 

[stevier95]

Anyone?

 

[ROE]

Im into medium to long term trading. How should i account for dividends? Can someone please provide a simple and easy to use spreadsheet template that allows me to account for dividends as well and shares acquired through a DRP.
Thanks in advance

buy topshare a very good peice of software and will save you hundred of hours in future tax return

 

[stevier95]

buy topshare a very good peice of software and will save you hundred of hours in future tax return

I'm on a Mac unfortunately

 

[ROE]

I'm on a Mac unfortunately

You got parallel and vmware to solve all windows related apps problem

I'm using Mac as well.. I have 4 PC but I'm slowly move them all to Mac

2 down, 2 more to go

 

[klumsyboy]

Hi can anyone design a spreadsheet that does partial sales so I can track the cost as it moves over time? I buy and sell in parcels so I may not close out a position.

eg I have 100 TLS bought from 2005 @$8, I buy 100 @$4 in 2010 then I sell 150 in 2011, assuming first in first out

then I have 50 left that cost $4 at end of 2011.

 

[pavilion103]

I'm not sure if this can be modified for that purpose or is of use to anyone but this is the one that I created for myself.

View attachment Trading Software - Master File - MAY 2012.xls

 

[white_goodman]

heres an analyzer for those on IB... its free

http://www.rapadashboard.com/

 

[hawamahal]

heres an analyzer for those on IB... its free

http://www.rapadashboard.com/

I downloaded it. looks fancy.

As soon as i start i get a message " Trial period has been expired, please buy a License."

 

[Wysiwyg]

Seeking spreadsheet expertise.

Goal - To have all rows change to align with a descending order column request.
Example - on the screenshot there are four columns of time and sales (actual about 4 thousand individual transactions). I want to see Time and Price rows corresponding with Volume and Value

 

[cynic]

Seeking spreadsheet expertise.

Goal - To have all rows change to align with a descending order column request.
Example - on the screenshot there are four columns of time and sales (actual about 4 thousand individual transactions). I want to see Time and Price rows corresponding with Volume and Value
View attachment 72606

I am not sure whether I am correctly understanding you, but, instead of sorting only one column you might choose to:

(1) highlight all four columns

(2) from the "DATA" menu click on "Sort"

(3) tick the "My data has headers" box

(4) in order of preference, select the desired column/s in the "Sort by" field/s (if more than one column is to be sorted, click "add level" for each additional column)

(5) select "Z to A" in the "Order" field for sorting in descending order

(6) on some occasions, depending upon XL version, and consistency of data formats, the "Options" menu or the "Sort on" fields may need to be utilised.

(7) click "OK"