tag:blogger.com,1999:blog-2788740867542574192024-03-14T03:39:23.794-07:00TURKO INVESTIDORTURKO INVESTIDORhttp://www.blogger.com/profile/08658687394496798117noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-278874086754257419.post-90425727960168171672021-04-05T20:42:00.000-07:002021-04-05T20:49:47.428-07:00IMPORTAR COTAÇÃO DO DOLAR E EURO E OUTRAS MOEDAS ATRAVÉS DA API DO BANCO CENTRAL<p> Tudo Bem pessoal da Blogosfera.</p><p><br /></p><p>Minha primeira postagem no blog, estou aprendendo ainda como usar o bloger e suas funcionalidades.</p><p>Hoje vim complementar o vídeo do nosso queiro amigo <a href="https://www.youtube.com/watch?v=WaoCWPXHL10&t=164s" target="_blank">foconomilhao</a>, que ensina como importar diretamente do banco central a cotação do dólar, para poder utilizar no controle de compras dos ativos no exterior.</p><p>segue o link do api que ele utilizou no vídeo para vocês poderem utilizar, no caso esse link informa a <b>cotação de venda</b></p><p> <span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">=INDEX(IMPORTHTML(</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"https://olinda.bcb.gov.br/olinda/servico/PTAX/versao/v1/odata/CotacaoDolarDia(dataCotacao=@dataCotacao)?@dataCotacao='"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">&MONTH(</span><span style="background: white; color: #f7981d; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">F39</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">)&</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"-"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">&DAY(</span><span style="background: white; color: #f7981d; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">F39</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">)&</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"-"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">&YEAR(</span><span style="background: white; color: #f7981d; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">F39</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">)&</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"'&$top=1&$format=text/html&$select=cotacaoVenda"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">;</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"table"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">;</span><span class="number"><span style="background: white; color: #1155cc; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%; mso-ansi-language: PT-BR; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">1</span></span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">);</span><span class="number"><span style="background: white; color: #1155cc; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%; mso-ansi-language: PT-BR; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">2</span></span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">;</span><span class="number"><span style="background: white; color: #1155cc; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%; mso-ansi-language: PT-BR; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;">1</span></span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">)</span></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;"><br /></span></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">So complementando a publicação dele, quem sabe pode ajudar aos colegas da blogosfera que aplicam em ETF´S na Irlanda em euro. </span></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">A logica da importação direta da cotação (dolar, euro, ...) seria através do link gerado pelo site do banco central <a href="https://olinda.bcb.gov.br/olinda/servico/PTAX/versao/v1/aplicacao#!/recursos">site </a> e após copiar esse link para o google planilhas.</span></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;"><br /></span></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">Vou fazer um passo a passo para ficar mais fácil.</span></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;"><br /></span></p><p style="text-align: center;"><b style="font-family: "Courier New";"><u><span style="font-size: medium;">COTAÇÃO DO DOLAR DE VENDA</span></u></b></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">Nesse primeiro passo a passo como gerar o link da <b><u>cotação do dólar de venda</u></b> em uma determinada data.</span></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;"></span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtvlggBdse1C9m-j1llgWrmaWGaXGOPZ-UyZiHCSe_oVUmUBKAZIAj9b8An-azqG5eBJ4KxMyql_CfsEQaiAcnTDYZGPSHNhAe_Se_KifY6fv8R4zzOaMH65vty4-s0O0OqyDMgRXU9iU/s1039/Capturar.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="444" data-original-width="1039" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtvlggBdse1C9m-j1llgWrmaWGaXGOPZ-UyZiHCSe_oVUmUBKAZIAj9b8An-azqG5eBJ4KxMyql_CfsEQaiAcnTDYZGPSHNhAe_Se_KifY6fv8R4zzOaMH65vty4-s0O0OqyDMgRXU9iU/w400-h171/Capturar.GIF" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: justify;">Após irá abrir a página você deve colocar as informações como informo abaixo.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgreffZZECJG0o-t7v6hT513buPbNTyVk3wFAISMpI4ZDcTaJLeVjEICVTT49I3Aga5oX2czLlx6ir5q3bTkfkDLqDxOGmwsx8rud2re_aeRpX4GoxBt0J3BlBJJaKKPZEHdE-6wH1K6s4/s844/Capturar1.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="521" data-original-width="844" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgreffZZECJG0o-t7v6hT513buPbNTyVk3wFAISMpI4ZDcTaJLeVjEICVTT49I3Aga5oX2czLlx6ir5q3bTkfkDLqDxOGmwsx8rud2re_aeRpX4GoxBt0J3BlBJJaKKPZEHdE-6wH1K6s4/w400-h248/Capturar1.GIF" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: justify;">Após clicar no botão executar irá aparecer a imagem abaixo, informando como irá aparecer a informação que você selecionou na tabela. Caso você queira testar o link gerado é só copiar ele e colocar na aba do seu navegador que vai aparecer a mesma informação.</div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVEDxFVaRfmT9v2FNKR3omYghFuTUPFV4lsj4ctgIqyGgwD2m-sJN6X28U4tDO0uY8fUABAkqkN2gNRKmzk1RMHEqylrzuvOeqFefCdSPmWQVc9dZmM6-rW0FiNqUtXmHpK7sAiE67iv8/s1126/Capturar3.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="309" data-original-width="1126" height="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVEDxFVaRfmT9v2FNKR3omYghFuTUPFV4lsj4ctgIqyGgwD2m-sJN6X28U4tDO0uY8fUABAkqkN2gNRKmzk1RMHEqylrzuvOeqFefCdSPmWQVc9dZmM6-rW0FiNqUtXmHpK7sAiE67iv8/w400-h110/Capturar3.GIF" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: justify;">A partir dai você consegue gerar o link e após isso é necessário fazer as modificações que o <a href="https://www.youtube.com/watch?v=WaoCWPXHL10&t=164s" target="_blank">foco do milhão</a> fez no vídeo dele a respeito da data e caso queira mudar para dólar de compra.</div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><b style="font-size: medium;"><u><span style="font-size: medium;">COTAÇÃO DO EURO DE VENDA</span></u></b></div><div class="separator" style="clear: both; text-align: center;"><b style="font-size: medium;"><u><span style="font-size: medium;"><br /></span></u></b></div><div class="separator" style="clear: both; text-align: justify;">A logica é a mesma da cotação do dólar, porém no final precisa modificar a formula índice no google planilhas, vou deixar o print de como uso na minha planilha e a formula também para facilitar.</div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyTzUg5ITcHRM3YcFZGIq7dM9oQ35E-DHbiCJLqnc4DPNyyfgu2H_-WeSaJlu2s2ayClALxxFeY40z5fkoqAYk7xrg1HflkbffNXgIm-bSu4to3gMMOVwXw17Kd9TI6LxE3vTy0dMrVuQ/s1038/Capturar4.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="441" data-original-width="1038" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyTzUg5ITcHRM3YcFZGIq7dM9oQ35E-DHbiCJLqnc4DPNyyfgu2H_-WeSaJlu2s2ayClALxxFeY40z5fkoqAYk7xrg1HflkbffNXgIm-bSu4to3gMMOVwXw17Kd9TI6LxE3vTy0dMrVuQ/w400-h170/Capturar4.GIF" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;">Preencher as informações nos campos conforme informado na figura abaixo.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKFlMynroJ2w4KCXQlIK3hubjhn58oOav5nDz44zlBqUF2FQYl6_xu8IlS-oJiJ1lwhVEpe9E3NyYZ6MzZ7zZAIwuUMjqhF-L9-w_WlCM5__LPwSoCQVFBj1zUPgor-e4zCvPK1gbf4iQ/s850/Capturar6.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="557" data-original-width="850" height="263" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKFlMynroJ2w4KCXQlIK3hubjhn58oOav5nDz44zlBqUF2FQYl6_xu8IlS-oJiJ1lwhVEpe9E3NyYZ6MzZ7zZAIwuUMjqhF-L9-w_WlCM5__LPwSoCQVFBj1zUPgor-e4zCvPK1gbf4iQ/w400-h263/Capturar6.GIF" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><p></p><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;"></span></p><div class="separator" style="clear: both; text-align: justify;">Quando você clicar no botão executar vai aparecer a imagem abaixo, que contem a cotação do euro de abertura, 3 cotações intermediarias e a cotação de fechamento, dai na planilha no google planilha vamos ajustar qual informação vamos desejar através da formula índice.</div><p></p></blockquote><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhg2zAKNoeQuU4dnsvD0PiShImLXwP4C2A5FB5KlectvaqJosmvw8T_zgRf0Yvo3B8x6FQrck-zDcl6LcO7yvsovRDSS4ZLkhuSdiOZG_dLg4bRTR3EB-40G6st9gItsoYX3tM6lsNJ64s/s1147/Capturar7.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="333" data-original-width="1147" height="116" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhg2zAKNoeQuU4dnsvD0PiShImLXwP4C2A5FB5KlectvaqJosmvw8T_zgRf0Yvo3B8x6FQrck-zDcl6LcO7yvsovRDSS4ZLkhuSdiOZG_dLg4bRTR3EB-40G6st9gItsoYX3tM6lsNJ64s/w400-h116/Capturar7.GIF" width="400" /></a></div><br /><p>Formula no google planilhas para buscar a cotação do euro de venda na data escolhida na célula.</p><p class="MsoNormal"><o:p></o:p></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">=ÍNDICE(IMPORTHTML(</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"https://olinda.bcb.gov.br/olinda/servico/PTAX/versao/v1/odata/CotacaoMoedaDia(moeda=@moeda,dataCotacao=@dataCotacao)?@moeda='EUR'&@dataCotacao='"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">&MÊS(</span><span style="background: white; color: #f7981d; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">D13</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">)&</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"-"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">&DIA(</span><span style="background: white; color: #f7981d; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">D13</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">)&</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"-"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">&ANO(</span><span style="background: white; color: #f7981d; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">D13</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">)&</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"'&$top=100&$skip=4&$format=text/html&$select=cotacaoCompra,cotacaoVenda,dataHoraCotacao,tipoBoletim"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">;</span><span style="background: white; color: green; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">"TABLE"</span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">;</span><span class="number"><span style="background: white; color: #1155cc; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">1</span></span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">);</span><span class="number"><span style="background: white; color: #1155cc; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">2</span></span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">;</span><span class="number"><span style="background: white; color: #1155cc; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">1</span></span><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;">)</span> </p><p>- Na minha planilha uso uma aba para registrar as compras (foto abaixo), na coluna moeda eu seleciono o tipo de moeda que é referente ao ativo que comprei se é <b>dólar </b>ou <b>euro </b>e caso eu deixei em branco a formula faz a multiplicação como se fosse investimento em reais.</p><p><b><u>Aplicando em reais: </u></b></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCXfclXca1JpyPEXWY0KK4JhVEuYYhHtTJVCyJt3k3OLdP9TCXbK0HRbEy93nX5q0ttKf9nzzObCbDm6lpD0IXm8jDI5z3fhI6rNLGC0cxGAlcamla_WLxe4W3gUPvX81e8a1-k68aRL0/s886/Capturar8.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="303" data-original-width="886" height="136" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCXfclXca1JpyPEXWY0KK4JhVEuYYhHtTJVCyJt3k3OLdP9TCXbK0HRbEy93nX5q0ttKf9nzzObCbDm6lpD0IXm8jDI5z3fhI6rNLGC0cxGAlcamla_WLxe4W3gUPvX81e8a1-k68aRL0/w400-h136/Capturar8.GIF" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: justify;"><b><u>Aplicando em DOLAR ou EURO:</u></b></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzt5t0A7Ot_Il1TOReuAwemedQyyalWzq7HeyDSxEhkWDzLkmmEIgXLt_Pv21PjIYypYSinbrpiCEONqbVOgs6bxOYSzxVCpeZhwzLVsMe0Jr8JWj86sAqSoYzFM366SAuXyAKmLvaByo/s890/Capturar9.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="325" data-original-width="890" height="146" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzt5t0A7Ot_Il1TOReuAwemedQyyalWzq7HeyDSxEhkWDzLkmmEIgXLt_Pv21PjIYypYSinbrpiCEONqbVOgs6bxOYSzxVCpeZhwzLVsMe0Jr8JWj86sAqSoYzFM366SAuXyAKmLvaByo/w400-h146/Capturar9.GIF" width="400" /></a></div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: justify;">Conforme eu mudo a moeda de dólar para euro a formula reconhece e puxa a cotação do dia informado.</div><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: justify;"><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">=</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">SE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">D270</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">=</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"DOLAR"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;"> </span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">ÍNDICE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">IMPORTHTML</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"https://olinda.bcb.gov.br/olinda/servico/PTAX/versao/v1/odata/CotacaoDolarDia(dataCotacao=@dataCotacao)?@dataCotacao='"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">MÊS</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #7e3794; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">E270</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"-"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">DIA</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #7e3794; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">E270</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"-"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">ANO</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #7e3794; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">E270</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"'&$top=1&$format=text/html&$select=cotacaoVenda"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"table"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">1</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">1</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">SE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">D270</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">=</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"EURO"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">ÍNDICE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">IMPORTHTML</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"https://olinda.bcb.gov.br/olinda/servico/PTAX/versao/v1/odata/CotacaoMoedaDia(moeda=@moeda,dataCotacao=@dataCotacao)?@moeda='EUR'&@dataCotacao='"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">MÊS</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #7e3794; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">E270</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"-"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">DIA</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #7e3794; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">E270</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"-"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">ANO</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #7e3794; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">E270</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">&</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"'&$top=100&$skip=4&$format=text/html&$select=cotacaoCompra,cotacaoVenda,dataHoraCotacao,tipoBoletim"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">"TABLE"</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">1</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">2</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class="number" dir="auto" style="background-color: white; color: #1155cc; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">1</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">SE</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">(</span><span dir="auto" style="background-color: white; color: #f7981d; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">D270</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">=</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">""</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">;</span><span class=" string " dir="auto" style="background-color: white; color: green; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">""</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">)</span></div><div class="separator" style="clear: both; text-align: justify;"><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;"><br /></span></div><div class="separator" style="clear: both; text-align: justify;"><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">Espero ter ajudado.</span></div><div class="separator" style="clear: both; text-align: justify;"><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;"><br /></span></div><div class="separator" style="clear: both; text-align: justify;"><span class=" default-formula-text-color" dir="auto" style="background-color: white; font-family: Inconsolata, monospace, arial, sans, sans-serif; font-size: 14px; text-align: left; white-space: pre-wrap;">Grande Abraço</span></div><br /><p><br /></p><p><span style="background: white; font-family: "Courier New"; font-size: 10.5pt; line-height: 107%;"><br /></span></p><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: justify;"><br /></div><br /><div class="separator" style="clear: both; text-align: justify;"><br /></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /><p></p>TURKO INVESTIDORhttp://www.blogger.com/profile/08658687394496798117noreply@blogger.com0