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.
The following user says Thank You to Anatta for this post:
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.
The following user says Thank You to NW27 for this post:
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...).
Hic Rhodos, hic salta.
The following 2 users say Thank You to vvhg for this post:
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?