Use only Table II of second sheet of Excel file (rows 1 to 59(
The file format is the same for the three frequencies: we can use a
single dataset with three frequencies
Dataset code: BPII
Dataset name: Balance of payments - Table II in million US$
Series name: column A. "Debt securities - public", "Debt
securities - private", "Direct loan", "Other loans" must be
preceeded by "Disbursement" and "Amortization" to distinguish them
Series codes: use a scheme exploiting the indentation:
S1 Current account S11 Balance on goods - Balance of Payments S111 Exports S112 Imports S12 Services S121 Travel S122 Transportation S123 Operational leasing S124 Other S13 Primary income S131 Compensation of employees S132 Interest S133 Dividends S14 Secondary income S2 Capital account S3 Financial account S31 Investments - assets S311 Direct investment assets S312 Bank assets S313 Other assets S32 Investments - liabilities S321 Direct investment liabities S322 Equity and investmets fund shares S323 Debt securities issued in Brazil S324 Long-term loans and debt securities issued abroad S3241 Disbursements S32411 Disbursements Debt securities - public S32412 Disbursements Debt securities - private S32413 Disbursements Direct loans S32414 Disbursements Other loans S3242 Amortizations S32421 Amortizations Debt securities - public S32422 Amortizations Debt securities - private S32423 Amortizations Direct loans S32424 Amortizations Other loans S325 Short-term loans and debt securities issued abroad S326 Other liabilities S33 Financial derivatives - assets and liabilities S34 Reserve assets S4 Errors and omissions
Be careful about dash that isn't an ASCII character
how to get release date: Excel file property "Modified"
Series Name: column header. Merge line when necessary. Duplicate
part of name that span several columns
Frequency: years and months in same column
Ignore summary lines after the dates
Some files like I.1 have several panels. Use "Percentage change in
12 months", "Percentage change in the year", "Percentage change in the
month" as value of "Concept" dimension
how to get release date: Excel file property "Modified"
dataset docHref: no
dataset notes: no
dimension_list: frequency + ??
use of attributes: yes
attribute_list: see on last lines
available frequencies: A M
availability of previous updates: NO
existence of real time datasets: NO
Series
Series key: see above
Series name: see above
Series docHref: no
Series notes: yes (see notes on lines 53, 54, 55
missing values: "-"
date format: AAAA; AAAA I II III IVl AAAA Jan Feb ....
mixed frequencies in the same dataset: yes
Updates
calendar of future updates: if yes, provide URL
summary of previous updates: no
regular updates: Econonimc indicators: on Wednesday
RSS flow:no
best way to monitor updates: check release date of files for pattern