{"id":15596,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/degerind\/"},"modified":"2021-02-25T16:33:59","modified_gmt":"2021-02-25T16:33:59","slug":"pricedisc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/pricedisc\/","title":{"rendered":"DE\u011eER\u0130ND"},"content":{"rendered":"

“PRICEDISC” veya T\u00fcrk\u00e7e’de “DE\u011eER\u0130ND”<\/strong> fonksiyonu, belirli bir menkul k\u0131ymetin nominal de\u011feri, iskonto oran\u0131 ve \u00e7\u0131k\u0131\u015f tarihi verileri do\u011frultusunda iskonto edilmi\u015f fiyat\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon, finansal analiz alan\u0131nda \u00f6zellikle tahvil ve bono al\u0131m sat\u0131mlar\u0131nda kritik bir role sahiptir.<\/p>\n

Genel Kullan\u0131m<\/h2>\n

“PRICEDISC” fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=PRICEDISC(settlement, maturity, discount, redemption, [basis])<\/code><\/pre>\n
    \n
  • settlement<\/strong> – Menkul k\u0131ymetin al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n
  • maturity<\/strong> – Menkul k\u0131ymetin vadesinin doldu\u011fu tarih.<\/li>\n
  • discount<\/strong> – Menkul k\u0131ymetin y\u0131ll\u0131k iskonto oran\u0131.<\/li>\n
  • redemption<\/strong> – Menkul k\u0131ymetin nominal de\u011feri.<\/li>\n
  • basis (iste\u011fe ba\u011fl\u0131)<\/strong> – G\u00fcn say\u0131m metodunu belirleyen say\u0131sal de\u011fer. Varsay\u0131lan de\u011fer 0\u2019d\u0131r (Amerikan (NASD) 30\/360).<\/li>\n<\/ul>\n
    Pratik \u00d6rnekler<\/h2>\n
    \u0130\u015fte “PRICEDISC” fonksiyonunun kullan\u0131ld\u0131\u011f\u0131 baz\u0131 pratik uygulamalar:<\/p>\n
    Menkul K\u0131ymet Fiyat\u0131 Hesaplama<\/h2>\n
    \u00d6rnek olarak, nominal de\u011feri 1,000 ve y\u0131ll\u0131k %5 iskonto oran\u0131 bulanan bir tahvil d\u00fc\u015f\u00fcnelim. Tahvilin al\u0131nd\u0131\u011f\u0131 ve vadesinin doldu\u011fu tarihler s\u0131ras\u0131yla 01.01.2023 ile 01.01.2024’t\u00fcr. A\u015fa\u011f\u0131da bu senaryo i\u00e7in bir hesaplama bulunmaktad\u0131r:<\/p>\n
    =PRICEDISC(\"2023-01-01\", \"2024-01-01\", 0.05, 1000, 0)<\/code><\/pre>\n
    Bu form\u00fcl, tahvilin al\u0131nd\u0131\u011f\u0131 tarih ile vadesinin doldu\u011fu tarih aras\u0131n\u0131 do\u011fru bir \u015fekilde hesaplamak i\u00e7in bu tarih formatlar\u0131n\u0131 kullan\u0131r.<\/p>\n
    Tahvil Portf\u00f6y\u00fc Y\u00f6netimi<\/h2>\n
    Bir portf\u00f6y y\u00f6neticisi olarak birden fazla tahvilin de\u011ferini hesaplama ihtiyac\u0131n\u0131z oldu\u011funu d\u00fc\u015f\u00fcn\u00fcn. Her bir tahvil i\u00e7in “PRICEDISC” fonksiyonunu kullanarak portf\u00f6y\u00fcn toplam de\u011ferini hesaplayabilirsiniz. \u00d6rnek olarak, yukar\u0131da bahsedilen tahvilin yan\u0131 s\u0131ra, nominal de\u011feri 2,000 ve y\u0131ll\u0131k %4 iskonto oran\u0131 olan ba\u015fka bir tahvil d\u00fc\u015f\u00fcnelim. Her iki tahvilin de al\u0131m ve vade tarihleri ayn\u0131d\u0131r:<\/p>\n
    =PRICEDISC(\"2023-01-01\", \"2024-01-01\", 0.04, 2000, 0)<\/code><\/pre>\n
    Her iki tahvilin de fiyat\u0131n\u0131 hesaplad\u0131ktan sonra, toplamlar\u0131n\u0131 alarak portf\u00f6y\u00fcn toplam de\u011ferini bulabilirsiniz.<\/p>\n
     This revised HTML content retains the original structure while using more precise and professional language typical of financial analytics descriptions in Turkish, accurately representing the functionality and use of the “PRICEDISC” function.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u0130ndirimli 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-15596","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de PRICEDISC (DE\u011eER\u0130ND) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da PRICEDISC (DE\u011eER\u0130ND) 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\/pricedisc\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de PRICEDISC (DE\u011eER\u0130ND) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da PRICEDISC (DE\u011eER\u0130ND) 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\/pricedisc\/\" \/>\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:33:59+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 PRICEDISC (DE\u011eER\u0130ND) 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\/pricedisc\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/pricedisc\/\",\"name\":\"Excel'de PRICEDISC (DE\u011eER\u0130ND) 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:33:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da PRICEDISC (DE\u011eER\u0130ND) 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\/pricedisc\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/pricedisc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/pricedisc\/#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\":\"DE\u011eER\u0130ND\"}]},{\"@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 PRICEDISC (DE\u011eER\u0130ND) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da PRICEDISC (DE\u011eER\u0130ND) 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\/pricedisc\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de PRICEDISC (DE\u011eER\u0130ND) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da PRICEDISC (DE\u011eER\u0130ND) 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\/pricedisc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:33:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de PRICEDISC (DE\u011eER\u0130ND) 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\/pricedisc\/","url":"https:\/\/functiontranslator.com\/tr\/pricedisc\/","name":"Excel'de PRICEDISC (DE\u011eER\u0130ND) 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:33:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da PRICEDISC (DE\u011eER\u0130ND) 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\/pricedisc\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/pricedisc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/pricedisc\/#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":"DE\u011eER\u0130ND"}]},{"@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\/15596","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=15596"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15596\/revisions"}],"predecessor-version":[{"id":26864,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15596\/revisions\/26864"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}