{"id":15597,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/degervade\/"},"modified":"2021-02-25T16:34:01","modified_gmt":"2021-02-25T16:34:01","slug":"pricemat","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/pricemat\/","title":{"rendered":"DE\u011eERVADE"},"content":{"rendered":"

Microsoft Excel ve Google E-Tablolar’\u0131n finansal i\u015flevlerinden biri olan PRICEMAT<\/code> (T\u00fcrk\u00e7e kar\u015f\u0131l\u0131\u011f\u0131 ile DE\u011eERVADE) i\u015flevi, vadesi dolmu\u015f bir tahvilin tam fiyat\u0131n\u0131 hesaplamaya yarar. Bu i\u015flev, \u00f6zellikle tahvil yat\u0131r\u0131mc\u0131lar\u0131 ve finans profesyonelleri taraf\u0131ndan kullan\u0131l\u0131r. Fonksiyonun do\u011fru uygulanabilmesi i\u00e7in belirli parametreleri anlamak ve bu parametreleri do\u011fru \u015fekilde form\u00fclde yerle\u015ftirmek gerekmektedir.<\/p>\n

DE\u011eERVADE \u0130\u015flevine Genel Bak\u0131\u015f<\/h2>\n

PRICEMAT<\/code> (DE\u011eERVADE) i\u015flevinin s\u00f6zdizimi a\u015fa\u011f\u0131daki gibi \u00f6zetlenebilir:<\/p>\n

=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])<\/code><\/pre>\n
    \n
  • settlement<\/strong>: Tahvilin fiyat\u0131n\u0131n hesapland\u0131\u011f\u0131 tarih.<\/li>\n
  • maturity<\/strong>: Tahvilin vadesinin doldu\u011fu tarih.<\/li>\n
  • issue<\/strong>: Tahvilin ihra\u00e7 edildi\u011fi tarih.<\/li>\n
  • rate<\/strong>: Tahvilin kupon oran\u0131.<\/li>\n
  • yld<\/strong>: Tahvilin getiri oran\u0131.<\/li>\n
  • [\\ basis\\]<\/strong>: (Opsiyonel) G\u00fcn say\u0131m temelinin tan\u0131m\u0131 (\u00f6rn. 0=30\/360 (Amerikan), 1=Gercek\/Gercek, vs.).<\/li>\n<\/ul>\n
    Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmleri<\/h2>\n
    Bu i\u015flevin kullan\u0131labilirli\u011fini daha iyi g\u00f6sterebilmek ad\u0131na, a\u015fa\u011f\u0131da iki farkl\u0131 senaryo \u00fczerinden detayl\u0131 \u00e7\u00f6z\u00fcmler sunulmu\u015ftur.<\/p>\n
    \u00d6rnek 1: Yat\u0131r\u0131m Getirisi Hesaplama<\/h3>\n
    Yat\u0131r\u0131mc\u0131, 2018 y\u0131l\u0131nda ihra\u00e7 edilmi\u015f, y\u0131ll\u0131k %5 kupon oran\u0131 olan ve 2023 y\u0131l\u0131nda vadesi dolacak olan bir tahvil sat\u0131n alm\u0131\u015ft\u0131r. Yat\u0131r\u0131mc\u0131, tahvil i\u00e7in %4 getiri oran\u0131 beklemektedir. G\u00fcn say\u0131m olarak Amerikan sistemi kullan\u0131lmaktad\u0131r. Bu senaryoda, tahvilin tam fiyat\u0131n\u0131 hesaplayaca\u011f\u0131z:<\/p>\n
    =PRICEMAT(\"2023-01-01\", \"2023-12-31\", \"2018-01-01\", 5%, 4%, 0)<\/code><\/pre>\n
    Bu form\u00fcl, tahvilin tam fiyat\u0131n\u0131, belirlenen getiri oran\u0131 \u00fczerinden vadesi dolmu\u015f tahvil baz\u0131nda hesaplar. Sonu\u00e7, yat\u0131r\u0131mc\u0131n\u0131n \u00f6demesi gereken toplam miktar\u0131 (anapara + faiz) g\u00f6sterir.<\/p>\n
    \u00d6rnek 2: Farkl\u0131 G\u00fcn Say\u0131m Temelinin Kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131<\/h3>\n
    Ayn\u0131 tahvil i\u00e7in farkl\u0131 bir g\u00fcn say\u0131m temeli (ger\u00e7ek\/ger\u00e7ek) kullanarak tam fiyat\u0131 hesaplayal\u0131m:<\/p>\n
    =PRICEMAT(\"2023-01-01\", \"2023-12-31\", \"2018-01-01\", 5%, 4%, 1)<\/code><\/pre>\n
    Bu de\u011fi\u015fiklik, tahvilin de\u011ferinin g\u00fcn say\u0131m temellerine g\u00f6re nas\u0131l farkl\u0131l\u0131k g\u00f6sterebilece\u011fini g\u00f6sterir. Sonu\u00e7lar, yat\u0131r\u0131m kararlar\u0131 \u00fczerinde do\u011frudan etkili olabilir.<\/p>\n
    Genellikle, PRICEMAT<\/code> i\u015flevi finansal analizler ve portf\u00f6y y\u00f6netimi i\u00e7in \u00e7ok \u00f6nemlidir. Tahvil yat\u0131r\u0131mlar\u0131 yaparken, \u00f6denmesi gereken toplam maliyetin yan\u0131 s\u0131ra, getiri oranlar\u0131 ve farkl\u0131 g\u00fcn say\u0131m temellerinin etkilerini g\u00f6z \u00f6n\u00fcnde bulundurmak, finansal kararlar i\u00e7in kritik olabilir. Bu y\u00fczden, i\u015flevin do\u011fru anla\u015f\u0131lmas\u0131 ve uygulanmas\u0131, finans profesyonelleri i\u00e7in b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Vadesinde faiz \u00f6denen 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-15597","post","type-post","status-publish","format-standard","hentry","category-finansal"],"acf":[],"yoast_head":"\nExcel'de PRICEMAT (DE\u011eERVADE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da PRICEMAT (DE\u011eERVADE) 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\/pricemat\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de PRICEMAT (DE\u011eERVADE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da PRICEMAT (DE\u011eERVADE) 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\/pricemat\/\" \/>\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:34:01+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 PRICEMAT (DE\u011eERVADE) 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\/pricemat\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/pricemat\/\",\"name\":\"Excel'de PRICEMAT (DE\u011eERVADE) 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:34:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da PRICEMAT (DE\u011eERVADE) 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\/pricemat\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/pricemat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/pricemat\/#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\u011eERVADE\"}]},{\"@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 PRICEMAT (DE\u011eERVADE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da PRICEMAT (DE\u011eERVADE) 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\/pricemat\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de PRICEMAT (DE\u011eERVADE) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da PRICEMAT (DE\u011eERVADE) 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\/pricemat\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:34:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de PRICEMAT (DE\u011eERVADE) 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\/pricemat\/","url":"https:\/\/functiontranslator.com\/tr\/pricemat\/","name":"Excel'de PRICEMAT (DE\u011eERVADE) 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:34:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da PRICEMAT (DE\u011eERVADE) 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\/pricemat\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/pricemat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/pricemat\/#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\u011eERVADE"}]},{"@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\/15597","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=15597"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15597\/revisions"}],"predecessor-version":[{"id":26865,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15597\/revisions\/26865"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}