Exporting trade data updates

If you’re exporting data from Tradervue in CSV format (see original blog post about this), we’ve made a couple of changes to the Trades View export that you’ll want to know about.

Removed columns:

  • Date

Added columns:

  • Open date/time
  • Close date/time
  • Side (e.g. L/S)

These new columns make it possible to do more sophisticated analysis in Excel; for example, if you want to make calculations based on time of day, or trade duration, there is now enough data there to do this.

The export functions are available for all silver and gold subscribers.

Significance test for trading results

In chapter 12 of his excellent book The Art & Science of Technical Analysis, Adam Grimes discusses a few ways to statistically analyze your trading results. One particular calculation, the p-value, is a significance test (known as a one-tailed t-test) for the average P&L of a set of trades being greater 0. Essentially, it’s calculating the probability that your trading results could have just been due to random chance.

Tradervue now includes this calculation in the stats tables, on the Detailed, Win vs. Loss days, and Compare tabs. In the tables, it’s referred to as “Probability of random chance”, and is expressed as a percentage. Lower numbers are better – they indicate the results are less likely to be random.

If you use this calculation in conjunction with trade filters, you’ll be able to quickly calculate this for any group of trades. And if you use the Compare reports, you could compare any two groups of trades – so if you’re using tags for trading strategies, for example, you could see the difference between those two strategies.

This new statistic is available now for all users with a Gold subscription plan.

Mini options now supported

We have added support to Tradervue for mini options. They will be represented in Tradervue like this:

APR26 13 375 PUT M

The “M” on the end indicates it is a mini option.

So far, the generic import format supports mini options (be sure to end your contract names with M as shown above), and the OptionsHouse importer will import mini options.

If you’re trading the mini options with any other broker, please let us know so we can update the importer to successfully import them.

Automated import from NinjaTrader

If you’re using NinjaTrader, then this will definitely be of interest!

The good folks at Indicator Warehouse have built a NinjaTrader plugin called Journal Lync to automatically import your trades during the trading day into Tradervue. All you have to do is install the plugin on your computer, enter in your Tradervue account info, and that’s it – every trade you make will be auto-imported into Tradervue within seconds.

On the Journal Lync page they have a video showing how to install and use it, and you can purchase and download it from there.

SQN calculation

If you’ve worked with Dr. Van Tharp, or read his books, you’ve undoubtedly seen what he refers to as the System Quality Number. It’s essentially a proprietary measure of the quality of a trading system, and can be roughly interpreted as follows:

  • 1.6 – 1.9 Poor, but tradeable
  • 2.0 – 2.4 Average
  • 2.5 – 2.9 Good
  • 3.0 – 4.9 Excellent
  • 5.0 – 6.9 Superb
  • 7.0+ Maybe the Holy Grail!

Tradervue will now calculate the SQN for any set of trades – it is shown in the stats tables on the Detailed, Win vs. Loss Days, and Compare tabs. Note that since the SQN is calculated using risk-based results, it will only be shown when running Tradervue reports in R mode.

The SQN calculation is available now for all users with a Gold subscription plan.