{"id":15671,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/htahes\/"},"modified":"2021-02-25T16:37:23","modified_gmt":"2021-02-25T16:37:23","slug":"tbilleq","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/tbilleq\/","title":{"rendered":"HTAHE\u015e"},"content":{"rendered":"

Excel ve Google Sheets, finansal analizlerde s\u0131k\u00e7a ba\u015fvurulan tablo uygulamalar\u0131d\u0131r. Bu uygulamalarda kullan\u0131lan pek \u00e7ok fonksiyondan biri de “TBILLEQ” (HTAHE\u015e) fonksiyonudur. Bu fonksiyon, Amerikan Hazine bonolar\u0131n\u0131n y\u0131ll\u0131k e\u015fde\u011fer getirisini hesaplamak amac\u0131yla kullan\u0131l\u0131r ve k\u0131sa vadeli hazine bonolar\u0131n\u0131n getirilerini de\u011ferlendirmek i\u00e7in idealdir.<\/p>\n

Gereksinimler:<\/strong> “TBILLEQ” fonksiyonunu kullanabilmek i\u00e7in \u00fc\u00e7 ana parametreye ihtiya\u00e7 vard\u0131r:<\/p>\n

    \n
  1. Settlement: Bononun al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n
  2. Maturity: Bononun vade tarihi.<\/li>\n
  3. Discount: Bononun sat\u0131\u015f indirimi y\u00fczdesi.<\/li>\n<\/ol>\n

    Hesaplama yap\u0131l\u0131rken y\u0131l\u0131n 365 g\u00fcn oldu\u011fu varsay\u0131l\u0131r ve bu sayede y\u0131ll\u0131k e\u015fde\u011fer getiri hesaplan\u0131r.<\/p>\n

    S\u00f6zdizimi ve Parametreler<\/h2>\n
      TBILLEQ(settlement, maturity, discount) <\/code> <\/pre>\n
    Form\u00fcldeki parametreler a\u015fa\u011f\u0131daki gibidir:<\/p>\n
      \n
    • settlement<\/strong> – Bononun al\u0131nd\u0131\u011f\u0131 tarih. Bu tarih DATE fonksiyonu ile ya da “YYYY\/MM\/DD” format\u0131nda do\u011frudan girilebilir.<\/li>\n
    • maturity<\/strong> – Bononun vade tarihi. Bu tarih de settlement gibi girilir.<\/li>\n
    • discount<\/strong> – Bononun indirim oran\u0131. Bu oran, bononun nominal de\u011feri \u00fczerinden hesaplan\u0131r ve y\u00fczde cinsinden ifade edilir.<\/li>\n<\/ul>\n
      Uygulama \u00d6rnekleri<\/h2>\n
      \u00d6rnek 1: Basit bir HTAHE\u015e hesaplama<\/strong><\/p>\n
      Bir hazine bonosu 2023\/01\/01 tarihinde sat\u0131n al\u0131nm\u0131\u015f ve 2023\/06\/01 tarihinde vadeye ula\u015facakt\u0131r. Bononun indirim oran\u0131 %5 olarak belirlenmi\u015ftir. E\u015fde\u011fer y\u0131ll\u0131k getirinin hesaplanmas\u0131 i\u015flemi \u015f\u00f6yledir:<\/p>\n
        =TBILLEQ(\"2023\/01\/01\", \"2023\/06\/01\", 5%) <\/code> <\/pre>\n
      Bu hesaplama, bononun y\u0131ll\u0131k e\u015fde\u011fer getirisini g\u00f6sterir.<\/p>\n
      \u00d6rnek 2: Kar\u015f\u0131la\u015ft\u0131rmal\u0131 HTAHE\u015e analizi<\/strong><\/p>\n
      Farkl\u0131 vade tarihleri ve indirim oranlar\u0131na sahip iki hazine bonosunun y\u0131ll\u0131k e\u015fde\u011fer getirilerini kar\u015f\u0131la\u015ft\u0131ral\u0131m:<\/p>\n\n\n\n\n\n\n
      Bono<\/th>\nAl\u0131m Tarihi<\/th>\nVade Tarihi<\/th>\nIndirim<\/th>\nY\u0131ll\u0131k E\u015fde\u011fer Getiri<\/th>\n<\/tr>\n<\/thead>\n
      Bono A<\/td>\n2023\/02\/01<\/td>\n2023\/08\/01<\/td>\n%4<\/td>\n=TBILLEQ(“2023\/02\/01”, “2023\/08\/01”, 4%)<\/td>\n<\/tr>\n
      Bono B<\/td>\n2023\/02\/01<\/td>\n2023\/05\/01<\/td>\n%6<\/td>\n=TBILLEQ(“2023\/02\/01”, “2023\/05\/01”, 6%)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
      Bu tablo, her iki bononun y\u0131ll\u0131k e\u015fde\u011fer getirisini kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in kullan\u0131labilir ve farkl\u0131 vade tarihleri ile indirim oranlar\u0131na sahip bonolar aras\u0131nda analiz yapmak m\u00fcmk\u00fcnd\u00fcr.<\/p>\n
      G\u00f6r\u00fcld\u00fc\u011f\u00fc gibi, TBILLEQ fonksiyonu, k\u0131sa vadeli yat\u0131r\u0131mlar\u0131n getirilerini de\u011ferlendirmede pratik bir ara\u00e7 sunar.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Hazine bonosunun bono e\u015fde\u011feri \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-15671","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de TBILLEQ (HTAHE\u015e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TBILLEQ (HTAHE\u015e) 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\/tbilleq\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TBILLEQ (HTAHE\u015e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TBILLEQ (HTAHE\u015e) 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\/tbilleq\/\" \/>\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:23+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 TBILLEQ (HTAHE\u015e) 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\/tbilleq\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/tbilleq\/\",\"name\":\"Excel'de TBILLEQ (HTAHE\u015e) 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:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TBILLEQ (HTAHE\u015e) 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\/tbilleq\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/tbilleq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/tbilleq\/#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\":\"HTAHE\u015e\"}]},{\"@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 TBILLEQ (HTAHE\u015e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TBILLEQ (HTAHE\u015e) 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\/tbilleq\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TBILLEQ (HTAHE\u015e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TBILLEQ (HTAHE\u015e) 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\/tbilleq\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:37:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TBILLEQ (HTAHE\u015e) 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\/tbilleq\/","url":"https:\/\/functiontranslator.com\/tr\/tbilleq\/","name":"Excel'de TBILLEQ (HTAHE\u015e) 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:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TBILLEQ (HTAHE\u015e) 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\/tbilleq\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/tbilleq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/tbilleq\/#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":"HTAHE\u015e"}]},{"@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\/15671","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=15671"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15671\/revisions"}],"predecessor-version":[{"id":26939,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15671\/revisions\/26939"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}