Skip to content

Instantly share code, notes, and snippets.

@angelyordanov
Created January 11, 2020 11:14
Show Gist options
  • Save angelyordanov/67edea6cc00e92faab0fc863db95076f to your computer and use it in GitHub Desktop.
Save angelyordanov/67edea6cc00e92faab0fc863db95076f to your computer and use it in GitHub Desktop.
BNB USDBGN excels exports Q1,Q2,Q3,Q4 of a given year
year=2019
curl "https://www.bnb.bg/Statistics/StExternalSector/StExchangeRates/StERForeignCurrencies/index.htm?downloadOper=true&group1=second&periodStartDays=01&periodStartMonths=01&periodStartYear=$year&periodEndDays=31&periodEndMonths=03&periodEndYear=$year&valutes=USD&search=true&showChart=false&showChartButton=true&type=MS-Excel" \
-H 'Connection: keep-alive' \
-H 'Upgrade-Insecure-Requests: 1' \
-H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36' \
-H 'Sec-Fetch-User: ?1' \
-H 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9' \
-H 'Sec-Fetch-Site: same-origin' \
-H 'Sec-Fetch-Mode: navigate' \
-H 'Accept-Encoding: gzip, deflate, br' \
-H 'Accept-Language: en-US,en;q=0.9,bg;q=0.8' \
--compressed \
--output "$year"Q1.xls
curl "https://www.bnb.bg/Statistics/StExternalSector/StExchangeRates/StERForeignCurrencies/index.htm?downloadOper=true&group1=second&periodStartDays=01&periodStartMonths=04&periodStartYear=$year&periodEndDays=30&periodEndMonths=06&periodEndYear=$year&valutes=USD&search=true&showChart=false&showChartButton=true&type=MS-Excel" \
-H 'Connection: keep-alive' \
-H 'Upgrade-Insecure-Requests: 1' \
-H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36' \
-H 'Sec-Fetch-User: ?1' \
-H 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9' \
-H 'Sec-Fetch-Site: same-origin' \
-H 'Sec-Fetch-Mode: navigate' \
-H 'Accept-Encoding: gzip, deflate, br' \
-H 'Accept-Language: en-US,en;q=0.9,bg;q=0.8' \
--compressed \
--output "$year"Q2.xls
curl "https://www.bnb.bg/Statistics/StExternalSector/StExchangeRates/StERForeignCurrencies/index.htm?downloadOper=true&group1=second&periodStartDays=01&periodStartMonths=07&periodStartYear=$year&periodEndDays=30&periodEndMonths=09&periodEndYear=$year&valutes=USD&search=true&showChart=false&showChartButton=true&type=MS-Excel" \
-H 'Connection: keep-alive' \
-H 'Upgrade-Insecure-Requests: 1' \
-H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36' \
-H 'Sec-Fetch-User: ?1' \
-H 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9' \
-H 'Sec-Fetch-Site: same-origin' \
-H 'Sec-Fetch-Mode: navigate' \
-H 'Accept-Encoding: gzip, deflate, br' \
-H 'Accept-Language: en-US,en;q=0.9,bg;q=0.8' \
--compressed \
--output "$year"Q3.xls
curl "https://www.bnb.bg/Statistics/StExternalSector/StExchangeRates/StERForeignCurrencies/index.htm?downloadOper=true&group1=second&periodStartDays=01&periodStartMonths=10&periodStartYear=$year&periodEndDays=31&periodEndMonths=12&periodEndYear=$year&valutes=USD&search=true&showChart=false&showChartButton=true&type=MS-Excel" \
-H 'Connection: keep-alive' \
-H 'Upgrade-Insecure-Requests: 1' \
-H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36' \
-H 'Sec-Fetch-User: ?1' \
-H 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9' \
-H 'Sec-Fetch-Site: same-origin' \
-H 'Sec-Fetch-Mode: navigate' \
-H 'Accept-Encoding: gzip, deflate, br' \
-H 'Accept-Language: en-US,en;q=0.9,bg;q=0.8' \
--compressed \
--output "$year"Q4.xls
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment