-
-
Notifications
You must be signed in to change notification settings - Fork 15
Selic: Divergência entre biblioteca e site do Banco Central #54
Comments
See #54 To avoid this bug to cause any miscalculation, let's remove Selic from the API temporarily. We can bring it back when the bug is fixed.
Obrigado por reportar esse erro, @JulioNegreiro. Temporariamente removi a Selic e soltei uma nova versão do PyPI sem a Selic para evitar que pessoas usem a conversão “bugada”. |
Acho que descobri onde está o erro: quantidade de casas decimais consideradas depois de todas as multiplicações acumuladas. Se você faz a pesquisa por dia, ele devolve o fator acumulado com 16 casas decimais: fator_diario_2017 = decimal.Decimal("1.0993932466542384") Se você faz por mês, cada fator possui apenas 8 casas decimais: Se multiplicarmos esses fatores mensais usando o fator_mensal_2017 = (
1
* decimal.Decimal("1.01086120")
* decimal.Decimal("1.00865084")
* decimal.Decimal("1.01052056")
* decimal.Decimal("1.00786581")
* decimal.Decimal("1.00927132")
* decimal.Decimal("1.00808869")
* decimal.Decimal("1.00797923")
* decimal.Decimal("1.00802289")
* decimal.Decimal("1.00638460")
* decimal.Decimal("1.00643930")
* decimal.Decimal("1.00568188")
* decimal.Decimal("1.00538400")
)
# resultado: Decimal('1.099393246654238379628934669') Se arredondarmos o resultado para 16 dígitos os valores ficam iguais: fator_mensal_2017_arredondado = fator_mensal_2017.quantize(decimal.Decimal("0.0000000000000001"))
fator_mensal_2017_arredondado == fator_diario_2017 # True Então, adicionar um |
Vou levantar outra hipótese aqui, que é o do período de vigência e como o cálculo é ffeito.
No esse pacote, o fator acumulado dá 35,983673%, sendo que a do site é de 35,476542% — a diferença é de pouco mais de 0,5% — será que as datas de referência, e a forma como é calculado o acumúlo mensal dá conta dessa diferença? Se sim, acho que temos que deixar claro essa questão de datas aqui:
Acho que isso mais o cuidado com as casas decimais que o @turicas mencionou seria a solução mais definitiva. O que acham? |
Compartilhando aqui um output meio bagunçado, mas que me ajuda a debugar — caso interesse a mais alguém
$ poetry run python -c "from calculadora_do_cidadao.adapters.selic import Selic; Selic()"
{"totalItems":12,"registros":[{"periodo":"Jan / 2022","fator":1.00732270,"fatorFormatado":"1,00732270"},{"periodo":"Feb / 2022","fator":1.00755041,"fatorFormatado":"1,00755041"},{"periodo":"Mar / 2022","fator":1.00927054,"fatorFormatado":"1,00927054"},{"periodo":"Apr / 2022","fator":1.00834321,"fatorFormatado":"1,00834321"},{"periodo":"May / 2022","fator":1.01034592,"fatorFormatado":"1,01034592"},{"periodo":"Jun / 2022","fator":1.01015316,"fatorFormatado":"1,01015316"},{"periodo":"Jul / 2022","fator":1.01034842,"fatorFormatado":"1,01034842"},{"periodo":"Aug / 2022","fator":1.01169361,"fatorFormatado":"1,01169361"},{"periodo":"Sep / 2022","fator":1.01071982,"fatorFormatado":"1,01071982"},{"periodo":"Oct / 2022","fator":1.01020676,"fatorFormatado":"1,01020676"},{"periodo":"Nov / 2022","fator":1.01020676,"fatorFormatado":"1,01020676"},{"periodo":"Dec / 2022","fator":1.00050788,"fatorFormatado":"1,00050788"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:23"}
Row(periodo='Jan / 2022', fator=1.0073227, fatorFormatado='1,00732270')
Row(periodo='Feb / 2022', fator=1.00755041, fatorFormatado='1,00755041')
Row(periodo='Mar / 2022', fator=1.00927054, fatorFormatado='1,00927054')
Row(periodo='Apr / 2022', fator=1.00834321, fatorFormatado='1,00834321')
Row(periodo='May / 2022', fator=1.01034592, fatorFormatado='1,01034592')
Row(periodo='Jun / 2022', fator=1.01015316, fatorFormatado='1,01015316')
Row(periodo='Jul / 2022', fator=1.01034842, fatorFormatado='1,01034842')
Row(periodo='Aug / 2022', fator=1.01169361, fatorFormatado='1,01169361')
Row(periodo='Sep / 2022', fator=1.01071982, fatorFormatado='1,01071982')
Row(periodo='Oct / 2022', fator=1.01020676, fatorFormatado='1,01020676')
Row(periodo='Nov / 2022', fator=1.01020676, fatorFormatado='1,01020676')
Row(periodo='Dec / 2022', fator=1.00050788, fatorFormatado='1,00050788')
{"totalItems":12,"registros":[{"periodo":"Jan / 2021","fator":1.00149486,"fatorFormatado":"1,00149486"},{"periodo":"Feb / 2021","fator":1.00134527,"fatorFormatado":"1,00134527"},{"periodo":"Mar / 2021","fator":1.00201080,"fatorFormatado":"1,00201080"},{"periodo":"Apr / 2021","fator":1.00207785,"fatorFormatado":"1,00207785"},{"periodo":"May / 2021","fator":1.00270326,"fatorFormatado":"1,00270326"},{"periodo":"Jun / 2021","fator":1.00307779,"fatorFormatado":"1,00307779"},{"periodo":"Jul / 2021","fator":1.00355616,"fatorFormatado":"1,00355616"},{"periodo":"Aug / 2021","fator":1.00427952,"fatorFormatado":"1,00427952"},{"periodo":"Sep / 2021","fator":1.00441999,"fatorFormatado":"1,00441999"},{"periodo":"Oct / 2021","fator":1.00485996,"fatorFormatado":"1,00485996"},{"periodo":"Nov / 2021","fator":1.00586749,"fatorFormatado":"1,00586749"},{"periodo":"Dec / 2021","fator":1.00769083,"fatorFormatado":"1,00769083"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:24"}
Row(periodo='Jan / 2021', fator=1.00149486, fatorFormatado='1,00149486')
Row(periodo='Feb / 2021', fator=1.00134527, fatorFormatado='1,00134527')
Row(periodo='Mar / 2021', fator=1.0020108, fatorFormatado='1,00201080')
Row(periodo='Apr / 2021', fator=1.00207785, fatorFormatado='1,00207785')
Row(periodo='May / 2021', fator=1.00270326, fatorFormatado='1,00270326')
Row(periodo='Jun / 2021', fator=1.00307779, fatorFormatado='1,00307779')
Row(periodo='Jul / 2021', fator=1.00355616, fatorFormatado='1,00355616')
Row(periodo='Aug / 2021', fator=1.00427952, fatorFormatado='1,00427952')
Row(periodo='Sep / 2021', fator=1.00441999, fatorFormatado='1,00441999')
Row(periodo='Oct / 2021', fator=1.00485996, fatorFormatado='1,00485996')
Row(periodo='Nov / 2021', fator=1.00586749, fatorFormatado='1,00586749')
Row(periodo='Dec / 2021', fator=1.00769083, fatorFormatado='1,00769083')
{"totalItems":12,"registros":[{"periodo":"Jan / 2020","fator":1.00376633,"fatorFormatado":"1,00376633"},{"periodo":"Feb / 2020","fator":1.00293729,"fatorFormatado":"1,00293729"},{"periodo":"Mar / 2020","fator":1.00338369,"fatorFormatado":"1,00338369"},{"periodo":"Apr / 2020","fator":1.00284925,"fatorFormatado":"1,00284925"},{"periodo":"May / 2020","fator":1.00235810,"fatorFormatado":"1,00235810"},{"periodo":"Jun / 2020","fator":1.00212332,"fatorFormatado":"1,00212332"},{"periodo":"Jul / 2020","fator":1.00194346,"fatorFormatado":"1,00194346"},{"periodo":"Aug / 2020","fator":1.00159890,"fatorFormatado":"1,00159890"},{"periodo":"Sep / 2020","fator":1.00156966,"fatorFormatado":"1,00156966"},{"periodo":"Oct / 2020","fator":1.00156966,"fatorFormatado":"1,00156966"},{"periodo":"Nov / 2020","fator":1.00149486,"fatorFormatado":"1,00149486"},{"periodo":"Dec / 2020","fator":1.00164447,"fatorFormatado":"1,00164447"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:24"}
Row(periodo='Jan / 2020', fator=1.00376633, fatorFormatado='1,00376633')
Row(periodo='Feb / 2020', fator=1.00293729, fatorFormatado='1,00293729')
Row(periodo='Mar / 2020', fator=1.00338369, fatorFormatado='1,00338369')
Row(periodo='Apr / 2020', fator=1.00284925, fatorFormatado='1,00284925')
Row(periodo='May / 2020', fator=1.0023581, fatorFormatado='1,00235810')
Row(periodo='Jun / 2020', fator=1.00212332, fatorFormatado='1,00212332')
Row(periodo='Jul / 2020', fator=1.00194346, fatorFormatado='1,00194346')
Row(periodo='Aug / 2020', fator=1.0015989, fatorFormatado='1,00159890')
Row(periodo='Sep / 2020', fator=1.00156966, fatorFormatado='1,00156966')
Row(periodo='Oct / 2020', fator=1.00156966, fatorFormatado='1,00156966')
Row(periodo='Nov / 2020', fator=1.00149486, fatorFormatado='1,00149486')
Row(periodo='Dec / 2020', fator=1.00164447, fatorFormatado='1,00164447')
{"totalItems":12,"registros":[{"periodo":"Jan / 2019","fator":1.00543042,"fatorFormatado":"1,00543042"},{"periodo":"Feb / 2019","fator":1.00493553,"fatorFormatado":"1,00493553"},{"periodo":"Mar / 2019","fator":1.00468818,"fatorFormatado":"1,00468818"},{"periodo":"Apr / 2019","fator":1.00518295,"fatorFormatado":"1,00518295"},{"periodo":"May / 2019","fator":1.00543042,"fatorFormatado":"1,00543042"},{"periodo":"Jun / 2019","fator":1.00468818,"fatorFormatado":"1,00468818"},{"periodo":"Jul / 2019","fator":1.00567796,"fatorFormatado":"1,00567796"},{"periodo":"Aug / 2019","fator":1.00501719,"fatorFormatado":"1,00501719"},{"periodo":"Sep / 2019","fator":1.00463760,"fatorFormatado":"1,00463760"},{"periodo":"Oct / 2019","fator":1.00479264,"fatorFormatado":"1,00479264"},{"periodo":"Nov / 2019","fator":1.00380386,"fatorFormatado":"1,00380386"},{"periodo":"Dec / 2019","fator":1.00374704,"fatorFormatado":"1,00374704"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:24"}
Row(periodo='Jan / 2019', fator=1.00543042, fatorFormatado='1,00543042')
Row(periodo='Feb / 2019', fator=1.00493553, fatorFormatado='1,00493553')
Row(periodo='Mar / 2019', fator=1.00468818, fatorFormatado='1,00468818')
Row(periodo='Apr / 2019', fator=1.00518295, fatorFormatado='1,00518295')
Row(periodo='May / 2019', fator=1.00543042, fatorFormatado='1,00543042')
Row(periodo='Jun / 2019', fator=1.00468818, fatorFormatado='1,00468818')
Row(periodo='Jul / 2019', fator=1.00567796, fatorFormatado='1,00567796')
Row(periodo='Aug / 2019', fator=1.00501719, fatorFormatado='1,00501719')
Row(periodo='Sep / 2019', fator=1.0046376, fatorFormatado='1,00463760')
Row(periodo='Oct / 2019', fator=1.00479264, fatorFormatado='1,00479264')
Row(periodo='Nov / 2019', fator=1.00380386, fatorFormatado='1,00380386')
Row(periodo='Dec / 2019', fator=1.00374704, fatorFormatado='1,00374704')
{"totalItems":12,"registros":[{"periodo":"Jan / 2018","fator":1.00584205,"fatorFormatado":"1,00584205"},{"periodo":"Feb / 2018","fator":1.00465602,"fatorFormatado":"1,00465602"},{"periodo":"Mar / 2018","fator":1.00532345,"fatorFormatado":"1,00532345"},{"periodo":"Apr / 2018","fator":1.00518295,"fatorFormatado":"1,00518295"},{"periodo":"May / 2018","fator":1.00518295,"fatorFormatado":"1,00518295"},{"periodo":"Jun / 2018","fator":1.00518295,"fatorFormatado":"1,00518295"},{"periodo":"Jul / 2018","fator":1.00543042,"fatorFormatado":"1,00543042"},{"periodo":"Aug / 2018","fator":1.00567796,"fatorFormatado":"1,00567796"},{"periodo":"Sep / 2018","fator":1.00468818,"fatorFormatado":"1,00468818"},{"periodo":"Oct / 2018","fator":1.00543042,"fatorFormatado":"1,00543042"},{"periodo":"Nov / 2018","fator":1.00493553,"fatorFormatado":"1,00493553"},{"periodo":"Dec / 2018","fator":1.00493553,"fatorFormatado":"1,00493553"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:25"}
Row(periodo='Jan / 2018', fator=1.00584205, fatorFormatado='1,00584205')
Row(periodo='Feb / 2018', fator=1.00465602, fatorFormatado='1,00465602')
Row(periodo='Mar / 2018', fator=1.00532345, fatorFormatado='1,00532345')
Row(periodo='Apr / 2018', fator=1.00518295, fatorFormatado='1,00518295')
Row(periodo='May / 2018', fator=1.00518295, fatorFormatado='1,00518295')
Row(periodo='Jun / 2018', fator=1.00518295, fatorFormatado='1,00518295')
Row(periodo='Jul / 2018', fator=1.00543042, fatorFormatado='1,00543042')
Row(periodo='Aug / 2018', fator=1.00567796, fatorFormatado='1,00567796')
Row(periodo='Sep / 2018', fator=1.00468818, fatorFormatado='1,00468818')
Row(periodo='Oct / 2018', fator=1.00543042, fatorFormatado='1,00543042')
Row(periodo='Nov / 2018', fator=1.00493553, fatorFormatado='1,00493553')
Row(periodo='Dec / 2018', fator=1.00493553, fatorFormatado='1,00493553')
{"totalItems":12,"registros":[{"periodo":"Jan / 2017","fator":1.01086120,"fatorFormatado":"1,01086120"},{"periodo":"Feb / 2017","fator":1.00865084,"fatorFormatado":"1,00865084"},{"periodo":"Mar / 2017","fator":1.01052056,"fatorFormatado":"1,01052056"},{"periodo":"Apr / 2017","fator":1.00786581,"fatorFormatado":"1,00786581"},{"periodo":"May / 2017","fator":1.00927132,"fatorFormatado":"1,00927132"},{"periodo":"Jun / 2017","fator":1.00808869,"fatorFormatado":"1,00808869"},{"periodo":"Jul / 2017","fator":1.00797923,"fatorFormatado":"1,00797923"},{"periodo":"Aug / 2017","fator":1.00802289,"fatorFormatado":"1,00802289"},{"periodo":"Sep / 2017","fator":1.00638460,"fatorFormatado":"1,00638460"},{"periodo":"Oct / 2017","fator":1.00643930,"fatorFormatado":"1,00643930"},{"periodo":"Nov / 2017","fator":1.00568188,"fatorFormatado":"1,00568188"},{"periodo":"Dec / 2017","fator":1.00538400,"fatorFormatado":"1,00538400"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:25"}
Row(periodo='Jan / 2017', fator=1.0108612, fatorFormatado='1,01086120')
Row(periodo='Feb / 2017', fator=1.00865084, fatorFormatado='1,00865084')
Row(periodo='Mar / 2017', fator=1.01052056, fatorFormatado='1,01052056')
Row(periodo='Apr / 2017', fator=1.00786581, fatorFormatado='1,00786581')
Row(periodo='May / 2017', fator=1.00927132, fatorFormatado='1,00927132')
Row(periodo='Jun / 2017', fator=1.00808869, fatorFormatado='1,00808869')
Row(periodo='Jul / 2017', fator=1.00797923, fatorFormatado='1,00797923')
Row(periodo='Aug / 2017', fator=1.00802289, fatorFormatado='1,00802289')
Row(periodo='Sep / 2017', fator=1.0063846, fatorFormatado='1,00638460')
Row(periodo='Oct / 2017', fator=1.0064393, fatorFormatado='1,00643930')
Row(periodo='Nov / 2017', fator=1.00568188, fatorFormatado='1,00568188')
Row(periodo='Dec / 2017', fator=1.005384, fatorFormatado='1,00538400')
{"totalItems":12,"registros":[{"periodo":"Jan / 2016","fator":1.01055880,"fatorFormatado":"1,01055880"},{"periodo":"Feb / 2016","fator":1.01002822,"fatorFormatado":"1,01002822"},{"periodo":"Mar / 2016","fator":1.01162079,"fatorFormatado":"1,01162079"},{"periodo":"Apr / 2016","fator":1.01055880,"fatorFormatado":"1,01055880"},{"periodo":"May / 2016","fator":1.01108965,"fatorFormatado":"1,01108965"},{"periodo":"Jun / 2016","fator":1.01162079,"fatorFormatado":"1,01162079"},{"periodo":"Jul / 2016","fator":1.01108965,"fatorFormatado":"1,01108965"},{"periodo":"Aug / 2016","fator":1.01215220,"fatorFormatado":"1,01215220"},{"periodo":"Sep / 2016","fator":1.01108965,"fatorFormatado":"1,01108965"},{"periodo":"Oct / 2016","fator":1.01048842,"fatorFormatado":"1,01048842"},{"periodo":"Nov / 2016","fator":1.01038286,"fatorFormatado":"1,01038286"},{"periodo":"Dec / 2016","fator":1.01123315,"fatorFormatado":"1,01123315"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:25"}
Row(periodo='Jan / 2016', fator=1.0105588, fatorFormatado='1,01055880')
Row(periodo='Feb / 2016', fator=1.01002822, fatorFormatado='1,01002822')
Row(periodo='Mar / 2016', fator=1.01162079, fatorFormatado='1,01162079')
Row(periodo='Apr / 2016', fator=1.0105588, fatorFormatado='1,01055880')
Row(periodo='May / 2016', fator=1.01108965, fatorFormatado='1,01108965')
Row(periodo='Jun / 2016', fator=1.01162079, fatorFormatado='1,01162079')
Row(periodo='Jul / 2016', fator=1.01108965, fatorFormatado='1,01108965')
Row(periodo='Aug / 2016', fator=1.0121522, fatorFormatado='1,01215220')
Row(periodo='Sep / 2016', fator=1.01108965, fatorFormatado='1,01108965')
Row(periodo='Oct / 2016', fator=1.01048842, fatorFormatado='1,01048842')
Row(periodo='Nov / 2016', fator=1.01038286, fatorFormatado='1,01038286')
Row(periodo='Dec / 2016', fator=1.01123315, fatorFormatado='1,01123315')
{"totalItems":12,"registros":[{"periodo":"Jan / 2015","fator":1.00935075,"fatorFormatado":"1,00935075"},{"periodo":"Feb / 2015","fator":1.00822411,"fatorFormatado":"1,00822411"},{"periodo":"Mar / 2015","fator":1.01039967,"fatorFormatado":"1,01039967"},{"periodo":"Apr / 2015","fator":1.00951792,"fatorFormatado":"1,00951792"},{"periodo":"May / 2015","fator":1.00985322,"fatorFormatado":"1,00985322"},{"periodo":"Jun / 2015","fator":1.01066676,"fatorFormatado":"1,01066676"},{"periodo":"Jul / 2015","fator":1.01178198,"fatorFormatado":"1,01178198"},{"periodo":"Aug / 2015","fator":1.01108965,"fatorFormatado":"1,01108965"},{"periodo":"Sep / 2015","fator":1.01108965,"fatorFormatado":"1,01108965"},{"periodo":"Oct / 2015","fator":1.01108965,"fatorFormatado":"1,01108965"},{"periodo":"Nov / 2015","fator":1.01055880,"fatorFormatado":"1,01055880"},{"periodo":"Dec / 2015","fator":1.01162079,"fatorFormatado":"1,01162079"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:25"}
Row(periodo='Jan / 2015', fator=1.00935075, fatorFormatado='1,00935075')
Row(periodo='Feb / 2015', fator=1.00822411, fatorFormatado='1,00822411')
Row(periodo='Mar / 2015', fator=1.01039967, fatorFormatado='1,01039967')
Row(periodo='Apr / 2015', fator=1.00951792, fatorFormatado='1,00951792')
Row(periodo='May / 2015', fator=1.00985322, fatorFormatado='1,00985322')
Row(periodo='Jun / 2015', fator=1.01066676, fatorFormatado='1,01066676')
Row(periodo='Jul / 2015', fator=1.01178198, fatorFormatado='1,01178198')
Row(periodo='Aug / 2015', fator=1.01108965, fatorFormatado='1,01108965')
Row(periodo='Sep / 2015', fator=1.01108965, fatorFormatado='1,01108965')
Row(periodo='Oct / 2015', fator=1.01108965, fatorFormatado='1,01108965')
Row(periodo='Nov / 2015', fator=1.0105588, fatorFormatado='1,01055880')
Row(periodo='Dec / 2015', fator=1.01162079, fatorFormatado='1,01162079')
{"totalItems":12,"registros":[{"periodo":"Jan / 2014","fator":1.00849344,"fatorFormatado":"1,00849344"},{"periodo":"Feb / 2014","fator":1.00790146,"fatorFormatado":"1,00790146"},{"periodo":"Mar / 2014","fator":1.00765957,"fatorFormatado":"1,00765957"},{"periodo":"Apr / 2014","fator":1.00822668,"fatorFormatado":"1,00822668"},{"periodo":"May / 2014","fator":1.00865873,"fatorFormatado":"1,00865873"},{"periodo":"Jun / 2014","fator":1.00824472,"fatorFormatado":"1,00824472"},{"periodo":"Jul / 2014","fator":1.00948727,"fatorFormatado":"1,00948727"},{"periodo":"Aug / 2014","fator":1.00865982,"fatorFormatado":"1,00865982"},{"periodo":"Sep / 2014","fator":1.00907292,"fatorFormatado":"1,00907292"},{"periodo":"Oct / 2014","fator":1.00950532,"fatorFormatado":"1,00950532"},{"periodo":"Nov / 2014","fator":1.00842493,"fatorFormatado":"1,00842493"},{"periodo":"Dec / 2014","fator":1.00961295,"fatorFormatado":"1,00961295"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:26"}
Row(periodo='Jan / 2014', fator=1.00849344, fatorFormatado='1,00849344')
Row(periodo='Feb / 2014', fator=1.00790146, fatorFormatado='1,00790146')
Row(periodo='Mar / 2014', fator=1.00765957, fatorFormatado='1,00765957')
Row(periodo='Apr / 2014', fator=1.00822668, fatorFormatado='1,00822668')
Row(periodo='May / 2014', fator=1.00865873, fatorFormatado='1,00865873')
Row(periodo='Jun / 2014', fator=1.00824472, fatorFormatado='1,00824472')
Row(periodo='Jul / 2014', fator=1.00948727, fatorFormatado='1,00948727')
Row(periodo='Aug / 2014', fator=1.00865982, fatorFormatado='1,00865982')
Row(periodo='Sep / 2014', fator=1.00907292, fatorFormatado='1,00907292')
Row(periodo='Oct / 2014', fator=1.00950532, fatorFormatado='1,00950532')
Row(periodo='Nov / 2014', fator=1.00842493, fatorFormatado='1,00842493')
Row(periodo='Dec / 2014', fator=1.00961295, fatorFormatado='1,00961295')
{"totalItems":12,"registros":[{"periodo":"Jan / 2013","fator":1.00601440,"fatorFormatado":"1,00601440"},{"periodo":"Feb / 2013","fator":1.00492750,"fatorFormatado":"1,00492750"},{"periodo":"Mar / 2013","fator":1.00549404,"fatorFormatado":"1,00549404"},{"periodo":"Apr / 2013","fator":1.00613646,"fatorFormatado":"1,00613646"},{"periodo":"May / 2013","fator":1.00598536,"fatorFormatado":"1,00598536"},{"periodo":"Jun / 2013","fator":1.00605273,"fatorFormatado":"1,00605273"},{"periodo":"Jul / 2013","fator":1.00724092,"fatorFormatado":"1,00724092"},{"periodo":"Aug / 2013","fator":1.00710315,"fatorFormatado":"1,00710315"},{"periodo":"Sep / 2013","fator":1.00713029,"fatorFormatado":"1,00713029"},{"periodo":"Oct / 2013","fator":1.00810510,"fatorFormatado":"1,00810510"},{"periodo":"Nov / 2013","fator":1.00719208,"fatorFormatado":"1,00719208"},{"periodo":"Dec / 2013","fator":1.00789746,"fatorFormatado":"1,00789746"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:26"}
Row(periodo='Jan / 2013', fator=1.0060144, fatorFormatado='1,00601440')
Row(periodo='Feb / 2013', fator=1.0049275, fatorFormatado='1,00492750')
Row(periodo='Mar / 2013', fator=1.00549404, fatorFormatado='1,00549404')
Row(periodo='Apr / 2013', fator=1.00613646, fatorFormatado='1,00613646')
Row(periodo='May / 2013', fator=1.00598536, fatorFormatado='1,00598536')
Row(periodo='Jun / 2013', fator=1.00605273, fatorFormatado='1,00605273')
Row(periodo='Jul / 2013', fator=1.00724092, fatorFormatado='1,00724092')
Row(periodo='Aug / 2013', fator=1.00710315, fatorFormatado='1,00710315')
Row(periodo='Sep / 2013', fator=1.00713029, fatorFormatado='1,00713029')
Row(periodo='Oct / 2013', fator=1.0081051, fatorFormatado='1,00810510')
Row(periodo='Nov / 2013', fator=1.00719208, fatorFormatado='1,00719208')
Row(periodo='Dec / 2013', fator=1.00789746, fatorFormatado='1,00789746')
{"totalItems":12,"registros":[{"periodo":"Jan / 2012","fator":1.00891016,"fatorFormatado":"1,00891016"},{"periodo":"Feb / 2012","fator":1.00748773,"fatorFormatado":"1,00748773"},{"periodo":"Mar / 2012","fator":1.00821139,"fatorFormatado":"1,00821139"},{"periodo":"Apr / 2012","fator":1.00711876,"fatorFormatado":"1,00711876"},{"periodo":"May / 2012","fator":1.00744724,"fatorFormatado":"1,00744724"},{"periodo":"Jun / 2012","fator":1.00641503,"fatorFormatado":"1,00641503"},{"periodo":"Jul / 2012","fator":1.00679965,"fatorFormatado":"1,00679965"},{"periodo":"Aug / 2012","fator":1.00691811,"fatorFormatado":"1,00691811"},{"periodo":"Sep / 2012","fator":1.00538995,"fatorFormatado":"1,00538995"},{"periodo":"Oct / 2012","fator":1.00611339,"fatorFormatado":"1,00611339"},{"periodo":"Nov / 2012","fator":1.00548846,"fatorFormatado":"1,00548846"},{"periodo":"Dec / 2012","fator":1.00550152,"fatorFormatado":"1,00550152"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:26"}
Row(periodo='Jan / 2012', fator=1.00891016, fatorFormatado='1,00891016')
Row(periodo='Feb / 2012', fator=1.00748773, fatorFormatado='1,00748773')
Row(periodo='Mar / 2012', fator=1.00821139, fatorFormatado='1,00821139')
Row(periodo='Apr / 2012', fator=1.00711876, fatorFormatado='1,00711876')
Row(periodo='May / 2012', fator=1.00744724, fatorFormatado='1,00744724')
Row(periodo='Jun / 2012', fator=1.00641503, fatorFormatado='1,00641503')
Row(periodo='Jul / 2012', fator=1.00679965, fatorFormatado='1,00679965')
Row(periodo='Aug / 2012', fator=1.00691811, fatorFormatado='1,00691811')
Row(periodo='Sep / 2012', fator=1.00538995, fatorFormatado='1,00538995')
Row(periodo='Oct / 2012', fator=1.00611339, fatorFormatado='1,00611339')
Row(periodo='Nov / 2012', fator=1.00548846, fatorFormatado='1,00548846')
Row(periodo='Dec / 2012', fator=1.00550152, fatorFormatado='1,00550152')
{"totalItems":12,"registros":[{"periodo":"Jan / 2011","fator":1.00862320,"fatorFormatado":"1,00862320"},{"periodo":"Feb / 2011","fator":1.00843908,"fatorFormatado":"1,00843908"},{"periodo":"Mar / 2011","fator":1.00920458,"fatorFormatado":"1,00920458"},{"periodo":"Apr / 2011","fator":1.00840155,"fatorFormatado":"1,00840155"},{"periodo":"May / 2011","fator":1.00987985,"fatorFormatado":"1,00987985"},{"periodo":"Jun / 2011","fator":1.00956276,"fatorFormatado":"1,00956276"},{"periodo":"Jul / 2011","fator":1.00967885,"fatorFormatado":"1,00967885"},{"periodo":"Aug / 2011","fator":1.01074063,"fatorFormatado":"1,01074063"},{"periodo":"Sep / 2011","fator":1.00941761,"fatorFormatado":"1,00941761"},{"periodo":"Oct / 2011","fator":1.00881955,"fatorFormatado":"1,00881955"},{"periodo":"Nov / 2011","fator":1.00860477,"fatorFormatado":"1,00860477"},{"periodo":"Dec / 2011","fator":1.00907328,"fatorFormatado":"1,00907328"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:27"}
Row(periodo='Jan / 2011', fator=1.0086232, fatorFormatado='1,00862320')
Row(periodo='Feb / 2011', fator=1.00843908, fatorFormatado='1,00843908')
Row(periodo='Mar / 2011', fator=1.00920458, fatorFormatado='1,00920458')
Row(periodo='Apr / 2011', fator=1.00840155, fatorFormatado='1,00840155')
Row(periodo='May / 2011', fator=1.00987985, fatorFormatado='1,00987985')
Row(periodo='Jun / 2011', fator=1.00956276, fatorFormatado='1,00956276')
Row(periodo='Jul / 2011', fator=1.00967885, fatorFormatado='1,00967885')
Row(periodo='Aug / 2011', fator=1.01074063, fatorFormatado='1,01074063')
Row(periodo='Sep / 2011', fator=1.00941761, fatorFormatado='1,00941761')
Row(periodo='Oct / 2011', fator=1.00881955, fatorFormatado='1,00881955')
Row(periodo='Nov / 2011', fator=1.00860477, fatorFormatado='1,00860477')
Row(periodo='Dec / 2011', fator=1.00907328, fatorFormatado='1,00907328')
{"totalItems":12,"registros":[{"periodo":"Jan / 2010","fator":1.00660567,"fatorFormatado":"1,00660567"},{"periodo":"Feb / 2010","fator":1.00594348,"fatorFormatado":"1,00594348"},{"periodo":"Mar / 2010","fator":1.00760070,"fatorFormatado":"1,00760070"},{"periodo":"Apr / 2010","fator":1.00665913,"fatorFormatado":"1,00665913"},{"periodo":"May / 2010","fator":1.00751364,"fatorFormatado":"1,00751364"},{"periodo":"Jun / 2010","fator":1.00792576,"fatorFormatado":"1,00792576"},{"periodo":"Jul / 2010","fator":1.00861030,"fatorFormatado":"1,00861030"},{"periodo":"Aug / 2010","fator":1.00888210,"fatorFormatado":"1,00888210"},{"periodo":"Sep / 2010","fator":1.00847666,"fatorFormatado":"1,00847666"},{"periodo":"Oct / 2010","fator":1.00807138,"fatorFormatado":"1,00807138"},{"periodo":"Nov / 2010","fator":1.00807138,"fatorFormatado":"1,00807138"},{"periodo":"Dec / 2010","fator":1.00928879,"fatorFormatado":"1,00928879"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:27"}
Row(periodo='Jan / 2010', fator=1.00660567, fatorFormatado='1,00660567')
Row(periodo='Feb / 2010', fator=1.00594348, fatorFormatado='1,00594348')
Row(periodo='Mar / 2010', fator=1.0076007, fatorFormatado='1,00760070')
Row(periodo='Apr / 2010', fator=1.00665913, fatorFormatado='1,00665913')
Row(periodo='May / 2010', fator=1.00751364, fatorFormatado='1,00751364')
Row(periodo='Jun / 2010', fator=1.00792576, fatorFormatado='1,00792576')
Row(periodo='Jul / 2010', fator=1.0086103, fatorFormatado='1,00861030')
Row(periodo='Aug / 2010', fator=1.0088821, fatorFormatado='1,00888210')
Row(periodo='Sep / 2010', fator=1.00847666, fatorFormatado='1,00847666')
Row(periodo='Oct / 2010', fator=1.00807138, fatorFormatado='1,00807138')
Row(periodo='Nov / 2010', fator=1.00807138, fatorFormatado='1,00807138')
Row(periodo='Dec / 2010', fator=1.00928879, fatorFormatado='1,00928879')
{"totalItems":12,"registros":[{"periodo":"Jan / 2009","fator":1.01047807,"fatorFormatado":"1,01047807"},{"periodo":"Feb / 2009","fator":1.00855086,"fatorFormatado":"1,00855086"},{"periodo":"Mar / 2009","fator":1.00970884,"fatorFormatado":"1,00970884"},{"periodo":"Apr / 2009","fator":1.00839567,"fatorFormatado":"1,00839567"},{"periodo":"May / 2009","fator":1.00770893,"fatorFormatado":"1,00770893"},{"periodo":"Jun / 2009","fator":1.00762182,"fatorFormatado":"1,00762182"},{"periodo":"Jul / 2009","fator":1.00790143,"fatorFormatado":"1,00790143"},{"periodo":"Aug / 2009","fator":1.00693749,"fatorFormatado":"1,00693749"},{"periodo":"Sep / 2009","fator":1.00693749,"fatorFormatado":"1,00693749"},{"periodo":"Oct / 2009","fator":1.00693749,"fatorFormatado":"1,00693749"},{"periodo":"Nov / 2009","fator":1.00660604,"fatorFormatado":"1,00660604"},{"periodo":"Dec / 2009","fator":1.00726867,"fatorFormatado":"1,00726867"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:27"}
Row(periodo='Jan / 2009', fator=1.01047807, fatorFormatado='1,01047807')
Row(periodo='Feb / 2009', fator=1.00855086, fatorFormatado='1,00855086')
Row(periodo='Mar / 2009', fator=1.00970884, fatorFormatado='1,00970884')
Row(periodo='Apr / 2009', fator=1.00839567, fatorFormatado='1,00839567')
Row(periodo='May / 2009', fator=1.00770893, fatorFormatado='1,00770893')
Row(periodo='Jun / 2009', fator=1.00762182, fatorFormatado='1,00762182')
Row(periodo='Jul / 2009', fator=1.00790143, fatorFormatado='1,00790143')
Row(periodo='Aug / 2009', fator=1.00693749, fatorFormatado='1,00693749')
Row(periodo='Sep / 2009', fator=1.00693749, fatorFormatado='1,00693749')
Row(periodo='Oct / 2009', fator=1.00693749, fatorFormatado='1,00693749')
Row(periodo='Nov / 2009', fator=1.00660604, fatorFormatado='1,00660604')
Row(periodo='Dec / 2009', fator=1.00726867, fatorFormatado='1,00726867')
{"totalItems":12,"registros":[{"periodo":"Jan / 2008","fator":1.00929384,"fatorFormatado":"1,00929384"},{"periodo":"Feb / 2008","fator":1.00802232,"fatorFormatado":"1,00802232"},{"periodo":"Mar / 2008","fator":1.00844598,"fatorFormatado":"1,00844598"},{"periodo":"Apr / 2008","fator":1.00901426,"fatorFormatado":"1,00901426"},{"periodo":"May / 2008","fator":1.00876783,"fatorFormatado":"1,00876783"},{"periodo":"Jun / 2008","fator":1.00955592,"fatorFormatado":"1,00955592"},{"periodo":"Jul / 2008","fator":1.01069671,"fatorFormatado":"1,01069671"},{"periodo":"Aug / 2008","fator":1.01017657,"fatorFormatado":"1,01017657"},{"periodo":"Sep / 2008","fator":1.01103091,"fatorFormatado":"1,01103091"},{"periodo":"Oct / 2008","fator":1.01175877,"fatorFormatado":"1,01175877"},{"periodo":"Nov / 2008","fator":1.01019969,"fatorFormatado":"1,01019969"},{"periodo":"Dec / 2008","fator":1.01124093,"fatorFormatado":"1,01124093"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:27"}
Row(periodo='Jan / 2008', fator=1.00929384, fatorFormatado='1,00929384')
Row(periodo='Feb / 2008', fator=1.00802232, fatorFormatado='1,00802232')
Row(periodo='Mar / 2008', fator=1.00844598, fatorFormatado='1,00844598')
Row(periodo='Apr / 2008', fator=1.00901426, fatorFormatado='1,00901426')
Row(periodo='May / 2008', fator=1.00876783, fatorFormatado='1,00876783')
Row(periodo='Jun / 2008', fator=1.00955592, fatorFormatado='1,00955592')
Row(periodo='Jul / 2008', fator=1.01069671, fatorFormatado='1,01069671')
Row(periodo='Aug / 2008', fator=1.01017657, fatorFormatado='1,01017657')
Row(periodo='Sep / 2008', fator=1.01103091, fatorFormatado='1,01103091')
Row(periodo='Oct / 2008', fator=1.01175877, fatorFormatado='1,01175877')
Row(periodo='Nov / 2008', fator=1.01019969, fatorFormatado='1,01019969')
Row(periodo='Dec / 2008', fator=1.01124093, fatorFormatado='1,01124093')
{"totalItems":12,"registros":[{"periodo":"Jan / 2007","fator":1.01082803,"fatorFormatado":"1,01082803"},{"periodo":"Feb / 2007","fator":1.00872484,"fatorFormatado":"1,00872484"},{"periodo":"Mar / 2007","fator":1.01052223,"fatorFormatado":"1,01052223"},{"periodo":"Apr / 2007","fator":1.00944823,"fatorFormatado":"1,00944823"},{"periodo":"May / 2007","fator":1.01028077,"fatorFormatado":"1,01028077"},{"periodo":"Jun / 2007","fator":1.00905629,"fatorFormatado":"1,00905629"},{"periodo":"Jul / 2007","fator":1.00972633,"fatorFormatado":"1,00972633"},{"periodo":"Aug / 2007","fator":1.00992635,"fatorFormatado":"1,00992635"},{"periodo":"Sep / 2007","fator":1.00804961,"fatorFormatado":"1,00804961"},{"periodo":"Oct / 2007","fator":1.00929493,"fatorFormatado":"1,00929493"},{"periodo":"Nov / 2007","fator":1.00844670,"fatorFormatado":"1,00844670"},{"periodo":"Dec / 2007","fator":1.00844670,"fatorFormatado":"1,00844670"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:28"}
Row(periodo='Jan / 2007', fator=1.01082803, fatorFormatado='1,01082803')
Row(periodo='Feb / 2007', fator=1.00872484, fatorFormatado='1,00872484')
Row(periodo='Mar / 2007', fator=1.01052223, fatorFormatado='1,01052223')
Row(periodo='Apr / 2007', fator=1.00944823, fatorFormatado='1,00944823')
Row(periodo='May / 2007', fator=1.01028077, fatorFormatado='1,01028077')
Row(periodo='Jun / 2007', fator=1.00905629, fatorFormatado='1,00905629')
Row(periodo='Jul / 2007', fator=1.00972633, fatorFormatado='1,00972633')
Row(periodo='Aug / 2007', fator=1.00992635, fatorFormatado='1,00992635')
Row(periodo='Sep / 2007', fator=1.00804961, fatorFormatado='1,00804961')
Row(periodo='Oct / 2007', fator=1.00929493, fatorFormatado='1,00929493')
Row(periodo='Nov / 2007', fator=1.0084467, fatorFormatado='1,00844670')
Row(periodo='Dec / 2007', fator=1.0084467, fatorFormatado='1,00844670')
{"totalItems":12,"registros":[{"periodo":"Jan / 2006","fator":1.01429317,"fatorFormatado":"1,01429317"},{"periodo":"Feb / 2006","fator":1.01145063,"fatorFormatado":"1,01145063"},{"periodo":"Mar / 2006","fator":1.01422302,"fatorFormatado":"1,01422302"},{"periodo":"Apr / 2006","fator":1.01077878,"fatorFormatado":"1,01077878"},{"periodo":"May / 2006","fator":1.01281366,"fatorFormatado":"1,01281366"},{"periodo":"Jun / 2006","fator":1.01184394,"fatorFormatado":"1,01184394"},{"periodo":"Jul / 2006","fator":1.01169966,"fatorFormatado":"1,01169966"},{"periodo":"Aug / 2006","fator":1.01256265,"fatorFormatado":"1,01256265"},{"periodo":"Sep / 2006","fator":1.01057310,"fatorFormatado":"1,01057310"},{"periodo":"Oct / 2006","fator":1.01094244,"fatorFormatado":"1,01094244"},{"periodo":"Nov / 2006","fator":1.01020605,"fatorFormatado":"1,01020605"},{"periodo":"Dec / 2006","fator":1.00987886,"fatorFormatado":"1,00987886"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:28"}
Row(periodo='Jan / 2006', fator=1.01429317, fatorFormatado='1,01429317')
Row(periodo='Feb / 2006', fator=1.01145063, fatorFormatado='1,01145063')
Row(periodo='Mar / 2006', fator=1.01422302, fatorFormatado='1,01422302')
Row(periodo='Apr / 2006', fator=1.01077878, fatorFormatado='1,01077878')
Row(periodo='May / 2006', fator=1.01281366, fatorFormatado='1,01281366')
Row(periodo='Jun / 2006', fator=1.01184394, fatorFormatado='1,01184394')
Row(periodo='Jul / 2006', fator=1.01169966, fatorFormatado='1,01169966')
Row(periodo='Aug / 2006', fator=1.01256265, fatorFormatado='1,01256265')
Row(periodo='Sep / 2006', fator=1.0105731, fatorFormatado='1,01057310')
Row(periodo='Oct / 2006', fator=1.01094244, fatorFormatado='1,01094244')
Row(periodo='Nov / 2006', fator=1.01020605, fatorFormatado='1,01020605')
Row(periodo='Dec / 2006', fator=1.00987886, fatorFormatado='1,00987886')
{"totalItems":12,"registros":[{"periodo":"Jan / 2005","fator":1.01383882,"fatorFormatado":"1,01383882"},{"periodo":"Feb / 2005","fator":1.01218186,"fatorFormatado":"1,01218186"},{"periodo":"Mar / 2005","fator":1.01528178,"fatorFormatado":"1,01528178"},{"periodo":"Apr / 2005","fator":1.01411529,"fatorFormatado":"1,01411529"},{"periodo":"May / 2005","fator":1.01503065,"fatorFormatado":"1,01503065"},{"periodo":"Jun / 2005","fator":1.01585603,"fatorFormatado":"1,01585603"},{"periodo":"Jul / 2005","fator":1.01511345,"fatorFormatado":"1,01511345"},{"periodo":"Aug / 2005","fator":1.01658483,"fatorFormatado":"1,01658483"},{"periodo":"Sep / 2005","fator":1.01503136,"fatorFormatado":"1,01503136"},{"periodo":"Oct / 2005","fator":1.01407164,"fatorFormatado":"1,01407164"},{"periodo":"Nov / 2005","fator":1.01381041,"fatorFormatado":"1,01381041"},{"periodo":"Dec / 2005","fator":1.01473572,"fatorFormatado":"1,01473572"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:28"}
Row(periodo='Jan / 2005', fator=1.01383882, fatorFormatado='1,01383882')
Row(periodo='Feb / 2005', fator=1.01218186, fatorFormatado='1,01218186')
Row(periodo='Mar / 2005', fator=1.01528178, fatorFormatado='1,01528178')
Row(periodo='Apr / 2005', fator=1.01411529, fatorFormatado='1,01411529')
Row(periodo='May / 2005', fator=1.01503065, fatorFormatado='1,01503065')
Row(periodo='Jun / 2005', fator=1.01585603, fatorFormatado='1,01585603')
Row(periodo='Jul / 2005', fator=1.01511345, fatorFormatado='1,01511345')
Row(periodo='Aug / 2005', fator=1.01658483, fatorFormatado='1,01658483')
Row(periodo='Sep / 2005', fator=1.01503136, fatorFormatado='1,01503136')
Row(periodo='Oct / 2005', fator=1.01407164, fatorFormatado='1,01407164')
Row(periodo='Nov / 2005', fator=1.01381041, fatorFormatado='1,01381041')
Row(periodo='Dec / 2005', fator=1.01473572, fatorFormatado='1,01473572')
{"totalItems":12,"registros":[{"periodo":"Jan / 2004","fator":1.01267551,"fatorFormatado":"1,01267551"},{"periodo":"Feb / 2004","fator":1.01084394,"fatorFormatado":"1,01084394"},{"periodo":"Mar / 2004","fator":1.01379123,"fatorFormatado":"1,01379123"},{"periodo":"Apr / 2004","fator":1.01181850,"fatorFormatado":"1,01181850"},{"periodo":"May / 2004","fator":1.01227805,"fatorFormatado":"1,01227805"},{"periodo":"Jun / 2004","fator":1.01229889,"fatorFormatado":"1,01229889"},{"periodo":"Jul / 2004","fator":1.01286889,"fatorFormatado":"1,01286889"},{"periodo":"Aug / 2004","fator":1.01293586,"fatorFormatado":"1,01293586"},{"periodo":"Sep / 2004","fator":1.01251327,"fatorFormatado":"1,01251327"},{"periodo":"Oct / 2004","fator":1.01213224,"fatorFormatado":"1,01213224"},{"periodo":"Nov / 2004","fator":1.01250986,"fatorFormatado":"1,01250986"},{"periodo":"Dec / 2004","fator":1.01482823,"fatorFormatado":"1,01482823"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:29"}
Row(periodo='Jan / 2004', fator=1.01267551, fatorFormatado='1,01267551')
Row(periodo='Feb / 2004', fator=1.01084394, fatorFormatado='1,01084394')
Row(periodo='Mar / 2004', fator=1.01379123, fatorFormatado='1,01379123')
Row(periodo='Apr / 2004', fator=1.0118185, fatorFormatado='1,01181850')
Row(periodo='May / 2004', fator=1.01227805, fatorFormatado='1,01227805')
Row(periodo='Jun / 2004', fator=1.01229889, fatorFormatado='1,01229889')
Row(periodo='Jul / 2004', fator=1.01286889, fatorFormatado='1,01286889')
Row(periodo='Aug / 2004', fator=1.01293586, fatorFormatado='1,01293586')
Row(periodo='Sep / 2004', fator=1.01251327, fatorFormatado='1,01251327')
Row(periodo='Oct / 2004', fator=1.01213224, fatorFormatado='1,01213224')
Row(periodo='Nov / 2004', fator=1.01250986, fatorFormatado='1,01250986')
Row(periodo='Dec / 2004', fator=1.01482823, fatorFormatado='1,01482823')
{"totalItems":12,"registros":[{"periodo":"Jan / 2003","fator":1.01971266,"fatorFormatado":"1,01971266"},{"periodo":"Feb / 2003","fator":1.01830380,"fatorFormatado":"1,01830380"},{"periodo":"Mar / 2003","fator":1.01777019,"fatorFormatado":"1,01777019"},{"periodo":"Apr / 2003","fator":1.01871595,"fatorFormatado":"1,01871595"},{"periodo":"May / 2003","fator":1.01965352,"fatorFormatado":"1,01965352"},{"periodo":"Jun / 2003","fator":1.01856679,"fatorFormatado":"1,01856679"},{"periodo":"Jul / 2003","fator":1.02084247,"fatorFormatado":"1,02084247"},{"periodo":"Aug / 2003","fator":1.01774261,"fatorFormatado":"1,01774261"},{"periodo":"Sep / 2003","fator":1.01679509,"fatorFormatado":"1,01679509"},{"periodo":"Oct / 2003","fator":1.01642060,"fatorFormatado":"1,01642060"},{"periodo":"Nov / 2003","fator":1.01343531,"fatorFormatado":"1,01343531"},{"periodo":"Dec / 2003","fator":1.01373250,"fatorFormatado":"1,01373250"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:29"}
Row(periodo='Jan / 2003', fator=1.01971266, fatorFormatado='1,01971266')
Row(periodo='Feb / 2003', fator=1.0183038, fatorFormatado='1,01830380')
Row(periodo='Mar / 2003', fator=1.01777019, fatorFormatado='1,01777019')
Row(periodo='Apr / 2003', fator=1.01871595, fatorFormatado='1,01871595')
Row(periodo='May / 2003', fator=1.01965352, fatorFormatado='1,01965352')
Row(periodo='Jun / 2003', fator=1.01856679, fatorFormatado='1,01856679')
Row(periodo='Jul / 2003', fator=1.02084247, fatorFormatado='1,02084247')
Row(periodo='Aug / 2003', fator=1.01774261, fatorFormatado='1,01774261')
Row(periodo='Sep / 2003', fator=1.01679509, fatorFormatado='1,01679509')
Row(periodo='Oct / 2003', fator=1.0164206, fatorFormatado='1,01642060')
Row(periodo='Nov / 2003', fator=1.01343531, fatorFormatado='1,01343531')
Row(periodo='Dec / 2003', fator=1.0137325, fatorFormatado='1,01373250')
{"totalItems":12,"registros":[{"periodo":"Jan / 2002","fator":1.01533959,"fatorFormatado":"1,01533959"},{"periodo":"Feb / 2002","fator":1.01248215,"fatorFormatado":"1,01248215"},{"periodo":"Mar / 2002","fator":1.01371333,"fatorFormatado":"1,01371333"},{"periodo":"Apr / 2002","fator":1.01483567,"fatorFormatado":"1,01483567"},{"periodo":"May / 2002","fator":1.01414989,"fatorFormatado":"1,01414989"},{"periodo":"Jun / 2002","fator":1.01329033,"fatorFormatado":"1,01329033"},{"periodo":"Jul / 2002","fator":1.01535435,"fatorFormatado":"1,01535435"},{"periodo":"Aug / 2002","fator":1.01443404,"fatorFormatado":"1,01443404"},{"periodo":"Sep / 2002","fator":1.01381266,"fatorFormatado":"1,01381266"},{"periodo":"Oct / 2002","fator":1.01645925,"fatorFormatado":"1,01645925"},{"periodo":"Nov / 2002","fator":1.01540931,"fatorFormatado":"1,01540931"},{"periodo":"Dec / 2002","fator":1.01742449,"fatorFormatado":"1,01742449"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:29"}
Row(periodo='Jan / 2002', fator=1.01533959, fatorFormatado='1,01533959')
Row(periodo='Feb / 2002', fator=1.01248215, fatorFormatado='1,01248215')
Row(periodo='Mar / 2002', fator=1.01371333, fatorFormatado='1,01371333')
Row(periodo='Apr / 2002', fator=1.01483567, fatorFormatado='1,01483567')
Row(periodo='May / 2002', fator=1.01414989, fatorFormatado='1,01414989')
Row(periodo='Jun / 2002', fator=1.01329033, fatorFormatado='1,01329033')
Row(periodo='Jul / 2002', fator=1.01535435, fatorFormatado='1,01535435')
Row(periodo='Aug / 2002', fator=1.01443404, fatorFormatado='1,01443404')
Row(periodo='Sep / 2002', fator=1.01381266, fatorFormatado='1,01381266')
Row(periodo='Oct / 2002', fator=1.01645925, fatorFormatado='1,01645925')
Row(periodo='Nov / 2002', fator=1.01540931, fatorFormatado='1,01540931')
Row(periodo='Dec / 2002', fator=1.01742449, fatorFormatado='1,01742449')
{"totalItems":12,"registros":[{"periodo":"Jan / 2001","fator":1.01265069,"fatorFormatado":"1,01265069"},{"periodo":"Feb / 2001","fator":1.01015835,"fatorFormatado":"1,01015835"},{"periodo":"Mar / 2001","fator":1.01257855,"fatorFormatado":"1,01257855"},{"periodo":"Apr / 2001","fator":1.01186373,"fatorFormatado":"1,01186373"},{"periodo":"May / 2001","fator":1.01336770,"fatorFormatado":"1,01336770"},{"periodo":"Jun / 2001","fator":1.01273316,"fatorFormatado":"1,01273316"},{"periodo":"Jul / 2001","fator":1.01497982,"fatorFormatado":"1,01497982"},{"periodo":"Aug / 2001","fator":1.01600001,"fatorFormatado":"1,01600001"},{"periodo":"Sep / 2001","fator":1.01324311,"fatorFormatado":"1,01324311"},{"periodo":"Oct / 2001","fator":1.01534938,"fatorFormatado":"1,01534938"},{"periodo":"Nov / 2001","fator":1.01393438,"fatorFormatado":"1,01393438"},{"periodo":"Dec / 2001","fator":1.01393542,"fatorFormatado":"1,01393542"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:29"}
Row(periodo='Jan / 2001', fator=1.01265069, fatorFormatado='1,01265069')
Row(periodo='Feb / 2001', fator=1.01015835, fatorFormatado='1,01015835')
Row(periodo='Mar / 2001', fator=1.01257855, fatorFormatado='1,01257855')
Row(periodo='Apr / 2001', fator=1.01186373, fatorFormatado='1,01186373')
Row(periodo='May / 2001', fator=1.0133677, fatorFormatado='1,01336770')
Row(periodo='Jun / 2001', fator=1.01273316, fatorFormatado='1,01273316')
Row(periodo='Jul / 2001', fator=1.01497982, fatorFormatado='1,01497982')
Row(periodo='Aug / 2001', fator=1.01600001, fatorFormatado='1,01600001')
Row(periodo='Sep / 2001', fator=1.01324311, fatorFormatado='1,01324311')
Row(periodo='Oct / 2001', fator=1.01534938, fatorFormatado='1,01534938')
Row(periodo='Nov / 2001', fator=1.01393438, fatorFormatado='1,01393438')
Row(periodo='Dec / 2001', fator=1.01393542, fatorFormatado='1,01393542')
{"totalItems":12,"registros":[{"periodo":"Jan / 2000","fator":1.01455733,"fatorFormatado":"1,01455733"},{"periodo":"Feb / 2000","fator":1.01450895,"fatorFormatado":"1,01450895"},{"periodo":"Mar / 2000","fator":1.01449262,"fatorFormatado":"1,01449262"},{"periodo":"Apr / 2000","fator":1.01295657,"fatorFormatado":"1,01295657"},{"periodo":"May / 2000","fator":1.01493863,"fatorFormatado":"1,01493863"},{"periodo":"Jun / 2000","fator":1.01391748,"fatorFormatado":"1,01391748"},{"periodo":"Jul / 2000","fator":1.01306000,"fatorFormatado":"1,01306000"},{"periodo":"Aug / 2000","fator":1.01405437,"fatorFormatado":"1,01405437"},{"periodo":"Sep / 2000","fator":1.01223622,"fatorFormatado":"1,01223622"},{"periodo":"Oct / 2000","fator":1.01287781,"fatorFormatado":"1,01287781"},{"periodo":"Nov / 2000","fator":1.01219897,"fatorFormatado":"1,01219897"},{"periodo":"Dec / 2000","fator":1.01198167,"fatorFormatado":"1,01198167"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:30"}
Row(periodo='Jan / 2000', fator=1.01455733, fatorFormatado='1,01455733')
Row(periodo='Feb / 2000', fator=1.01450895, fatorFormatado='1,01450895')
Row(periodo='Mar / 2000', fator=1.01449262, fatorFormatado='1,01449262')
Row(periodo='Apr / 2000', fator=1.01295657, fatorFormatado='1,01295657')
Row(periodo='May / 2000', fator=1.01493863, fatorFormatado='1,01493863')
Row(periodo='Jun / 2000', fator=1.01391748, fatorFormatado='1,01391748')
Row(periodo='Jul / 2000', fator=1.01306, fatorFormatado='1,01306000')
Row(periodo='Aug / 2000', fator=1.01405437, fatorFormatado='1,01405437')
Row(periodo='Sep / 2000', fator=1.01223622, fatorFormatado='1,01223622')
Row(periodo='Oct / 2000', fator=1.01287781, fatorFormatado='1,01287781')
Row(periodo='Nov / 2000', fator=1.01219897, fatorFormatado='1,01219897')
Row(periodo='Dec / 2000', fator=1.01198167, fatorFormatado='1,01198167')
{"totalItems":12,"registros":[{"periodo":"Jan / 1999","fator":1.02177954,"fatorFormatado":"1,02177954"},{"periodo":"Feb / 1999","fator":1.02378709,"fatorFormatado":"1,02378709"},{"periodo":"Mar / 1999","fator":1.03334520,"fatorFormatado":"1,03334520"},{"periodo":"Apr / 1999","fator":1.02352438,"fatorFormatado":"1,02352438"},{"periodo":"May / 1999","fator":1.02018830,"fatorFormatado":"1,02018830"},{"periodo":"Jun / 1999","fator":1.01671869,"fatorFormatado":"1,01671869"},{"periodo":"Jul / 1999","fator":1.01658764,"fatorFormatado":"1,01658764"},{"periodo":"Aug / 1999","fator":1.01568475,"fatorFormatado":"1,01568475"},{"periodo":"Sep / 1999","fator":1.01487146,"fatorFormatado":"1,01487146"},{"periodo":"Oct / 1999","fator":1.01383896,"fatorFormatado":"1,01383896"},{"periodo":"Nov / 1999","fator":1.01386499,"fatorFormatado":"1,01386499"},{"periodo":"Dec / 1999","fator":1.01599629,"fatorFormatado":"1,01599629"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:30"}
Row(periodo='Jan / 1999', fator=1.02177954, fatorFormatado='1,02177954')
Row(periodo='Feb / 1999', fator=1.02378709, fatorFormatado='1,02378709')
Row(periodo='Mar / 1999', fator=1.0333452, fatorFormatado='1,03334520')
Row(periodo='Apr / 1999', fator=1.02352438, fatorFormatado='1,02352438')
Row(periodo='May / 1999', fator=1.0201883, fatorFormatado='1,02018830')
Row(periodo='Jun / 1999', fator=1.01671869, fatorFormatado='1,01671869')
Row(periodo='Jul / 1999', fator=1.01658764, fatorFormatado='1,01658764')
Row(periodo='Aug / 1999', fator=1.01568475, fatorFormatado='1,01568475')
Row(periodo='Sep / 1999', fator=1.01487146, fatorFormatado='1,01487146')
Row(periodo='Oct / 1999', fator=1.01383896, fatorFormatado='1,01383896')
Row(periodo='Nov / 1999', fator=1.01386499, fatorFormatado='1,01386499')
Row(periodo='Dec / 1999', fator=1.01599629, fatorFormatado='1,01599629')
{"totalItems":12,"registros":[{"periodo":"Jan / 1998","fator":1.02669973,"fatorFormatado":"1,02669973"},{"periodo":"Feb / 1998","fator":1.02129793,"fatorFormatado":"1,02129793"},{"periodo":"Mar / 1998","fator":1.02200729,"fatorFormatado":"1,02200729"},{"periodo":"Apr / 1998","fator":1.01706698,"fatorFormatado":"1,01706698"},{"periodo":"May / 1998","fator":1.01630035,"fatorFormatado":"1,01630035"},{"periodo":"Jun / 1998","fator":1.01602412,"fatorFormatado":"1,01602412"},{"periodo":"Jul / 1998","fator":1.01703732,"fatorFormatado":"1,01703732"},{"periodo":"Aug / 1998","fator":1.01476317,"fatorFormatado":"1,01476317"},{"periodo":"Sep / 1998","fator":1.02487509,"fatorFormatado":"1,02487509"},{"periodo":"Oct / 1998","fator":1.02940886,"fatorFormatado":"1,02940886"},{"periodo":"Nov / 1998","fator":1.02632152,"fatorFormatado":"1,02632152"},{"periodo":"Dec / 1998","fator":1.02401553,"fatorFormatado":"1,02401553"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:30"}
Row(periodo='Jan / 1998', fator=1.02669973, fatorFormatado='1,02669973')
Row(periodo='Feb / 1998', fator=1.02129793, fatorFormatado='1,02129793')
Row(periodo='Mar / 1998', fator=1.02200729, fatorFormatado='1,02200729')
Row(periodo='Apr / 1998', fator=1.01706698, fatorFormatado='1,01706698')
Row(periodo='May / 1998', fator=1.01630035, fatorFormatado='1,01630035')
Row(periodo='Jun / 1998', fator=1.01602412, fatorFormatado='1,01602412')
Row(periodo='Jul / 1998', fator=1.01703732, fatorFormatado='1,01703732')
Row(periodo='Aug / 1998', fator=1.01476317, fatorFormatado='1,01476317')
Row(periodo='Sep / 1998', fator=1.02487509, fatorFormatado='1,02487509')
Row(periodo='Oct / 1998', fator=1.02940886, fatorFormatado='1,02940886')
Row(periodo='Nov / 1998', fator=1.02632152, fatorFormatado='1,02632152')
Row(periodo='Dec / 1998', fator=1.02401553, fatorFormatado='1,02401553')
{"totalItems":12,"registros":[{"periodo":"Jan / 1997","fator":1.01731821,"fatorFormatado":"1,01731821"},{"periodo":"Feb / 1997","fator":1.01672399,"fatorFormatado":"1,01672399"},{"periodo":"Mar / 1997","fator":1.01641633,"fatorFormatado":"1,01641633"},{"periodo":"Apr / 1997","fator":1.01659642,"fatorFormatado":"1,01659642"},{"periodo":"May / 1997","fator":1.01584469,"fatorFormatado":"1,01584469"},{"periodo":"Jun / 1997","fator":1.01606833,"fatorFormatado":"1,01606833"},{"periodo":"Jul / 1997","fator":1.01603844,"fatorFormatado":"1,01603844"},{"periodo":"Aug / 1997","fator":1.01585855,"fatorFormatado":"1,01585855"},{"periodo":"Sep / 1997","fator":1.01590281,"fatorFormatado":"1,01590281"},{"periodo":"Oct / 1997","fator":1.01672888,"fatorFormatado":"1,01672888"},{"periodo":"Nov / 1997","fator":1.03043480,"fatorFormatado":"1,03043480"},{"periodo":"Dec / 1997","fator":1.02972367,"fatorFormatado":"1,02972367"}],"observacoes":null,"dataAtual":"01/12/2022 às 19:50:31"}
Row(periodo='Jan / 1997', fator=1.01731821, fatorFormatado='1,01731821')
Row(periodo='Feb / 1997', fator=1.01672399, fatorFormatado='1,01672399')
Row(periodo='Mar / 1997', fator=1.01641633, fatorFormatado='1,01641633')
Row(periodo='Apr / 1997', fator=1.01659642, fatorFormatado='1,01659642')
Row(periodo='May / 1997', fator=1.01584469, fatorFormatado='1,01584469')
Row(periodo='Jun / 1997', fator=1.01606833, fatorFormatado='1,01606833')
Row(periodo='Jul / 1997', fator=1.01603844, fatorFormatado='1,01603844')
Row(periodo='Aug / 1997', fator=1.01585855, fatorFormatado='1,01585855')
Row(periodo='Sep / 1997', fator=1.01590281, fatorFormatado='1,01590281')
Row(periodo='Oct / 1997', fator=1.01672888, fatorFormatado='1,01672888')
Row(periodo='Nov / 1997', fator=1.0304348, fatorFormatado='1,03043480')
Row(periodo='Dec / 1997', fator=1.02972367, fatorFormatado='1,02972367')
1997-01-01: 1.01731821000000000054797055781818926334381103515625 => 1.017318210000000000547970558
1997-02-01: 1.01672399000000002189381120842881500720977783203125 => 1.034331829570857922830107641
1997-03-01: 1.0164163299999999789946514283656142652034759521484375 => 1.051311762214596863147900603
1997-04-01: 1.01659641999999994510517353774048388004302978515625 => 1.068759773771250385107808939
1997-05-01: 1.0158446899999999946118123261840082705020904541015625 => 1.085693941071125972613544549
1997-06-01: 1.016068329999999964030621413257904350757598876953125 => 1.103139229595257339161333550
1997-07-01: 1.01603843999999998715111360070295631885528564453125 => 1.120831861940767084105921605
1997-08-01: 1.01585854999999991576942193205468356609344482421875 => 1.138606630064947741539253920
1997-09-01: 1.01590281000000004496541805565357208251953125 => 1.156713674967610944330804904
1997-10-01: 1.016728880000000057037823353311978280544281005859375 => 1.176064199230503177681631883
1997-11-01: 1.0304348000000000951104084379039704799652099609375 => 1.211857477921243807649683151
1997-12-01: 1.02972367000000009085169949685223400592803955078125 => 1.247878329682007254677117226
1998-01-01: 1.0266997300000000326036797559936530888080596923828125 => 1.281196344157367874920462929
1998-02-01: 1.0212979300000000204562411454389803111553192138671875 => 1.308483174211487431113229075
1998-03-01: 1.022007289999999901652927292161621153354644775390625 => 1.337279342886480027655603059
1998-04-01: 1.01706698000000006487653081421740353107452392578125 => 1.360102662685936811316045179
1998-05-01: 1.0163003500000000745018269299180246889591217041015625 => 1.382272812123649622748513858
1998-06-01: 1.01602411999999997505028659361414611339569091796875 => 1.404422517537856404654080262
1998-07-01: 1.0170373200000000224463292397558689117431640625 => 1.428350113384354507858351537
1998-08-01: 1.0147631699999999366212932727648876607418060302734375 => 1.449437088927766918271147777
1998-09-01: 1.0248750900000000996215021586976945400238037109375 => 1.485491966964183268257265306
1998-10-01: 1.0294088599999999811274165040231309831142425537109375 => 1.529178592251757530972714486
1998-11-01: 1.0263215199999999871494082981371320784091949462890625 => 1.569428897151283992208513682
1998-12-01: 1.0240155300000000071491967901238240301609039306640625 => 1.607119563913687578682073042
1999-01-01: 1.0217795400000000416440570916165597736835479736328125 => 1.642121888740728360776461272
1999-02-01: 1.02378708999999989970319802523590624332427978515625 => 1.681183189899173888260229533
1999-03-01: 1.0333452000000000747803596823359839618206024169921875 => 1.737242579602999947118528171
1999-04-01: 1.023524380000000011392558008083142340183258056640625 => 1.778110134197761186806161195
1999-05-01: 1.02018830000000004787352736457251012325286865234375 => 1.814007155019985934098164186
1999-06-01: 1.0167186900000000360222429662826471030712127685546875 => 1.844334978302547088079318303
1999-07-01: 1.01658764000000001459511622670106589794158935546875 => 1.874928142962037577177709696
1999-08-01: 1.0156847499999999140385398277430795133113861083984375 => 1.904335922152361234894786891
1999-09-01: 1.0148714599999999474988499059691093862056732177734375 => 1.932656177645213088925249240
1999-10-01: 1.0138389599999999557411456407862715423107147216796875 => 1.959402129181398001517213914
1999-11-01: 1.0138649900000000769750840845517814159393310546875 => 1.986569220108476943819413719
1999-12-01: 1.015996289999999913078454483184032142162322998046875 => 2.018346957458405799795395881
2000-01-01: 1.0145573299999999239418002616730518639087677001953125 => 2.047728700172623620785095360
2000-02-01: 1.0145089499999999649304527338244952261447906494140625 => 2.077439093496993136454966830
2000-03-01: 1.014492619999999956093006403534673154354095458984375 => 2.107546628852189437910111836
2000-04-01: 1.012956570000000056097633205354213714599609375 => 2.134853204277176968244032602
2000-05-01: 1.014938630000000063802190197748132050037384033203125 => 2.166744986400188268625462138
2000-06-01: 1.013917479999999926576492725871503353118896484375 => 2.196900616413513001760275365
2000-07-01: 1.0130600000000000715516534910420887172222137451171875 => 2.225592138463873638755136221
2000-08-01: 1.0140543699999999827099372851080261170864105224609375 => 2.256871433846936112026819593
2000-09-01: 1.0122362199999999088362301336019299924373626708984375 => 2.284487009223202462874616390
2000-10-01: 1.01287780999999998954308466636575758457183837890625 => 2.313906198875447087894360517
2000-11-01: 1.0121989700000000311774783767759799957275390625 => 2.342133471178342772797931665
2000-12-01: 1.01198166999999994430936567368917167186737060546875 => 2.370196141525956056613582772
2001-01-01: 1.01265069000000007548578651039861142635345458984375 => 2.400180758151597232555543584
2001-02-01: 1.0101583499999999826712837602826766669750213623046875 => 2.424562634356166468710822908
2001-03-01: 1.0125785499999999661469018974457867443561553955078125 => 2.455060116680547144366868713
2001-04-01: 1.0118637299999999612509782309643924236297607421875 => 2.484186287038613556808730359
2001-05-01: 1.0133677000000000933965793592506088316440582275390625 => 2.517394144067859863266584124
2001-06-01: 1.0127331600000000211281303563737310469150543212890625 => 2.549448526487339026950967297
2001-07-01: 1.0149798199999999770426484246854670345783233642578125 => 2.587638806513384539325081790
2001-08-01: 1.01600000999999995343614500598050653934478759765625 => 2.629041053293986636597690329
2001-09-01: 1.013243109999999891357447268092073500156402587890625 => 2.663857733157274478338952301
2001-10-01: 1.015349379999999968049451126717031002044677734375 => 2.704746297769443998959561954
2001-11-01: 1.0139343800000000239691644310369156301021575927734375 => 2.742435260486156648860292850
2001-12-01: 1.0139354199999999206482925728778354823589324951171875 => 2.780652247663840428331033124
2002-01-01: 1.015339589999999958536136546172201633453369140625 => 2.823306313075582083030470447
2002-02-01: 1.0124821500000000806807065600878559052944183349609375 => 2.858547245971338687714517408
2002-03-01: 1.0137133300000000790674903328181244432926177978515625 => 2.897747447675935051699070268
2002-04-01: 1.014835670000000078516677604056894779205322265625 => 2.940737472552997718589012741
2002-05-01: 1.014149890000000109324673758237622678279876708984375 => 2.982348584308500976972463022
2002-06-01: 1.0132903300000000168523683896637521684169769287109375 => 3.021984981168993827021386466
2002-07-01: 1.01535434999999996108499544789083302021026611328125 => 3.068385596264605849788752993
2002-08-01: 1.0144340400000000368407881978782825171947479248046875 => 3.112674796696513134250581707
2002-09-01: 1.0138126599999999211121348707820288836956024169921875 => 3.155669115353850947807249794
2002-10-01: 1.016459250000000036351366361486725509166717529296875 => 3.207609062240738933732830398
2002-11-01: 1.01540930999999989836624081362970173358917236328125 => 3.257036104639615448590422043
2002-12-01: 1.0174244900000000146889078678213991224765777587890625 => 3.313788297674547429420534629
2003-01-01: 1.0197126599999999374546177932643331587314605712890625 => 3.379111879698584366288419995
2003-02-01: 1.0183037999999999811961970408447086811065673828125 => 3.440962467722211251271936014
2003-03-01: 1.0177701900000000190260607269010506570339202880859375 => 3.502109024556503877895136929
2003-04-01: 1.0187159500000000367236907550250180065631866455078125 => 3.567654321954652305258997225
2003-05-01: 1.0196535200000000909170694285421632230281829833984375 => 3.637771287524274827794126718
2003-06-01: 1.018566789999999944171804600046016275882720947265625 => 3.705313023087767455333860172
2003-07-01: 1.0208424700000000573396619074628688395023345947265625 => 3.782540898612083768350028498
2003-08-01: 1.01774260999999999199872036115266382694244384765625 => 3.849653046585207481674025922
2003-09-01: 1.016795090000000012508962754509411752223968505859375 => 3.914308315971380282152581116
2003-10-01: 1.016420600000000007412381819449365139007568359375 => 3.978583607104619958228043586
2003-11-01: 1.0134353099999999781033466206281445920467376708984375 => 4.032037111226988642681358217
2003-12-01: 1.0137324999999999253219584716134704649448394775390625 => 4.087407060856912963112345133
2004-01-01: 1.0126755100000000009430323189008049666881561279296875 => 4.139217029930875375799962254
2004-02-01: 1.01084393999999999635974745615385472774505615234375 => 4.184102451050423977454819174
2004-03-01: 1.0137912300000000431765556641039438545703887939453125 => 4.241806370296424296780545782
2004-04-01: 1.011818499999999954042095851036719977855682373046875 => 4.291938158883772392387516078
2004-05-01: 1.01227804999999992929815562092699110507965087890625 => 4.344634790195454990561925826
2004-06-01: 1.0122988900000000622725337962037883698940277099609375 => 4.398068975570242240542214795
2004-07-01: 1.01286889000000002170054358430206775665283203125 => 4.454667241429268470649593589
2004-08-01: 1.0129358600000000212304485103231854736804962158203125 => 4.512292193210983782062914341
2004-09-01: 1.012513269999999909742882664431817829608917236328125 => 4.568755723743524581827002810
2004-10-01: 1.0121322399999999053221699796267785131931304931640625 => 4.624184964685354287939749829
2004-11-01: 1.0125098599999999837706354810507036745548248291015625 => 4.682032871207672939084692393
2004-12-01: 1.01482822999999999780129655846394598484039306640625 => 4.751459131489500680895814414
2005-01-01: 1.0138388199999999184086618697619996964931488037109375 => 4.817213719147539825030700419
2005-02-01: 1.0121818600000000998306859401054680347442626953125 => 4.875896342264274955429398810
2005-03-01: 1.015281780000000022567974156117998063564300537109375 => 4.950408717469562417196883328
2005-04-01: 1.014115289999999891534798734937794506549835205078125 => 5.020285172135172819941640439
2005-05-01: 1.015030649999999923238647170364856719970703125 => 5.095743321457725969923814853
2005-06-01: 1.0158560299999999099185288287117145955562591552734375 => 5.176541580435058857602650851
2005-07-01: 1.0151134500000000837616198623436503112316131591796875 => 5.254776982783885531489593697
2005-08-01: 1.0165848299999999948539652905310504138469696044921875 => 5.341926565731269172727543511
2005-09-01: 1.0150313600000000491263563162647187709808349609375 => 5.422222987034339805349101283
2005-10-01: 1.01407164000000005188439899939112365245819091796875 => 5.498522556907611984056424834
2005-11-01: 1.013810410000000050700919018709100782871246337890625 => 5.574459407812754716457304404
2005-12-01: 1.01473572000000000770114638726226985454559326171875 => 5.656603080797649325317426563
2006-01-01: 1.0142931699999999661798710803850553929805755615234375 => 5.737453870254013671417528405
2006-02-01: 1.0114506299999999061611788420123048126697540283203125 => 5.803151331664359849587964465
2006-03-01: 1.0142230199999999751270252090762369334697723388671875 => 5.885689669117648528674214295
2006-04-01: 1.0107787800000000988376314126071520149707794189453125 => 5.949130223209341038009743468
2006-05-01: 1.01281365999999994897962096729315817356109619140625 => 6.025360355185269339367968494
2006-06-01: 1.0118439400000001082702283383696340024471282958984375 => 6.096724361710463010674423828
2006-07-01: 1.0116996599999998895924591124639846384525299072265625 => 6.168053963856191773217546712
2006-08-01: 1.012562650000000008532197171007283031940460205078125 => 6.245541066985229813424410706
2006-09-01: 1.0105731000000000019412027540965937077999114990234375 => 6.311575797240571358888589863
2006-10-01: 1.01094243999999999772398950881324708461761474609375 => 6.380639836707328462183733994
2006-11-01: 1.0102060500000000775600028646294958889484405517578125 => 6.445760965912755786717648306
2006-12-01: 1.0098788599999999338052703024004586040973663330078125 => 6.509437736088472246673416979
2007-01-01: 1.0108280300000000995197524389368481934070587158203125 => 6.579922123177970954632196150
2007-02-01: 1.0087248399999999559639718427206389605998992919921875 => 6.637330890915158752982373431
2007-03-01: 1.0105222300000000767994379202718846499919891357421875 => 6.707170413135473473611048863
2007-04-01: 1.0094482300000000574158320887363515794277191162109375 => 6.770541301847972833246395214
2007-05-01: 1.010280770000000050146127250627614557743072509765625 => 6.840147679747772756427675435
2007-06-01: 1.0090562899999999668665395802236162126064300537109375 => 6.902094040778395486726221415
2007-07-01: 1.009726329999999894226903052185662090778350830078125 => 6.969226085110038888044769146
2007-08-01: 1.0099263499999999726952637502108700573444366455078125 => 7.038405062459970732268232221
2007-09-01: 1.008049610000000040344048102269880473613739013671875 => 7.095061478234799421232158309
2007-10-01: 1.0092949300000000345534090229193679988384246826171875 => 7.161009578020688650575113034
2007-11-01: 1.008446699999999918162529866094700992107391357421875 => 7.221496477623355415361018371
2007-12-01: 1.008446699999999918162529866094700992107391357421875 => 7.282494291920896020558945975
2008-01-01: 1.0092938399999999976586195771233178675174713134765625 => 7.350176628670922103779567965
2008-02-01: 1.0080223200000000272069655693485401570796966552734375 => 7.409142097642641615567163334
2008-03-01: 1.0084459800000000750941353544476442039012908935546875 => 7.471719563616489970182530825
2008-04-01: 1.0090142600000000516757836521719582378864288330078125 => 7.539071586410015937168112084
2008-05-01: 1.008767830000000031986928661353886127471923828125 => 7.605172884437489508354237780
2008-06-01: 1.009555919999999940017687549698166549205780029296875 => 7.677847308107342946921054015
2008-07-01: 1.010696709999999942652948448085226118564605712890625 => 7.759975014186447402992908537
2008-08-01: 1.010176570000000051408051149337552487850189208984375 => 7.838944943116567176965976527
2008-09-01: 1.0110309099999998938557155270245857536792755126953125 => 7.925415639279040316944840277
2008-10-01: 1.0117587699999999184541366048506461083889007568359375 => 8.018608778935724871567660686
2008-11-01: 1.0101996900000000945141209740540944039821624755859375 => 8.100396102712148553054700815
2008-12-01: 1.011240930000000037836116462131030857563018798828125 => 8.191452088275008931576720325
2009-01-01: 1.010478070000000005990159479551948606967926025390625 => 8.277282696657600703480510789
2009-02-01: 1.0085508599999999379548398792394436895847320556640625 => 8.348060582177141801466543871
2009-03-01: 1.0097088400000000518730303156189620494842529296875 => 8.429110566679806955913493967
2009-04-01: 1.008395670000000077237700679688714444637298583984375 => 8.499878597391164261824167156
2009-05-01: 1.0077089299999999472134959432878531515598297119140625 => 8.565403566506950481058195270
2009-06-01: 1.0076218200000000013716316971112973988056182861328125 => 8.630687530718224498122313274
2009-07-01: 1.007901429999999987074943419429473578929901123046875 => 8.698882304094067287166387200
2009-08-01: 1.0069374900000001016309170154272578656673431396484375 => 8.759230713089897722105816714
2009-09-01: 1.0069374900000001016309170154272578656673431396484375 => 8.819997788569652646862598317
2009-10-01: 1.0069374900000001016309170154272578656673431396484375 => 8.881186435027877622788144451
2009-11-01: 1.0066060400000000907283492779242806136608123779296875 => 8.939855907865129989254772724
2009-12-01: 1.0072686699999999770938075016601942479610443115234375 => 9.004836770306951818875708880
2010-01-01: 1.00660566999999989690195434377528727054595947265625 => 9.064319750415464412916029112
2010-02-01: 1.00594348000000000098452801466919481754302978515625 => 9.118193353565663726268984001
2010-03-01: 1.0076007000000000157768909048172645270824432373046875 => 9.187498005788110410409978456
2010-04-01: 1.00665913000000006860545909148640930652618408203125 => 9.248678749383394820399770445
2010-05-01: 1.00751363999999998810608303756453096866607666015625 => 9.318169991981911761055101919
2010-06-01: 1.00792576000000000391310095437802374362945556640625 => 9.392023570977562354477341892
2010-07-01: 1.00861029999999995965254129259847104549407958984375 => 9.472891711530750080673814940
2010-08-01: 1.0088820999999998928586819602060131728649139404296875 => 9.557030883001736341027264210
2010-09-01: 1.008476659999999913708279564161784946918487548828125 => 9.638042584406441014707159227
2010-10-01: 1.008071380000000072385546445730142295360565185546875 => 9.715834888561368172239425437
2010-11-01: 1.008071380000000072385546445730142295360565185546875 => 9.794255083964205331363492876
2010-12-01: 1.0092887900000000467315430796588771045207977294921875 => 9.885231862645581659904062164
2011-01-01: 1.0086231999999999420225549329188652336597442626953125 => 9.970474194043546466553259581
2011-02-01: 1.008439080000000043213503886363469064235687255859375 => 10.05461582340501590952734520
2011-03-01: 1.009204580000000017747652236721478402614593505859375 => 10.14716433912081342931368742
2011-04-01: 1.0084015500000000908897845874889753758907318115234375 => 10.23241624767415482165431879
2011-05-01: 1.00987984999999991231334206531755626201629638671875 => 10.33351098533873742292265686
2011-06-01: 1.0095627599999998924573674230487085878849029541015625 => 10.43232787084889417630810960
2011-07-01: 1.0096788500000000166068048201850615441799163818359375 => 10.53330080746166016895410212
2011-08-01: 1.01074062999999991774302543490193784236907958984375 => 10.64643509411330623357711901
2011-09-01: 1.0094176100000000761980345487245358526706695556640625 => 10.74669906771997945873294634
2011-10-01: 1.0088195499999998983042814870714209973812103271484375 => 10.84148011748268811067493116
2011-11-01: 1.0086047700000000393316668123588897287845611572265625 => 10.93476856035320004726250722
2011-12-01: 1.00907327999999996137603375245817005634307861328125 => 11.03398277723648110784320138
2012-01-01: 1.0089101599999998892798203087295405566692352294921875 => 11.13229732921890129066650575
2012-02-01: 1.0074877300000000257540477832662872970104217529296875 => 11.21565296589981382112938542
2012-03-01: 1.008211390000000040600980355520732700824737548828125 => 11.30774906650747434870857479
2012-04-01: 1.00711876000000000175305103766731917858123779296875 => 11.38824621825216511662624868
2012-05-01: 1.0074472400000000771314034864190034568309783935546875 => 11.47305722101858224916080641
2012-06-01: 1.0064150300000000992639570540632121264934539794921875 => 11.54665722728313422370769972
2012-07-01: 1.006799650000000045935166781418956816196441650390625 => 11.62517045509863051772955928
2012-08-01: 1.00691810999999997733311829506419599056243896484375 => 11.70559466307575264099420582
2012-09-01: 1.005389950000000087726448327885009348392486572265625 => 11.76868723302999882083177790
2012-10-01: 1.0061133900000001073493649528245441615581512451171875 => 11.84063380787353334868416348
2012-11-01: 1.005488460000000028315980671322904527187347412109375 => 11.90562065290269525680624060
2012-12-01: 1.0055015199999999264690586642245762050151824951171875 => 11.97111966303705161738397147
2013-01-01: 1.0060143999999999753214297015802003443241119384765625 => 12.04311876513842136520144747
2013-02-01: 1.00492749999999997356781022972427308559417724609375 => 12.10246123285364061815247698
2013-03-01: 1.0054940400000000888525164555176161229610443115234375 => 12.16895263896538890918836726
2013-04-01: 1.006136460000000010239773473585955798625946044921875 => 12.24362693007629458422136374
2013-05-01: 1.005985359999999939617509880918078124523162841796875 => 12.31690944495849529547329679
2013-06-01: 1.006052729999999950649680613423697650432586669921875 => 12.39146037226327832085965191
2013-07-01: 1.00724092000000009505811249255202710628509521484375 => 12.48118594550200811602756499
2013-08-01: 1.0071031500000000580286041440558619797229766845703125 => 12.56984168145080142924272467
2013-09-01: 1.00713029000000009460791261517442762851715087890625 => 12.65946829789363445337212316
2013-10-01: 1.0081051000000000872347527547390200197696685791015625 => 12.76207455439489325432573653
2013-11-01: 1.0071920800000000451035475634853355586528778076171875 => 12.85386041555606625381714425
2013-12-01: 1.0078974599999999117727611519512720406055450439453125 => 12.95537326403350253075340199
2014-01-01: 1.008493440000000074263653004891239106655120849609375 => 13.06540894952917620460154879
2014-02-01: 1.0079014600000000267954192167962901294231414794921875 => 13.16864475572752335930826979
2014-03-01: 1.007659569999999948919366943300701677799224853515625 => 13.26951091203915055274281601
2014-04-01: 1.00822667999999993071469361893832683563232421875 => 13.37867493206900387242992521
2014-05-01: 1.008658730000000058879550124402157962322235107421875 => 13.49451726606355850606061164
2014-06-01: 1.008244719999999983173211148823611438274383544921875 => 13.60577578245741782107730700
2014-07-01: 1.0094872699999999365871872214484028518199920654296875 => 13.73485745086505174466816670
2014-08-01: 1.0086598200000000957743395701982080936431884765625 => 13.85379884411520325251458043
2014-09-01: 1.009072919999999928819534034118987619876861572265625 => 13.97949325272395197628852790
2014-10-01: 1.0095053199999999282709950421121902763843536376953125 => 14.11237280952893300875264194
2014-11-01: 1.0084249300000001081656364476657472550868988037109375 => 14.23126856258311912879985907
2014-12-01: 1.0096129499999999534765038333716802299022674560546875 => 14.36807303571180186174068726
2015-01-01: 1.0093507500000000742801375963608734309673309326171875 => 14.50242529465048506026180108
2015-02-01: 1.008224110000000006692744136671535670757293701171875 => 14.62169483554047315801177262
2015-03-01: 1.0103996699999999719921106589026749134063720703125 => 14.77375563667079794097614198
2015-04-01: 1.009517919999999957525460558827035129070281982421875 => 14.91437106092017903460605114
2015-05-01: 1.009853220000000106892912299372255802154541015625 => 15.06132564014506055531396999
2015-06-01: 1.0106667600000001083770939658279530704021453857421875 => 15.22198118603033591374567498
2015-07-01: 1.0117819800000000807216338216676376760005950927734375 => 15.40132626392452283961789959
2015-08-01: 1.0110896499999999509356030102935619652271270751953125 => 15.57212158172725266866948225
2015-09-01: 1.0110896499999999509356030102935619652271270751953125 => 15.74481095982605353218983752
2015-10-01: 1.0110896499999999509356030102935619652271270751953125 => 15.91941540268668775423343109
2015-11-01: 1.0105588000000000903355612535960972309112548828125 => 16.08750532604057739098215627
2015-12-01: 1.0116207900000000474705075248493812978267669677734375 => 16.27445484705837723600355044
2016-01-01: 1.0105588000000000903355612535960972309112548828125 => 16.44629356089749869972507743
2016-02-01: 1.0100282199999999210859868981060571968555450439453125 => 16.61122061091076091629260890
2016-03-01: 1.0116207900000000474705075248493812978267669677734375 => 16.80425611727382736618412589
2016-04-01: 1.0105588000000000903355612535960972309112548828125 => 16.98168889676489977260009864
2016-05-01: 1.0110896499999999509356030102935619652271270751953125 => 17.17000988303890781016698774
2016-06-01: 1.0116207900000000474705075248493812978267669677734375 => 17.36953896218762833472738152
2016-07-01: 1.0110896499999999509356030102935619652271270751953125 => 17.56216106993965151506363586
2016-08-01: 1.01215220000000005740048436564393341541290283203125 => 17.77557996369377315628154410
2016-09-01: 1.0110896499999999509356030102935619652271270751953125 => 17.97270492403814893561598966
2016-10-01: 1.0104884199999999427888042191625572741031646728515625 => 18.16121020181752810943534300
2016-11-01: 1.01038285999999999376086634583771228790283203125 => 18.34977550477357113603145707
2016-12-01: 1.0112331500000000250594212047872133553028106689453125 => 18.55590128548501883647292222
2017-01-01: 1.01086119999999990426431395462714135646820068359375 => 18.75744064052692694659768217
2017-02-01: 1.008650840000000048490846893400885164737701416015625 => 18.91970825831762381686856947
2017-03-01: 1.0105205600000000121241328088217414915561676025390625 => 19.11875418423175010667641990
2017-04-01: 1.0078658099999999731011257608770392835140228271484375 => 19.26913867208162153471005194
2017-05-01: 1.0092713200000000828282509246491827070713043212890625 => 19.44778902283486691010629297
2017-06-01: 1.0080886899999998984611693231272511184215545654296875 => 19.60509615942597909502764401
2017-07-01: 1.0079792299999998927972910678363405168056488037109375 => 19.76152973085415354848264427
2017-08-01: 1.008022889999999893717586019192822277545928955078125 => 19.92007431011652392814214644
2017-09-01: 1.006384600000000073549699663999490439891815185546875 => 20.04725601655689535192924558
2017-10-01: 1.0064393000000000366611629942781291902065277099609375 => 20.17634631222431090312464398
2017-11-01: 1.00568188000000002801925802486948668956756591796875 => 20.29098589080881253608514315
2017-12-01: 1.0053840000000000554081225345726124942302703857421875 => 20.40023255884492830706485815
2018-01-01: 1.0058420500000000430418367614038288593292236328125 => 20.51941173746532919854462610
2018-02-01: 1.004656020000000093972403192310594022274017333984375 => 20.61495052890320444885806691
2018-03-01: 1.0053234499999998963204461688292212784290313720703125 => 20.72469318729629207523246730
2018-04-01: 1.0051829500000000194859239854849874973297119140625 => 20.83210823585138979608358949
2018-05-01: 1.0051829500000000194859239854849874973297119140625 => 20.94008001123239616276007847
2018-06-01: 1.0051829500000000194859239854849874973297119140625 => 21.04861139892661351848866317
2018-07-01: 1.0054304199999999358539071181439794600009918212890625 => 21.16291419923957122888555255
2018-08-01: 1.0056779600000000929327370613464154303073883056640625 => 21.28307637954628751146785629
2018-09-01: 1.004688180000000041758312363526783883571624755859375 => 21.38285527256734971439872118
2018-10-01: 1.0054304199999999358539071181439794600009918212890625 => 21.49897315749660353000816589
2018-11-01: 1.00493553000000002128899723174981772899627685546875 => 21.60508198448462319932020713
2018-12-01: 1.00493553000000002128899723174981772899627685546875 => 21.71171451477150705160967855
2019-01-01: 1.0054304199999999358539071181439794600009918212890625 => 21.82961824350681114621122489
2019-02-01: 1.00493553000000002128899723174981772899627685546875 => 21.93735897923618678255836713
2019-03-01: 1.004688180000000041758312363526783883571624755859375 => 22.04020526685546320477571030
2019-04-01: 1.0051829500000000194859239854849874973297119140625 => 22.15443854874331215726666702
2019-05-01: 1.0054304199999999358539071181439794600009918212890625 => 22.27474645492717739335105818
2019-06-01: 1.004688180000000041758312363526783883571624755859375 => 22.37917447576223881801883903
2019-07-01: 1.0056779600000000929327370613464154303073883056640625 => 22.50624253326863985929593448
2019-08-01: 1.0050171900000000047015191739774309098720550537109375 => 22.61916062824413005232512625
2019-09-01: 1.0046375999999999084622004374978132545948028564453125 => 22.72405924757367295934759740
2019-10-01: 1.0047926400000000146661705002770759165287017822265625 => 22.83296748288596478059441245
2019-11-01: 1.003803860000000103269712781184352934360504150390625 => 22.91982089457541774453871821
2019-12-01: 1.003747039999999923765017229015938937664031982421875 => 23.00570238026022587055206356
2020-01-01: 1.003766329999999928901388557278551161289215087890625 => 23.09234944730606973138160541
2020-02-01: 1.0029372899999999813047679708688519895076751708984375 => 23.16017837441414694522606427
2020-03-01: 1.0033836899999999392463223557570017874240875244140625 => 23.23854523837786694303714511
2020-04-01: 1.0028492499999999143511786314775235950946807861328125 => 23.30475766339831309007058371
2020-05-01: 1.002358099999999918594539849436841905117034912109375 => 23.35971261244437075503375787
2020-06-01: 1.00212331999999992859784470056183636188507080078125 => 23.40931275742862446841150844
2020-07-01: 1.0019434599999998969366288292803801596164703369140625 => 23.45480782040017429027819790
2020-08-01: 1.0015989000000000697099267199519090354442596435546875 => 23.49230971262421376398385810
2020-09-01: 1.001569659999999917232571533531881868839263916015625 => 23.52918465148772954296256935
2020-10-01: 1.001569659999999917232571533531881868839263916015625 => 23.56611747146778182506686846
2020-11-01: 1.0014948599999999867549149712431244552135467529296875 => 23.60134551783117984127065821
2020-12-01: 1.001644470000000008980123311630450189113616943359375 => 23.64015722249488789352722564
2021-01-01: 1.0014948599999999867549149712431244552135467529296875 => 23.67549594792050628852785124
2021-02-01: 1.0013452700000000650248921374441124498844146728515625 => 23.70734588235436684751918942
2021-03-01: 1.0020108000000000902929286894504912197589874267578125 => 23.75501661345460714898187218
2021-04-01: 1.00207785000000004771436579176224768161773681640625 => 23.80437597472487493790193625
2021-05-01: 1.002703260000000096141548056039027869701385498046875 => 23.86872539212231199191612576
2021-06-01: 1.0030777900000000801838950792443938553333282470703125 => 23.94218831644693403642909781
2021-07-01: 1.003556160000000030407818485400639474391937255859375 => 24.02733056885035069340180198
2021-08-01: 1.0042795200000000921392029340495355427265167236328125 => 24.13015601056635936006031611
2021-09-01: 1.0044199899999999292532493200269527733325958251953125 => 24.23681105883150085563805796
2021-10-01: 1.00485996000000010752728485385887324810028076171875 => 24.35460099110498220265491137
2021-11-01: 1.0058674899999999752253643237054347991943359375 => 24.49750136887428017130280044
2021-12-01: 1.007690830000000037358631743700243532657623291015625 => 24.68590748732706046666579344
2022-01-01: 1.007322700000000015307932699215598404407501220703125 => 24.86667498208451071023525748
2022-02-01: 1.007550409999999896371036811615340411663055419921875 => 25.05442857353598884383917853
2022-03-01: 1.0092705399999999382742998932371847331523895263671875 => 25.28669665580409562335339891
2022-04-01: 1.008343210000000045312162910704500973224639892578125 => 25.49766887620976805779403556
2022-05-01: 1.0103459200000000084429530033958144485950469970703125 => 25.76146571858952443661414805
2022-06-01: 1.0101531599999999944117234917939640581607818603515625 => 26.02302600186487870858080766
2022-07-01: 1.0103484199999999137986606001504696905612945556640625 => 26.29232320460309501348656286
2022-08-01: 1.0116936100000000209320205613039433956146240234375 => 26.59977537815167436171866939
2022-09-01: 1.0107198200000000465337279820232652127742767333984375 => 26.88492018224589348136162025
2022-10-01: 1.01020675999999998140310708549804985523223876953125 => 27.15932811016523307713546114
2022-11-01: 1.01020675999999998140310708549804985523223876953125 => 27.43653685394694266641872778
2022-12-01: 1.0005078800000000160963509188150055706501007080078125 => 27.45047132228432568128827372 |
Eu tenho a impressão que a nossa chamada a API do BCB está muito fixada em meses fechados e isso não permite a gente comparar corretamente o dado, já que na teoria a gente estaria pegando a taxa referente ao mês inteiro de novembro também. Só a critério de comparação, estou utilizando mais 1 site para vermos corretamente o que acontece, a referência de vários bancos e sistemas do mercado: Com Dinheiro e a taxa deles também dá um acumulado de Para esse valor bater com um código simples que fiz utilizando a API do BCB com a série 11 (dados da Selic). import pandas as pd
import requests
from datetime import datetime
from decimal import Decimal, getcontext
req = requests.get("https://api.bcb.gov.br/dados/serie/bcdata.sgs.11/dados?formato=json")
selic_json = req.json()
df_selic = pd.DataFrame(selic_json)
df_selic["data"] = pd.to_datetime(df_selic["data"])
df_selic["data"].iloc[0] # So para confirmar que convertemos o valor certo
# Utilizando Float
df_divergencia = df_selic[(df_selic["data"] >= datetime(2017, 10, 1)) & (df_selic["data"] <= datetime(2022, 11, 1))]
df_divergencia = df_divergencia.sort_values(by=['data'])
df_divergencia["valor"] = df_divergencia["valor"].apply(lambda x: 1 + (float(x.replace(",", ".")) / 100))
df_divergencia["valor"] = df_divergencia["valor"].cumprod()
df_divergencia["valor_monetario"] = df_divergencia["valor"] * 800000
print(df_divergencia["valor"].iloc[-2]) # 1.3547654246160838
print(df_divergencia["valor_monetario"].iloc[-2]) # 1083812.3396928671
# Utilizando decimal
getcontext().prec = 8
df_divergencia = df_selic[(df_selic["data"] >= datetime(2017, 10, 1)) & (df_selic["data"] <= datetime(2022, 11, 1))]
df_divergencia = df_divergencia.sort_values(by=['data'])
df_divergencia["valor"] = df_divergencia["valor"].apply(lambda x: 1 + (Decimal(x.replace(",", ".")) / 100))
df_divergencia["valor"] = df_divergencia["valor"].cumprod()
df_divergencia["valor_monetario"] = df_divergencia["valor"] * 800000
print(df_divergencia["valor"].iloc[-2]) # 1.3553309
print(df_divergencia["valor_monetario"].iloc[-1]) # 1084641.5 Então aqui temos alguns pontos:
|
Talvez a gente apenas reproduza um erro do BC ao fazer isso, dado que cientificamente o cálculo mais preciso seria usando o decimal, não? |
O cálculo do BACEN é o cálculo que os bancos usam, então não seria errado |
Mais algumas informações que podem ajudar: Simulei manualmente no site novo (vejam prints abaixo) e encontrei o seguinte:
Fiquei com dúvida se o simulador inclui a taxa do último dia escolhido (ou se termina no dia útil anterior), mas parece que inclui sim, por conta de duas outras simulações que fiz: uma de 1 dia e outra de 0 dias: Se baixarmos os dados mensais e compararmos com o valor que não inclui o dia 01/11, temos o seguinte: import datetime
import decimal
dados = [
(datetime.date(2017, 1, 1), Decimal('1.01086120')),
(datetime.date(2017, 2, 1), Decimal('1.00865084')),
(datetime.date(2017, 3, 1), Decimal('1.01052056')),
(datetime.date(2017, 4, 1), Decimal('1.00786581')),
(datetime.date(2017, 5, 1), Decimal('1.00927132')),
(datetime.date(2017, 6, 1), Decimal('1.00808869')),
(datetime.date(2017, 7, 1), Decimal('1.00797923')),
(datetime.date(2017, 8, 1), Decimal('1.00802289')),
(datetime.date(2017, 9, 1), Decimal('1.00638460')),
(datetime.date(2017, 10, 1), Decimal('1.00643930')),
(datetime.date(2017, 11, 1), Decimal('1.00568188')),
(datetime.date(2017, 12, 1), Decimal('1.00538400')),
(datetime.date(2018, 1, 1), Decimal('1.00584205')),
(datetime.date(2018, 2, 1), Decimal('1.00465602')),
(datetime.date(2018, 3, 1), Decimal('1.00532345')),
(datetime.date(2018, 4, 1), Decimal('1.00518295')),
(datetime.date(2018, 5, 1), Decimal('1.00518295')),
(datetime.date(2018, 6, 1), Decimal('1.00518295')),
(datetime.date(2018, 7, 1), Decimal('1.00543042')),
(datetime.date(2018, 8, 1), Decimal('1.00567796')),
(datetime.date(2018, 9, 1), Decimal('1.00468818')),
(datetime.date(2018, 10, 1), Decimal('1.00543042')),
(datetime.date(2018, 11, 1), Decimal('1.00493553')),
(datetime.date(2018, 12, 1), Decimal('1.00493553')),
(datetime.date(2019, 1, 1), Decimal('1.00543042')),
(datetime.date(2019, 2, 1), Decimal('1.00493553')),
(datetime.date(2019, 3, 1), Decimal('1.00468818')),
(datetime.date(2019, 4, 1), Decimal('1.00518295')),
(datetime.date(2019, 5, 1), Decimal('1.00543042')),
(datetime.date(2019, 6, 1), Decimal('1.00468818')),
(datetime.date(2019, 7, 1), Decimal('1.00567796')),
(datetime.date(2019, 8, 1), Decimal('1.00501719')),
(datetime.date(2019, 9, 1), Decimal('1.00463760')),
(datetime.date(2019, 10, 1), Decimal('1.00479264')),
(datetime.date(2019, 11, 1), Decimal('1.00380386')),
(datetime.date(2019, 12, 1), Decimal('1.00374704')),
(datetime.date(2020, 1, 1), Decimal('1.00376633')),
(datetime.date(2020, 2, 1), Decimal('1.00293729')),
(datetime.date(2020, 3, 1), Decimal('1.00338369')),
(datetime.date(2020, 4, 1), Decimal('1.00284925')),
(datetime.date(2020, 5, 1), Decimal('1.00235810')),
(datetime.date(2020, 6, 1), Decimal('1.00212332')),
(datetime.date(2020, 7, 1), Decimal('1.00194346')),
(datetime.date(2020, 8, 1), Decimal('1.00159890')),
(datetime.date(2020, 9, 1), Decimal('1.00156966')),
(datetime.date(2020, 10, 1), Decimal('1.00156966')),
(datetime.date(2020, 11, 1), Decimal('1.00149486')),
(datetime.date(2020, 12, 1), Decimal('1.00164447')),
(datetime.date(2021, 1, 1), Decimal('1.00149486')),
(datetime.date(2021, 2, 1), Decimal('1.00134527')),
(datetime.date(2021, 3, 1), Decimal('1.00201080')),
(datetime.date(2021, 4, 1), Decimal('1.00207785')),
(datetime.date(2021, 5, 1), Decimal('1.00270326')),
(datetime.date(2021, 6, 1), Decimal('1.00307779')),
(datetime.date(2021, 7, 1), Decimal('1.00355616')),
(datetime.date(2021, 8, 1), Decimal('1.00427952')),
(datetime.date(2021, 9, 1), Decimal('1.00441999')),
(datetime.date(2021, 10, 1), Decimal('1.00485996')),
(datetime.date(2021, 11, 1), Decimal('1.00586749')),
(datetime.date(2021, 12, 1), Decimal('1.00769083')),
(datetime.date(2022, 1, 1), Decimal('1.00732270')),
(datetime.date(2022, 2, 1), Decimal('1.00755041')),
(datetime.date(2022, 3, 1), Decimal('1.00927054')),
(datetime.date(2022, 4, 1), Decimal('1.00834321')),
(datetime.date(2022, 5, 1), Decimal('1.01034592')),
(datetime.date(2022, 6, 1), Decimal('1.01015316')),
(datetime.date(2022, 7, 1), Decimal('1.01034842')),
(datetime.date(2022, 8, 1), Decimal('1.01169361')),
(datetime.date(2022, 9, 1), Decimal('1.01071982')),
(datetime.date(2022, 10, 1), Decimal('1.01020676')),
(datetime.date(2022, 11, 1), Decimal('1.01020676')),]
data_inicial = datetime.date(2017, 10, 1)
data_final = datetime.date(2022, 10, 31)
fator_total = 1
for data, fator_mensal in dados:
if data_inicial <= data <= data_final:
fator_total *= fator_mensal
fator_total = fator_total.quantize(Decimal('0.0000000000000001'))
# fator_total: Decimal('1.3547653647828167')
O valor ajustado para R$ 800.000,00 por esse fator final que calculei com base no mensal (e arredondado para 16 casas decimais) é de: R$ 1.083.812,29, que é muito próximo da simulação que inclui o dia 01/11/2022 (diferença de 15 centaos). Ponto importante: o valor relatado pelo @JulioNegreiro (~ R$ 1.087.869,39) é BEM diferente dos valores que obtive acima, então mesmo que ele quisesse somente o ajuste do mês fechado (ou seja, excluindo a possibilidade de 1 dia influenciar) e se a questão das 16 casas decimais fosse resolvida, isso ainda não resolveria o problema. Será que existe diferença entre os valores que estou usando (desse simulador "novoselic" - que é diferente do que foi usado pelo @JulioNegreiro) com os que a biblioteca usa? |
Mais um detalhe interessante: a API que o @vmesel citou tem um número bem menor de casas decimais comparado àquele simulador que utilizei: a que possui taxa diária tem 6 dígitos (dividindo por 100 ficariam 8) e a mensal tem apenas 2 dígitos (dividindo por 100 ficariam 4). Pegando a mensal de 11/2022 temos |
Além da correção com relação à conta (para ficar igual a do simulador), acho que o ideal seria a biblioteca sempre pegar os valores diários e, caso o usuário passe só o mês, ela utiliza o primeiro dia do mês inicial e o último dia do mês final ( |
Li em vários manuais que usam a Selic para alguns conta (do BCB, da ANBIMA etc.) que deve-se usar o valor da taxa anual com 2 dígitos, fazendo a conta diária ( |
Não quero poluir esse Issue, com outro issue.. mas apenas gostaria de levantar um ponto de atenção. Validando os adaptadores do IPCA também é possível encontrar diferença entre o valor do banco central e o valor do adaptador. Talvez o problema esteja mais profundo no código do que apenas no tratamento da Selic. ( Por favor conferir as refêrencias utilizadas) Simulando o IPCA 2017-10 a 2022-10 - 800.000,00 no site- > R$ 1.054.615,28 simulando o IPCA 2017-10 a 2022-10 - 800.000,00 no adaptador -> R$1.050.211,318822023047375160051
A diferença é de 4404 reais. |
@JulioNegreiro não acho que você está poluindo a issue não, inclusive esse problema é correlato a correção da SELIC. Só para deixar uma projeção registrada que eu fiz usando a data de novembro ao invés de outubro de 2017. |
Encontrei uma divergência no uso da biblioteca para ajustar um valor pela selic,
utilizei o código abaixo :
v = 1087869.386433910510912246451
Simulando no site da calculadora do cidadão encontra-se :
data inicial : 01/10/2017
data final : 01/11/2022
valor: 800000
valor corrigido = R$ 1.083.812,34 (REAL)
Os valores apresentam um diferença de R$ 4057,04
The text was updated successfully, but these errors were encountered: