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)
The following is a PM exchange I had with vvhg - posting here at his suggestion:
Hi VVHG
Just looking at your spreadsheet and thx for your efforts! I am not clear as to where the raw data comes from? Does it somehow feed in from NT? Or can I migrate data into it from existing spreadsheets? I do have spreadsheets of a different format and without some field information - ie I have not tracked mae/mfe or time in trade and I dont use VWAP. If have some fields blank will this cause serious functional issues? Also I am an all in all out trader so do I simply leave exit2 and 3 blank?
Sorry if some of these questions are answered in the thread.
many thx
Lindsay
Unfortunately at the moment you have to enter the data manually ( or use copy paste column by column from other excel files, but make sure to not paste the format, only paste values. How to do that can be found in a liknk in post #2 "migrating from older versions"), but we are working on a tool that will be able to import from NT, you can download it in the thread to play around with it.
If you don't enter mae and mfe that's ok but obviously some tools of the journal related to mae and mfe will not work. If you plan on using mae and mfe in the future, I would suggest to use two journals, one for the old data and one for the new data including mae and mfe ( otherwise when mae and mfe are only entered for half the trades it may lead to skewed results). Vwap can be omitted, I don't track it myself...the only thing not working then of course is the vwap statistics on the overview tab.
Regarding exits, it is up to three but if you only need one, that's fine ( obviously exit three statistics would not show as they don't apply).
Would it be possible for the spreadsheet to have the capacity to accept previously calculated trade system statistics so that it could generate synthetic trades/curves and other stats? For example - I know my
ave win
ave loss
win %
% of account I risk per trade
this defines my methodolgy
It would be great to be able to input those and be able to access the other functions on the SS.