{"id":10815,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/cupdataant\/"},"modified":"2021-02-25T17:16:18","modified_gmt":"2021-02-25T17:16:18","slug":"couppcd","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/","title":{"rendered":"CUPDATAANT"},"content":{"rendered":"

A fun\u00e7\u00e3o COUPPCD, ou CUPDATAANT em portugu\u00eas, \u00e9 utilizada tanto no Microsoft Excel quanto no Google Planilhas para determinar a data do \u00faltimo cupom pago antes da data de liquida\u00e7\u00e3o de um t\u00edtulo financeiro. Essa fun\u00e7\u00e3o \u00e9 extremamente \u00fatil no gerenciamento de investimentos, sendo aplicada principalmente em c\u00e1lculos envolvendo rendimentos de t\u00edtulos de renda fixa.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

A sintaxe da fun\u00e7\u00e3o CUPDATAANT \u00e9 a seguinte:<\/p>\n

COUPPCD(data_liquida\u00e7\u00e3o, data_vencimento, frequ\u00eancia, [base])<\/code><\/pre>\n
    \n
  • data_liquida\u00e7\u00e3o<\/strong>: A data na qual o t\u00edtulo \u00e9 adquirido pelo investidor.<\/li>\n
  • data_vencimento<\/strong>: A data em que o t\u00edtulo atinge sua maturidade e o principal deve ser devolvido.<\/li>\n
  • frequ\u00eancia<\/strong>: A quantidade de pagamentos de cupom por ano, que pode ser 1, 2 ou 4 vezes.<\/li>\n
  • base<\/strong> (opcional): O m\u00e9todo utilizado para contar os dias no ano, podendo ser 0 (30\/360), 1 (real\/real), 2 (real\/360) ou 3 (real\/365).<\/li>\n<\/ul>\n
    Por exemplo, considere um t\u00edtulo com data de liquida\u00e7\u00e3o em 10\/01\/2023, data de vencimento em 10\/01\/2033, frequ\u00eancia semestral de pagamento de cupons, e utilizando a base 30\/360:<\/p>\n
    =COUPPCD(\"10\/01\/2023\", \"10\/01\/2033\", 2, 0)<\/code><\/pre>\n
    Este exemplo retornar\u00e1 a data do \u00faltimo cupom pago antes de 10\/01\/2023, conforme o calend\u00e1rio 30\/360.<\/p>\n
    Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h2>\n
    Monitoramento de Fluxo de Caixa<\/h2>\n
    Imagine um gestor de fundo que precise monitorar os pagamentos de juros de t\u00edtulos para estimar o fluxo de caixa do fundo. Se um t\u00edtulo foi adquirido recentemente e ele deseja descobrir quando ocorreu o \u00faltimo pagamento de cupom, a fun\u00e7\u00e3o CUPDATAANT pode ser empregada para facilitar essa an\u00e1lise:<\/p>\n
    =COUPPCD(\"23\/07\/2023\", \"23\/07\/2030\", 2, 1)<\/code><\/pre>\n
    Utilizando essa f\u00f3rmula, o gestor poder\u00e1 determinar a \u00faltima data de pagamento de juros antes de 23\/07\/2023 para um t\u00edtulo com vencimento em 23\/07\/2030, que realiza pagamentos semestrais e adota a contagem real\/real de dias.<\/p>\n
    An\u00e1lise de Investimentos em T\u00edtulos<\/h2>\n
    Um investidor interessado em ajustar sua carteira poder\u00e1 querer verificar a data do \u00faltimo cupom pago de um t\u00edtulo antes de decidir se compra mais t\u00edtulos ou os vende. Por exemplo, para um t\u00edtulo com condi\u00e7\u00f5es semelhantes ao exemplo anterior, um investidor pode utilizar esta fun\u00e7\u00e3o para confirmar a \u00faltima data de pagamento e ajustar sua estrat\u00e9gia de investimento:<\/p>\n
    =COUPPCD(\"15\/05\/2023\", \"15\/05\/2038\", 4, 3)<\/code><\/pre>\n
    Este c\u00e1lculo auxiliar\u00e1 o investidor a entender melhor o cronograma de pagamentos de juros, o que \u00e9 essencial para planejar o reinvestimento ou a realoca\u00e7\u00e3o de recursos na carteira.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve a data do cup\u00e3o anterior antes da data de regulariza\u00e7\u00e3o<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[438],"tags":[],"class_list":["post-10815","post","type-post","status-publish","format-standard","hentry","category-financeira"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o COUPPCD (CUPDATAANT) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPPCD (CUPDATAANT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\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\/pt-pt\/couppcd\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o COUPPCD (CUPDATAANT) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPPCD (CUPDATAANT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:16:18+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o COUPPCD (CUPDATAANT) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/\",\"name\":\"Fun\u00e7\u00e3o COUPPCD (CUPDATAANT) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:16:18+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPPCD (CUPDATAANT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Financeira\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/financeira\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CUPDATAANT\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o COUPPCD (CUPDATAANT) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPPCD (CUPDATAANT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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\/pt-pt\/couppcd\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o COUPPCD (CUPDATAANT) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPPCD (CUPDATAANT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:16:18+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o COUPPCD (CUPDATAANT) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/","url":"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/","name":"Fun\u00e7\u00e3o COUPPCD (CUPDATAANT) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:16:18+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o COUPPCD (CUPDATAANT) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/couppcd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/couppcd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Financeira","item":"https:\/\/functiontranslator.com\/pt-pt\/financeira\/"},{"@type":"ListItem","position":3,"name":"CUPDATAANT"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10815"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10815\/revisions"}],"predecessor-version":[{"id":25644,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10815\/revisions\/25644"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}