NexusFi: Find Your Edge


Home Menu

 





How to work with statistics? (IB based trading)


Discussion in Traders Hideout

Updated
    1. trending_up 1,195 views
    2. thumb_up 0 thanks given
    3. group 1 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread

How to work with statistics? (IB based trading)

  #1 (permalink)
 Deetee 
Amsterdam, The Netherlands
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader / IB /Rithmic
Broker: EdgeClear / InteractiveBrokers / Rithmic
Trading: DAX / (M)NQ / (M)ES
Frequency: Daily
Duration: Hours
Posts: 631 since Jul 2019
Thanks Given: 2,822
Thanks Received: 787

I have been working on a system for FDAX and I would like to ask for some feedback. Totally inspired by GFIs1’s successful journal, so it is based on the 9:00 – 9:30 bar (=initial balance=IB).

I created Excel files with 11 years of FDAX RTH data (from Kinetic). One file for each day of the week and each weekday can have the following situations:
a> IB long-short trade
b> IB long-long trade
c> IB short-short trade
d> IB short-long trade
So, 20 situations/files in total.

Each of these files contain data for:
Trade entry time every 30 minutes from 9:30 to 12:00 (6 options)
Trade exit time every 30 minutes from 10:00 to 15:30 (7-12 options, depending on the entry time)
Stoploss 5 to 60pts with 5pts interval (12 options)
These files have some other data, like:
2 days ago Open/Close red or green (2 options)
Prior day Hi/Lo pts
Prior day Op/Cl pts
Gap up, down or none
Gap closed during IB
plus data for the IB Hi/Lo, IB Op/Cl and IB Volume
And then the number of trades that would have happened with their result.

I excluded some German and US holidays, roll-over days and German IFO days. I use (Excel) pivot tables to analyse the data.

In 11 years, there are roughly 2800 trading days (after excluding holidays/IFO days), if you assume 50-50 on short and long IB’s, there are about 280 short trades per weekday and 280 long trades. Is the population size big enough to count on these statistics? And if yes, to rely on the results, how many trades come out of the analysis as a minimum to take the trade?

This example (from the file Tuesdays - long IB - long trades) might clarifies what I mean:
Without other filters, the best result would be 1867 pts with 243 trades (9:30-14:00 SL60). Not good.
Adding a filter on PrDay range Op/Cl: Green gives 1891 pts with 126 trades (9:30-15:30 SL55), 78 wins/48 losses. Sounds better, right?
Adding a filter on 2PrDay range Op/Cl: Red gives 1271 pts with 69 trades (9:30-15:30 SL55). 42 wins/27 losses. More points per trade. Not sure if this is better than the previous example with the 126 trades?!
Adding a filter on PrDay range Hi/Lo cat: 161-200, the best result is 654 pts with 11 trades (9:30-15:30 SL50), 8 wins/3 losses.

I would think that the last one doesn’t have enough samples, with only 11 trades in 11 year. What do you think, and what minimum would you use (based on the 280 population size)?

Thanks for your input,
Deetee

PS. Based on input from @askerix I made the Hi/Lo ranges (and other ranges) more dynamic (ATR and average volume based), but I already had this example and haven’t updated all the files yet, because I hope to get some more input here first.

Visit my NexusFi Trade Journal Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
MC PL editor upgrade
MultiCharts
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Better Renko Gaps
The Elite Circle
ZombieSqueeze
Platforms and Indicators
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
What is Markets Chat (markets.chat) real-time trading ro …
77 thanks
Spoo-nalysis ES e-mini futures S&P 500
55 thanks
Just another trading journal: PA, Wyckoff & Trends
38 thanks
Bigger Wins or Fewer Losses?
24 thanks
The Program
17 thanks
  #2 (permalink)
 Deetee 
Amsterdam, The Netherlands
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader / IB /Rithmic
Broker: EdgeClear / InteractiveBrokers / Rithmic
Trading: DAX / (M)NQ / (M)ES
Frequency: Daily
Duration: Hours
Posts: 631 since Jul 2019
Thanks Given: 2,822
Thanks Received: 787

I guess the total population would be all years that you can get data for, and that the 11 years (sample size, 2800 days) I am using is sufficient.

I'm still confused about how I should look at the sample size. In my example from above, the last one (that only has 11 trades), is the sample size here 69?

Visit my NexusFi Trade Journal Started this thread Reply With Quote
  #3 (permalink)
 Deetee 
Amsterdam, The Netherlands
Market Wizard
 
Experience: Intermediate
Platform: NinjaTrader / IB /Rithmic
Broker: EdgeClear / InteractiveBrokers / Rithmic
Trading: DAX / (M)NQ / (M)ES
Frequency: Daily
Duration: Hours
Posts: 631 since Jul 2019
Thanks Given: 2,822
Thanks Received: 787


Good morning, I started a new journal, and I'll find some answers along the way:


Visit my NexusFi Trade Journal Started this thread Reply With Quote




Last Updated on February 17, 2021


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts