Peter2,
Peter2 wrote: "General data like % invested, portfolio heat, movement of the benchmark (XAO) etc . . I collate EOW only."
Once again this makes sense ... weekly will be enough to keep me on track, thanks. I love this graph, a quick picture telling a thousand words ... beautiful.
My comments in regards to the spreadsheet a couple of weeks ago came from wanting to tidy up my spreadsheet, over the course of the 2 threads you have mentioned quite a few things we should record and be aware of so I had a look around the web for already made trading spreadsheets and found none that really suited what I wanted and needed. That's why the question did you know of one or did you buy one that suited all your requirements.
I went back over the 2 momentum threads once again and seen your comments:
Peter2 wrote: "I keep detailed stats and record my description of the market condition when I start every trade. I also record the type of trade setup (break-out, pullback and reversal). I know my edge for each type of setup in every market condition. These stats show me that trading with the trend does improve my edge."
"I'm not going to provide anymore details of these stats as they are personal and assist me to improve my overall edge. However it should indicate the level of commitment I've made in order to be consistently profitable."
and that's fair enough as well.
Your comments below also tell me that you must construct your own spreadsheet, as you say, you add to it when needed as below:
Peter2 wrote: "I add columns whenever I think the additional data might help me identify an aspect of my trading performance (both good and bad)."
So yes, I have answered my own questions in a way.
Chasing this area up in the last couple of weeks has pushed me to find excel data forms which makes entering data easier and quicker for me but it only works up to 32 columns. I keep a record of all your trades in a spreadsheet that has 28 columns so this is perfect, I only need to fill in 8 of them as the others fill in automatically by formulas. Using this data form saves time scrolling down and clicking on individual cells across the page entering data. Probably nothing new for most out there but new for me and I find it very helpful for smaller spreadsheets.
My main spreadsheet that I want to reorganize has heaps more columns than 32 so to do this in the same manner I will have to use UserForm1 and set it up and enter formulas to make it work so to enter data the same way but this is a lot more work and time but it's a road I'd like to travel. This way I just enter the data then press the button and away it goes and into a new row and across the spreadsheet into the right cells. Once again nothing new for most but new to me.
Anyway that's enough from me but that's why the questions about spreadsheets out in the market and also what is a great list of data info we should be collecting at least to have info at our fingertips like yourself that we probably have not even thought about.
Thanks Peter for your updates, support and even a couple more tips to be aware of in the
Outlook section of your last post. Very good.
Cheers ... debtfree