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)
Could someone explain to me what the "Bench Mark" number is in the journal. What does a 1 or a 2 or a 3 or that matter any number entered in this column.
Can you help answer these questions from other members on NexusFi?
I haven't looked at the recent versions of the journal, but my original idea behind the benchmark is what I called a "perfect trade", it would represent the best possible MFE if you were able to capture 100% of the move. So it's a benchmark to aim for, as a way to measure your overall efficiency with this best-case scenario MFE vs your actual MFE.
But this may have changed over time with the new versions, I may be wrong...
Benchmark is the maximum favourable excursion of the trade WHILE still in the trade. MFE2 is the maximum favourable excursion BEFORE or AFTER the trade was exited.
There also is a rudimentary help file that explains some of the stats.
So you basically want to chart your daily P/L if its negative? The easiest would be to have a pivot table pulling out a daily P/L and then only use the negative numbers for plotting....
You can do that on the same tab just out of sight to the right.
In the journal entry, if I enter any number LESS than 25 in the columns MAE1 or MAE2, I get the following error message:
"A formula in the worksheet contains one or more invalid references. Verify that your formula contains a valid path, workbook, range name, and cell reference"
This error occurs when trying to save the worksheet. If I change the number to anything higher than 24, there is no error.
I believe I have found the Bug, that is causing this error. In the "Stop Efficiency" worksheet, there is a cell that says "Max MAE to display(ticks)". If I change this cell to zero (0), then I can save the whole spreadsheet with any number in the Journal section of the MAE1 or MAE2. Originally this cell contained a number of 24, which caused the error to occur for any number less than 25 in the MAE.
I am trying to insert a new record in Journal tab of the Journal (4.1)
It is all grayed out, when I try, I get the message --The cell or chart you are trying to change is protected.
I am not much of an excel person. Can someone please point me on how to insert new Journal entries.
The bug should be gone now, no other changes since 4.1. There are Beta versions with extended commissions calculations which should better suit some other financial products.
I would appreciate some feedback if I should include that in the next release...