{"id":15672,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/htahdeger\/"},"modified":"2021-02-25T16:37:25","modified_gmt":"2021-02-25T16:37:25","slug":"tbillprice","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/tbillprice\/","title":{"rendered":"HTAHDE\u011eER"},"content":{"rendered":"

Devlet tahvilleri, yat\u0131r\u0131mc\u0131lar i\u00e7in \u00f6nemli finansal ara\u00e7lardan biridir ve finansal analizlerde tahvil de\u011ferlemesi yapmak b\u00fcy\u00fck bir \u00f6nem ta\u015f\u0131r. Microsoft Excel ve Google E-Tablolar ikisi de bu t\u00fcr finansal analizler i\u00e7in olduk\u00e7a etkili ara\u00e7lard\u0131r. Bu makalede, hem Excel hem de Google E-Tablolar’da kullan\u0131lan TBILLPRICE<\/code> (T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131yla HTAHDE\u011eER<\/code>) fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131na dair detayl\u0131 bilgiler, \u00f6rnekler ve pratik uygulamalar hakk\u0131nda bilgi verilecektir.<\/p>\n

HTAHDE\u011eER \u0130\u015flevinin Genel Tan\u0131m\u0131<\/h2>\n

HTAHDE\u011eER<\/code> i\u015flevi, belirli bir vade tarihi, indirim oran\u0131 ve y\u00fcz de\u011feri ile verilen Hazine bonosunu alma fiyat\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu i\u015flev, yat\u0131r\u0131mc\u0131n\u0131n k\u0131sa vadeli devlet tahvillerinden bekledi\u011fi getiriyi hesaplarken \u00f6nemli bir rol oynar.<\/p>\n

 S\u00f6zdizimi: HTAHDE\u011eER(yat\u0131r\u0131m_tarihi, vade_tarihi, indirim_oran\u0131, y\u00fczde\u011feri, [day_basis]) <\/code><\/pre>\n
    \n
  • yat\u0131r\u0131m_tarihi<\/strong>: Tahvilin al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n
  • vade_tarihi<\/strong>: Tahvilin itfa tarihi.<\/li>\n
  • indirim_oran\u0131<\/strong>: Tahvilin vadeye kadar olan s\u00fcresi boyunca uygulanan indirim oran\u0131 (y\u00fczdelik olarak).<\/li>\n
  • y\u00fczde\u011feri<\/strong>: Tahvilin nominal veya y\u00fcz de\u011feri.<\/li>\n
  • [day_basis]<\/strong> (iste\u011fe ba\u011fl\u0131): Zaman s\u00fcresi hesaplamas\u0131nda kullan\u0131lan g\u00fcn say\u0131m\u0131 sistemi. Bu alan doldurulmad\u0131\u011f\u0131nda genellikle varsay\u0131lan de\u011fer olarak 30\/360 kullan\u0131l\u0131r.<\/li>\n<\/ul>\n
    Pratik Uygulamalar ve \u00d6rnekler<\/h2>\n
    A\u015fa\u011f\u0131da, HTAHDE\u011eER<\/code> i\u015flevini kullanarak ger\u00e7ekle\u015ftirilebilecek iki farkl\u0131 senaryo sunulmaktad\u0131r:<\/p>\n
    \u00d6rnek 1: Basit Tahvil De\u011ferlemesi<\/h3>\n
    Yat\u0131r\u0131mc\u0131, 1000 TL nominal de\u011fere sahip bir devlet tahvilini, %5 indirim oran\u0131 ile almay\u0131 d\u00fc\u015f\u00fcnmektedir. Tahvilin al\u0131m tarihi 2023-01-01, vade tarihi ise 2023-12-31’dir.<\/p>\n
     Kullan\u0131lacak Form\u00fcl: =HTAHDE\u011eER(\"2023-01-01\", \"2023-12-31\", 5%, 1000) <\/code><\/pre>\n
    Bu form\u00fcl, tahvilin al\u0131m fiyat\u0131n\u0131 hesaplar ve yat\u0131r\u0131mc\u0131n\u0131n karar vermesine yard\u0131mc\u0131 olur.<\/p>\n
    \u00d6rnek 2: Farkl\u0131 G\u00fcn Say\u0131m\u0131 Sistemleri Kullanarak Tahvil De\u011ferlemesi<\/h3>\n
    E\u011fer g\u00fcn say\u0131m\u0131 baz\u0131nda farkl\u0131 bir sistem kullan\u0131lmas\u0131 gerekiyorsa (\u00f6rne\u011fin ger\u00e7ek g\u00fcn say\u0131m\u0131), bu durum form\u00fcle eklemek gerekebilir. \u00d6rnek vermek gerekirse, yat\u0131r\u0131mc\u0131 ayn\u0131 tahvili almay\u0131 d\u00fc\u015f\u00fcn\u00fcyor ancak bu kez 365\/365 g\u00fcn say\u0131m\u0131 temel al\u0131narak de\u011ferleme yap\u0131lacak.<\/p>\n
     Kullan\u0131lacak Form\u00fcl: =HTAHDE\u011eER(\"2023-01-01\", \"2023-12-31\", 5%, 1000, 1) <\/code><\/pre>\n
    Bu form\u00fcl ile tahvilin daha ger\u00e7ek\u00e7i bir piyasa de\u011feri hesaplamas\u0131 yap\u0131labilir.<\/p>\n
    Genel olarak, HTAHDE\u011eER<\/code> i\u015flevi, tahvil yat\u0131r\u0131mlar\u0131n\u0131n analizi ve de\u011ferlemesi i\u00e7in vazge\u00e7ilmez bir ara\u00e7t\u0131r. Hem Excel hem de Google E-Tablolar’da kolayca kullan\u0131labilir ve finansal analizlerde derinlemesine bilgi sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Hazine bonosu i\u00e7in 100 TL’lik nominal de\u011ferin fiyat\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-15672","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de TBILLPRICE (HTAHDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TBILLPRICE (HTAHDE\u011eER) 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\/tbillprice\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TBILLPRICE (HTAHDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TBILLPRICE (HTAHDE\u011eER) 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\/tbillprice\/\" \/>\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:25+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 TBILLPRICE (HTAHDE\u011eER) 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\/tbillprice\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/tbillprice\/\",\"name\":\"Excel'de TBILLPRICE (HTAHDE\u011eER) 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:25+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TBILLPRICE (HTAHDE\u011eER) 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\/tbillprice\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/tbillprice\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/tbillprice\/#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\":\"HTAHDE\u011eER\"}]},{\"@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 TBILLPRICE (HTAHDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TBILLPRICE (HTAHDE\u011eER) 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\/tbillprice\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TBILLPRICE (HTAHDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TBILLPRICE (HTAHDE\u011eER) 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\/tbillprice\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:37:25+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TBILLPRICE (HTAHDE\u011eER) 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\/tbillprice\/","url":"https:\/\/functiontranslator.com\/tr\/tbillprice\/","name":"Excel'de TBILLPRICE (HTAHDE\u011eER) 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:25+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TBILLPRICE (HTAHDE\u011eER) 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\/tbillprice\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/tbillprice\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/tbillprice\/#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":"HTAHDE\u011eER"}]},{"@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\/15672","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=15672"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15672\/revisions"}],"predecessor-version":[{"id":26940,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15672\/revisions\/26940"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}