Syntax<\/h3>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])<\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Connections T – One tool – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container” _builder_version=”4.27.4″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_colors_info=”{}” global_module=”255434″ theme_builder_area=”post_content”]<\/p>\n One tool to merge, split, and filter all your spreadsheet data<\/span><\/p>\n Find out how<\/a><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The formula might look a little complicated, but a few examples can establish a clear understanding for us. So let\u2019s get digging straight into them. Please have a look at the screenshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/PRICE-formula-1.png” alt=”PRICE formula 1″ title_text=”PRICE formula 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 We need to ensure the\u00a0settlement<\/strong>\u00a0and\u00a0maturity<\/strong>\u00a0parameters get valid dates as inputs. They can either references to other date type cells or results returned from formulas such as\u00a0DATE<\/a>,\u00a0TO_DATE<\/a>. Otherwise, the formula might return parsing errors.<\/p>\n The other parameters \u2013\u00a0rate<\/strong>,\u00a0yield<\/strong>,\u00a0<\/span>redemption<\/strong>,\u00a0frequency<\/strong>, and\u00a0day_count_convention\u00a0<\/strong>\u2013 can be direct numeric values or can be references to the cells holding the appropriate values. This is demonstrated in the examples above.<\/p>\n In all of the examples, we notice that the initial six parameters are essentially the same. Yet, the output values vary across the examples. This is because of the method with which the days are counted which we indicated using the\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 PRICE formula in Google Sheets to calculate the price of an investment.<\/p>\n If you\u2019d like to learn more about the various formulas of Google Sheets, why not take a look at our blog posts on the SLN formula in Google Sheets <\/span><\/a>and the YIELD formula in Google Sheets<\/a><\/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":" Given the periodic interest rate and expected yield, do you need to calculate the price of an investment or a security? The aptly named\u00a0PRICE\u00a0formula in Google Sheets helps us with that. To be able to\u00a0use the formula, however, we will need additional information corresponding to the security, as explained below. SyntaxPRICE(settlement, maturity, rate, yield, redemption, […]<\/p>\n","protected":false},"author":40,"featured_media":8383,"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 periodic interest rate and expected yield, do you need to calculate the price of an investment or a security? The aptly named PRICE<\/a> formula in Google Sheets helps us with that. To be able to use the formula, however, we will need additional information corresponding to the security, as explained below.\n\n
\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\")
<\/p>\n![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\nUsage: PRICE formula in Google Sheets<\/h3>\n
PRICE formula<\/h3>\n
Syntax<\/h3>\nPRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])<\/strong>\n
\n \t
\n \t
Usage: PRICE formula in Google Sheets<\/h3>\nThe formula might look a little complicated, but a few examples can establish a clear understanding for us. So let's get digging straight into them. Please have a look at the screenshot below.\n\n
![\"PRICE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/PRICE-formula-Illustration-Frame-2.png\")
\n\nWe need to ensure the settlement<\/strong> and maturity<\/strong> parameters get valid dates as inputs. They can either references to other date type cells or results returned from formulas such as DATE<\/a>, TO_DATE<\/a>. Otherwise, the formula might return parsing errors.\n\nThe other parameters \u2013 rate<\/strong>, yield<\/strong>, redemption<\/strong>, frequency<\/strong>, and day_count_convention <\/strong>\u2013 can be direct numeric values or can be references to the cells holding the appropriate values. This is demonstrated in the examples above.\n\nIn all of the examples, we notice that the initial six parameters are essentially the same. Yet, the output values vary across the examples. 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-8382","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\/es\/wp-json\/wp\/v2\/posts\/8382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=8382"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8382\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/8383"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}