Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
I dont have a predefined journal that I use daily (personally I found I became too obsessed with it rather than using my gut feel which works better), but previously when I did use one, the thing I found more important than a bunch on numbers and mathematical analytics when I looked back at the history - which lets face it thats what a journal is for - was the personal thoughts v the actual positions taken.
eg; the market was in a long term uptrend, short term consolidation, my thoughts were to buy a dip. So why then did I suddenly find myself doing more than a fair share of failed sells. It was because I was focussed on trying to make the market fit my strategy and predefined journals etc; rather than following my plan and the market.
It was more a personal thing for me as I was largely discretionary - but I found the focus of any journal should be tailored to the element that highlights the weaknesses and strengths. So when I feel I am not in sync with the market these days, I actually write down a simple review of thoughts and plans and see how closely I follow that, or deviate from that in order to get back in sync. Once back in sync, I drop the journal so that I dont fall into the trap of obsessing about trying to perfect it, or my style.
Point being is sometimes just reviewing the numbers is less relevant than the frame of mind, or if you are so number inclined then maybe use a ranking system - eg; bullish to bearish on a scale of 1-5 in order to review your history.
@Big Mike, are you planning on making your spreadsheet available when you are satisfied with it? I took a look at your beta version screen shot and I really like it......just curious.
Simplicity is the ultimate sophistication, Leonardo da Vinci
Most people chose unhappiness over uncertainty, Tim Ferris
My friend, a successful forex trader, uses a spreadsheet he bought from TradingSpreadsheets.com and says it has helped him immensely improve his trading.
Here's sample spreadsheet they have for futures. They also have stock, options and forex-specific spreadsheets. Cost is $57 for all of them.
looking at your beta screen shot looks great, what is your sharpe ratio calc? thats the highest SR i have ever seen and am wondering if its correct? might be worth checking?
I believe the calculation is right. You need to remember, the results are annual, but the screen shots only had 2 days of trading results, so it was extrapolating 2 days of performance over 365 days.
"Any way" ? I'm sure. But I won't be pursuing it, just the initial math required and special cells required in the spreadsheet were already more than I cared to do for the sharpe ratio.
Great! when you release it i will have a stab at making it a monthly figure. Really looking forward to using your spreadsheet Mike, I think it will be the most profitable "indicator" on this site .