{"id":5790,"date":"2025-07-15T13:34:45","date_gmt":"2025-07-15T13:34:45","guid":{"rendered":"https:\/\/functiontranslator.com\/rtd\/"},"modified":"2021-02-26T10:02:51","modified_gmt":"2021-02-26T10:02:51","slug":"rtd","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/cs\/rtd\/","title":{"rendered":"RTD"},"content":{"rendered":"<p>Funkce RTD (Real-Time Data) umo\u017e\u0148uje v aplikaci MS Excel z\u00edsk\u00e1vat data v re\u00e1ln\u00e9m \u010dase z extern\u00edch zdroj\u016f. Je to nesm\u00edrn\u011b u\u017eite\u010dn\u00e9 pro monitorov\u00e1n\u00ed prom\u011bnliv\u00fdch \u00fadaj\u016f jako jsou finan\u010dn\u00ed, ekonomick\u00e9 nebo jin\u00e9 informace. Je d\u016fle\u017eit\u00e9 si v\u0161imnout, \u017ee Google Sheets nepodporuje funkci RTD p\u0159\u00edmo, ale existuj\u00ed alternativn\u00ed postupy skrze Google Apps Script.<\/p>\n<h2>Podrobn\u00fd popis a syntaxe<\/h2>\n<p>Syntaxe funkce RTD v Excelu vypad\u00e1 takto:<\/p>\n<pre> <code>RTD(progID, server, topic1, [topic2], ...)<\/code> <\/pre>\n<ul>\n<li><b>progID<\/b>: Identifik\u00e1tor programu poskytuj\u00edc\u00edho data, odkazuje na COM server.<\/li>\n<li><b>server<\/b>: \u0158et\u011bzec, kter\u00fd ur\u010duje server. Pokud je pr\u00e1zdn\u00fd, pou\u017eije se lok\u00e1ln\u00ed server.<\/li>\n<li><b>topic1, topic2,&#8230;<\/b>: Tyto parametry specifikuj\u00ed po\u017eadovan\u00e1 data. Po\u010det a druh parametr\u016f se m\u016f\u017ee li\u0161it v z\u00e1vislosti na dan\u00e9m serveru.<\/li>\n<\/ul>\n<p>N\u00e1sleduj\u00edc\u00ed p\u0159\u00edklad ukazuje, jak pou\u017e\u00edt funkci RTD v Excelu:<\/p>\n<pre> <code>=RTD(\"myProgID\", \"\", \"Stocks\", \"AAPL\")<\/code> <\/pre>\n<p>Tento vzorec z\u00edsk\u00e1 aktu\u00e1ln\u00ed cenu akci\u00ed spole\u010dnosti Apple z programu identifikovan\u00e9ho &#8222;myProgID&#8220;.<\/p>\n<h2>P\u0159\u00edklady v praxi<\/h2>\n<h2>P\u0159\u00edklad 1: Sledov\u00e1n\u00ed akciov\u00e9ho trhu<\/h2>\n<p>Pokud chcete sledovat ceny akci\u00ed n\u011bkolika spole\u010dnost\u00ed v re\u00e1ln\u00e9m \u010dase, m\u016f\u017eete v Excelu nastavit list pro monitoring cen akci\u00ed Apple a Microsoft pomoc\u00ed funkce RTD:<\/p>\n<pre> <code>=RTD(\"financeProg\", \"\", \"Stocks\", \"AAPL\") =RTD(\"financeProg\", \"\", \"Stocks\", \"MSFT\")<\/code> <\/pre>\n<p>Kde &#8222;financeProg&#8220; je identifik\u00e1tor programu z\u00edsk\u00e1vaj\u00edc\u00edho a poskytuj\u00edc\u00edho finan\u010dn\u00ed \u00fadaje a &#8218;AAPL&#8216; a &#8218;MSFT&#8216; jsou k\u00f3dy akci\u00ed na NASDAQ.<\/p>\n<h2>P\u0159\u00edklad 2: Sledov\u00e1n\u00ed m\u011bnov\u00fdch kurz\u016f<\/h2>\n<p>Jestli\u017ee pot\u0159ebujete sledovat m\u011bnov\u00e9 kurzy v re\u00e1ln\u00e9m \u010dase, m\u016f\u017eete pou\u017e\u00edt RTD pro z\u00edsk\u00e1n\u00ed aktu\u00e1ln\u00edch kurzu mezi EUR a USD:<\/p>\n<pre> <code>=RTD(\"currencyFeed\", \"\", \"Currency\", \"EUR\/USD\")<\/code> <\/pre>\n<p>&#8222;currencyFeed&#8220; je n\u00e1zev serveru poskytuj\u00edc\u00edho m\u011bnov\u00e9 \u00fadaje a &#8222;EUR\/USD&#8220; je m\u011bnov\u00fd p\u00e1r, kter\u00fd si p\u0159ejete monitorovat.<\/p>\n<p>V\u00fd\u0161e zm\u00edn\u011bn\u00e9 p\u0159\u00edklady ilustruj\u00ed, jak lze funkci RTD efektivn\u011b vyu\u017e\u00edt pro z\u00edsk\u00e1v\u00e1n\u00ed kl\u00ed\u010dov\u00fdch informac\u00ed v re\u00e1ln\u00e9m \u010dase, co\u017e je z\u00e1sadn\u00ed pro obchodn\u00ed a finan\u010dn\u00ed anal\u00fdzy.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Na\u010dte data v re\u00e1ln\u00e9m \u010dase z aplikace, kter\u00e1 podporuje automatizaci COM<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[284],"tags":[],"class_list":["post-5790","post","type-post","status-publish","format-standard","hentry","category-vyhledavaci-a-pro-odkazy"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Funkce RTD v Excelu: jak funguje, primjeri kori\u0161tenja formule<\/title>\n<meta name=\"description\" content=\"Opis funkcije RTD u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\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\/cs\/rtd\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funkce RTD v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta property=\"og:description\" content=\"Opis funkcije RTD u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/cs\/rtd\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T10:02:51+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funkce RTD v Excelu: jak funguje, primjeri kori\u0161tenja formule\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/rtd\/\",\"url\":\"https:\/\/functiontranslator.com\/cs\/rtd\/\",\"name\":\"Funkce RTD v Excelu: jak funguje, primjeri kori\u0161tenja formule\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:45+00:00\",\"dateModified\":\"2021-02-26T10:02:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Opis funkcije RTD u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/cs\/rtd\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/cs\/rtd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/cs\/rtd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Funkce aplikace Excel\",\"item\":\"https:\/\/functiontranslator.com\/cs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vyhled\u00e1vac\u00ed a pro odkazy\",\"item\":\"https:\/\/functiontranslator.com\/cs\/vyhledavaci-a-pro-odkazy\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"RTD\"}]},{\"@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\":\"cs\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@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\/cs\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funkce RTD v Excelu: jak funguje, primjeri kori\u0161tenja formule","description":"Opis funkcije RTD u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","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\/cs\/rtd\/","og_locale":"cs_CZ","og_type":"article","og_title":"Funkce RTD v Excelu: jak funguje, primjeri kori\u0161tenja formule","og_description":"Opis funkcije RTD u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","og_url":"https:\/\/functiontranslator.com\/cs\/rtd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:45+00:00","article_modified_time":"2021-02-26T10:02:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funkce RTD v Excelu: jak funguje, primjeri kori\u0161tenja formule","twitter_misc":{"Napsal(a)":"glavadmin","Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/cs\/rtd\/","url":"https:\/\/functiontranslator.com\/cs\/rtd\/","name":"Funkce RTD v Excelu: jak funguje, primjeri kori\u0161tenja formule","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:45+00:00","dateModified":"2021-02-26T10:02:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Opis funkcije RTD u Excelu i Google tablicama. Sintaksa, parametri funkcije te prakti\u010dni primjeri.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/cs\/rtd\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/cs\/rtd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/cs\/rtd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Funkce aplikace Excel","item":"https:\/\/functiontranslator.com\/cs\/"},{"@type":"ListItem","position":2,"name":"Vyhled\u00e1vac\u00ed a pro odkazy","item":"https:\/\/functiontranslator.com\/cs\/vyhledavaci-a-pro-odkazy\/"},{"@type":"ListItem","position":3,"name":"RTD"}]},{"@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":"cs"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"cs","@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\/cs\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/comments?post=5790"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5790\/revisions"}],"predecessor-version":[{"id":30927,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/posts\/5790\/revisions\/30927"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/media?parent=5790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/categories?post=5790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/cs\/wp-json\/wp\/v2\/tags?post=5790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}