{"id":15335,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kupongundsk\/"},"modified":"2021-02-25T16:24:17","modified_gmt":"2021-02-25T16:24:17","slug":"coupdaysnc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/coupdaysnc\/","title":{"rendered":"KUPONG\u00dcNDSK"},"content":{"rendered":"

Kupong\u00fcnlerinin Hesaplanmas\u0131<\/h2>\n

COUPDAYSNC<\/b> veya T\u00fcrk\u00e7e ad\u0131yla KUPONG\u00dcNDSK<\/b>, Microsoft Excel ve Google E-Tablolar’da finansal analiz yaparken kullan\u0131lan bir fonksiyondur. Bu i\u015flev, bir tahvilin faiz \u00f6deme d\u00f6nemleri aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. \u00d6zellikle, belirli bir tarih itibar\u0131yla sonraki kupon \u00f6deme tarihine kadar ge\u00e7ecek g\u00fcn say\u0131s\u0131n\u0131 bulur.<\/p>\n

\u0130\u015flevin S\u00f6zdizimi<\/h2>\n

\u0130\u015flevin genel yaz\u0131m \u015fekli a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=COUPDAYSNC(ba\u015flang\u0131\u00e7_tarihi, son_tarih, s\u0131kl\u0131k, [temel])<\/code><\/pre>\n
    \n
  • ba\u015flang\u0131\u00e7_tarihi:<\/b> Tahvilin faiz d\u00f6neminin ba\u015flad\u0131\u011f\u0131 tarih.<\/li>\n
  • son_tarih:<\/b> Tahvilin vadesinin doldu\u011fu tarih.<\/li>\n
  • s\u0131kl\u0131k:<\/b> Y\u0131lda ka\u00e7 kupon \u00f6demesi yap\u0131ld\u0131\u011f\u0131n\u0131n belirtildi\u011fi say\u0131 (\u00f6rne\u011fin, 1 y\u0131ll\u0131k, 2 yar\u0131y\u0131ll\u0131k veya 4 \u00e7eyreklik).<\/li>\n
  • temel:<\/b> G\u00fcn say\u0131m\u0131 temelinin ne oldu\u011funu belirten iste\u011fe ba\u011fl\u0131 bir arg\u00fcman. 0 olursa NASD (30\/360), 1 olursa Ger\u00e7ek\/Ger\u00e7ek, 2 olursa Ger\u00e7ek\/360, 3 ise Ger\u00e7ek\/365 \u015feklinde hesaplar.<\/li>\n<\/ul>\n
    Pratik Uygulamalar<\/h2>\n
    Bu fonksiyon, \u00f6zellikle yat\u0131r\u0131m portf\u00f6ylerini y\u00f6netirken ve mali tablolar\u0131 analiz ederken kullan\u0131labilir. \u0130ki \u00f6zg\u00fcn kullan\u0131m senaryosunu inceleyelim:<\/p>\n
    Senaryo 1: Tahvil \u0130\u00e7in Kupon Faizi Hesaplama<\/h3>\n
    Bir yat\u0131r\u0131mc\u0131n\u0131n elindeki, yar\u0131y\u0131ll\u0131k kupon \u00f6demeli ve 30\/360 g\u00fcn say\u0131m temeline sahip bir tahvilde, bir sonraki kupon \u00f6demesine kalan g\u00fcn say\u0131s\u0131n\u0131 hesaplamak istedi\u011fini varsayal\u0131m.<\/p>\n
      =COUPDAYSNC(\"01\/01\/2023\", \"31\/12\/2028\", 2, 0) <\/code> <\/pre>\n
    \u00d6rne\u011fimizde, “01\/01\/2023” ba\u015flang\u0131\u00e7, “31\/12\/2028” ise son tarih olarak kullan\u0131lm\u0131\u015ft\u0131r. Fonksiyon, verilen parametrelerle birlikte sonraki kupon \u00f6demesine ka\u00e7 g\u00fcn kald\u0131\u011f\u0131n\u0131 hesaplayacakt\u0131r.<\/p>\n
    Senaryo 2: Y\u0131ll\u0131k Finansal Raporlama<\/h3>\n
    Bir \u015firketin finans departman\u0131, y\u0131l sonunda yap\u0131lacak tahvil \u00f6demeleri i\u00e7in gereken toplam g\u00fcn say\u0131s\u0131n\u0131 hesaplamak isteyebilir. \u015eirket, ger\u00e7ek\/ger\u00e7ek g\u00fcn say\u0131m temelini kullanarak hesap yap\u0131yor olabilir.<\/p>\n
      =COUPDAYSNC(\"01\/06\/2023\", \"01\/06\/2033\", 1, 1) <\/code> <\/pre>\n
    Bu fonksiyon, 01\/06\/2023 tarihinden itibaren bir sonraki y\u0131l\u0131n ayn\u0131 g\u00fcn\u00fcne kadar olan g\u00fcn say\u0131s\u0131n\u0131 hesaplam\u0131\u015f olacak. Bu bilgi, \u015firketin kupon \u00f6demeleri i\u00e7in y\u0131l i\u00e7inde ne kadar likit kayna\u011fa sahip olmas\u0131 gerekti\u011fini planlamas\u0131nda yard\u0131mc\u0131 olur.<\/p>\n
    Yorumlar ve \u00d6neriler<\/h2>\n
    COUPDAYSNC<\/b> fonksiyonunun do\u011fru kullan\u0131m\u0131, tahvil yat\u0131r\u0131mlar\u0131n\u0131 ve mali de\u011ferlendirmeleri yaparken kritik \u00f6neme sahiptir. Fonksiyonun temel parametrelerini ve nas\u0131l etkili bir \u015fekilde kullan\u0131labilece\u011fini anlamak, finans profesyonellerinin do\u011fru ve zaman\u0131nda kararlar almas\u0131na olanak sa\u011flar. \u00d6zellikle mali y\u0131l sonu gibi kritik d\u00f6nemlerde tahvil \u00f6demelerini ve mali y\u00fck\u00fcml\u00fcl\u00fckleri do\u011fru bir \u015fekilde hesaplamak i\u00e7in bu t\u00fcr fonksiyonlardan faydalanmak verimlili\u011fi art\u0131rabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Al\u0131\u015f tarihinden bir sonraki kupon tarihine kadar olan g\u00fcn 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-15335","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de COUPDAYSNC (KUPONG\u00dcNDSK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da COUPDAYSNC (KUPONG\u00dcNDSK) 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\/coupdaysnc\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de COUPDAYSNC (KUPONG\u00dcNDSK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da COUPDAYSNC (KUPONG\u00dcNDSK) 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\/coupdaysnc\/\" \/>\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:17+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 COUPDAYSNC (KUPONG\u00dcNDSK) 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\/coupdaysnc\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/coupdaysnc\/\",\"name\":\"Excel'de COUPDAYSNC (KUPONG\u00dcNDSK) 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:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da COUPDAYSNC (KUPONG\u00dcNDSK) 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\/coupdaysnc\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/coupdaysnc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/coupdaysnc\/#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\":\"KUPONG\u00dcNDSK\"}]},{\"@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 COUPDAYSNC (KUPONG\u00dcNDSK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da COUPDAYSNC (KUPONG\u00dcNDSK) 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\/coupdaysnc\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de COUPDAYSNC (KUPONG\u00dcNDSK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da COUPDAYSNC (KUPONG\u00dcNDSK) 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\/coupdaysnc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de COUPDAYSNC (KUPONG\u00dcNDSK) 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\/coupdaysnc\/","url":"https:\/\/functiontranslator.com\/tr\/coupdaysnc\/","name":"Excel'de COUPDAYSNC (KUPONG\u00dcNDSK) 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:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da COUPDAYSNC (KUPONG\u00dcNDSK) 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\/coupdaysnc\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/coupdaysnc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/coupdaysnc\/#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":"KUPONG\u00dcNDSK"}]},{"@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\/15335","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=15335"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15335\/revisions"}],"predecessor-version":[{"id":26603,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15335\/revisions\/26603"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}