from pylatex.utils import italic, NoEscape, bold import os import csv import datetime import requests import json import impFunc #getting authentication code authCode = impFunc.getAuthCode('DanishYasin', 'Alpha103') #getting data for the tables #Public Debt Section dfCenCurUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-nigeria-chart.csv' ) dfCenCurNGN = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-nigeria-chart-in-nigerian-naira.csv' ) dfCenBanOmoIsUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-bank-lending-in-nigeria-chart.csv' ) dfCenBanOmoIsNGN = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-bank-lending-in-nigeria-chart-in-nigerian-naira.csv' ) dfCenBanOmoHoUSD = impFunc.get_data_TrounceFlow( authCode,
from pylatex import Document, Foot, PageStyle, Section, MultiColumn, MultiRow, Subsection, Center, Subsubsection, Tabularx, Tabular, Math, TikZ, Axis, Plot, Figure, Matrix, Alignat, Command, NewPage, NewLine, section, HugeText, LargeText, SmallText, PageStyle from pylatex.utils import italic, NoEscape, bold import os import csv import datetime import requests import json import impFunc #getting authentication code authCode = impFunc.getAuthCode('DanishYasin', 'Alpha103') #getting data for the tables dfUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-colombia-chart.csv' ) dfCOP = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-colombia-chart-in-colombian-peso.csv' ) dfResUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-colombia-chart.csv' ) dfResCOP = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-colombia-chart-in-colombian-peso.csv' ) dfExtDebtByMatUSD = impFunc.get_data_TrounceFlow( authCode,
from pylatex import Document, Foot, PageStyle, Section, MultiColumn, MultiRow, Subsection, Center, Subsubsection, Tabularx, Tabular, Math, TikZ, Axis, Plot, Figure, Matrix, Alignat, Command, NewPage, NewLine, section, HugeText, LargeText, SmallText, PageStyle from pylatex.utils import italic, NoEscape, bold import os import csv import datetime import requests import json import impFunc #getting authentication code authCode = impFunc.getAuthCode('DanishYasin', 'Alpha103') #Central Government Debt dfLegUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/debt-by-legislation-in-ecuador-chart.csv' ) #Public Debt dfGrossByIssuerUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/public-debt-stock-by-issuer-in-ecuador-chart.csv' ) dfGrossByInstrUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/public-debt-stock-in-ecuador-chart.csv' ) dfGrossByCurUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/public-debt-stock-by-currencies-in-ecuador-chart.csv' ) dfGrossByHoldResUSD = impFunc.get_data_TrounceFlow(
import pandas from pylatex import Document, Foot, PageStyle, Section, MultiColumn, MultiRow, Subsection, Center, Subsubsection, Tabularx, Tabular, Math, TikZ, Axis, Plot, Figure, Matrix, Alignat, Command, NewPage, NewLine, section,HugeText, LargeText, SmallText, PageStyle from pylatex.utils import italic, NoEscape, bold import os import csv import datetime import requests import json import impFunc #getting authentication code authCode = impFunc.getAuthCode('DanishYasin','Alpha103') #getting data for the tables dfUSD = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-argentina-chart.csv') dfARS = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-argentina-chart-in-argentine-peso.csv') dfCurUSD = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/public-debt-by-currency-in-argentina-chart.csv') dfCurARS = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/public-debt-by-currency-in-argentina-chart-in-argentine-peso.csv') dfLegUSD = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/debt-by-legislation-in-argentina-chart.csv') dfLegARS = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/debt-by-legislation-in-argentina-chart-in-argentine-peso.csv') dfResUSD = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-argentina-chart.csv') dfResARS = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-argentina-chart-in-argentine-peso.csv') dfExtCurUSD = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/external-debt-by-currency-in-argentina-chart.csv') dfExtCurARS = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/external-debt-by-currency-in-argentina-chart-in-argentine-peso.csv') dfExtSecUSD = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/external-debt-by-sector-in-argentina-chart.csv') dfExtSecARS = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/external-debt-by-sector-in-argentina-chart-in-argentine-peso.csv') dfPortUSD = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/international-portfolio-position-in-argentina-chart.csv') dfPortARS = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/international-portfolio-position-in-argentina-chart-in-argentine-peso.csv') dfIIPUSD = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/international-investment-position-in-argentina-chart.csv') dfIIPARS = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/international-investment-position-in-argentina-chart-in-argentine-peso.csv')
from pylatex import Document, Foot, PageStyle, Section, MultiColumn, MultiRow, Subsection, Center, Subsubsection, Tabularx, Tabular, Math, TikZ, Axis, Plot, Figure, Matrix, Alignat, Command, NewPage, NewLine, section, HugeText, LargeText, SmallText, PageStyle from pylatex.utils import italic, NoEscape, bold import os import csv import datetime import requests import json import impFunc #getting authentication code authCode = impFunc.getAuthCode('DanishYasin', 'Alpha103') #central government dfResUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-dominican-republic-chart.csv' ) dfResDOP = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-dominican-republic-chart-in-dominican-peso.csv' ) dfUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-dominican-republic-chart.csv' ) dfDOP = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-dominican-republic-chart-in-dominican-peso.csv' ) #Other Public Debt
from pylatex import Document, Foot, PageStyle, Section, MultiColumn, MultiRow, Subsection, Center, Subsubsection, Tabularx, Tabular, Math, TikZ, Axis, Plot, Figure, Matrix, Alignat, Command, NewPage, NewLine, section, HugeText, LargeText, SmallText, PageStyle from pylatex.utils import italic, NoEscape, bold import os import csv import datetime import requests import json import impFunc #getting authentication code authCode = impFunc.getAuthCode('DanishYasin', 'Alpha103') #central government dfResUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-chile-chart.csv' ) dfResCLP = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-chile-chart-in-chilean-peso.csv' ) dfUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-chile-chart.csv' ) dfCLP = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-chile-chart-in-chilean-peso.csv' ) #other debt dfForHolStCLP = impFunc.get_data_TrounceFlow(
from pylatex.utils import italic, NoEscape, bold import os import csv import datetime import requests import json import impFunc #getting authentication code authCode = impFunc.getAuthCode('DanishYasin', 'Alpha103') #_______________________________________________________________ #Government Debt dfResEGP = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-egypt-chart-in-egyptian-pound.csv' ) dfResUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-egypt-chart.csv' ) #dfCenbyHoldStockEGP = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/composition-of-holdings-in-egypt-chart-in-egyptian-pound.csv') #dfCenbyHoldStockUSD = impFunc.get_data_TrounceFlow(authCode,'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/composition-of-holdings-in-egypt-chart.csv') #Local Inst dfBankEGP = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/holdings-of-banks-in-egypt-chart-in-egyptian-pound.csv' ) dfBankUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/holdings-of-banks-in-egypt-chart.csv'
from pylatex import Document, Foot, PageStyle, Section, MultiColumn, MultiRow, Subsection, Center, Subsubsection, Tabularx, Tabular, Math, TikZ, Axis, Plot, Figure, Matrix, Alignat, Command, NewPage, NewLine, section, HugeText, LargeText, SmallText, PageStyle from pylatex.utils import italic, NoEscape, bold import os import csv import datetime import requests import json import impFunc #getting authentication code authCode = impFunc.getAuthCode('DanishYasin', 'Alpha103') #getting data for the tables dfUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-mexico-chart.csv' ) dfMXN = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-currency-in-mexico-chart-in-mexican-peso.csv' ) dfResUSD = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-mexico-chart.csv' ) dfResMXN = impFunc.get_data_TrounceFlow( authCode, 'https://www.trounceflow.com/api/v1/chart/granularbondholdingschart/central-government-debt-stock-by-residency-of-holders-in-mexico-chart-in-mexican-peso.csv' ) dfGovHoldPer = impFunc.get_data_TrounceFlow(