NexusFi: Find Your Edge


Home Menu

 





Spread trading, calculating spread


Discussion in Emini and Emicro Index

Updated
      Top Posters
    1. looks_one calhawk01 with 5 posts (0 thanks)
    2. looks_two sledmt with 2 posts (0 thanks)
    3. looks_3 jumpingfella with 1 posts (0 thanks)
    4. looks_4 Quick Summary with 1 posts (0 thanks)
    1. trending_up 6,469 views
    2. thumb_up 1 thanks given
    3. group 11 followers
    1. forum 13 posts
    2. attach_file 0 attachments




 
Search this Thread

Spread trading, calculating spread

  #1 (permalink)
 calhawk01 
baltimore marylnd
 
Experience: Beginner
Platform: ninja
Trading: es
Posts: 91 since May 2013
Thanks Given: 5
Thanks Received: 11

Hi guys; call me a dumbass if you want but i got a simple question. what is the formula to calculate spread between ES and NQ?

ES - NQ= pure price spread
ES% return vs NQ%= % spread
ES*50 / NQ*20= spread

I tried googling and there are so many different ways? What is the most common/efficient? I just started reading up on pair trading and would like to create an indicator (that I can share once I create it).

Essentially I want to:

Calculate the spread
Find the mean
Find the standard deviation
Plot them all on a chart
Buy sell when spread is above/below std

Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
ZombieSqueeze
Platforms and Indicators
How to apply profiles
Traders Hideout
Trade idea based off three indicators.
Traders Hideout
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Just another trading journal: PA, Wyckoff & Trends
34 thanks
Tao te Trade: way of the WLD
24 thanks
GFIs1 1 DAX trade per day journal
17 thanks
Vinny E-Mini & Algobox Review TRADE ROOM
13 thanks
My NQ Trading Journal
12 thanks
  #3 (permalink)
sledmt
Kalispell montana
 
Posts: 158 since Jan 2015
Thanks Given: 157
Thanks Received: 23


Curious, are still looking into spread trading?

Reply With Quote
  #4 (permalink)
 montanajtt 
Como, Italy
 
Experience: Advanced
Platform: Tradestation, IB
Broker: Tradestation, IB
Trading: ES
Frequency: Daily
Duration: Minutes
Posts: 184 since Aug 2014
Thanks Given: 299
Thanks Received: 312

I just trade spread with commodities, never tryed index. With commodities I usually just take the spread multipling the instrument with the point value
in your case would be es*50 - nq*20

But I guess all depends to what you are looking for in this spread

Reply With Quote
  #5 (permalink)
sledmt
Kalispell montana
 
Posts: 158 since Jan 2015
Thanks Given: 157
Thanks Received: 23

I was looking at using spread to limit risk during the trade.

Reply With Quote
  #6 (permalink)
 calhawk01 
baltimore marylnd
 
Experience: Beginner
Platform: ninja
Trading: es
Posts: 91 since May 2013
Thanks Given: 5
Thanks Received: 11

Hi guys. So here are my findings. It may help someone one day. Or correct me if I'm wrong!

Ratio= Instrument 1 / Instrument 2;

Spread = Ratio - Moving Average of Ratio; // essentially this tells us how far the current ratio value is from it's moving average

z-score = spread / standard deviation

Started this thread Reply With Quote
  #7 (permalink)
 calhawk01 
baltimore marylnd
 
Experience: Beginner
Platform: ninja
Trading: es
Posts: 91 since May 2013
Thanks Given: 5
Thanks Received: 11

hi guys, i'm having a bit trouble conceptually understanding the pair between Gold and SP500. These are both co-integrated pairs and have negative correlation. Co-integration means that historically, the spread between these two expands and then contracts. An expansion follows a contraction, and a contraction follows a expansion. Right now, SP500 has outperformed gold and the spread has expanded. I'm having trouble picking the buy/sell sides of these pairs to profit from the contraction in spread.

Lets say sp500/gc pair has hit a peak and my bet is that the spread is going to decrease. In other words, I am betting that gold will outperform sp500; would I just go long gold and gold sp500, even though these are negatively correlated? And hope that gold prices appreciate more than sp500? Would this be an outright trade? You see, if the pair was sp500/nasdaq, its easy to pick the side because both are positively correlation, so you are essentially going long both or short both and your profit is the spread. But in the case of negatively correlated instruments, how do I set up the trade? THX!

Also if anybody has any good examples of making the pair beta neutral, that would be awsome!

Started this thread Reply With Quote
  #8 (permalink)
 addchild 
Bay Area California
 
Experience: None
Platform: TT T4
Broker: Phillip Capital
Trading: Futures
Posts: 809 since Nov 2011
Thanks Given: 926
Thanks Received: 898


calhawk01 View Post
hi guys, i'm having a bit trouble conceptually understanding the pair between Gold and SP500. These are both co-integrated pairs and have negative correlation. Co-integration means that historically, the spread between these two expands and then contracts. An expansion follows a contraction, and a contraction follows a expansion. Right now, SP500 has outperformed gold and the spread has expanded. I'm having trouble picking the buy/sell sides of these pairs to profit from the contraction in spread.

Lets say sp500/gc pair has hit a peak and my bet is that the spread is going to decrease. In other words, I am betting that gold will outperform sp500; would I just go long gold and gold sp500, even though these are negatively correlated? And hope that gold prices appreciate more than sp500? Would this be an outright trade? You see, if the pair was sp500/nasdaq, its easy to pick the side because both are positively correlation, so you are essentially going long both or short both and your profit is the spread. But in the case of negatively correlated instruments, how do I set up the trade? THX!

Also if anybody has any good examples of making the pair beta neutral, that would be awsome!

With positive correlation you would typically Buy one product and sell the other. With Negative correlation you are Buying or selling both products in the same direction.

.
Reply With Quote
  #9 (permalink)
 calhawk01 
baltimore marylnd
 
Experience: Beginner
Platform: ninja
Trading: es
Posts: 91 since May 2013
Thanks Given: 5
Thanks Received: 11

Thanks addchild.

Also what does everything think of the below:

so right now it seems most people, including myself, the way they calculate ratio is:

instrument1/instrument2

the above just doesnt seem to make sense to me as just dividing prices of two stocks do not really tell the entire story, as some stocks have higher tick values, point values and larger average true range. so what does everyone think of the below calculation:

a == (average true range of instrument 1 / tick size) * point value // to get the net dollar move
b == (average true range of instrument 2 / tick size) * point value // to get the net dollar move
c == a/b

for Gold as ES the above plays out as:

a = ....
b = ....
c = 1015/1992 = .5

So basically the above ratio says that on average Gold's dollar move is twice as large as ES. So now we can use the above ratio to give our ratio some weights.

so the final ratio is:

d = ES/(Gold *.5) // here we are essentially trying to make ES and Gold equivalent of one another.. to find days that are wacked out.

What do you think?

and then we can use the above ratio to give weights to the price ratio.

Started this thread Reply With Quote
  #10 (permalink)
 
tigertrader's Avatar
 tigertrader 
Philly, Pa
Legendary Market Wizard
 
Experience: Master
Platform: NinjaTrader
Trading: ES, ZB
Posts: 6,482 since Jul 2010
Thanks Given: 6,662
Thanks Received: 36,258


you're better off just trading the out-rights and not attempting tp spread the two against each other as there's really no advantage in doing so. if you think you're going to somehow reduce your risk because you're spreading ; think again. also, there isn't any spread margin for that spread and you're going to be incurring more friction because you are going to be paying twice the commissions and experience twice the slippage, especially in the gold. i would first learn how-to trade, period. and then you can play around with spread trading if you wish. but, in the electronic arena, there is really no advantage in doing so. the whole idea behind trading, is making money, and spreading does not afford you the best opportunity for making the most amount of money.

Follow me on Twitter Reply With Quote
Thanked by:




Last Updated on February 21, 2017


© 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