After reading this forum and also a book called "The FX Bootcamp Guide to Strategic and Tactical Forex trading I am keen to record, learn and share my trading.
It appears there is quite a bit of information that should be recorded in a journal. I have found a few (freely shared by their authors) but of course I would like to tweak them
Looking at the FX bootcamp book there are a few screen shots which have inspired me to create something quite substantial. However my Xcell spreadsheet knowledge is quite limited so I am hoping some of you may be able to help in what I am trying to achieve :pcguru:
I have attached a copy of the relevant xls spreadsheet
Within this I have a sheet called "visual trade journal" into which i enter relevant data. I have created a "macro" (not something I have ever done before) so was quite :) when I got it to work. So when I click the macro ( Enter Trade Details)button, it transfers the data to a sheet called "daily trade sheet" . Then before i enter a new trade I click the Reset Trade Details button, to clear the previous trade data in the boxes.
The aim of this "daily trade sheet" is to keep a record of each trade which will also hopefully have a screen shot of the charts for reference. My problems are so far :faint:
I do not know how to update the "daily trade sheet" for each new trade, from the "visual trade journal"
I can only update the first line. That is the single line of data is overwritten each time I try to enter a new trade. What I want is a new line of data created for each trade in the "daily trade sheet"
also when I click the Reset Trade Details button in the "visual trade journal" it deletes the info already in the "daily trade sheet" as well as the data in the "visual trade journal". So I need someway to lock or save data already enteredThe goal will then be to possibly create a new "Daily trade sheet " at the start of each week, so I can just refer to the week that has just passed without having to sift through a mountain of information
This weekly data will then be loaded into "Raw Data sheet " so i have a progressive record of my PnL
So any of you with knowledge more advanced that mine I would appreciate your help
Thank you
Greg
OK, I just worked out, that I am unable to attach the "macro"enable version of this spreadsheet.
Obviously for security/virus reasons. So I don't really know if you can help me without the macros working.
If you think you can or if you are ok with accepting a macro enabled spreadsheet from me, maybe you can PM me and i'll forward it to you directly
This will be a great Journal available to all when its finished so If you can help, please do:becky: