{"id":15725,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/odemevade\/"},"modified":"2021-02-25T16:39:26","modified_gmt":"2021-02-25T16:39:26","slug":"yieldmat","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/yieldmat\/","title":{"rendered":"\u00d6DEMEVADE"},"content":{"rendered":"<h1>YIELDMAT Fonksiyonunu Kullanarak Yat\u0131r\u0131m Getirileri Hesaplama<\/h1>\n<p>Yat\u0131r\u0131m d\u00fcnyas\u0131nda, \u00f6zellikle sabit getirili menkul k\u0131ymetler s\u00f6z konusu oldu\u011funda, yat\u0131r\u0131mc\u0131lar i\u00e7in en \u00f6nemli verilerden biri getiriyi anlamakt\u0131r. Bu rehberde, MS Excel ve Google E-Tablolar&#8217;da kullan\u0131lan <strong>YIELDMAT<\/strong> fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ayr\u0131nt\u0131l\u0131 bir \u015fekilde a\u00e7\u0131klayaca\u011f\u0131z. <\/p>\n<h2>Fonksiyonun Kullan\u0131m\u0131<\/h2>\n<p><strong>YIELDMAT<\/strong> fonksiyonu, bir menkul k\u0131ymetin vade tarihi, itfa tarihi, nominal de\u011feri ve fiyat\u0131 verildi\u011fi zaman getiri oran\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Fonksiyonun yap\u0131s\u0131 a\u015fa\u011f\u0131daki gibi \u00f6zetlenebilir:<\/p>\n<pre> <code> YIELDMAT(al\u0131s_tarihi, vade_tarihi, itfa_tarihi, fiyat, de\u011fer, [day_count_convention]) <\/code> <\/pre>\n<ul>\n<li><strong>al\u0131s_tarihi:<\/strong> Menkul k\u0131ymetin sat\u0131n al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n<li><strong>vade_tarihi:<\/strong> Menkul k\u0131ymetin itfa edildi\u011fi tarih.<\/li>\n<li><strong>itfa_tarihi:<\/strong> Menkul k\u0131ymetin sahibine nominal de\u011ferinin \u00f6denece\u011fi tarih.<\/li>\n<li><strong>fiyat:<\/strong> Menkul k\u0131ymetin al\u0131\u015f fiyat\u0131.<\/li>\n<li><strong>de\u011fer:<\/strong> Menkul k\u0131ymetin nominal de\u011feri.<\/li>\n<li><strong>day_count_convention<\/strong> (\u0130ste\u011fe ba\u011fl\u0131): G\u00fcn sayma kural\u0131n\u0131 belirtir. Excel&#8217;de bu, genellikle 0 (ABD(NASD) 30\/360), 1 (Ger\u00e7ek\/ger\u00e7ek), 2 (Ger\u00e7ek\/360), 3 (Ger\u00e7ek\/365), veya 4(Europ30\/360) de\u011ferlerinden birisidir.<\/li>\n<\/ul>\n<h2>Pratik \u00d6rnekler<\/h2>\n<p>Yukar\u0131daki fonksiyonun kullan\u0131m\u0131n\u0131 daha iyi anlamak i\u00e7in ger\u00e7ek d\u00fcnya senaryolar\u0131ndan iki \u00f6rnek \u00fczerinden gidece\u011fiz. <\/p>\n<h3>\u00d6rnek 1: Yat\u0131r\u0131m Getirisinin Hesaplanmas\u0131<\/h3>\n<p>Farz edelim ki, bir yat\u0131r\u0131mc\u0131 1000 birimlik nominal de\u011fere sahip bir menkul k\u0131ymeti, 950 birime al\u0131\u015f tarihinde sat\u0131n ald\u0131 ve bu k\u0131ymetin itfa tarihi al\u0131\u015ftan bir y\u0131l sonra. Al\u0131\u015f tarihi 01.01.2023, itfa tarihi ise 01.01.2024 olsun. Yat\u0131r\u0131mc\u0131, menkul k\u0131ymetin getirisini hesaplamak istiyor.<\/p>\n<pre> <code> = YIELDMAT(\"01\/01\/2023\", \"01\/01\/2024\", \"01\/01\/2024\", 950, 1000, 0) <\/code> <\/pre>\n<p>Bu form\u00fcl, menkul k\u0131ymetin yat\u0131r\u0131m getirisini %5.26 olarak hesaplar. Bu, yat\u0131r\u0131mc\u0131n\u0131n bir y\u0131l sonunda elde edece\u011fi getiridir.<\/p>\n<h3>\u00d6rnek 2: Farkl\u0131 Day Count Convention Kullan\u0131m\u0131<\/h3>\n<p>\u0130lk \u00f6rne\u011fimizdeki ayn\u0131 senaryo i\u00e7in farkl\u0131 bir g\u00fcn say\u0131m kural\u0131 uygulayarak, ger\u00e7ek\/ger\u00e7ek kural\u0131n\u0131 kullanaca\u011f\u0131z (1 olarak ifade edilir).<\/p>\n<pre> <code> = YIELDMAT(\"01\/01\/2023\", \"01\/01\/2024\", \"01\/01\/2024\", 950, 1000, 1) <\/code> <\/pre>\n<p>Bu durumda, hesaplanan getiri bir miktar de\u011fi\u015fecek ve yat\u0131r\u0131mc\u0131n\u0131n ald\u0131\u011f\u0131 risk ve getirinin daha ger\u00e7ek\u00e7i bir de\u011feri ortaya \u00e7\u0131kacakt\u0131r. <\/p>\n<p>Kullan\u0131lan g\u00fcn say\u0131m kural\u0131na ba\u011fl\u0131 olarak hesaplanan yat\u0131r\u0131m getirisinin de\u011fi\u015febilece\u011fini unutmamak \u00f6nemlidir. Bu, \u00f6zellikle farkl\u0131 piyasa ko\u015fullar\u0131nda ve \u00e7e\u015fitli menkul k\u0131ymet tiplerinde \u00f6nemli bir fark yaratabilir. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Vadesinin bitiminde faiz \u00f6deyen bir tahvilin y\u0131ll\u0131k \u00f6demesini 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-15725","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de YIELDMAT (\u00d6DEMEVADE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da YIELDMAT (\u00d6DEMEVADE) 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\/yieldmat\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de YIELDMAT (\u00d6DEMEVADE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da YIELDMAT (\u00d6DEMEVADE) 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\/yieldmat\/\" \/>\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:39:26+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de YIELDMAT (\u00d6DEMEVADE) 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\/yieldmat\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/yieldmat\/\",\"name\":\"Excel'de YIELDMAT (\u00d6DEMEVADE) 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:39:26+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da YIELDMAT (\u00d6DEMEVADE) 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\/yieldmat\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/yieldmat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/yieldmat\/#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\":\"\u00d6DEMEVADE\"}]},{\"@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 YIELDMAT (\u00d6DEMEVADE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da YIELDMAT (\u00d6DEMEVADE) 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\/yieldmat\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de YIELDMAT (\u00d6DEMEVADE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da YIELDMAT (\u00d6DEMEVADE) 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\/yieldmat\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:39:26+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de YIELDMAT (\u00d6DEMEVADE) 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\/yieldmat\/","url":"https:\/\/functiontranslator.com\/tr\/yieldmat\/","name":"Excel'de YIELDMAT (\u00d6DEMEVADE) 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:39:26+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da YIELDMAT (\u00d6DEMEVADE) 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\/yieldmat\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/yieldmat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/yieldmat\/#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":"\u00d6DEMEVADE"}]},{"@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\/15725","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=15725"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15725\/revisions"}],"predecessor-version":[{"id":26993,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15725\/revisions\/26993"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}