Syntax<\/h3>\n
DISC(settlement, maturity, price, redemption, [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 Nothing helps us as much as examples do to understand a concept, so let\u2019s use a few of them. Please see the snapshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/1.-DISC-formula-Illustration-Frame-1.png” alt=”DISC formula in Google Sheets: Usage” title_text=”disc-formula-usage” _builder_version=”4.16″ 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 we should ensure that we enter only valid dates for\u00a0<\/span>settlement<\/strong>and\u00a0<\/span>maturity<\/strong>\u00a0<\/span>parameters. They can be values returned from functions such as\u00a0<\/span>DATE<\/a>,\u00a0<\/span>TO_DATE<\/a>, or references to other date\u00a0type cells. We cannot enter direct text values for dates. The other parameters can be direct numeric values or can be references to the cells holding the appropriate values.<\/p>\n The DISC formula can also return negative values depending upon\u00a0<\/span>price<\/strong>\u00a0<\/span>and\u00a0<\/span>redemption<\/strong>\u00a0<\/span>values. Please see the illustration below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/2.-DISC-formula-Illustration-Frame-2.png” alt=”DISC formula in Google Sheets” title_text=”disc-formula-google-sheets” _builder_version=”4.16″ 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 We will notice that even if all the first four parameters are essentially the same, the output values vary. This is because of the method with which the days are counted which we indicated using the\u00a0<\/span>day_count_convention<\/strong>\u00a0parameter.<\/span><\/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 DISC formula in Google Sheets to calculate a security’s discount rate based on its price.<\/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 PPMT formula in Google Sheets.<\/span><\/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":" With the\u00a0DISC\u00a0formula in Google Sheets, we can calculate\u00a0a security\u2019s discount rate based on its price. This is one of the myriads of Financial formulas that Google Sheets is ported with. Syntax DISC(settlement, maturity, price, redemption, [day_count_convention]) settlement \u2013\u00a0is the date after issuing the security, when it is actually delivered to the buyer. maturity \u2013\u00a0is the […]<\/p>\n","protected":false},"author":40,"featured_media":15914,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"With the DISC<\/a> formula in Google Sheets, we can calculate a security's discount rate based on its price. This is one of the myriads of Financial formulas that Google Sheets is ported with.\n\n
\n
Usage: DISC formula in Google Sheets<\/h3>\n
DISC formula<\/h3>\n
Syntax<\/h3>\nDISC(settlement, maturity, price, redemption, [day_count_convention])<\/strong>\n
\n \t
\n \t
Usage: DISC formula in Google Sheets<\/h3>\nNothing helps us as much as examples do to understand a concept, so let's use a few of them. Please see the snapshot below.\n\n
![\"1.](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/1.-DISC-formula-Illustration-Frame-1.png\")
\n\nPlease note that we should ensure that we enter only valid dates for settlement<\/strong> and maturity<\/strong> parameters. They can be values returned from functions such as DATE<\/a>, TO_DATE<\/a>, or references to other date type cells. We cannot enter direct text values for dates. The other parameters can be direct numeric values or can be references to the cells holding the appropriate values.\n\nThe DISC formula can also return negative values depending upon price<\/strong> and redemption<\/strong> values. Please see the illustration below.\n\n![\"2.](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/2.-DISC-formula-Illustration-Frame-2.png\")
\n\nWe will notice that even if all the first four parameters are essentially the same, the output values vary. This is because of the method with which the days are counted which we indicated using the day_count_convention<\/strong> parameter.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8298","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\/8298","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=8298"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8298\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/15914"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}