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 think I am ok. I figures that whenever there are some inconsistent logic on the input, the same error message when I try to save the file. Let say if I put 20 on point value, the tick value must be lower, if not the inconsitenct will create problem. Or if I change the name of the instrument or whatever, I have to make sure other pages have made the changes properly. Any slight inconsistency will create an error.
The difficulty is that there is no hints pointing to the problem area. I guess the main reason is I am not familiar with the spreasheet. I will have to play around it more to understand how it works.
Anyway. Big thanks. The spreadsheet is very comprehensive and you have put a lot of effort to build it.
Now this seems like a great Journal- I like the idea of putting the data on one page for the day then in the background all the info is tabulated. Great user interface and simple to use.
Few Questions?
How does your spreadsheet cope when adding data that is scaled in and out of trades? Multiple entries etc
DO you collate MAE and MFE and or R?
Regards
"Train yourself to let go of everything you fear to lose."
-Yoda, Star Wars Episode III Revenge of the Sith
In regard to your questions -
1. I tossed and turn on this one. In regard to scaling in with multiple entries, basically I decided on the fact that each new trade entry was a new trade with it's own risk ie you could buy 5 contracts at 4000 with a stop at 3990, risk 5*10. Prive moves in your favour and goes to 4020 so currently long at 4000 with 5 contracts, Buy another 5 at 4020.
What is the risk? Is the risk on these new 5< 4015? Or if we are willing to say we are playing with the markets money, there is no risk because we are plus 15 on the trade?
To hard. Each new entry has it's own risk.
2. Staged exits are allowed. Ie Trade entry, Buy 20, Sell 10 PT, Sell 5 on PT, trail last 5.
Note, each of these exits has it's own recorded reason for exit ie PT or TS.
3. MAE is based on the worst case from the entry. MFE is based on the least performing exit. Ie in answer 2 this would be the 10 PT exit.
As you can see, each exit has it's own MAE and MFE recorded and then at the bottom in the summary area, the worst case is displayed.
First of all thank you for your hard work and generous spirit in sharing and updating this Journal for communal use. I had put one of my own together and was looking for ways to improve it when I found yours. Needless to say, mine is now confined to the archives section on my backup drive!
I have a question regarding the importing of the NT7 .csv files into the excel sheet. I am encountering exactly the same errors as perryg in the quote above. I have tried all kinds of configurations but I don't know what I am doing wrong to get this error. Any pointers would be much appreciated.
Secondly, I trade from Sydney, Australia so are there any other settings that I need to be wary of?
Thank you for your kind words. Regarding the importer for NT trades, I have never used it, so I can not offer any help. You would have to ask @petrmac as he created it.
I am not aware of any other settings you would have to change, just remember that the journal can only handle one currency correctly (if the account balance has to stay correct...).
Just downloaded teh Trade tracking spreadsheet. In your summary you state to delete trades in the "journal Tab". The only tabs on the workbook are "trade tracking" and "sheet1". Are you speaking of some other area on the sheet? A column?
Well bummer. Appears this was built to only run on MS Excel in windows. Tried to run in Excel for Mac 2011 and nothing but a bunch of VB script errors. :-(
Are you sure you have the right journal? There are other people's journals in here too...
If you are referring to my journal, that is correct, as I have no mac compatibility is limited to windows. However, you could run it on a virtual windows machine...