Syntax<\/h3>\n
MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])<\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Seemingly the formula feeds on multiple parameters and it might look a little complex. But understanding the concepts with the help of a few examples should make us feel at ease. So, let\u2019s dive into them head first.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/MDURATION-1.png” alt=”MDURATION 1″ title_text=”MDURATION 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Please note that the\u00a0settlement<\/strong>\u00a0and\u00a0maturity<\/strong>\u00a0parameters require valid dates. Therefore, we need to use either the results from formulas such as\u00a0DATE<\/a>,\u00a0TO_DATE<\/a>, or references to other date\u00a0type cells. If we do not ensure this, Google Sheets may return parsing errors. Similarly, the other parameters \u2013\u00a0rate<\/strong>,\u00a0yield<\/strong>,\u00a0frequency<\/strong>, and\u00a0day_count_convention\u00a0<\/strong>\u2013 can be direct numeric values or references to the cells holding the appropriate values.<\/p>\n We might notice\u00a0that all the formulas seem to produce different output values. Even if the initial parameters effectively being the same. This is happening due to the day counting method which we indicated using the final\u00a0day_count_convention<\/strong>\u00a0parameter.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n And there you go! Use the MDURATION formula in Google Sheets to calculate the modified Macaulay duration.<\/p>\n If you\u2019d like to learn more about the various formulas of Google Sheets, why not take a look at our blog post on the DURATION formula in Google Sheets<\/a>.<\/p>\n Alternatively, check out related blog posts below!<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Given the expected yield that an investment and the interest rate, the\u00a0MDURATION formula\u00a0in Google Sheets calculates the modified Macaulay duration. It is the weighted average\u00a0before the buyer would receive the investment\u2019s cash flows. Also, the formula will require other inputs as explained below, for it to be able to evaluate the duration correctly. Syntax MDURATION(settlement, […]<\/p>\n","protected":false},"author":40,"featured_media":8398,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Given the expected yield that an investment and the interest rate, the MDURATION<\/a> formula in Google Sheets calculates the modified Macaulay duration. It is the weighted average before the buyer would receive the investment's cash flows. Also, the formula will require other inputs as explained below, for it to be able to evaluate the duration correctly.\n\n
\n
Usage: MDURATION formula in Google Sheets<\/h3>\n
MDURATION formula<\/h3>\n
Syntax<\/h3>\nMDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])<\/strong>\n
\n \t
\n \t
Usage: MDURATION formula in Google Sheets<\/h3>\nSeemingly the formula feeds on multiple parameters and it might look a little complex. But understanding the concepts with the help of a few examples should make us feel at ease. So, let's dive into them head first.\n\n
![\"MDURATION](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/MDURATION-formula-Illustration-Frame-1.png\")
\n\nPlease note that the settlement<\/strong> and maturity<\/strong> parameters require valid dates. Therefore, we need to use either the results from formulas such as DATE<\/a>, TO_DATE<\/a>, or references to other date type cells. If we do not ensure this, Google Sheets may return parsing errors. Similarly, the other parameters \u2013 rate<\/strong>, yield<\/strong>, frequency<\/strong>, and day_count_convention <\/strong>\u2013 can be direct numeric values or references to the cells holding the appropriate values.\n\nWe might notice that all the formulas seem to produce different output values. Even if the initial parameters effectively being the same. This is happening due to the day counting method which we indicated using the final day_count_convention<\/strong> parameter.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8397","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=8397"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8397\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/8398"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}