{"id":15673,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/htahodeme\/"},"modified":"2021-02-25T16:37:26","modified_gmt":"2021-02-25T16:37:26","slug":"tbillyield","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/tbillyield\/","title":{"rendered":"HTAH\u00d6DEME"},"content":{"rendered":"

MS Excel ve Google Sheets’te finansal analizler yaparken kullan\u0131lan \u00f6nemli fonksiyonlardan biri de HTAH\u00d6DEME (TBILLYIELD) fonksiyonudur. Bu fonksiyon, ABD Hazine bonolar\u0131n\u0131n getirisini y\u00fczdelik olarak hesaplamak i\u00e7in kullan\u0131l\u0131r. A\u015fa\u011f\u0131da bu fonksiyonun nas\u0131l kullan\u0131laca\u011f\u0131na dair detayl\u0131 bilgiler ve \u00f6rnekler sunulacakt\u0131r.<\/p>\n

Fonksiyonun Kullan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n

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

=HTAH\u00d6DEME(vade_tarihi, sat\u0131\u015f_tarihi, fiyat)<\/code><\/pre>\n
    \n
  • vade_tarihi:<\/strong> Bononun vadesinin dolaca\u011f\u0131 tarih.<\/li>\n
  • sat\u0131\u015f_tarihi:<\/strong> Bononun sat\u0131n al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n
  • fiyat:<\/strong> Nominal de\u011ferin 100 TL’ye b\u00f6l\u00fcnm\u00fc\u015f hali (\u00f6rne\u011fin bono 98.5 TL fiyatla sat\u0131n al\u0131nd\u0131ysa bu de\u011fer 98.5 olarak girilmeli).<\/li>\n<\/ul>\n
    Tarihler Excel’in kabul etti\u011fi formatlarda girilmelidir, fiyat ise genellikle nominal de\u011ferinin alt\u0131nda olacak \u015fekilde ifade edilir.<\/p>\n
    Verilen Fonksiyonun Kullan\u0131m \u00d6rnekleri<\/h2>\n
    A\u015fa\u011f\u0131da, HTAH\u00d6DEME fonksiyonunun tipik kullan\u0131m\u0131na dair iki farkl\u0131 senaryo bulunmaktad\u0131r:<\/p>\n
    Yat\u0131r\u0131m Getirisinin Hesaplanmas\u0131<\/h2>\n
    Diyelim ki, bir yat\u0131r\u0131mc\u0131 15 Temmuz 2020’de 98.5 TL’ye bir Hazine bonosu sat\u0131n ald\u0131 ve bu bononun vade tarihi 15 Temmuz 2021. Yat\u0131r\u0131mc\u0131n\u0131n bu bonodan elde edece\u011fi getiriyi hesaplamak istiyoruz. Excel ya da Google Sheets’te bu bilgilerle hesaplama yapmak i\u00e7in a\u015fa\u011f\u0131daki gibi bir form\u00fcl kullanabiliriz:<\/p>\n
    =HTAH\u00d6DEME(\"15\/07\/2021\",\"15\/07\/2020\",98.5)<\/code><\/pre>\n
    Bu form\u00fcl, bononun y\u0131ll\u0131k y\u00fczde olarak getirisini hesaplar ve yat\u0131r\u0131mc\u0131ya yat\u0131r\u0131m\u0131n\u0131n performans\u0131 hakk\u0131nda fikir verir.<\/p>\n
    Yat\u0131r\u0131m Portf\u00f6y\u00fc Kar\u015f\u0131la\u015ft\u0131rmas\u0131<\/h2>\n
    Bir finans m\u00fcd\u00fcr\u00fc, farkl\u0131 vade tarihleri olan iki hazine bonosundan hangisinin daha y\u00fcksek getiri sundu\u011funu de\u011ferlendirmek istiyor. Bonolar\u0131n \u00f6zellikleri \u015f\u00f6yledir:<\/p>\n\n\n\n\n
    Sat\u0131\u015f Tarihi<\/th>\nVade Tarihi<\/th>\nFiyat<\/th>\n<\/tr>\n
    10\/06\/2020<\/td>\n10\/06\/2021<\/td>\n97.0<\/td>\n<\/tr>\n
    15\/07\/2020<\/td>\n15\/01\/2021<\/td>\n99.0<\/td>\n<\/tr>\n<\/table>\n
    Her iki bono i\u00e7in getiri hesaplama i\u015flemi \u015fu \u015fekilde yap\u0131labilir:<\/p>\n
    =HTAH\u00d6DEME(\"10\/06\/2021\",\"10\/06\/2020\",97.0)<\/code><\/pre>\n
    =HTAH\u00d6DEME(\"15\/01\/2021\",\"15\/07\/2020\",99.0)<\/code><\/pre>\n
    Bu hesaplamalar sayesinde, finans m\u00fcd\u00fcr\u00fc her iki bononun getirilerini kar\u015f\u0131la\u015ft\u0131rabilir ve hangi yat\u0131r\u0131m\u0131n daha avantajl\u0131 oldu\u011funu belirleyebilir.<\/p>\n
    HTAH\u00d6DEME fonksiyonu, yat\u0131r\u0131m ve finans profesyonellerine, Hazine bonosu gibi sabit getirili menkul k\u0131ymetlerin performans\u0131n\u0131 de\u011ferlendirme konusunda de\u011ferli bir ara\u00e7 sa\u011flar. Yat\u0131r\u0131m kararlar\u0131 al\u0131rken bu t\u00fcr hesaplamalar, daha bilin\u00e7li ve veriye dayal\u0131 kararlar verilmesini sa\u011flamaktad\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Hazine bonosunun \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-15673","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de TBILLYIELD (HTAH\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TBILLYIELD (HTAH\u00d6DEME) 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\/tbillyield\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TBILLYIELD (HTAH\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TBILLYIELD (HTAH\u00d6DEME) 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\/tbillyield\/\" \/>\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:37: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'de TBILLYIELD (HTAH\u00d6DEME) 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\/tbillyield\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/tbillyield\/\",\"name\":\"Excel'de TBILLYIELD (HTAH\u00d6DEME) 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:37:26+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TBILLYIELD (HTAH\u00d6DEME) 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\/tbillyield\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/tbillyield\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/tbillyield\/#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\":\"HTAH\u00d6DEME\"}]},{\"@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 TBILLYIELD (HTAH\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TBILLYIELD (HTAH\u00d6DEME) 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\/tbillyield\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TBILLYIELD (HTAH\u00d6DEME) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TBILLYIELD (HTAH\u00d6DEME) 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\/tbillyield\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:37:26+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TBILLYIELD (HTAH\u00d6DEME) 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\/tbillyield\/","url":"https:\/\/functiontranslator.com\/tr\/tbillyield\/","name":"Excel'de TBILLYIELD (HTAH\u00d6DEME) 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:37:26+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TBILLYIELD (HTAH\u00d6DEME) 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\/tbillyield\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/tbillyield\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/tbillyield\/#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":"HTAH\u00d6DEME"}]},{"@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\/15673","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=15673"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15673\/revisions"}],"predecessor-version":[{"id":26941,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15673\/revisions\/26941"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}