My Excel Trading Journal

amar_gr · #11 17th July 2006, 01:20 PM

Hi Ganesh,

Thanks, Could manage to download it successfully.
Great work there, I had been on the look out for a trade logging & analysis tool. Your work is indeed terrific.

Many many thanks for sharing this. I hope to take some inspiration from your work and design a similar tool for my Nifty Fut trading requirements. Will appreciate your thoughts and views on the same.

Thanks and Regards
Amar R

ger06 · #12 18th July 2006, 06:12 AM

Dear ganesh;

""The P&L calculation is done using a pivot table. As time goes by, whenever you press the refresh button (red "!" on the pivot toolbar), it will automatically update the table and charts to include the new week and calculate the profits for that week.

You can experiment this by putting in fictitious sell dates for the coming weeks.[/quote]""

I am not able to see Red ! on the pivot table & not able to get P&L calculated.
How to get the chart as what to drag "" Drag Page Field Here" location.
Pl. give the details to get the sheet working.

Thanks.

rajeevrdarji · #13 1st November 2006, 04:28 PM

any one intrested to trade in comex market with right guidance and right levels in market can contact me for further details on rajeev_darji@*****.com

investguruji · #14 1st November 2006, 07:00 PM

Just downloaded the excel file. Looks Good. Thanks.

scorpio155 · #15 2nd November 2006, 11:38 PM

thanks for this

tintin8801 · #16 22nd December 2006, 12:08 AM

does this take into acount the brokerrages and other charges while computing my seling price to make no loss?

tintin8801 · #17 22nd December 2006, 12:58 AM

the megaupload link has expired, can some 1 pls upload again !

akxsat · #18 22nd December 2006, 05:28 PM

HAI,

Good Job, contracts,

Suppose If i want to edit something like brokerage, etc.,

I am not able to.
Pls adv what to do?

tks,
akx

hmp · #19 22nd December 2006, 07:44 PM

link is expired can someone download again?
regards
hmp

kgsirasangi · #20 23rd December 2006, 10:02 PM

Quote:

Originally Posted by ksganesh100

Hi all,

I would like to share my trade logging system with all of you . This acts as my trading journal which also keeps track of my weekly P/L. To give an overview of my trading style, I am a swing trader who mostly trades channels and less frequently, breakouts.

You would be able to download this from here:

My trading Journal

Most of this should be self-explanatory to the traders here. I would be happy to clarify if need be. To protect the formulae from being edited by mistake, I have protected the worksheet. People interested in editing formulae might want to unlock the sheet by using the password "traderji".

Hope you find it useful !

Best Regards,

hmp,

The link given in above message works and file can be downloaded from there.

Regards

Similar Threads for: My Excel Trading Journal
Thread	Thread Starter	Forum	Replies	Last Post
Traders Journal Magazine at ***** group	jdm	Magazines	1	28th May 2006 12:24 AM
excel help	vvn	Introductions	4	8th August 2005 08:06 PM