... | ... | @@ -84,7 +84,7 @@ |
|
|
* **mixed frequencies in the same dataset**: no
|
|
|
|
|
|
### Balance of payments
|
|
|
* **file URL**: http://www.tcmb.gov.tr/wps/wcm/connect/586dbab2-cfc2-421e-998e-b6efc921f433/BOPMetadata.pdf?MOD=AJPERES&CACHEID=ROOTWORKSPACE-586dbab2-cfc2-421e-998e-b6efc921f433-mcFXHOZ
|
|
|
* **file URL**: http://www.tcmb.gov.tr/wps/wcm/connect/08454646-62d8-4188-bfbe-1c8c01d83fc4/bop.zip?MOD=AJPERES&CACHEID=ROOTWORKSPACE-08454646-62d8-4188-bfbe-1c8c01d83fc4-mi88Ypv
|
|
|
|
|
|
#### Sheet 1
|
|
|
* **datasetCode**: bopmap
|
... | ... | @@ -166,8 +166,46 @@ |
|
|
#### Sheet 5
|
|
|
* **datasetCode**: bopydp
|
|
|
* **datasetName**: "Table 4. Balance of Payments (BPM6) - Yearly Detailed Presentation (Million US Dollars)"
|
|
|
* same as sheet 1 except columns frequency = A
|
|
|
* same as sheet 2 except columns frequency = A
|
|
|
|
|
|
#### Sheet 19
|
|
|
* **datasetCode**: bopmeds
|
|
|
* **datasetName**: "Table 19. Monthly External Debt Service (Million USD)"
|
|
|
* **how to get release date**: Excel file property "Modified"
|
|
|
* **dataset docHref**: http://www.tcmb.gov.tr/wps/wcm/connect/586dbab2-cfc2-421e-998e-b6efc921f433/BOPMetadata.pdf?MOD=AJPERES&CACHEID=ROOTWORKSPACE-586dbab2-cfc2-421e-998e-b6efc921f433-mcFXHOZ
|
|
|
* **dataset notes**: no
|
|
|
* **dimension_list**: freq
|
|
|
* **use of attributes**: no
|
|
|
* **attribute_list**: none
|
|
|
* **available frequencies**: M
|
|
|
* **availability of previous updates**: no
|
|
|
* **existence of real time datasets**: no
|
|
|
|
|
|
##### Series
|
|
|
|
|
|
* ** Remark **: two series on a single line
|
|
|
* **Series name**: column C by cumulating the bold, the indentation and line 7
|
|
|
- Lines 8, 27, 43 contain the same series. Only necessary to record two series: "Total. Principal" and "Total. Interest"
|
|
|
- Lines 9, 28, 44 contain the same series. Only necessary to record two series: "Long Term. Principal" and "Long Term. Interest"
|
|
|
- Lines 22, 40, 50 contain the same series. Only necessary to record two series: "Short Term. Principal" and "Short Term. Interest"
|
|
|
- Example Line 10: "By Borrower. Long term. CBRT. Principal" and "By Borrower. Long term. CBRT. Interest"
|
|
|
- Example Line 31: "By Lender. International org. IBRD. Principal" and "By Lender. International org. IBRD. Interest"
|
|
|
* **Series key**: use initials of name or acronyms. Check that this method doesn't generate the same key for two different names
|
|
|
- TP: Total. Principal
|
|
|
- TI: Total. Interest
|
|
|
- LTPL: Long Term. Principal
|
|
|
- BBLTCBRTP: By Borrower. Long term. CBRT. Principal
|
|
|
* Series values: drop column D and last column. The last column will change every month.
|
|
|
* **Series docHref**: no
|
|
|
* **Series notes**: yes, check for **, ***, **** with signification below the table
|
|
|
* **missing values**: blank
|
|
|
* **date format**: yyyy Month
|
|
|
* **mixed frequencies in the same dataset**: no
|
|
|
|
|
|
#### Sheet 20
|
|
|
* **datasetCode**: bopaeds
|
|
|
* **datasetName**: "Table 20. Annual External Debt Service (Million USD)"
|
|
|
* same as sheet 19. Frequency = A. Take all columns. Give attribute provisional for the last year (check for ***** on line 6
|
|
|
|
|
|
|
|
|
|
... | ... | @@ -178,7 +216,7 @@ |
|
|
* **summary of previous updates**: no
|
|
|
* **regular updates**: date and time
|
|
|
* **RSS flow**: http://www.tcmb.gov.tr/wps/wcm/connect/EN/TCMB+EN/Bottom+Menu/Other/RSS
|
|
|
* **best way to monitor updates**:
|
|
|
* **best way to monitor updates**:
|
|
|
|
|
|
## Special problems
|
|
|
|
... | ... | @@ -186,6 +224,8 @@ |
|
|
|
|
|
## Other remarks
|
|
|
|
|
|
I wonder whether the URLs shouldn't be parsed in the HTML pages because, given their syntax I doubt they are very stable through time
|
|
|
|
|
|
## Data samples
|
|
|
* **location**: in test_xxx file or light files in dlstats/dlstats/tests/resources
|
|
|
* **description**: a very brief description of the data samples
|
... | ... | |