1
$\begingroup$

Need some input in how to attack this problem. Given are 8 timeseries:

  • UK Oil price, Delivery Quarter 1 2020
  • UK Oil price, Delivery Quarter 2 2020
  • UK Oil price, Delivery Quarter 3 2020
  • UK Oil price, Delivery Quarter 4 2020

and

  • FR Oil price, Delivery Quarter 1 2020
  • FR Oil price, Delivery Quarter 2 2020
  • FR Oil price, Delivery Quarter 3 2020
  • FR Oil price, Delivery Quarter 4 2020

The prices plotted (UK=BQ) enter image description here

UK and FR Prices These prices are given for 390 days, starting in september 2017.

The question now is how to price the right to transfer oil from UK to FR. For the year 2020. Context: If UK price is above FR price, assume we can buy at the spot in FR and sell at the UK spot. If we have this transfer right.

The transfer right is bought for a full year and you pay whether you use it or not. You buy a daily transfercapacity and you can choose to not use it (if UK is cheaper than FR for example).

As of now the UK price is 12 cent above US in the quarter one future. 22 cent in quarter 2 -12 cent in quarter 3 16 cent in quarter 4

So this option is intuitively already worth (12+22+16)/4=12.5 cent.

Transfer is only one way. Delivery is done from the first day of the quarter to the last (Q1 starts Jan 1).

I plotted the UK-FR spreads:

enter image description here Now my question is whether there is a good way to attack this problem.

I think that it is smarter to model the UK-FR difference than the underlying timeseries itself. Is that correct?

Also when it comes to modeling this, my intuition says 390 days is not a lot. In previous problems I had multiple years of data so I could better detect seasonality and trends with a STL decomposition. Here that does not seem to make sense.

Any input or ideas are welcome.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.