macrobond 数据库

以下内容为学院购买的Macrobond 数据库，需要在图书馆电脑操作，可以在Excel插件中下载数据，我已安装
Remark: 通过Python API 下载数据，我测试的时候（2022/05）没有权限

The Macrobond API for Python； pakage：macrobond-api-constants 1.0.2
case： Visualising Macrobond data as maps using Python

离线安装 mhammond py；可以参考安装win32com

双击：

经济楼电脑数据：

One case for Analysis：

美国的数据，Gold为例，季度数据：

找数据说明书
A case for Searching(Python):

import win32com.client
c = win32com.client.Dispatch("Macrobond.Connection")
d = c.Database
query = d.CreateSearchQuery()
query.AddAttributeValueFilter("Region", [ "ar", "au", "at", "be", "br", "ca", "cn", "cl", "cz", "dk", "co", "ee", "eueu27", "eueu", "eu", "eueu28", "eu19", "eu18", "fi", "fr", "de", "gr", "hk", "hu", "id", "in", "ie", "il", "jp", "it", "lv", "lt", "lu", "my", "mx", "nl", "nz", "no", "pe", "ph", "pl", "pt", "ru", "sg", "sk", "si", "za", "kr", "es", "se", "ch", "tw", "th", "tr", "gb", "us", "world", "vn", "eg", "sa" ])
query.AddAttributeValueFilter("Source", "src_aisi")

运行官方文档的demo：FetchSeries 会报错, 因为需要Data+ and Legacy license