YIELD_CURVE
Get yield curve data by country and date.
Syntax
=OBB.FIXEDINCOME.GOVERNMENT.YIELD_CURVE([date],[use_cache],[country])
Examples
=OBB.FIXEDINCOME.GOVERNMENT.YIELD_CURVE()
=OBB.FIXEDINCOME.GOVERNMENT.YIELD_CURVE("2023-05-01,2024-05-01")
=OBB.FIXEDINCOME.GOVERNMENT.YIELD_CURVE("2023-05-01",,"united_kingdom")
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| date | Text | A specific date to get data for. By default is the current data. Multiple comma separated items allowed. | False |
| use_cache | Boolean | If true, cache the request for four hours. | False |
| country | Text | The country to get data. New Zealand, Mexico, Singapore, and Thailand have only monthly data. The nearest date to the requested one will be used. Options: australia, canada, china, hong_kong, india, japan, mexico, new_zealand, russia, saudi_arabia, singapore, south_africa, south_korea, taiwan, thailand, united_kingdom, united_states. | False |
Data
- econdb
| Name | Description |
|---|---|
| date | The date of the data. |
| maturity | Maturity length of the security. |
| rate | The yield as a normalized percent (0.05 is 5%) |