... | ... | @@ -59,6 +59,116 @@ |
|
|
* **date format**: mm-yyyy
|
|
|
* **mixed frequencies in the same dataset**: no
|
|
|
|
|
|
* **datasetCode**: dppi
|
|
|
* **datasetName**: "Domestic Producer Price Index (Producer Prices)(2003=100)"
|
|
|
* **how to get release date**: None
|
|
|
* **dataset docHref**: no
|
|
|
* **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
|
|
|
|
|
|
* **Series key**: dppiyty, dppimtm (we don't take data in the first and third columns "PPI")
|
|
|
* **Series name**: D-PPI (Year to Year % Changes), D-PPI (Month to Month % Changes)
|
|
|
* **Series docHref**: no
|
|
|
* **Series notes**: no
|
|
|
* **missing values**: none
|
|
|
* **date format**: mm-yyyy
|
|
|
* **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
|
|
|
#### Sheet 1
|
|
|
* **datasetCode**: bopmap
|
|
|
* **datasetName**: "Table 1. Balance of Payments (BPM6) - Monthly Analytic Presentation (Million US Dollars)"
|
|
|
* **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
|
|
|
|
|
|
* **Series key**: column B but
|
|
|
- BG: Balance of goods (line 11)
|
|
|
- BGS: Balance of goods and services (line 14)
|
|
|
- BGSPI: Balance of goods, services and primary income (line 17)
|
|
|
- CCFA: Current, Capital and Financial account (line 37)
|
|
|
- GB: General Balance (line 39)
|
|
|
* **Series name**: column C without indentation
|
|
|
* Series values: drop column D and last column. The last column will change every month.
|
|
|
* **Series docHref**: no
|
|
|
* **Series notes**: no
|
|
|
* **missing values**: blank
|
|
|
* **date format**: yyyy Month
|
|
|
* **mixed frequencies in the same dataset**: no
|
|
|
|
|
|
#### Sheet 2 and 6
|
|
|
* **datasetCode**: bopmdp
|
|
|
* **datasetName**: "Table 2. Balance of Payments (BPM6) - Monthly Detailed Presentation (Million US Dollars)"
|
|
|
* **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
|
|
|
|
|
|
* **Series key**: column B (drop final typographic mark - or .) For lines without code use the previous code with "a" or "b". Example I.a (line 9) I.b (line 10)
|
|
|
* **Series name**: column C without indentation but
|
|
|
- for lines without code add first the name of the previous series. Example. Goods exports (line 12) Goods imports (line 13)
|
|
|
- line 15 General merchandise exports
|
|
|
- line 16 General merchandise exports f.o.b.
|
|
|
- line 17 General merchandise exports shuttle trade
|
|
|
- line 18 General merchandise exports adjustment coverage
|
|
|
- line 19 General merchandise imports
|
|
|
- line 20 General merchandise imports c.i.f.
|
|
|
- line 21 General merchandise imports adjustment classification
|
|
|
- line 22 General merchandise imports adjustment coverage
|
|
|
- line 42 (+ 43, 44) Transport other
|
|
|
- lines 84-89 add Interest expenditure before the series name of that line
|
|
|
- for III Financial account (lines 100 to 206) add all the names of the code hierarchy. Examples:
|
|
|
- line 103: Direct investment. Net acquisition of financial assets. Equity capital. Outflow
|
|
|
- line 116: Portfolio investment. Net acquisition of financial assets. Other sectors
|
|
|
* Series values: sheet 6: column C to O (drop column P) sheet 2: drop column D and last column. The last column will change every month.
|
|
|
* **Series docHref**: no
|
|
|
* **Series notes**: no
|
|
|
* **missing values**: blank
|
|
|
* **date format**: yyyy Month
|
|
|
* **mixed frequencies in the same dataset**: no
|
|
|
|
|
|
#### Sheet 3
|
|
|
* **datasetCode**: bopadp
|
|
|
* **datasetName**: "Table 3. Balance of Payments (BPM6) - Annualized Detailed Presentation (Million US Dollars)"
|
|
|
* same as sheet 2 except columns. Frequency = M
|
|
|
|
|
|
#### Sheet 4
|
|
|
* **datasetCode**: bopyap
|
|
|
* **datasetName**: "Table 4. Balance of Payments (BPM6) - Yearly Analytic Presentation (Million US Dollars)"
|
|
|
* same as sheet 1 except columns and frequency = A
|
|
|
|
|
|
#### 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
## Updates
|
|
|
|
|
|
* **calendar of future updates**: http://www3.tcmb.gov.tr/veriyaytakvim/calendar.php (but not for inflation data that come from TURKSTAT)
|
... | ... | |