How to calculate implied correlation via observed market price (Margrabe option) The 2019...

I see my dog run

Are there any other methods to apply to solving simultaneous equations?

On the insanity of kings as an argument against monarchy

What does "sndry explns" mean in one of the Hitchhiker's guide books?

Access elements in std::string where positon of string is greater than its size

Lethal sonic weapons

How to reverse every other sublist of a list?

Can't find the latex code for the ⍎ (down tack jot) symbol

Why is it "Tumoren" and not "Tumore"?

Return to UK after being refused

Monty Hall variation

How are circuits which use complex ICs normally simulated?

Potential by Assembling Charges

Inflated grade on resume at previous job, might former employer tell new employer?

What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?

How come people say “Would of”?

Does light intensity oscillate really fast since it is a wave?

Does it makes sense to buy a new cycle to learn riding?

Why do some words that are not inflected have an umlaut?

How to change the limits of integration

Is an up-to-date browser secure on an out-of-date OS?

Manuscript was "unsubmitted" because the manuscript was deposited in Arxiv Preprints

Unbreakable Formation vs. Cry of the Carnarium

How can I fix this gap between bookcases I made?



How to calculate implied correlation via observed market price (Margrabe option)



The 2019 Stack Overflow Developer Survey Results Are InCan the Heston model be shown to reduce to the original Black Scholes model if appropriate parameters are chosen?Calculate volatility from call option priceImplied Correlation using market quotesImplied Vol vs. Calibrated VolInterpretation of CorrelationPricing of Black-Scholes with dividendHow do they calculate stocks implied volatility?Implied correlationEuropean option Vega with respect to expiry and implied volatilityIs American option price lower than European option price?












3












$begingroup$


I can't seem to figure out how to do the following: compute the implied correlation $ρ_{imp}$ by using the observed market price $M_{quote}$ of a Margrabe option, and solving the non-linear equation shown below:



$$M_{quote} = e^{−q_0T}times S_0(0)times N(d_+)−e^{−q_1T}times S_1(0)times N(d_−)$$



where:



$$begin{align}
& d_pm = frac{logfrac{S_0(0)}{S_1(0)}+(q_1 − q_0 ±σ^2/2)T}{sigmasqrt{T}}
\[4pt]
& sigma = sqrt{sigma^2_0 + sigma^2_1 − 2rho_{imp}sigma_0 sigma_1}
end{align}$$



Note that $d_− = d_+ − σsqrt{T}$.










share|improve this question









New contributor




Tara is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$








  • 1




    $begingroup$
    Bear in mind that what you're calculating is the margrabe option implied correlation, it's not necessarily the correct correlation to use for pricing other options, it's important to be aware of that.
    $endgroup$
    – will
    yesterday
















3












$begingroup$


I can't seem to figure out how to do the following: compute the implied correlation $ρ_{imp}$ by using the observed market price $M_{quote}$ of a Margrabe option, and solving the non-linear equation shown below:



$$M_{quote} = e^{−q_0T}times S_0(0)times N(d_+)−e^{−q_1T}times S_1(0)times N(d_−)$$



where:



$$begin{align}
& d_pm = frac{logfrac{S_0(0)}{S_1(0)}+(q_1 − q_0 ±σ^2/2)T}{sigmasqrt{T}}
\[4pt]
& sigma = sqrt{sigma^2_0 + sigma^2_1 − 2rho_{imp}sigma_0 sigma_1}
end{align}$$



Note that $d_− = d_+ − σsqrt{T}$.










share|improve this question









New contributor




Tara is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$








  • 1




    $begingroup$
    Bear in mind that what you're calculating is the margrabe option implied correlation, it's not necessarily the correct correlation to use for pricing other options, it's important to be aware of that.
    $endgroup$
    – will
    yesterday














3












3








3


1



$begingroup$


I can't seem to figure out how to do the following: compute the implied correlation $ρ_{imp}$ by using the observed market price $M_{quote}$ of a Margrabe option, and solving the non-linear equation shown below:



$$M_{quote} = e^{−q_0T}times S_0(0)times N(d_+)−e^{−q_1T}times S_1(0)times N(d_−)$$



where:



$$begin{align}
& d_pm = frac{logfrac{S_0(0)}{S_1(0)}+(q_1 − q_0 ±σ^2/2)T}{sigmasqrt{T}}
\[4pt]
& sigma = sqrt{sigma^2_0 + sigma^2_1 − 2rho_{imp}sigma_0 sigma_1}
end{align}$$



Note that $d_− = d_+ − σsqrt{T}$.










share|improve this question









New contributor




Tara is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$




I can't seem to figure out how to do the following: compute the implied correlation $ρ_{imp}$ by using the observed market price $M_{quote}$ of a Margrabe option, and solving the non-linear equation shown below:



$$M_{quote} = e^{−q_0T}times S_0(0)times N(d_+)−e^{−q_1T}times S_1(0)times N(d_−)$$



where:



$$begin{align}
& d_pm = frac{logfrac{S_0(0)}{S_1(0)}+(q_1 − q_0 ±σ^2/2)T}{sigmasqrt{T}}
\[4pt]
& sigma = sqrt{sigma^2_0 + sigma^2_1 − 2rho_{imp}sigma_0 sigma_1}
end{align}$$



Note that $d_− = d_+ − σsqrt{T}$.







black-scholes correlation european-options implied nonlinear






share|improve this question









New contributor




Tara is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Tara is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited yesterday









Daneel Olivaw

3,0981629




3,0981629






New contributor




Tara is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 2 days ago









TaraTara

186




186




New contributor




Tara is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Tara is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Tara is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.








  • 1




    $begingroup$
    Bear in mind that what you're calculating is the margrabe option implied correlation, it's not necessarily the correct correlation to use for pricing other options, it's important to be aware of that.
    $endgroup$
    – will
    yesterday














  • 1




    $begingroup$
    Bear in mind that what you're calculating is the margrabe option implied correlation, it's not necessarily the correct correlation to use for pricing other options, it's important to be aware of that.
    $endgroup$
    – will
    yesterday








1




1




$begingroup$
Bear in mind that what you're calculating is the margrabe option implied correlation, it's not necessarily the correct correlation to use for pricing other options, it's important to be aware of that.
$endgroup$
– will
yesterday




$begingroup$
Bear in mind that what you're calculating is the margrabe option implied correlation, it's not necessarily the correct correlation to use for pricing other options, it's important to be aware of that.
$endgroup$
– will
yesterday










2 Answers
2






active

oldest

votes


















2












$begingroup$

Let $rhotriangleqrho_{imp}$. Note that:
$$frac{partial sigma}{partial rho}(rho)=-frac{sigma_0sigma_1}{sigma(rho)}<0$$
Therefore $sigma$ is monotonic in implied correlation. In addition, the Margrabe pricing function $M(cdot)$ is also monotonic in volatility $sigma$ thus you can find an unique solution to the equation:
$$tag{1}M_{text{quote}}=M(rho)$$
where:
$$M(rho)=e^{−q_0T}S_0(0)N(d_+)−e^{−q_1T}S_1(0)N(d_−)$$
and $d_pm$ as defined in your question, with $M_{text{quote}}$ the observed market price. In practice, this can be restated as:
$$begin{align}
&min_rholeft(M(rho)-M_{text{quote}}right)^2tag{2}
\
& text{s.t. } rho in [-1,1]
end{align}$$

because $(M(rho)-M_{text{quote}})^2geq0$. This is an optimization problem which can be solved through traditional techniques:




  • The solution suggested by @Alex C will give you a quick, approximate answer;

  • If you want arbitrary precision, you can use a simple Newton algorithm on either $(1)$ or $(2)$ with root value $rho=0$, this is quick to program in Excel VBA, or you can maybe even find an online tool that does it. This PDF explains the method for a vanilla call in a Black-Scholes framework to find the implied volatility, but the set-up is very similar. Another alternative is gradient descent but this would probably take longer to program and you have to do it on $(2)$;

  • You can also use Excel's Solver to find a solution to $(1)$ directly. I have tried with $S_0(0)=$101$, $S_1(0)=$113.5$, $sigma_0=45%$, $sigma_1=37%$, $T=1text{ year}$ and $q_0=q_1=0$ and it has worked just fine.






share|improve this answer











$endgroup$





















    3












    $begingroup$

    We know that $-1lerho_{imp}le 1$ so perhaps the simplest approach is to try the possible values $rho_{imp}={-1,-0.9,-0.8,cdots,0.8,0.9,+1}$, to calculate resulting $sigma$ values, d± values, and $M_{quote}$ values, then see which of these is closest to the observed market price. If desired you can then search a finer grid between two adjacent assumed correlations to pin it down more precisely. It is a manual but relatively simple method.






    share|improve this answer









    $endgroup$














      Your Answer





      StackExchange.ifUsing("editor", function () {
      return StackExchange.using("mathjaxEditing", function () {
      StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
      StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
      });
      });
      }, "mathjax-editing");

      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "204"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: false,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: null,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      noCode: true, onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });






      Tara is a new contributor. Be nice, and check out our Code of Conduct.










      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fquant.stackexchange.com%2fquestions%2f44977%2fhow-to-calculate-implied-correlation-via-observed-market-price-margrabe-option%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      2












      $begingroup$

      Let $rhotriangleqrho_{imp}$. Note that:
      $$frac{partial sigma}{partial rho}(rho)=-frac{sigma_0sigma_1}{sigma(rho)}<0$$
      Therefore $sigma$ is monotonic in implied correlation. In addition, the Margrabe pricing function $M(cdot)$ is also monotonic in volatility $sigma$ thus you can find an unique solution to the equation:
      $$tag{1}M_{text{quote}}=M(rho)$$
      where:
      $$M(rho)=e^{−q_0T}S_0(0)N(d_+)−e^{−q_1T}S_1(0)N(d_−)$$
      and $d_pm$ as defined in your question, with $M_{text{quote}}$ the observed market price. In practice, this can be restated as:
      $$begin{align}
      &min_rholeft(M(rho)-M_{text{quote}}right)^2tag{2}
      \
      & text{s.t. } rho in [-1,1]
      end{align}$$

      because $(M(rho)-M_{text{quote}})^2geq0$. This is an optimization problem which can be solved through traditional techniques:




      • The solution suggested by @Alex C will give you a quick, approximate answer;

      • If you want arbitrary precision, you can use a simple Newton algorithm on either $(1)$ or $(2)$ with root value $rho=0$, this is quick to program in Excel VBA, or you can maybe even find an online tool that does it. This PDF explains the method for a vanilla call in a Black-Scholes framework to find the implied volatility, but the set-up is very similar. Another alternative is gradient descent but this would probably take longer to program and you have to do it on $(2)$;

      • You can also use Excel's Solver to find a solution to $(1)$ directly. I have tried with $S_0(0)=$101$, $S_1(0)=$113.5$, $sigma_0=45%$, $sigma_1=37%$, $T=1text{ year}$ and $q_0=q_1=0$ and it has worked just fine.






      share|improve this answer











      $endgroup$


















        2












        $begingroup$

        Let $rhotriangleqrho_{imp}$. Note that:
        $$frac{partial sigma}{partial rho}(rho)=-frac{sigma_0sigma_1}{sigma(rho)}<0$$
        Therefore $sigma$ is monotonic in implied correlation. In addition, the Margrabe pricing function $M(cdot)$ is also monotonic in volatility $sigma$ thus you can find an unique solution to the equation:
        $$tag{1}M_{text{quote}}=M(rho)$$
        where:
        $$M(rho)=e^{−q_0T}S_0(0)N(d_+)−e^{−q_1T}S_1(0)N(d_−)$$
        and $d_pm$ as defined in your question, with $M_{text{quote}}$ the observed market price. In practice, this can be restated as:
        $$begin{align}
        &min_rholeft(M(rho)-M_{text{quote}}right)^2tag{2}
        \
        & text{s.t. } rho in [-1,1]
        end{align}$$

        because $(M(rho)-M_{text{quote}})^2geq0$. This is an optimization problem which can be solved through traditional techniques:




        • The solution suggested by @Alex C will give you a quick, approximate answer;

        • If you want arbitrary precision, you can use a simple Newton algorithm on either $(1)$ or $(2)$ with root value $rho=0$, this is quick to program in Excel VBA, or you can maybe even find an online tool that does it. This PDF explains the method for a vanilla call in a Black-Scholes framework to find the implied volatility, but the set-up is very similar. Another alternative is gradient descent but this would probably take longer to program and you have to do it on $(2)$;

        • You can also use Excel's Solver to find a solution to $(1)$ directly. I have tried with $S_0(0)=$101$, $S_1(0)=$113.5$, $sigma_0=45%$, $sigma_1=37%$, $T=1text{ year}$ and $q_0=q_1=0$ and it has worked just fine.






        share|improve this answer











        $endgroup$
















          2












          2








          2





          $begingroup$

          Let $rhotriangleqrho_{imp}$. Note that:
          $$frac{partial sigma}{partial rho}(rho)=-frac{sigma_0sigma_1}{sigma(rho)}<0$$
          Therefore $sigma$ is monotonic in implied correlation. In addition, the Margrabe pricing function $M(cdot)$ is also monotonic in volatility $sigma$ thus you can find an unique solution to the equation:
          $$tag{1}M_{text{quote}}=M(rho)$$
          where:
          $$M(rho)=e^{−q_0T}S_0(0)N(d_+)−e^{−q_1T}S_1(0)N(d_−)$$
          and $d_pm$ as defined in your question, with $M_{text{quote}}$ the observed market price. In practice, this can be restated as:
          $$begin{align}
          &min_rholeft(M(rho)-M_{text{quote}}right)^2tag{2}
          \
          & text{s.t. } rho in [-1,1]
          end{align}$$

          because $(M(rho)-M_{text{quote}})^2geq0$. This is an optimization problem which can be solved through traditional techniques:




          • The solution suggested by @Alex C will give you a quick, approximate answer;

          • If you want arbitrary precision, you can use a simple Newton algorithm on either $(1)$ or $(2)$ with root value $rho=0$, this is quick to program in Excel VBA, or you can maybe even find an online tool that does it. This PDF explains the method for a vanilla call in a Black-Scholes framework to find the implied volatility, but the set-up is very similar. Another alternative is gradient descent but this would probably take longer to program and you have to do it on $(2)$;

          • You can also use Excel's Solver to find a solution to $(1)$ directly. I have tried with $S_0(0)=$101$, $S_1(0)=$113.5$, $sigma_0=45%$, $sigma_1=37%$, $T=1text{ year}$ and $q_0=q_1=0$ and it has worked just fine.






          share|improve this answer











          $endgroup$



          Let $rhotriangleqrho_{imp}$. Note that:
          $$frac{partial sigma}{partial rho}(rho)=-frac{sigma_0sigma_1}{sigma(rho)}<0$$
          Therefore $sigma$ is monotonic in implied correlation. In addition, the Margrabe pricing function $M(cdot)$ is also monotonic in volatility $sigma$ thus you can find an unique solution to the equation:
          $$tag{1}M_{text{quote}}=M(rho)$$
          where:
          $$M(rho)=e^{−q_0T}S_0(0)N(d_+)−e^{−q_1T}S_1(0)N(d_−)$$
          and $d_pm$ as defined in your question, with $M_{text{quote}}$ the observed market price. In practice, this can be restated as:
          $$begin{align}
          &min_rholeft(M(rho)-M_{text{quote}}right)^2tag{2}
          \
          & text{s.t. } rho in [-1,1]
          end{align}$$

          because $(M(rho)-M_{text{quote}})^2geq0$. This is an optimization problem which can be solved through traditional techniques:




          • The solution suggested by @Alex C will give you a quick, approximate answer;

          • If you want arbitrary precision, you can use a simple Newton algorithm on either $(1)$ or $(2)$ with root value $rho=0$, this is quick to program in Excel VBA, or you can maybe even find an online tool that does it. This PDF explains the method for a vanilla call in a Black-Scholes framework to find the implied volatility, but the set-up is very similar. Another alternative is gradient descent but this would probably take longer to program and you have to do it on $(2)$;

          • You can also use Excel's Solver to find a solution to $(1)$ directly. I have tried with $S_0(0)=$101$, $S_1(0)=$113.5$, $sigma_0=45%$, $sigma_1=37%$, $T=1text{ year}$ and $q_0=q_1=0$ and it has worked just fine.







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited 8 hours ago

























          answered yesterday









          Daneel OlivawDaneel Olivaw

          3,0981629




          3,0981629























              3












              $begingroup$

              We know that $-1lerho_{imp}le 1$ so perhaps the simplest approach is to try the possible values $rho_{imp}={-1,-0.9,-0.8,cdots,0.8,0.9,+1}$, to calculate resulting $sigma$ values, d± values, and $M_{quote}$ values, then see which of these is closest to the observed market price. If desired you can then search a finer grid between two adjacent assumed correlations to pin it down more precisely. It is a manual but relatively simple method.






              share|improve this answer









              $endgroup$


















                3












                $begingroup$

                We know that $-1lerho_{imp}le 1$ so perhaps the simplest approach is to try the possible values $rho_{imp}={-1,-0.9,-0.8,cdots,0.8,0.9,+1}$, to calculate resulting $sigma$ values, d± values, and $M_{quote}$ values, then see which of these is closest to the observed market price. If desired you can then search a finer grid between two adjacent assumed correlations to pin it down more precisely. It is a manual but relatively simple method.






                share|improve this answer









                $endgroup$
















                  3












                  3








                  3





                  $begingroup$

                  We know that $-1lerho_{imp}le 1$ so perhaps the simplest approach is to try the possible values $rho_{imp}={-1,-0.9,-0.8,cdots,0.8,0.9,+1}$, to calculate resulting $sigma$ values, d± values, and $M_{quote}$ values, then see which of these is closest to the observed market price. If desired you can then search a finer grid between two adjacent assumed correlations to pin it down more precisely. It is a manual but relatively simple method.






                  share|improve this answer









                  $endgroup$



                  We know that $-1lerho_{imp}le 1$ so perhaps the simplest approach is to try the possible values $rho_{imp}={-1,-0.9,-0.8,cdots,0.8,0.9,+1}$, to calculate resulting $sigma$ values, d± values, and $M_{quote}$ values, then see which of these is closest to the observed market price. If desired you can then search a finer grid between two adjacent assumed correlations to pin it down more precisely. It is a manual but relatively simple method.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 2 days ago









                  Alex CAlex C

                  6,65611123




                  6,65611123






















                      Tara is a new contributor. Be nice, and check out our Code of Conduct.










                      draft saved

                      draft discarded


















                      Tara is a new contributor. Be nice, and check out our Code of Conduct.













                      Tara is a new contributor. Be nice, and check out our Code of Conduct.












                      Tara is a new contributor. Be nice, and check out our Code of Conduct.
















                      Thanks for contributing an answer to Quantitative Finance Stack Exchange!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      Use MathJax to format equations. MathJax reference.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fquant.stackexchange.com%2fquestions%2f44977%2fhow-to-calculate-implied-correlation-via-observed-market-price-margrabe-option%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      Popular posts from this blog

                      VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

                      Tribunal Administrativo e Fiscal de Mirandela Referências Menu de...

                      looking for continuous Screen Capture for retroactivly reproducing errors, timeback machineRolling desktop...