{"id":10774,"date":"2023-01-06T06:26:31","date_gmt":"2023-01-06T05:26:31","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10774"},"modified":"2022-12-23T16:28:33","modified_gmt":"2022-12-23T15:28:33","slug":"excel-lire-les-donnees-boursieres-yahoo-finance-a-laide-dune-requete-web-et-de-power-query","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10774","title":{"rendered":"EXCEL : Lire les donn\u00e9es boursi\u00e8res Yahoo Finance \u00e0 l&#8217;aide d&#8217;une requ\u00eate web et de Power Query"},"content":{"rendered":"<p style=\"text-align: justify;\">L\u2019analyse boursi\u00e8re ou la <strong>valorisation de portefeuilles-titres<\/strong> cot\u00e9s n\u00e9cessite d\u2019obtenir les cours de bourse. <a href=\"https:\/\/www.auditsi.eu\/?tag=yahoo\"><strong>Yahoo Finance<\/strong><\/a> diffuse gratuitement de nombreuses informations et actualit\u00e9s sur les indices boursiers, les taux, les cours de mati\u00e8res premi\u00e8res, de devises, d\u2019actions, d\u2019OPCVM, de trackers, de d\u00e9riv\u00e9s\u2026 Ces donn\u00e9es sont <a href=\"https:\/\/www.auditsi.eu\/?p=9490\">librement t\u00e9l\u00e9chargeables sous forme de fichier texte<\/a> ou interrogeables \u00e0 l&#8217;aide de <a href=\"https:\/\/www.auditsi.eu\/?tag=requete-http\">requ\u00eates web<\/a> gr\u00e2ce \u00e0 Power Query (Excel). C&#8217;est cette deuxi\u00e8me solution qui est expos\u00e9e ci-apr\u00e8s.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10747\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer.png\" alt=\"Power Query Remplacer\" width=\"1312\" height=\"484\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer.png 1312w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer-300x111.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer-1024x378.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer-768x283.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer-730x269.png 730w\" sizes=\"auto, (max-width: 1312px) 100vw, 1312px\" \/><\/p>\n<p style=\"text-align: justify;\">Une requ\u00eate web interroge une <strong>base de donn\u00e9es stock\u00e9e sur internet<\/strong>. Cette requ\u00eate est r\u00e9dig\u00e9e sous la forme d&#8217;une URL (pour <em>Uniform Resource Locator<\/em>) qui comprend l&#8217;adresse du site internet qui h\u00e9berge les donn\u00e9es ainsi que les param\u00e8tres de la requ\u00eate.<\/p>\n<p style=\"text-align: justify;\">D\u00e9finition du texte de la requ\u00eate Yahoo Finance (exemple avec l&#8217;action <a href=\"https:\/\/fr.finance.yahoo.com\/quote\/STLA.PA?p=STLA.PA\" target=\"_blank\" rel=\"noopener\">STELLANTIS<\/a>) :<\/p>\n<p style=\"text-align: center;\">https:\/\/query1.finance.yahoo.com\/v7\/finance\/download\/<span style=\"color: #ff9900;\">STLA.PA<\/span>?<span style=\"color: #3366ff;\">period1=1639859181&amp;period2=167139518<\/span>1&amp;<span style=\"color: #ff00ff;\">interval=1d<\/span>&amp;<span style=\"color: #cc99ff;\">events=history<\/span>&amp;includeAdjustedClose=true<\/p>\n<p style=\"text-align: justify;\">Les param\u00e8tres de la requ\u00eate :<\/p>\n<ul>\n<li>Le code de la valeur : ici <span style=\"color: #ff9900;\">STLA.PA<\/span> = STELLANTIS. Pour obtenir le code valeur, il suffit de <a href=\"https:\/\/www.auditsi.eu\/?p=9490\">rechercher la valeur en clair sur Yahoo Finance<\/a>.<\/li>\n<li>Les dates : period1= suivi de la date de d\u00e9but et period2= suivi de la date de fin ; exemple : <span style=\"color: #3366ff;\">period1=1639859181&amp;period2=167139518<\/span><\/li>\n<li>Fr\u00e9quence : <span style=\"color: #ff00ff;\">quotidienne = 1d<\/span>, hebdomadaire = 1wk ou mensuelle = 1mo<\/li>\n<li>Ev\u00e9nement : <span style=\"color: #cc99ff;\">events=history<\/span> (pour cours historiques)<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Les dates (period1 et period2) sont exprim\u00e9es au format timestamp UNIX (se reporter \u00e0 <a href=\"https:\/\/www.auditsi.eu\/?p=10767\">cet article<\/a> pour toutes les explications sur ce format de date).<\/p>\n<p style=\"text-align: justify;\">Il est possible de variabiliser la requ\u00eate. Ceci permet de changer les param\u00e8tres de la requ\u00eate dynamiquement en fonction des besoins. Exemple de requ\u00eate dynamique pr\u00e9par\u00e9e avec Excel :<\/p>\n<p style=\"text-align: center;\">=&#8221;https:\/\/query1.finance.yahoo.com\/v7\/finance\/download\/&#8221;&amp;B5&amp;&#8221;?period1=&#8221;&amp;(B3-DATE(1970;1;1))*86400&amp;&#8221;&amp;period2=&#8221;&amp;(B4-DATE(1970;1;1))*86400&amp;&#8221;&amp;interval=1d&amp;events=history&amp;includeAdjustedClose=true&#8221;<\/p>\n<p style=\"text-align: justify;\">Cette m\u00eame formule en situation dans un classeur Excel (t\u00e9l\u00e9chargeable en bas d&#8217;article) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10787\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Requete-Yahoo-variable.png\" alt=\"Requ\u00eate Yahoo variable\" width=\"1072\" height=\"164\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Requete-Yahoo-variable.png 1072w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Requete-Yahoo-variable-300x46.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Requete-Yahoo-variable-1024x157.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Requete-Yahoo-variable-768x117.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Requete-Yahoo-variable-730x112.png 730w\" sizes=\"auto, (max-width: 1072px) 100vw, 1072px\" \/><\/p>\n<p style=\"text-align: justify;\">Ce classeur Excel fonctionne de mani\u00e8re similaire \u00e0 celui expos\u00e9 dans cet article : <a href=\"https:\/\/www.auditsi.eu\/?p=10767\">T\u00e9l\u00e9charger les cotations boursi\u00e8res avec Yahoo Finance \u00e0 l\u2019aide de liens hypertextes dynamiques<\/a>.<\/p>\n<p style=\"text-align: justify;\">Une fois la valeur s\u00e9lectionn\u00e9e et les dates renseign\u00e9es, le texte de la requ\u00eate se met \u00e0 jour automatiquement.<\/p>\n<p style=\"text-align: justify;\">Pour obtenir les donn\u00e9es correspondant \u00e0 la requ\u00eate Yahoo Finance (<em>query<\/em> en anglais) : se rendre dans le <strong>Menu Donn\u00e9es<\/strong> (d&#8217;Excel) \/ <strong>A partir du web&#8230;<\/strong> :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10744\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web.png\" alt=\"Menu Donn\u00e9es Web\" width=\"430\" height=\"131\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web.png 430w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web-300x91.png 300w\" sizes=\"auto, (max-width: 430px) 100vw, 430px\" \/><\/p>\n<p style=\"text-align: justify;\">Entrer le texte de la requ\u00eate puis cliquer sur le bouton Ok :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10790\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web-Query-YF.png\" alt=\"Menu Donn\u00e9es Web Query YF\" width=\"704\" height=\"224\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web-Query-YF.png 704w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web-Query-YF-300x95.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/p>\n<p style=\"text-align: justify;\">Importation des donn\u00e9es (module Power Query) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10791\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web-Query-Import-YF.png\" alt=\"Menu Donn\u00e9es Web Query Import YF\" width=\"882\" height=\"662\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web-Query-Import-YF.png 882w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web-Query-Import-YF-300x225.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web-Query-Import-YF-768x576.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Menu-Donnees-Web-Query-Import-YF-730x548.png 730w\" sizes=\"auto, (max-width: 882px) 100vw, 882px\" \/><\/p>\n<p style=\"text-align: justify;\">Cliquer sur le bouton &#8220;Transformer les donn\u00e9es&#8221;.<\/p>\n<p style=\"text-align: justify;\">Les donn\u00e9es s&#8217;affichent dans le module Power Query.<\/p>\n<p style=\"text-align: justify;\">La <strong>d\u00e9cimale<\/strong> des cours utilis\u00e9e par Yahoo Finance est le point. Pour remplacer le point par une virgule (format en vigueur en France), se rendre dans le <strong>menu Transformer<\/strong>, s\u00e9lectionner les colonnes Open (ouverture), High (+ haut), Low (+ bas), Close (cours de cl\u00f4ture) et Adj Close (cous ajust\u00e9), puis dans le menu Transformer, choisir l&#8217;option <strong>Remplacer les valeurs<\/strong> :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10747\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer.png\" alt=\"Power Query Remplacer\" width=\"1312\" height=\"484\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer.png 1312w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer-300x111.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer-1024x378.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer-768x283.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Power-Query-Remplacer-730x269.png 730w\" sizes=\"auto, (max-width: 1312px) 100vw, 1312px\" \/><\/p>\n<p style=\"text-align: justify;\">Remplacer le point par la virgule :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10748\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Remplacer.png\" alt=\"PQ Remplacer\" width=\"706\" height=\"302\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Remplacer.png 706w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Remplacer-300x128.png 300w\" sizes=\"auto, (max-width: 706px) 100vw, 706px\" \/><\/p>\n<p style=\"text-align: justify;\">Puis changer le <strong>type de donn\u00e9es<\/strong> Texte pour Nombre d\u00e9cimal :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10749\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Nombre-decimal.png\" alt=\"PQ Nombre d\u00e9cimal\" width=\"725\" height=\"387\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Nombre-decimal.png 725w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Nombre-decimal-300x160.png 300w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/p>\n<p style=\"text-align: justify;\">Les donn\u00e9es sont maintenant dans le bon format.<\/p>\n<p style=\"text-align: justify;\">L&#8217;ensemble des manipulations op\u00e9r\u00e9es dans Power Query (remplacement de caract\u00e8res&#8230;) sont trac\u00e9es en langage M. <strong>La requ\u00eate (langage M)<\/strong> prend la forme suivante :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10792\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Requete-M.png\" alt=\"PQ Requ\u00eate M\" width=\"1220\" height=\"400\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Requete-M.png 1220w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Requete-M-300x98.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Requete-M-1024x336.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Requete-M-768x252.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Requete-M-730x239.png 730w\" sizes=\"auto, (max-width: 1220px) 100vw, 1220px\" \/><\/p>\n<p style=\"text-align: justify;\">Texte int\u00e9gral de la requ\u00eate en langage M :<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">let\r\n    Source = Csv.Document(Web.Contents(\"https:\/\/query1.finance.yahoo.com\/v7\/finance\/download\/STLA.PA?period1=1609459200&amp;period2=1671753600&amp;interval=1d&amp;events=history&amp;includeAdjustedClose=true\"),[Delimiter=\",\", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),\r\n    #\"En-t\u00eates promus\" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),\r\n    #\"Valeur remplac\u00e9e\" = Table.ReplaceValue(#\"En-t\u00eates promus\",\".\",\",\",Replacer.ReplaceText,{\"Open\", \"High\", \"Low\", \"Close\", \"Adj Close\"}),\r\n    #\"Type modifi\u00e9\" = Table.TransformColumnTypes(#\"Valeur remplac\u00e9e\",{{\"Date\", type date}, {\"Open\", type number}, {\"High\", type number}, {\"Low\", type number}, {\"Close\", type number}, {\"Adj Close\", type number}, {\"Volume\", Int64.Type}})\r\nin\r\n    #\"Type modifi\u00e9\"<\/pre>\n<p style=\"text-align: justify;\">La requ\u00eate est introduite par <strong>Let<\/strong> suivi de <strong>Source<\/strong> pr\u00e9cise la source de donn\u00e9es (ici un contenu Web : Web.Contents ; mais la source peut \u00eatre de nature tr\u00e8s vari\u00e9e : fichier texte, base de donn\u00e9es Access.. et m\u00eame <a href=\"https:\/\/www.auditsi.eu\/?p=10302\">fichier PDF<\/a>). Ensuite, les diff\u00e9rentes manipulations de donn\u00e9es se d\u00e9roulent dans l&#8217;ordre d&#8217;apparition : ent\u00eate de champs de donn\u00e9es (PromoteHeaders), remplacements de caract\u00e8res (ReplaceValue), changement de type de donn\u00e9es (TransformColumnTypes).<\/p>\n<p style=\"text-align: justify;\">Une fois les traitements de donn\u00e9es op\u00e9r\u00e9s, charger les donn\u00e9es dans Excel :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10751\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Charger.png\" alt=\"PQ Charger\" width=\"226\" height=\"223\"><\/p>\n<p style=\"text-align: justify;\">Les donn\u00e9es sont charg\u00e9es dans Excel (en <a href=\"https:\/\/www.auditsi.eu\/?p=10586\">mode tableau<\/a>) :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10793\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Resultat-tableau.png\" alt=\"PQ R\u00e9sultat tableau\" width=\"539\" height=\"368\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Resultat-tableau.png 539w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/PQ-Resultat-tableau-300x205.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/p>\n<p style=\"text-align: justify;\">Ces donn\u00e9es sont pr\u00eates \u00e0 \u00eatre utilis\u00e9es, par exemple pour en tirer un graphique :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10794\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Graphique-STELLANTIS.png\" alt=\"Graphique STELLANTIS\" width=\"754\" height=\"524\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Graphique-STELLANTIS.png 754w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Graphique-STELLANTIS-300x208.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Graphique-STELLANTIS-730x507.png 730w\" sizes=\"auto, (max-width: 754px) 100vw, 754px\" \/><\/p>\n<p style=\"text-align: justify;\">Excel dispose par ailleurs de graphiques boursiers :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10795\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Excel-graphique-boursier.png\" alt=\"Excel graphique boursier\" width=\"637\" height=\"327\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Excel-graphique-boursier.png 637w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/12\/Excel-graphique-boursier-300x154.png 300w\" sizes=\"auto, (max-width: 637px) 100vw, 637px\" \/><\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : tous les&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?tag=bourse\">articles sur la bourse<\/a><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%20%3A%20Lire%20les%20donn%C3%A9es%20boursi%C3%A8res%20Yahoo%20Finance%20%C3%A0%20l%27aide%20d%27une%20requ%C3%AAte%20web%20et%20de%20Power%20Query\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>L\u2019analyse boursi\u00e8re ou la valorisation de portefeuilles-titres cot\u00e9s n\u00e9cessite d\u2019obtenir les cours de bourse. Yahoo Finance diffuse gratuitement de nombreuses informations et actualit\u00e9s sur les indices boursiers, les taux, les cours de mati\u00e8res premi\u00e8res, de devises, d\u2019actions, d\u2019OPCVM, de trackers, de d\u00e9riv\u00e9s\u2026 Ces donn\u00e9es sont librement t\u00e9l\u00e9chargeables sous forme de fichier texte ou interrogeables \u00e0 &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10774\" class=\"more-link\">Continue reading &lsquo;EXCEL : Lire les donn\u00e9es boursi\u00e8res Yahoo Finance \u00e0 l&#8217;aide d&#8217;une requ\u00eate web et de Power Query&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"EXCEL%20%3A%20Lire%20les%20donn%C3%A9es%20boursi%C3%A8res%20Yahoo%20Finance%20%C3%A0%20l%27aide%20d%27une%20requ%C3%AAte%20web%20et%20de%20Power%20Query\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[8,2680,30],"tags":[2436,2833,2305,2376,2832,1541,2440,2433,2706,2712,2831,2708,2395,2835,2837,2834,2812,2838,2449],"class_list":["post-10774","post","type-post","status-publish","format-standard","hentry","category-extractions-de-donnees","category-m","category-sites-internet","tag-actions","tag-analyse-financiere","tag-bourse","tag-cotation","tag-cours-de-bourse","tag-date","tag-donnees-historiques","tag-indice-boursier","tag-langage-m","tag-let-in","tag-portefeuille-titres","tag-power-query","tag-requete-http","tag-secondes","tag-timestamp","tag-unix","tag-url","tag-web-contents","tag-yahoo"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10774"}],"version-history":[{"count":9,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10774\/revisions"}],"predecessor-version":[{"id":10804,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10774\/revisions\/10804"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}