{"id":15337,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kuponsayi\/"},"modified":"2021-02-25T16:24:20","modified_gmt":"2021-02-25T16:24:20","slug":"coupnum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/coupnum\/","title":{"rendered":"KUPONSAYI"},"content":{"rendered":"

Microsoft Excel ve Google Sheets’te finansal analizlerin \u00f6nemli bir arac\u0131 olan KUPONSAYI (COUPNUM)<\/strong> fonksiyonu, belirli bir tahvil i\u00e7in toplam kupon say\u0131s\u0131n\u0131, yani \u00f6deme periyotlar\u0131n\u0131n say\u0131s\u0131n\u0131 hesaplar. \u0130\u015fte bu fonksiyonun kullan\u0131m\u0131yla ilgili detayl\u0131 bir rehber.<\/p>\n

KUPONSAYI Fonksiyonunun S\u00f6zdizimi<\/h2>\n

KUPONSAYI fonksiyonun s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

KUPONSAYI(ba\u015flang\u0131\u00e7_tarihi, biti\u015f_tarihi, d\u00f6nem, [temel])<\/strong><\/code><\/pre>\n
    \n
  • ba\u015flang\u0131\u00e7_tarihi:<\/strong> Tahvilin ba\u015flang\u0131\u00e7 tarihini belirten arg\u00fcman.<\/li>\n
  • biti\u015f_tarihi:<\/strong> Tahvilin vadesinin sona erdi\u011fi tarihi belirten arg\u00fcman.<\/li>\n
  • d\u00f6nem:<\/strong> Y\u0131lda ger\u00e7ekle\u015fen kupon \u00f6deme s\u0131kl\u0131\u011f\u0131n\u0131 g\u00f6sterir (\u00f6rne\u011fin, y\u0131lda 1, 2 veya 4 kez).<\/li>\n
  • temel (iste\u011fe ba\u011fl\u0131):<\/strong> G\u00fcn say\u0131m temelini belirtir. E\u011fer bu arg\u00fcman belirtilmez veya 0 ise NASD (30\/360) kullan\u0131l\u0131r; 1 ise Ger\u00e7ek\/Ger\u00e7ek; 2 ise Ger\u00e7ek\/360; 3 ise Ger\u00e7ek\/365; 4 ise Avrupa 30\/360 dayan\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek Uygulamalar<\/h2>\n
    A\u015fa\u011f\u0131da KUPONSAYI fonksiyonunun iki farkl\u0131 kullan\u0131m senaryosu \u00fczerinden a\u00e7\u0131klamalar yap\u0131lacakt\u0131r.<\/p>\n
    Senaryo 1: Y\u0131ll\u0131k Kupon \u00d6demeleri<\/h2>\n
    \u00d6rnek olarak, 01.01.2020 ba\u015flang\u0131\u00e7 ve 31.12.2024 biti\u015f tarihleri ile y\u0131lda bir kez kupon \u00f6deme yapan bir tahvil ele alal\u0131m.<\/p>\n
    Form\u00fcl:<\/strong> =KUPONSAYI(\"01.01.2020\", \"31.12.2024\", 1) Beklenen Sonu\u00e7:<\/strong> 5<\/code><\/pre>\n
    Bu tahvilin toplamda 5 kez kupon \u00f6demesi yap\u0131lacakt\u0131r \u00e7\u00fcnk\u00fc y\u0131lda bir kere \u00f6deme yap\u0131l\u0131yor ve s\u00fcre 5 y\u0131l olarak belirlenmi\u015ftir.<\/p>\n
    Senaryo 2: \u00c7eyreklik Kupon \u00d6demeleri<\/h2>\n
    Bir di\u011fer \u00f6rnekte, 01.01.2020 ba\u015flang\u0131\u00e7 ve 31.12.2022 biti\u015f tarihleri ile \u00e7eyreklik olarak kupon \u00f6deme yapan bir tahvil d\u00fc\u015f\u00fcnelim.<\/p>\n
    Form\u00fcl:<\/strong> =KUPONSAYI(\"01.01.2020\", \"31.12.2022\", 4) Beklenen Sonu\u00e7:<\/strong> 12<\/code><\/pre>\n
    Bu durumda, tahvil i\u00e7in toplam 12 kupon \u00f6demesi yap\u0131lacakt\u0131r, \u00f6deme s\u0131kl\u0131\u011f\u0131 her \u00e7eyrek ve toplam s\u00fcre 3 y\u0131l oldu\u011fundan.<\/p>\n
    Bu fonksiyon, yat\u0131r\u0131m ve finans profesyonelleri i\u00e7in de\u011ferli bir kaynak sunar. Tahvil yat\u0131r\u0131mlar\u0131nda \u00f6deme periyotlar\u0131n\u0131 hesaplamak, getiri analizi yaparken do\u011fru ve h\u0131zl\u0131 bilgi sa\u011flar. KUPONSAYI fonksiyonu sayesinde yat\u0131r\u0131mc\u0131lar, tahvil getirisini daha efektif bir \u015fekilde de\u011ferlendirebilmektedir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Al\u0131\u015f tarihiyle vade tarihi aras\u0131nda \u00f6denecek kuponlar\u0131n say\u0131s\u0131n\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[578],"tags":[],"class_list":["post-15337","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de COUPNUM (KUPONSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COUPNUM (KUPONSAYI) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\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\/tr\/coupnum\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COUPNUM (KUPONSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COUPNUM (KUPONSAYI) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/coupnum\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:24:20+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de COUPNUM (KUPONSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/coupnum\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/coupnum\/\",\"name\":\"Excel'de COUPNUM (KUPONSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:24:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COUPNUM (KUPONSAYI) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/coupnum\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/coupnum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/coupnum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finansal\",\"item\":\"https:\/\/functiontranslator.com\/tr\/finansal\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"KUPONSAYI\"}]},{\"@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\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de COUPNUM (KUPONSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COUPNUM (KUPONSAYI) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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\/tr\/coupnum\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COUPNUM (KUPONSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COUPNUM (KUPONSAYI) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/coupnum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COUPNUM (KUPONSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/coupnum\/","url":"https:\/\/functiontranslator.com\/tr\/coupnum\/","name":"Excel'de COUPNUM (KUPONSAYI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:24:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COUPNUM (KUPONSAYI) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/coupnum\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/coupnum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/coupnum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Finansal","item":"https:\/\/functiontranslator.com\/tr\/finansal\/"},{"@type":"ListItem","position":3,"name":"KUPONSAYI"}]},{"@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":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@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\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15337"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15337\/revisions"}],"predecessor-version":[{"id":26605,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15337\/revisions\/26605"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}