{"id":15595,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/deger\/"},"modified":"2021-02-25T16:33:57","modified_gmt":"2021-02-25T16:33:57","slug":"price","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/price\/","title":{"rendered":"DE\u011eER"},"content":{"rendered":"<h1>Excel ve Google E-Tablolar&#8217;da Finansal Analizler i\u00e7in PRICE Fonksiyonu<\/h1>\n<p>Finansal raporlama ve analizler, \u00f6zellikle tahvil i\u015flemleri konusunda \u00f6nemli bir yer tutar. Bu yaz\u0131m\u0131zda, Excel ve Google E-Tablolar&#8217;da kullan\u0131lan <strong>PRICE<\/strong> fonksiyonunun nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131, bu fonksiyonun s\u00f6zdizimini ve uygulama \u00f6rneklerini ele alaca\u011f\u0131z. PRICE fonksiyonu, belirli bir faiz \u00f6deme d\u00f6nemi i\u00e7in bir tahvilin fiyat\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Yat\u0131r\u0131mc\u0131lar\u0131n tahvil al\u0131m-sat\u0131m kararlar\u0131nda b\u00fcy\u00fck rol oynar.<\/p>\n<h2>PRICE Fonksiyonunun S\u00f6zdizimi<\/h2>\n<p>PRICE fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n<pre> <code> =PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]) <\/code> <\/pre>\n<ul>\n<li><strong>settlement<\/strong> : Tahvilin al\u0131nd\u0131\u011f\u0131 tarih.<\/li>\n<li><strong>maturity<\/strong> : Tahvilin vadesinin doldu\u011fu tarih.<\/li>\n<li><strong>rate<\/strong> : Tahvilin kupon faiz oran\u0131.<\/li>\n<li><strong>yld<\/strong> : Tahvilin getirisinin y\u0131ll\u0131k y\u00fczdesi.<\/li>\n<li><strong>redemption<\/strong> : Tahvilin nominal de\u011feri.<\/li>\n<li><strong>frequency<\/strong> : Y\u0131lda faiz \u00f6deme say\u0131s\u0131 (genellikle 1, 2 veya 4).<\/li>\n<li><strong>[basis]<\/strong> : G\u00fcn say\u0131m konvansiyonu (opsiyonel).<\/li>\n<\/ul>\n<h2>Pratik Uygulamalar ve \u00d6rnekler<\/h2>\n<p>PRICE fonksiyonun uygulanabilece\u011fi baz\u0131 pratik senaryolar ve bu senaryolar\u0131n \u00e7\u00f6z\u00fcmleri.<\/p>\n<h3>\u00d6rnek 1: Tahvil De\u011ferinin Hesaplanmas\u0131<\/h3>\n<p>A\u015fa\u011f\u0131da verilen bilgilere g\u00f6re bir tahvilin de\u011ferini hesaplayal\u0131m:<\/p>\n<ul>\n<li>Al\u0131m tarihi: 01\/01\/2020<\/li>\n<li>Vade tarihi: 01\/01\/2030<\/li>\n<li>Kupon faiz oran\u0131: %5<\/li>\n<li>Y\u0131ll\u0131k getiri: %6<\/li>\n<li>Nominal de\u011fer: 100<\/li>\n<li>Faiz \u00f6deme s\u0131kl\u0131\u011f\u0131: Y\u0131lda 2 kez (her alt\u0131 ayda bir)<\/li>\n<li>G\u00fcn say\u0131m konvansiyonu: 0 (ABD (NASD) 30\/360)<\/li>\n<\/ul>\n<p>Excel ya da Google E-Tablolar&#8217;da bu veriler ile kullan\u0131lacak form\u00fcl:<\/p>\n<pre> <code> =PRICE(\"2020-01-01\", \"2030-01-01\", 5%, 6%, 100, 2, 0) <\/code> <\/pre>\n<p>Bu form\u00fcl, tahvilin mevcut piyasa de\u011ferini hesaplayacakt\u0131r. Bu bilgi, yat\u0131r\u0131m kararlar\u0131 al\u0131rken kullan\u0131labilir.<\/p>\n<h3>\u00d6rnek 2: Yat\u0131r\u0131m Portf\u00f6y\u00fcnde De\u011ferlendirme<\/h3>\n<p>Yat\u0131r\u0131mc\u0131lar, yat\u0131r\u0131m portf\u00f6ylerinin performans\u0131n\u0131 de\u011ferlendirmek i\u00e7in PRICE fonksiyonunu kullanabilirler. \u00d6rne\u011fin, farkl\u0131 vade tarihlerine ve faiz oranlar\u0131na sahip birden fazla tahvili de\u011ferlendirirken:<\/p>\n<pre> <code> =PRICE(\"2020-01-01\", \"2025-01-01\", 3%, 4%, 100, 2, 0) =PRICE(\"2020-01-01\", \"2027-01-01\", 4%, 3.5%, 100, 2, 0) =PRICE(\"2020-01-01\", \"2030-01-01\", 5%, 4.5%, 100, 2, 0) <\/code> <\/pre>\n<p>Bu form\u00fcller, kullan\u0131c\u0131ya \u00e7e\u015fitli tahvillerin piyasa de\u011ferlerini kar\u015f\u0131la\u015ft\u0131rma imkan\u0131 sa\u011flar.<\/p>\n<h2>Sonu\u00e7 ve Yorumlar<\/h2>\n<p>PRICE fonksiyonu, tahvil yat\u0131r\u0131mlar\u0131n\u0131n de\u011ferini belirlemek ve yat\u0131r\u0131m kararlar\u0131n\u0131 desteklemek i\u00e7in \u00e7ok kritik bir ara\u00e7t\u0131r. Finansal analizler, tahvil al\u0131mlar\u0131 veya portf\u00f6y de\u011ferlendirmeleri yaparken bu t\u00fcr fonksiyonlar veriye dayal\u0131 ve objektif kararlar al\u0131nmas\u0131n\u0131 sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>D\u00f6nemsel faizi \u00f6denen menkul de\u011ferin 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-15595","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 PRICE (DE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da PRICE (DE\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\/price\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de PRICE (DE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da PRICE (DE\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\/price\/\" \/>\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:57+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 PRICE (DE\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\/price\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/price\/\",\"name\":\"Excel'de PRICE (DE\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:33:57+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da PRICE (DE\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\/price\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/price\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/price\/#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\"}]},{\"@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 PRICE (DE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da PRICE (DE\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\/price\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de PRICE (DE\u011eER) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da PRICE (DE\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\/price\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:33:57+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de PRICE (DE\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\/price\/","url":"https:\/\/functiontranslator.com\/tr\/price\/","name":"Excel'de PRICE (DE\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:33:57+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da PRICE (DE\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\/price\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/price\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/price\/#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"}]},{"@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\/15595","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=15595"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15595\/revisions"}],"predecessor-version":[{"id":26863,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15595\/revisions\/26863"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}