{"id":15571,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/tekydeger\/"},"modified":"2021-02-25T16:33:12","modified_gmt":"2021-02-25T16:33:12","slug":"oddfprice","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/oddfprice\/","title":{"rendered":"TEKYDE\u011eER"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets her ikisi de, finansal analizler i\u00e7in geni\u015f bir i\u015flev yelpazesi sunar. Bu i\u015flevlerden biri olan TEKYDE\u011eER fonksiyonu, d\u00fczensiz ilk \u00f6deme d\u00f6nemlerine sahip tahvillerin fiyat\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Fonksiyon, tahvilin nominal de\u011feri, kupon oran\u0131, vadeye kalan s\u00fcre, ve d\u00f6nemsel faiz oranlar\u0131n\u0131 kullanarak tahvilin ger\u00e7ek piyasa de\u011ferini belirlemeye yard\u0131mc\u0131 olur.<\/p>\n<h2>TEKYDE\u011eER Fonksiyonunun S\u00f6zdizimi<\/h2>\n<p><code>TEKYDE\u011eER(kupon, y\u0131ll\u0131k_faiz, ilk_vade, vade, geri_\u00f6deme, s\u0131kl\u0131k, [dayanak])<\/code><\/p>\n<ul>\n<li><strong>kupon<\/strong>: Tahvilin y\u0131ll\u0131k kupon faiz oran\u0131.<\/li>\n<li><strong>y\u0131ll\u0131k_faiz<\/strong>: Tahvilin y\u0131ll\u0131k piyasa faiz oran\u0131.<\/li>\n<li><strong>ilk_vade<\/strong>: \u0130lk kupon \u00f6demesine kadar ge\u00e7en zaman, y\u0131l olarak.<\/li>\n<li><strong>vade<\/strong>: Tahvilin toplam vadesi, y\u0131l olarak.<\/li>\n<li><strong>geri_\u00f6deme<\/strong>: Vade sonunda \u00f6denecek nominal de\u011fer.<\/li>\n<li><strong>s\u0131kl\u0131k<\/strong>: Y\u0131lda yap\u0131lan \u00f6deme say\u0131s\u0131 (genellikle 1 veya 2).<\/li>\n<li><strong>[dayanak]<\/strong>: Opsiyonel; tarih sayma y\u00f6ntemi (US (NASD) 30\/360, Actual\/Actual, Actual\/360 vb.).<\/li>\n<\/ul>\n<pre><code> =TEKYDE\u011eER(0.05, 0.06, 0.5, 3, 1000, 2, 0) <\/code><\/pre>\n<p>Bu \u00f6rnek, y\u0131lda iki kez \u00f6deme yap\u0131lan, %5 kupon oran\u0131 ve %6 piyasa faiz oran\u0131 olan, ilk kupon \u00f6demesi yar\u0131m y\u0131l sonra ba\u015flayacak ve toplam 3 y\u0131l s\u00fcrecek bir tahvilin fiyat\u0131n\u0131 hesaplar. \u00d6deme dayana\u011f\u0131 olarak US (NASD) 30\/360 kullan\u0131lm\u0131\u015ft\u0131r.<\/p>\n<h2>Pratik Uygulama \u00d6rnekleri<\/h2>\n<h2>Yat\u0131r\u0131m De\u011ferlendirme<\/h2>\n<p>Yat\u0131r\u0131mc\u0131lar, TEKYDE\u011eER fonksiyonunu, farkl\u0131 tahvillerin mali de\u011ferlerini kar\u015f\u0131la\u015ft\u0131rarak hangi tahvilin daha y\u00fcksek getiri sa\u011flayaca\u011f\u0131n\u0131 belirlemede kullanabilirler.<\/p>\n<table>\n<tr>\n<th>Tahvil<\/th>\n<th>Kupon Oran\u0131 (%)<\/th>\n<th>Yeni Kupon Tarihi<\/th>\n<th>Piyasa Faiz Oran\u0131 (%)<\/th>\n<th>Fiyat<\/th>\n<\/tr>\n<tr>\n<td>A<\/td>\n<td>4.5<\/td>\n<td>1<\/td>\n<td>4.0<\/td>\n<td>=TEKYDE\u011eER(0.045, 0.04, 1, 10, 1000, 2)<\/td>\n<\/tr>\n<tr>\n<td>B<\/td>\n<td>6.0<\/td>\n<td>1<\/td>\n<td>4.0<\/td>\n<td>=TEKYDE\u011eER(0.06, 0.04, 1, 15, 1000, 2)<\/td>\n<\/tr>\n<\/table>\n<h2>Risk Y\u00f6netimi<\/h2>\n<p>Tahvil fiyatlar\u0131, piyasa faiz oranlar\u0131ndaki de\u011fi\u015fikliklere duyarl\u0131d\u0131r. TEKYDE\u011eER fonksiyonu, faiz oranlar\u0131ndaki dalgalanmalar\u0131n tahvil fiyatlar\u0131 \u00fczerindeki etkisini \u00f6l\u00e7mek i\u00e7in idealdir. Bu \u015fekilde, faiz oranlar\u0131n\u0131n y\u00fckselmesi veya d\u00fc\u015fmesinin yat\u0131r\u0131m portf\u00f6y\u00fcn\u00fcz \u00fczerindeki olas\u0131 etkilerini de\u011ferlendirebilirsiniz.<\/p>\n<pre><code> =TEKYDE\u011eER(0.045, de\u011fi\u015fken_faiz_oran\u0131, 1, 5, 1000, 2) <\/code><\/pre>\n<p>Burada, <code>de\u011fi\u015fken_faiz_oran\u0131<\/code> piyasa ko\u015fullar\u0131na g\u00f6re ayarlanabilir ve kullan\u0131c\u0131lara senaryo analizi yapma imkan\u0131 tan\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0130lk d\u00f6nemi tek olan bir tahvilin 100 TL&#8217;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-15571","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 ODDFPRICE (TEKYDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da ODDFPRICE (TEKYDE\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\/oddfprice\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de ODDFPRICE (TEKYDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da ODDFPRICE (TEKYDE\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\/oddfprice\/\" \/>\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:12+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 ODDFPRICE (TEKYDE\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\/oddfprice\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/oddfprice\/\",\"name\":\"Excel'de ODDFPRICE (TEKYDE\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:12+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ODDFPRICE (TEKYDE\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\/oddfprice\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/oddfprice\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/oddfprice\/#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\":\"TEKYDE\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 ODDFPRICE (TEKYDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ODDFPRICE (TEKYDE\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\/oddfprice\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ODDFPRICE (TEKYDE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ODDFPRICE (TEKYDE\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\/oddfprice\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:12+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ODDFPRICE (TEKYDE\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\/oddfprice\/","url":"https:\/\/functiontranslator.com\/tr\/oddfprice\/","name":"Excel'de ODDFPRICE (TEKYDE\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:12+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ODDFPRICE (TEKYDE\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\/oddfprice\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/oddfprice\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/oddfprice\/#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":"TEKYDE\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\/15571","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=15571"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15571\/revisions"}],"predecessor-version":[{"id":26839,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15571\/revisions\/26839"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}