Example #1
0
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,
Example #2
0
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(