{"id":6757,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/rtd\/"},"modified":"2021-02-26T08:13:20","modified_gmt":"2021-02-26T08:13:20","slug":"rtd","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/rtd\/","title":{"rendered":"RTD"},"content":{"rendered":"

La fonction RTD (Real-Time Data) de Microsoft Excel est un outil avanc\u00e9 qui permet aux utilisateurs de r\u00e9cup\u00e9rer des donn\u00e9es en direct depuis des programmes externes. Notez que cette fonctionnalit\u00e9 n’est pas disponible dans Google Sheets. Ce guide d\u00e9taillera l’utilisation de la fonction RTD dans Excel \u00e0 travers des exemples pratiques et pr\u00e9cis.<\/p>\n

Explication et syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction RTD est la suivante :<\/p>\n

=RTD(progID, serveur, sujet1, [sujet2], ...)<\/code><\/pre>\n
    \n
  • progID<\/strong> : L’identifiant du programme qui fournit les donn\u00e9es.<\/li>\n
  • serveur<\/strong> : Typiquement une cha\u00eene de caract\u00e8res vide (\u00ab\u00a0\u00a0\u00bb) qui d\u00e9signe le serveur local.<\/li>\n
  • sujet1, sujet2, …<\/strong> : Param\u00e8tres d\u00e9finissant les donn\u00e9es sp\u00e9cifiques \u00e0 r\u00e9cup\u00e9rer. La nature et le nombre de ces param\u00e8tres varient selon la source des donn\u00e9es.<\/li>\n<\/ul>\n
    Exemple :<\/strong> Pour obtenir le prix actuel d’une action sur un march\u00e9 financier via un serveur sp\u00e9cialis\u00e9, votre formule pourrait \u00eatre : <\/p>\n
    =RTD(\"prog.financial\", \"\", \"NASDAQ:AAPL\")<\/code><\/pre>\n
    Applications pratiques de la fonction<\/h2>\n
    Surveillance des cours boursiers en temps r\u00e9el<\/h2>\n
    Si vous \u00eates un analyste financier d\u00e9sirant suivre les cours des actions de plusieurs entreprises majeures cot\u00e9es sur le NASDAQ, la fonction RTD peut \u00eatre utilis\u00e9e pour afficher le prix actuel des actions directement dans votre feuille Excel. Voici comment vous pourriez configurer cela :<\/p>\n\n\n\n\n
    Ticker des actions<\/th>\nFormule RTD<\/th>\n<\/tr>\n
    Apple Inc.<\/td>\n=RTD(\"prog.financial\", \"\", \"NASDAQ:AAPL\")<\/code><\/td>\n<\/tr>\n
    Microsoft Corp.<\/td>\n=RTD(\"prog.financial\", \"\", \"NASDAQ:MSFT\")<\/code><\/td>\n<\/tr>\n<\/table>\n
    Chaque cellule contenant une formule RTD se mettra \u00e0 jour automatiquement pour refl\u00e9ter les informations les plus r\u00e9centes du march\u00e9.<\/p>\n
    Gestion du trading automatique<\/h2>\n
    Lorsque vous d\u00e9veloppez des strat\u00e9gies de trading automatique en utilisant Visual Basic for Applications (VBA) dans Excel, vous pouvez int\u00e9grer la fonction RTD pour alimenter vos algorithmes avec des donn\u00e9es de march\u00e9 mises \u00e0 jour en temps r\u00e9el. Par exemple, voici comment vous pourriez g\u00e9rer une d\u00e9cision de trading bas\u00e9e sur des seuils de prix :<\/p>\n
    If Cells(1, 2).Value > 100 Then ' Code pour acheter ElseIf Cells(1, 2).Value < 80 Then ' Code pour vendre End If<\/code><\/pre>\n
    Dans cet exemple simple, si le prix de l’action d\u00e9passe 100, un ordre d’achat est ex\u00e9cut\u00e9, tandis qu’un prix inf\u00e9rieur \u00e0 80 d\u00e9clenchera une vente.<\/p>\n
    En r\u00e9sum\u00e9, bien que la fonction RTD soit extr\u00eamement b\u00e9n\u00e9fique pour des applications sp\u00e9cialis\u00e9es n\u00e9cessitant des donn\u00e9es en temps r\u00e9el, son utilisation se limite au logiciel Microsoft Excel et n\u00e9cessite l’acc\u00e8s \u00e0 des serveurs ou des programmes externes appropri\u00e9s. Les exemples pr\u00e9sent\u00e9s illustrent la valeur pratique de cette fonction dans les domaines de la finance et du trading.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Extrait lEs donn\u00e9Es En tEmps r\u00e9El \u00e0 partir d\u2019un programmE prEnant En chargE l\u2019automation COM<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[312],"tags":[],"class_list":["post-6757","post","type-post","status-publish","format-standard","hentry","category-recherche-et-matrices"],"acf":[],"yoast_head":"\nFonction RTD dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction RTD d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/rtd\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction RTD dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction RTD d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/rtd\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:13:20+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction RTD dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/rtd\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/rtd\/\",\"name\":\"Fonction RTD dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:13:20+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction RTD d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/rtd\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/rtd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/rtd\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recherche et matrices\",\"item\":\"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/\"},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction RTD dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction RTD d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/rtd\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction RTD dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction RTD d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/rtd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:20+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction RTD dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/rtd\/","url":"https:\/\/functiontranslator.com\/fr\/rtd\/","name":"Fonction RTD dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:13:20+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction RTD d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/rtd\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/rtd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/rtd\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Recherche et matrices","item":"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/"},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6757","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6757"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6757\/revisions"}],"predecessor-version":[{"id":29768,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6757\/revisions\/29768"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}