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)
Most people are using some form of 3rd party software that auto populates.
I will say, since you have ninjatrader listed as a used software listed in your bio, I truly wish they would update their performance tracking metrics.
If the numbers could measure 'flat to flat' it would be great. As the only way to get accurate numbers from them is to trade 1 contract, or a static amount each time (all-in/all out)
I find that detailed analysis by hand is cumbersome, and even exporting to a spreadsheet (this is how I would do this if I wanted specifically a spreadsheet) or using an online journal with metrics is just a much less labor intensive way of doing this.
It's easier to do that in TradeStation. In TradeStation you can download data directly from your charts. Then you can use Easy Language to test your strategies. TS has a huge library of math functions - it's essentially plug and play.
I don't use TS anymore because I don't need that capability. But I highly recommend TradeStation for any serious development.
I love doing things with charting packages as they are much faster to analyse - but not the same way and some detail is missing for my needs, e.g. trade the same day open to close... or even today close to n-day close.
I am using Strategy Builder and some results are cumbersome - compared to what I can get from Excel - which is closer to trading scenario I want to test.
Thank you for your answer and included example.
I am looking for more specific analysis - like analysing trades (from Excel column) and deriving metrics, similar to those we can get from NT at the end of backtest.
Probably few more than above - but just to illustrate what I need.
Trading: 6C (Low Margin,) 6E, CL, GC, ES and Maybe DX for smaller tick value
Posts: 1,394 since May 2011
Thanks Given: 1,719
Thanks Received: 1,020
@romus the example makes it appear U have already have a version of this. May I rquest you share it and we can work from there?
I know someone whom is trying to analyze trades based on the MAE, MFE, ETD data.
I also had a sheet years ago. One of the things I liked about it was that the calculation for numbers excluded weekends. NT's includes the weekend for the # of days calculations.
Wow! That is another ball game - probably useful to squeeze out the juice! :-)
I am now analysing probability of scenario from A to B - and to get typical, selected (useful in my view) metrics using some simple formula, rather than column by column analysing each metric separately - it is time consuming!
There are better formulas - or programming - to get results automatically (like doing a SUM function for each column).
Trickier part is to get Consecutive winners/losers... when there are 10000 rows in a column.
In my calculations I have used No. of calendar days - now it is by No. of trading days - basically looking for best day to exit, regardless if Win, Lose or Draw.
Another advantage here is that the Day Of Week means - day of entry!
I have not done the 1R loss limit yet - although may not be that critical in this scenario as majority of them fit into 1R risk - some not - but if you trade overnight anything may happen and stop can go through...
Thank you for this info.
I do not have TS - although these days might be easier to get access via web platform..?
I have tired to find if they have the data for ASX stocks, which I mostly trade these days.
There is only info that stocks (and almost anything) can be traded - but do not specify which exchanges.
I do not think NT will get the Yahoo connection again...
You could call them to ask about the ASX stocks. TS is a big brokerage - I'm sure they offer everything. I think you can still get the developer's platform for $99/mo.