Serving the Quantitative Finance Community

 
User avatar
hrad
Topic Author
Posts: 8
Joined: February 3rd, 2012, 2:01 pm

Krik Spread Option with Odd Volumes

October 2nd, 2012, 9:10 am

So I'm pricing a spread option, I've used the Espen Haug's implementation which I have pasted below in case required.I'm pricing a spread option on Jan13/Feb13 gas futures. However, in this market one lot of Jan13 gas for example, will deliver 10,000 units per day which over the course of the 31 days in Jan13 will amount to 310,000 units in total. Feb13 on the other hand will only deliver a total of 280,000 units (28 x 10,000 units per day).The model appears to have inputs for 'quantities' but I am not sure if they are designed to be used for this purpose, and even if they are, I am not sure if they are working properly because the prices I get when I use different volumes for asset1 and asset2 are wildly different to what i get when I price it 1:1 for example:Asset1 = 100, Asset2 = 100, Strike = 0, Asset1Vol = 25%, Asset2Vol = 25%, Correlation = 90%, Time = 1 year, Interest Rate = 0, Cost Of Carry's = 0Quantity1 = 1, Quantity2 = 1Call Value = 4.46I then thought if we use Quantity1 = 31, Quantity2 = 28 to account for the different number of days that I would get the right price, but when the model spits out a call value of 332.43 vs the 4.46 I got before I thought I might be doing something wrong!!I then tried Quantity1 = 1, Quantity2 = 28/31 the gave me call value of 10.72 vs the original 4.46 which again seems a bit punchy.Does anyone know what is going on and how I should be accounting for the different volumes???Function SpreadApproximation(CallPutFlag As String, S1 As Double, S2 As Double, Q1 As Double, Q2 As Double, X As Double, T As Double, _ r As Double, b1 As Double, b2 As Double, v1 As Double, v2 As Double, rho As Double) As Double Dim v As Double, S As Double Dim d1 As Double, d2 As Double Dim F As Double F = Q2 * S2 * Exp((b2 - r) * T) / (Q2 * S2 * Exp((b2 - r) * T) + X * Exp(-r * T)) v = Sqr(v1 ^ 2 + (v2 * F) ^ 2 - 2 * rho * v1 * v2 * F) S = Q1 * S1 * Exp((b1 - r) * T) / (Q2 * S2 * Exp((b2 - r) * T) + X * Exp(-r * T)) d1 = (Log(S) + v ^ 2 / 2 * T) / (v * Sqr(T)) d2 = d1 - v * Sqr(T) If CallPutFlag = "c" Then SpreadApproximation = (Q2 * S2 * Exp((b2 - r) * T) + X * Exp(-r * T)) * (S * CND(d1) - CND(d2)) Else SpreadApproximation = (Q2 * S2 * Exp((b2 - r) * T) + X * Exp(-r * T)) * (CND(-d2) - S * CND(-d1)) End If End Function
Last edited by hrad on October 1st, 2012, 10:00 pm, edited 1 time in total.
 
User avatar
daveangel
Posts: 5
Joined: October 20th, 2003, 4:05 pm

Krik Spread Option with Odd Volumes

October 2nd, 2012, 9:49 am

are you sure about the contract spec ? I am no Nat Gas expert but looking at Bberg the contracts are for delivery of 10,000 MMBtus.so if I was pricing the spread option it would be for the exchange of one futures contract for another so in this case Q1 = Q2 = 1
knowledge comes, wisdom lingers
 
User avatar
hrad
Topic Author
Posts: 8
Joined: February 3rd, 2012, 2:01 pm

Krik Spread Option with Odd Volumes

October 2nd, 2012, 10:09 am

ah, I think you're looking at US nat gas, in the US it trades in units per month. I am looking at european gas markets where it trades in units per day
 
User avatar
daveangel
Posts: 5
Joined: October 20th, 2003, 4:05 pm

Krik Spread Option with Odd Volumes

October 2nd, 2012, 10:34 am

yes i was. are the contract prices flat ?
knowledge comes, wisdom lingers
 
User avatar
ZhuLiAn
Posts: 0
Joined: June 9th, 2011, 7:21 am

Krik Spread Option with Odd Volumes

October 2nd, 2012, 11:01 am

with 90% correlation i would use Black-Scholes on a single asset as a first sanity check.
 
User avatar
hrad
Topic Author
Posts: 8
Joined: February 3rd, 2012, 2:01 pm

Krik Spread Option with Odd Volumes

October 2nd, 2012, 12:08 pm

the contract prices arent flat no... but i was just trying to price something up and used the example of Asset1 = 100, Asset2 = 100, Strike = 0 just to make it simple so I could attempt to sense check it.same goes for the correlation ZhuLiAn, 90% is just something I pulled out of thin air to start pricing experiments. in reality it could be 60-80%my real issue is the fact that with odd volumes, even though only slightly ratio'd the premium drastically changes. does anyone know what the "quantites" are supposed to be used for in this model?
 
User avatar
daveangel
Posts: 5
Joined: October 20th, 2003, 4:05 pm

Krik Spread Option with Odd Volumes

October 2nd, 2012, 1:58 pm

is there a quote for the spread (or roll) in the market ? What is the futures contract ?
knowledge comes, wisdom lingers
 
User avatar
hrad
Topic Author
Posts: 8
Joined: February 3rd, 2012, 2:01 pm

Krik Spread Option with Odd Volumes

October 2nd, 2012, 2:07 pm

yepJan13 65.85 / 66.15Feb13 65.85 / 66.15Jan13/Feb13 -0.10 / +0.10
 
User avatar
daveangel
Posts: 5
Joined: October 20th, 2003, 4:05 pm

Krik Spread Option with Odd Volumes

October 2nd, 2012, 2:09 pm

does the contract have a name so I can look it up on bloomberg ?
knowledge comes, wisdom lingers
 
User avatar
hrad
Topic Author
Posts: 8
Joined: February 3rd, 2012, 2:01 pm

Krik Spread Option with Odd Volumes

October 2nd, 2012, 2:11 pm

it's ICE UK Natural gas. Also called NBP