Excel or Google Sheets. Get monthly prices on one stock, the current T-bill rate, and the premium, strike, and expiration on at least three options
Excel or Google Sheets. Get monthly prices on one stock, the current T-bill rate, and the premium, strike, and expiration on at least three options on that stock. Use a binomial model withu,d, andrfrom the data and at least ten periods to price the options. Use the Black-Scholes equation to price the options. Compare these to the actual price of the options.
Microsoft Stock
MSFT Date Open High LOW Close Adj Close Volume 2017- 04- 01 | null null null null null null 2017 - 05 - 01 | 6 68. 680000 70. 7399 98 67. 139999 69. 8399 96 67. 27 1942 5172 1 8500 2017- 06 - 01 | 70. 239998 72.889999 68. 089996 68. 930000 66. 775978 629584800 2017 - 07 - 01 | 69. 330002 74. 419 998 68. 019997 72.699997 70. 428162 46985 1 200 2017- 08- 01 | 73. 0999 98 74.959999 71 .279999 74. 769997 72. 433472 44 4041 200 2017 - 09- 01 | 74. 709999 75. 9700 01 72. 91 9 9 98 74. 489998 72.546715 375983900 2017- 10 - 01 | 74. 709999 86. 199997 73. 709999 83. 180000 81. 010 010 4 49 950000 2017 - 71 - 01 | 83. 680000 85. 059.9 98 82.239998 84. 169998 81. 974782 421 2 29400 2017- 12 - 01 | 83.599998\\ 87. 500000 80. 699997 85. 540001 83. 726814 466203300 2018 - 01 - 01 | 86. 129997 95. 449997 85. 500000 95. 010002 92. 996078 57 4239800 2018 - 02- 01 | 94. 790001 96. 07000 0 83. 830002 93. 769997 91. 782364 725663300 2018 - 03 - 01 | 93. 989998 97. 239998 87. 080002 91 . 269997 89.755013 75075 4800 2018 - 04 - 01 | 90. 470001 97. 900002 87. 5 10002 93.5 1 9997 91. 967659 668130700 2018- 05- 01 | 93. 209999 99. 9899 98 92. 449997 98. 8399 96 97 . 199356 509281500 2018 - 06- 01 | 99. 279999 102. 690002| 97 . 260002 98. 610001 97. 393494 602585200 2018- 07 - 01 | 98. 09 9998 1 1 1 . 150002 | 98. 00000 0 106. 080002\\ 104. 7 71339\\ 569352300 2018- 08- 01 / 106. 029999\\ 9 / 1 12. 779999 | 104. 839 9 96 | 1 12.330002\\ 1 10 . 94 4244 45661 1300 2018 - 09 - 01\\ 1 / 1 10 . 849998 | 1 15 . 290001\\ 107 . 230003| 714 . 370003 3 | 1 13. 393768\\ \\48025 5500 2018-10- 01 / 1 14. 750000 | 1 16. 180000| 100. 1 10001 | 106. 809998\\ 3 | 105. 898293\\ 9275 48000 2018- 71- 01 | 107. 050003 | 1 12. 239998| 99. 349 998 1 10. 889999 | 109. 943474| 7202 28600 2018 - 12 - 01 / 1 13. 000000 | 1 13. 419 998| 93. 959 999 101 . 570000 101 . 138069 94 431 4600 2019 - 01 - 01\\ |99. 550003 107 . 900002| 97 . 199997\\ 104 . 430000 103. 985909\\ \\71 4157300 2019 - 02- 01 / 103. 779 999 / 1 13. 239998| 102. 349 998| 1 12. 029999 | 171. 553589\\ 469095900 2019 - 03 - 01 / 1 12.889999 | 120. 820000| 108. 800003 | 1 17 . 940002\\ | 1 17. 940002\\ 58907 8100 2019- 04 - 01 / 1 18. 949997\\ 7 \\ 131. 369995 / 1 18. 099998\\ 8 | 129 . 770004 | 129. 770004\\ | 40893 1200