{"id":15573,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/teksdeger\/"},"modified":"2021-02-25T16:33:14","modified_gmt":"2021-02-25T16:33:14","slug":"oddlprice","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/oddlprice\/","title":{"rendered":"TEKSDE\u011eER"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, finansal analizler i\u00e7in geni\u015f bir fonksiyon yelpazesi sunmaktad\u0131r. Bu fonksiyonlardan biri olan ODDFPRICE, tahvilin ilk veya son faiz d\u00f6nemi farkl\u0131 olduklar\u0131nda tahvil fiyat\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu makalede ODDFPRICE fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131, form\u00fcl yap\u0131s\u0131n\u0131 ve baz\u0131 pratik uygulama \u00f6rneklerini detayl\u0131 bir \u015fekilde inceleyece\u011fiz.<\/p>\n

S\u00f6zdizimi ve Parametreler<\/h2>\n

ODDFPRICE fonksiyonunun genel format\u0131 a\u015fa\u011f\u0131da verilmi\u015ftir:<\/p>\n

  ODDFPRICE(setleme, vade, verim, ilk_kupon, son_kupon, oran, \u00f6deme_s\u0131kl\u0131\u011f\u0131, [teminat]) <\/code> <\/pre>\n
    \n
  • setleme:<\/strong> Tahvilin al\u0131\u015f tarihi.<\/li>\n
  • vade:<\/strong> Tahvilin vadesinin dolaca\u011f\u0131 tarih.<\/li>\n
  • verim:<\/strong> Tahvilin y\u0131ll\u0131k getiri oran\u0131.<\/li>\n
  • ilk_kupon:<\/strong> \u0130lk kupon \u00f6demesinin ger\u00e7ekle\u015fece\u011fi tarih.<\/li>\n
  • son_kupon:<\/strong> Son kupon \u00f6demesinin yap\u0131laca\u011f\u0131 ve normal kupon \u00f6deme periyotlar\u0131n\u0131n ba\u015flang\u0131c\u0131ndan \u00f6nceki tarih.<\/li>\n
  • oran:<\/strong> Y\u00fczde olarak ifade edilen kupon oran\u0131.<\/li>\n
  • \u00f6deme_s\u0131kl\u0131\u011f\u0131:<\/strong> Y\u0131lda ka\u00e7 kez kupon \u00f6demesi yap\u0131ld\u0131\u011f\u0131 (tipik olarak 1, 2 veya 4).<\/li>\n
  • [teminat]:<\/strong> Opsiyonel, tahvilin 100 para birimi de\u011ferine g\u00f6re \u00f6l\u00e7\u00fcl\u00fc teminat.<\/li>\n<\/ul>\n
    Uygulama Senaryolar\u0131<\/h2>\n
    \u00d6rnek 1: Tahvil Fiyat\u0131 Hesaplama<\/h2>\n
    Bir yat\u0131r\u0131mc\u0131, normalden farkl\u0131 ilk kupon \u00f6deme periyoduna sahip bir tahvil sat\u0131n ald\u0131. \u00d6zellikler a\u015fa\u011f\u0131daki gibidir:<\/p>\n
      Setleme tarihi: 01.01.2020 Vade tarihi: 01.01.2030 Verim: %5 \u0130lk kupon tarihi: 01.07.2020 Son kupon tarihi: 01.07.2021 Kupon oran\u0131: %6 \u00d6deme s\u0131kl\u0131\u011f\u0131: Y\u0131lda 2 kez <\/code> <\/pre>\n
    \u015eimdi tahvilin fiyat\u0131n\u0131 hesaplayal\u0131m:<\/p>\n
      =ODDFPRICE(\"01.01.2020\", \"01.01.2030\", 0.05, \"01.07.2020\", \"01.07.2021\", 0.06, 2) <\/code> <\/pre>\n
    Bu form\u00fcl, tahvil i\u00e7in ola\u011fan\u00fcst\u00fc d\u00f6nemleri dikkate alarak tahmin edilen fiyat\u0131 verecektir.<\/p>\n
    \u00d6rnek 2: Farkl\u0131 Yat\u0131r\u0131m Senaryolar\u0131n\u0131n Kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131<\/h2>\n
    Bir finans analisti, farkl\u0131 ilk ve son kupon tarihlerine sahip iki tahvilin performans\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rmak istiyor. \u0130\u015fte tahvil \u00f6zellikleri:<\/p>\n\n\n\n\n
    Tahvil<\/th>\nSetleme Tarihi<\/th>\nVade Tarihi<\/th>\n\u0130lk Kupon Tarihi<\/th>\nSon Kupon Tarihi<\/th>\nVerim<\/th>\nKupon Oran\u0131<\/th>\n\u00d6deme S\u0131kl\u0131\u011f\u0131<\/th>\n<\/tr>\n
    A<\/td>\n01.01.2020<\/td>\n01.01.2030<\/td>\n01.07.2020<\/td>\n01.01.2021<\/td>\n%5<\/td>\n%6<\/td>\n2<\/td>\n<\/tr>\n
    B<\/td>\n01.01.2020<\/td>\n01.01.2030<\/td>\n01.07.2020<\/td>\n01.07.2021<\/td>\n%5<\/td>\n%6<\/td>\n2<\/td>\n<\/tr>\n<\/table>\n
    \u0130ki tahvil i\u00e7in de ODDFPRICE fonksiyonunu kullanarak fiyatlar\u0131 hesaplayabiliriz:<\/p>\n
      =ODDFPRICE(\"01.01.2020\", \"01.01.2030\", 0.05, \"01.07.2020\", \"01.01.2021\", 0.06, 2) \/\/ Tahvil A i\u00e7in =ODDFPRICE(\"01.01.2020\", \"01.01.2030\", 0.05, \"01.07.2020\", \"01.07.2021\", 0.06, 2) \/\/ Tahvil B i\u00e7in <\/code> <\/pre>\n
    Bu hesaplamalar, analistin tahviller hakk\u0131nda bilgi sahibi olmas\u0131n\u0131 sa\u011flayacak ve yat\u0131r\u0131mc\u0131lara detayl\u0131 analizler sunma imkan\u0131 verecektir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Son d\u00f6nemi tek olan bir tahvilin 100 TL’lik nominal de\u011ferinin 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-15573","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de ODDLPRICE (TEKSDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ODDLPRICE (TEKSDE\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\/oddlprice\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ODDLPRICE (TEKSDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ODDLPRICE (TEKSDE\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\/oddlprice\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:33:14+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 ODDLPRICE (TEKSDE\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\/oddlprice\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/oddlprice\/\",\"name\":\"Excel'de ODDLPRICE (TEKSDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:33:14+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ODDLPRICE (TEKSDE\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\/oddlprice\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/oddlprice\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/oddlprice\/#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\":\"TEKSDE\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 ODDLPRICE (TEKSDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ODDLPRICE (TEKSDE\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\/oddlprice\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ODDLPRICE (TEKSDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ODDLPRICE (TEKSDE\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\/oddlprice\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:14+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ODDLPRICE (TEKSDE\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\/oddlprice\/","url":"https:\/\/functiontranslator.com\/tr\/oddlprice\/","name":"Excel'de ODDLPRICE (TEKSDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:33:14+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ODDLPRICE (TEKSDE\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\/oddlprice\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/oddlprice\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/oddlprice\/#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":"TEKSDE\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\/15573","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=15573"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15573\/revisions"}],"predecessor-version":[{"id":26841,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15573\/revisions\/26841"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}