{"id":6703,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/prix-dcoupon-irreg\/"},"modified":"2021-02-26T08:11:27","modified_gmt":"2021-02-26T08:11:27","slug":"oddlprice","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/oddlprice\/","title":{"rendered":"PRIX.DCOUPON.IRREG"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction PRIX.DCOUPON.IRREG dans Excel (ODDLPRICE en anglais) sert \u00e0 calculer le prix d’un titre qui comporte deux p\u00e9riodes de coupon irr\u00e9guli\u00e8res, c’est-\u00e0-dire des p\u00e9riodes au d\u00e9but ou \u00e0 la fin du titre qui ne correspondent pas \u00e0 la dur\u00e9e habituelle des autres p\u00e9riodes de coupon. Cette fonction est fr\u00e9quemment utilis\u00e9e pour \u00e9valuer les prix des obligations lors de leur premi\u00e8re ou derni\u00e8re p\u00e9riode de coupon avant leur \u00e9ch\u00e9ance, en se basant sur une m\u00e9thode sp\u00e9cifique de comptage des jours.<\/p>\n

Syntaxe<\/h2>\n
PRIX.DCOUPON.IRREG(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])<\/code><\/pre>\n
    \n
  • settlement<\/code> : La date \u00e0 laquelle l’obligation est effectivement achet\u00e9e.<\/li>\n
  • maturity<\/code> : La date \u00e0 laquelle l’obligation arrive \u00e0 \u00e9ch\u00e9ance, c’est-\u00e0-dire quand le principal et les derniers int\u00e9r\u00eats sont pay\u00e9s.<\/li>\n
  • issue<\/code> : La date de lancement de l’obligation.<\/li>\n
  • first_coupon<\/code> : La premi\u00e8re date de paiement des int\u00e9r\u00eats.<\/li>\n
  • rate<\/code> : Le taux annuel d’int\u00e9r\u00eat de l’obligation.<\/li>\n
  • yld<\/code> : Le rendement annuel attendu de l’obligation.<\/li>\n
  • redemption<\/code> : La valeur de rachat de l’obligation par tranche de 100 unit\u00e9s de valeur nominale.<\/li>\n
  • frequency<\/code> : Le nombre de paiements de coupon annuels (1 = Annuel, 2 = Semi-annuel, 4 = Trimestriel).<\/li>\n
  • basis<\/code> : (optionnel) La m\u00e9thode de comptage des jours utilis\u00e9e (0 = 30\/360 US (par d\u00e9faut), 1 = r\u00e9el\/r\u00e9el, 2 = r\u00e9el\/360, 3 = r\u00e9el\/365).<\/li>\n<\/ul>\n
    Exemple de calcul<\/h2>\n
    =PRIX.DCOUPON.IRREG(\"01\/04\/2020\", \"31\/03\/2030\", \"01\/04\/2019\", \"01\/10\/2019\", 0.05, 0.06, 100, 2, 0)<\/code><\/pre>\n
    Dans cet exemple, la fonction calcule le prix d’une obligation avec les caract\u00e9ristiques suivantes :<\/p>\n
      \n
    • Date de r\u00e8glement : 1er avril 2020<\/li>\n
    • Date de maturit\u00e9 : 31 mars 2030<\/li>\n
    • Date d’\u00e9mission : 1er avril 2019<\/li>\n
    • Date du premier coupon : 1er octobre 2019<\/li>\n
    • Taux d’int\u00e9r\u00eat : 5%<\/li>\n
    • Rendement : 6%<\/li>\n
    • Valeur de remboursement : 100<\/li>\n
    • Fr\u00e9quence de paiement des coupons : semi-annuelle<\/li>\n
    • Base de calcul des jours : 30\/360 US<\/li>\n<\/ul>\n
      Utilisations pratiques<\/h2>\n
      Calcul du prix d’achat initial d’une obligation<\/h3>\n
      L’utilisation de PRIX.DCOUPON.IRREG est id\u00e9ale pour d\u00e9terminer le prix \u00e0 payer pour une obligation nouvellement \u00e9mise qui pr\u00e9sente des premiers ou derniers coupons sur des p\u00e9riodes irr\u00e9guli\u00e8res, en prenant en consid\u00e9ration le rendement souhait\u00e9 et la sp\u00e9cificit\u00e9 des p\u00e9riodes de coupon.<\/p>\n
      \u00c9valuation du rendement des investissements<\/h3>\n
      Cette fonction est aussi pr\u00e9cieuse pour les investisseurs qui cherchent \u00e0 \u00e9valuer le rendement potentiel de diff\u00e9rentes obligations, particuli\u00e8rement lorsque les p\u00e9riodes de coupon diff\u00e8rent des cycles traditionnels. Elle permet ainsi une comparaison plus juste entre diverses options d’investissement.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie le pRix paR tRanche de valeuR nominale de 100\u00a0euRos d\u2019un titRe dont la deRni\u00e8Re p\u00e9Riode de coupon est iRR\u00e9guli\u00e8Re<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[311],"tags":[],"class_list":["post-6703","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction ODDLPRICE (PRIX.DCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ODDLPRICE (PRIX.DCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/oddlprice\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ODDLPRICE (PRIX.DCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ODDLPRICE (PRIX.DCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/oddlprice\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:11:27+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ODDLPRICE (PRIX.DCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/oddlprice\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/oddlprice\/\",\"name\":\"Fonction ODDLPRICE (PRIX.DCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:11:27+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ODDLPRICE (PRIX.DCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/oddlprice\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/oddlprice\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/oddlprice\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finances\",\"item\":\"https:\/\/functiontranslator.com\/fr\/finances\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PRIX.DCOUPON.IRREG\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction ODDLPRICE (PRIX.DCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ODDLPRICE (PRIX.DCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/oddlprice\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ODDLPRICE (PRIX.DCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ODDLPRICE (PRIX.DCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/oddlprice\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:27+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ODDLPRICE (PRIX.DCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/oddlprice\/","url":"https:\/\/functiontranslator.com\/fr\/oddlprice\/","name":"Fonction ODDLPRICE (PRIX.DCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:11:27+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ODDLPRICE (PRIX.DCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/oddlprice\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/oddlprice\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/oddlprice\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Finances","item":"https:\/\/functiontranslator.com\/fr\/finances\/"},{"@type":"ListItem","position":3,"name":"PRIX.DCOUPON.IRREG"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6703"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6703\/revisions"}],"predecessor-version":[{"id":29714,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6703\/revisions\/29714"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}