oxmetrics安装好后为什么无法您所调用程序没有找到包

苹果/安卓/wp
积分 57, 距离下一级还需 28 积分
道具: 涂鸦板, 彩虹炫, 雷达卡, 热点灯, 显身卡, 匿名卡, 金钱卡下一级可获得
权限: 自定义头衔
购买后可立即获得
权限: 隐身
道具: 金钱卡, 变色卡, 彩虹炫, 雷达卡, 热点灯, 涂鸦板
苦逼签到天数: 1 天连续签到: 1 天[LV.1]初来乍到
本人刚学ox,下了个msvar 解压缩后一堆文件[img]file:///C:/Users/cuijing/AppData/Roaming/Tencent/Users//QQ/WinTemp/RichOle/VDGVW~GM%25OE[DJ~[A4J8%60HA.jpg[/img] 不知道在ox软件里怎么用啊
没有人回答?
一个菜鸟的奋斗,仍相信付出才有收获
为何要学ox?
的洒脱企鹅王同他
的洒脱企鹅王同他
这个ox如何使用,有没有个教程之类的。
本帖最后由 Alicia329 于
15:32 编辑
请问楼主,你从哪里找到的msvar的包??可不可以分享一下??可以发我邮箱。。。。灰常感谢。。。
楼主能把MSVAR压缩包也发我一份吗?邮箱,万分感激
我也想要mavar的软件包,能麻烦发给我一份吗?, 谢谢!
我也在做这方面ms vecm ms var&&软件和程序包能发我么 真的感谢&&万分感谢!! &&
&nbsp&nbsp|
&nbsp&nbsp|
&nbsp&nbsp|
&nbsp&nbsp|
&nbsp&nbsp|
&nbsp&nbsp|
如有投资本站或合作意向,请联系(010-);
邮箱:service@pinggu.org
投诉或不良信息处理:(010-)
论坛法律顾问:王进律师v&b&working paper&/b&&p&&a href=&//link.zhihu.com/?target=http%3A//www.federalreserve.gov/pubs/ifdp/2013/default.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&FRB_ International Finance Discussion Papers 2013&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.imf.org/external/pubs/cat/wp1_sp.aspx%3Fs_year%3D2013%26e_year%3D2013%26brtype%3Ddefault& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&IMF Working Papers&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.bis.org/list/wpapers/index.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Working Papers - BIS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.ecb.int/pub/scientific/wps/date/html/index.en.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&ECB_ By date&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.un.org/en/development/desa/papers/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Working Papers - United Nations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.nber.org/new.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&New This Week-NBER&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//research.stlouisfed.org/wp/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Working Papers - St. Louis Fed&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//fic.wharton.upenn.edu/fic/papers.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Working Papers-沃顿商学院&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.nber.org/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&The National Bureau of Economic Research&/a&&/p&&p&&b&VOX&/b&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/macroeconomics-and-financial-cycle-hamlet-without-prince& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Macroeconomics and the financial cycle_ Hamlet without the Prince_ _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/will-dollar-lose-its-throne-economic-fundamentals-vs-network-effects& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Will the dollar lose its throne_ Economic fundamentals vs network effects _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/have-we-solved-too-big-fail& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Have we solved 'too big to fail'_ _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/world-economy-cliffs-avoided-mountains-ahead& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&The world economy_ Cliffs avoided, mountains ahead _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/appreciating-renminbi& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&The appreciating renminbi _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/excessive-risk-taking-banks-new-ereport& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Excessive risk-taking by banks_ A new eReport _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/monetary-alchemy-fiscal-science& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Monetary alchemy, fiscal science _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/multilateral-approach-capital-controls& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&The multilateral approach to capital controls _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/systemic-risks-global-banking-what-available-data-can-tell-us-and-what-more-data-are-needed& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Systemic risks in global banking_ What available data can tell us and what more data are needed_ _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/value-added-exchange-rates& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Value-added exchange rates _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/understanding-bubbly-episodes& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Understanding bubbly episodes _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/content/topics/international-finance& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&International finance _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/person/philip-lane& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Philip Lane _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/macroeconomics-debate-guided-tour& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&The macroeconomics debate_ A guided tour _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/financial-perspective-exchange-rates& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&A Financial Perspective on Exchange Rates _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/article/managing-credit-booms-and-busts& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Managing credit booms and busts _ vox&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.cf40.org.cn/index.php& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&- 金融四十人论坛——中国金融中坚智库&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//edu-worldeconomy.drcnet.com.cn/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&国研网-世经版&/a&&/p&&p&&b&学术论坛&/b&&b&&&/b&&b&网站&/b&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//reader.360duzhe.com/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&读者杂志在线阅读 - 您的网上书桌&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.wise.xmu.edu.cn/cean/class.aspx%3Fid%3D4& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中国计量经济学学术网-分类浏览&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.unirule.org.cn/Secondweb/DWForum.asp& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&天则经济研究所&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.nsd.edu.cn/cn/list.asp%3Fclassid%3D344& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&北京大学国家发展研究院 - 讨论稿&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.cfrn.com.cn/home.do& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中国金融学术研究网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//iwep.org.cn/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中国社会科学院世界经济与政治研究所&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.50forum.org.cn/Meet.asp%3FMid%3D1& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&长安讲坛——中国经济50人论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//old.ccer.edu.cn/cn/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&北京大学中国经济研究中心&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&SCI SSCI投稿模板大全 - 学术道德监督 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.cqvip.com/QK/86250X/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&经济学家茶座 - - 维普中文期刊&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.cenet.org.cn/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中国经济学教育科研网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.pinggu.org/bbs/index.php& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.jjxj.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&经济学家论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.cssn.cn/cate/71.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中国社会科学网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//epub.cnki.net/grid2008/index/ZKCALD.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数字出版物超市_检索首页&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.cenet.org.cn/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中国经济学教育科研网 - 首页&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.voxeu.org/columns/reads& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&VOX——这个网站可以看外国争论&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.chinaes.org.cn/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中国经济学堂&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/schhp%3Fhl%3Dzh-CN& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Google 学术搜索&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.ciidbnu.org/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中国收入分配研究院 China Institute for Income Distribution&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.aisixiang.com/data/more.php%3Flanmu%3D679& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&爱思想-搜索结果&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.jjxj.org/forum-173-1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&科研教学交流 - 经济学家&/a&&/p&&p&&b&计量&/b&&b&&&/b&&b&软件&/b&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//space.cenet.org.cn/user1/3178/cmd.html%3Fdo%3Dblogs%26id%3D868%26uid%3D3178& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&登高见博&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.cenet.org.cn/dispbbs.asp%3Fboardid%3D33751%26id%3D50130& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&正在学习或研究cointegration朋友请进来看看![经济学论坛-中国经济学教育科研网]&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.stathome.cn/html/Eviews/shouce/2637.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&软件家园(eviews操作手册)&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread-.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&[求助]求教STATA中面板数据单位根检验的做法 - Stata专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&面板协整_Panel cointegration的STATA实现【xtwest】(免费) - stata上传下载区 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&聂辉华公布程序或数据专栏(09年5月27日更新) - 学者数据公开 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&面板VAR - Stata专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&VAR脉冲响应 - 统计软件培训班VIP答疑区 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&[求助] 关于VAR和脉冲响应函数 - EViews专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//hi.baidu.com//blog/category/stata%2540%25BC%25C6%25C1%25BF& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&stata@计量_それぞれの翼_百度空间&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.cnfol.com/arlion/article/1333966.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Princeton stata 教程,写得相当不错-Arlion (连玉君) 的博客_arlion&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.soku.com/search_video/type_tag_q_Stata& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Stata 搜库-专找视频&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.jjxj.org/thread-.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&stata教学视频链接 - Stata - 经济学家&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.qhltw.com/html//31.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&学习一学期计量经济学,也能成为应用计量经济学家-评伍德里奇教授的《计量经济学导论:现代观点》-期货龙听网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/articlelist__0_2.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&博文_老范_计量&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/blog_6eujbr.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&stata的两章_独闲居士_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/blog_6eutff.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&graph of stata_独闲居士_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.cnfol.com/arlion& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Arlion (连玉君) 的博客_arlion&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/blog_6aa3b1010100qpbe.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&转:stata学习笔记_至臻思想_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.cppblog.com/Amigo/archive//45914.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&卡尔曼滤波 – Kalman Filtering - Amigo - C++博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&关于做状态空间模型(卡尔曼滤波)的一点启发 - EViews专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.journals.elsevier.com/journal-of-econometrics/recent-articles/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Recent Journal of Econometrics Articles&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&读Hansen门槛回归的部份心得感想 - Stata专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&请问如何用STATA作分位数回归图? - Stata专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&R作面板分位数回归 - S-Plus&R专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/forum.php%3Fmod%3Dviewthread%26tid%3Dhighlight%3DOx& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&分享关于msvar的软件包!!OX,MATLAB!! - Matlab及其他计量软件专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Oxmetrics - 第8页 - Matlab及其他计量软件专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bbs.pinggu.org/thread--1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&终于找到了!!!stata门限回归程序 - Stata专版 - 人大经济论坛&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//product.dangdang.com/main/product.aspx%3Fproduct_id%3D& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&统计模拟及其R实现 - 当当网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.r-bloggers.com/why-r-is-hard-to-learn/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Why R is Hard to Learn _ (R news & tutorials)&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.cnfol.com/arlion/article/-.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&arlion:一个极佳的统计学网站 _ 中金博客 _ 最专业的财经博客 _ 中金在线&/a&&/p&&p&&b&数据来源&/b&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//data.worldbank.org.cn/catalog& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&世界银行中文数据目录 _ 数据&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.datatang.com/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数据堂&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//unstats.un.org/unsd/databases.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&联合国数据库&/a&&/p&&p&&a href=&//link.zhihu.com/?target=https%3A//pwt.sas.upenn.edu/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Penn World Table&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//data.un.org/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&UNdata&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//rfe.org/toc.php%3Fshow%3Dcomplete& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&美国经济学会提供数据源&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//individual.utoronto.ca/swee/data.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&各类宏微观数据集合&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//individual.utoronto.ca/swee/data.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&data&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//fx.sauder.ubc.ca/data.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&两国汇率历史生成器&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//research.stlouisfed.org/fred2/categories& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&圣路易斯银行数据库&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//stats.oecd.org/Index.aspx& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&OECD数据库&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//globalization.kof.ethz.ch/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&全球化指数&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//archive.transparency.org/policy_research/surveys_indices/cpi/2001& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&政府透明指数&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.freetheworld.com/datasets_efw.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Economic Freedom of the World&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//imfstatext.imf.org/WBOS-Query/Index.aspx& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&IMF下面的一个数据库&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//edu-data.drcnet.com.cn/web/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&国研网统计数据库&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//finance.sina.com.cn/mac/%23fininfo-0-0-32-1& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&新浪财经--有点用&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.shujuhui.com/database/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数据汇-全球最大的免费财经数据库&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//211.81.31.59/portal/portal/group/usrgest/media-type/html/page/srcnavtrd.psml%3FmetainfoId%3DABC00319& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&可以用中经网了!&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//lib.jxufe.edu.cn%3A8000/irasstat/jxufe_huntstat/allEles.jsp%2330& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&很多数据库,有能用的&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.econstats.com/index_gl.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&IMF的两个数据库&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.principalglobalindicators.org/default.aspx& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Principal Global Indicators&/a&&/p&&p&&b&名人博客&/b&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/zhangwuchang& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&张五常_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/liuyejin& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&刘业进的博客 个人空间 - 博客 - 《财经网》&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/yetan& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&叶檀_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/sicmonan& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&张茉楠_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/xuxiliang& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&许锡良的博客 个人空间 - 博客 - 《财经网》&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/xiezuoshi& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&谢作诗的博客 个人空间 - 博客 - 《财经网》&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/zhangqi& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&章奇的博客 个人空间 - 博客 - 《财经网》&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/liziyang& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&李子暘的博客 个人空间 - 博客 - 《财经网》&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/weisen& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&韦森的博客 个人空间 - 博客 - 《财经网》&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/jiangxiaoyu& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&江小鱼的博客 个人空间 - 博客 - 《财经网》&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/yaoshujie& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&姚树洁的博客 个人空间 - 博客 - 《财经网》&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//xuezhaofeng.com/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&薛兆丰 新制度主义时代&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//zhouqiren.org/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&周其仁 真实世界的经济学&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/articlelist__0_1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&博文_封思贤_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/zhongdaobuffettclub& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中道巴菲特俱乐部_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/yfjj1998& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&范建军_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//lidequan12345.blog.163.com/blog/static//& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&李德全博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/expert.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&名家博客 - 博客 - 《财经网》&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/huangyouguang& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&黄有光的博客 个人空间 - 博客 - 财经网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/bashusong& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&巴曙松_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/zhanghuaqiao& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&张化桥的博客 个人空间 - 博客 - 财经网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.niehuihua.com/dispArticle.Asp%3FID%3D73& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&白鲨在线_聂辉华官方网站_niehuihua.com&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/u/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&洪平凡_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/articlelist__9_1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&评论张五常_张五常_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/blog_4dsyw.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&经济学讲义-第一讲:入门序言(作者:本博客管理员)_张五常_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/expert_article-38.shtml& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&重读哈耶克之一 - 韦森 - 名家博客 - 博客 - 财经网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.caijing.com.cn/bashusong& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&巴曙松的博客 个人空间 - 博客 - 财经网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/blog_0ifd.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&_圆石金融研究院_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/articlelist__0_1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&博文_哈克_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/articlelist__0_1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&博文_高善文围脖_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//lum.chinavalue.net/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&陆铭的网站 - 价值中国网&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//user.qzone.qq.com/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&李俊慧 [http___.qzone.qq.com]&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//prozhang.blog.sohu.com/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&张军-搜狐空间&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/u/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&李迅雷_新浪博客&/a&&/p&&p&&b&本土牛人&/b&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/top/top.person.wscworks.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Economist Rankings at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.sfruc.edu.cn/team/hb/zhangchengsi.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&张成思 — 中国人民大学财政金融学院&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//se.ruc.edu.cn/zgjs_displaynews2.asp%3Fid%3D2241& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中国人民大学经济学院--陈彦斌&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.niehuihua.com/about.asp& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&白鲨在线_聂辉华官方网站_niehuihua.com&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ccerchenbinkai.blog.sohu.com/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&十年磨一剑-我的搜狐&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//fanzhiyongblog.blog.163.com/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&范志勇 的博客 - 范志勇 - 网易博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//rudaiyang.blog.sohu.com/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&杨汝岱-我的搜狐&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.dong-zhiqiang.cn/post/paper.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&学术 - 董志强教授&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/yinjianfeng& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&殷剑峰_新浪博客&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//bus.sysu.edu.cn/Teacher/ShowTeacher.aspx%3Ftid%3D274& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&彭方平 - 中山大学管理学院&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//econpapers.repec.org/article/mespostke/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&后凯恩斯主义大本营&/a&&/p&&p&&a href=&//link.zhihu.com/?target=https%3A//mises.org/Literature/Subject/11/Money-and-Banking& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&奥地利学派大本营&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//baike.baidu.com/view/1552831.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&陈昆亭_百度百科&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//epub.cnki.net/KNS/brief/result.aspx%3Fdbprefix%3DCJFQ& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&学术期刊—中国知网___龚六堂&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.lingnan.sysu.edu.cn/lnshizi/shizi_jianli.asp%3Fname%3Dyangzh& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&师资简介-中山大学岭南(大学)学院&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//chuanglian.weebly.com/research.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&陈创练&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//blog.sina.com.cn/s/articlelist__1_1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&MATLAB学习_曹志广_新浪博客&/a&&/p&&p&&b&IDEAS&/b&&b&牛人&/b&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pei2.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Barry Eichengreen at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/psu137.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Lawrence H. Summers at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pke4.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Patrick Kehoe at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pca44.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Ricardo J. Caballero at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pbl2.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Olivier Blanchard at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/f/pbo243.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Michael David Bordo at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pro164.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Kenneth S Rogoff at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pra149.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Rajan at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pwr2.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Randall Wright at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pke16.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Timothy J. Kehoe at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pwo3.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Michael Woodford at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pge11.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Mark L. Gertler at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pbe55.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Ben S. Bernanke at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pta174.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&John B. Taylor at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/f/pca694.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Guillermo A. Calvo at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pen14.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Charles Engel at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/puh1.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Harald Uhlig at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pal67.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Franklin Allen at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pre33.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Carmen M. Reinhart at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pur9.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Martín Uribe at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/f/pba242.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&David Backus at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pme30.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Mendoza at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/plu15.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Robert E. Lucas at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pme99.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Andrew Metrick at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pdo13.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Michael Dooley at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pve34.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Carlos A. Vegh at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pre8.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Helene Rey at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pgo28.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Pierre-Olivier Gourinchas at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/f/pgo458.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Gary Gorton at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/f/pfa207.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Emmanuel Farhi at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/e/pmi103.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Jianjun Miao at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ideas.repec.org/f/pmo265.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&John Moore at IDEAS&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.columbia.edu/%7Emu2166/research.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Martin Uribe Research&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//people.ischool.berkeley.edu/%7Ehal/pages/interesting.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Other interesting servers-无所不包&/a&&/p&&p&&b&经济学牛人主页&/b&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.columbia.edu/%7Emu2166/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Martin Uribe--matlab&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.homepages.ed.ac.uk/jhmoore/papers.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&John Moore&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//econ.sciences-po.fr/nicolas-coeurdacier/master-epp& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&International Macroeconomics _Coeurdacier&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//faculty.chicagobooth.edu/zhiguo.he/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Zhiguo He - Assistant Professor of Finance&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//ihome.ust.hk/%7Epfwang/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Pengfei Wang(课件很好)&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.princeton.edu/%7Ekiyotaki/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Nobuhiro Kiyotaki&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.ssc.wisc.edu/%7Ebhansen/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Bruce E. Hansen&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.princeton.edu/%7Ehsshin/biographical.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Hyun song Shin&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.newyorkfed.org/research/economists/adrian/index.html& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Economists - Tobias Adrian&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.princeton.edu/%7Ewxiong/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Wei Xiong Research Page&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.princeton.edu/%7Esmorris/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Stephen Morris Home Page&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.kellogg.northwestern.edu/Faculty/Directory/Krishnamurthy_Arvind.aspx%23vita& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Arvind Krishnamurthy&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//pages.stern.nyu.edu/%7Esternfin/vacharya/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Acharya,Viral V.&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.princeton.edu/%7Emarkus/teaching/teaching.htm& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Markus Brunnermeier&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.philiplane.org/& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Philip R. Lane's Webpage&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fsortby%3Dpubdate%26hl%3Den%26user%3DWozc0GgAAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Hyun Song Shin - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fhl%3Den%26user%3DY0LsOJsAAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Stephen Morris - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fsortby%3Dpubdate%26hl%3Den%26user%3DKAit8lUAAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Tobias Adrian - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fsortby%3Dpubdate%26hl%3Den%26user%3Ds5B27PkAAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Martin Eichenbaum - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fsortby%3Dpubdate%26hl%3Den%26user%3DItLhJVAAAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Wei Xiong - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DHmw2siAAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Arvind Krishnamurthy - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fhl%3Den%26user%3DiZAsYLgAAAAJ%26sortby%3Dpubdate%26view_op%3Dlist_works%26citft%3D1%26email_for_op%3Dlianyonghui123%2540gmail.com%26gmla%3DAJsN-F7kd9EOg2FeQh0LN3UVMjLNTlnGMV8k5YOkl8WbxSRCh63x2-mr7-eAyNI8tS2_orFOAF5nlnCCLFvGChCuWXqotNG1sNP5Nw2kKos0XzQrNyv5ZIbsrjXKcTm0C8rlFZjAhAfSa13ND8QZ0y2DExHOd4AaPRa6R998S05TwYeEiMpdCZchO4HY9ObPcTkiuOBEadcb-zsh-OPtvrmTdDmqEWhRONGskFfRQnyYdb6XOQhR9jePYoaT07fxRyv2kChdjXFq& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Viral Acharya - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3D34PkXd0AAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Markus Brunnermeier - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3D8iXVkrEAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Philip Lane - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DPQLS-sIAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Graciela Laura Kaminsky - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3D30LFrlkAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Guillermo Calvo - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3D-ojbSSQAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Carlos Vegh - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DagPERYMAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Alan M. Taylor - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DV2eY1aoAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Martin Uribe - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fsortby%3Dpubdate%26hl%3Den%26user%3DCQZ4f7QAAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Ramkishen Rajan - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DgUmhh8EAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Gary Gorton - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DGhxQGgoAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Harald Uhlig - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3Dmb6omkkAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Enrique G. Mendoza - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DI-tdv7kAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Robert J. Barro - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fsortby%3Dpubdate%26hl%3Den%26user%3DyX255OoAAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&lawrence summers - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DmcZMzRsAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Kenneth Rogoff - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DVDJQu5MAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Mark Gertler - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DrvtSK2oAAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Carmen M Reinhart - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DW_A6SK8AAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Sergio Rebelo - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fsortby%3Dpubdate%26hl%3Den%26user%3Di4JLlG4AAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Lucio Sarno - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fuser%3DhKHo_d8AAAAJ%26hl%3Den& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Philippe Bacchetta - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fsortby%3Dpubdate%26hl%3Den%26user%3DlnCpAycAAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Robert C. Feenstra - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//scholar.google.com/citations%3Fsortby%3Dpubdate%26hl%3Den%26user%3DrlpAtE0AAAAJ%26view_op%3Dlist_works& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Lawrence Christiano - Google Scholar Citations&/a&&/p&&p&&a href=&//link.zhihu.com/?target=http%3A//www.nber.org/authors/nobuhiro_kiyotaki& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Nobuhiro Kiyotaki&/a&&/p&
vworking paper
&p&&b&内容提要&/b&&/p&&blockquote&1) 获取需要下载数据的股票代码列表&br&2) 寻找可以下载数据的数据接口&br&3) 下载并保存数据&/blockquote&&p&&b&写在之前&/b& &/p&&p&之前我在《&a href=&https://zhuanlan.zhihu.com/p/& class=&internal&&全A股市场财务指标数据汇总 - 知乎专栏&/a&》和《如何通过财务报表分析行业特征》两篇文章中提到并使用了Python,从反应来看,大家对于如何使用Python进行财务报表分析有比较浓厚的兴趣,这就是这篇文章存在的原因。&/p&&p&关于使用Python分析财务报表的场景,我认为主要有:1)同业分析:批量计算、比较,也就是将同业财务指标显示或者导出;2)选股:比如筛选近三年roe大于15%的公司、最近一期所有roe大于15%的公司等。如果是针对单个公司进行分析,给大家安利一下我之前提供的《&a href=&https://zhuanlan.zhihu.com/p/& class=&internal&&一个财务分析小工具(Excel版) - 知乎专栏&/a&》,这个工具已经将主要科目及变动,增长分析等已经涵盖了,我自己现在也在用这个工具。一般来说选对工具也可以达到事半功倍的效果。。&/p&&p&本文分文上下两篇,上篇主要说数据采集,下篇主要讲通过财务指标进行比较和分析&/p&&p&有知友问为什么不直接分享代码,其实完成财务分析所需代码简单到爆,任何一个程序员写的都比我漂亮百倍(我只是网工狗里面代码写的较好的,也可能是网工狗里面财务分析较好的),但是一方面当心别有用心的人滥用接口导致接口失效,另一方面爬取别人网站的数据终归是不太好的,所以里面涉及的财务接口并不适合公开出来。基于这些考虑,我之前分享的EXCEL工具也对代码部分加了密。同样,这一篇我也不打算公开分享代码而只分享思路,如果你有心,在主要财经网站都能找的到下载接口。接口都找到了,按照本文思路,很容易获得全市场上市公司财务数据。实在找不到的,可以私信我电子邮件地址,我可以把我的&b&示例代码&/b&提供给大家参考。&/p&&p&对于大家提供的电子邮件地址,我个人承诺不会用于除了发送所须资料以外的其他用途。不过也建议大家保护好自己的隐私,尽量不要将联系方式留在评论区而通过私信,这样也方便我回复(放在评论区我经常会找不到,就没法回给你了)&/p&&p&本文虽然简单,但还是需要一定Python基础的,如果大家对Python一无所知但又比较感兴趣的话,建议搜一下&&&b&廖雪峰 Python3&/b&&&的教程(Pyhon2已经过期不用了),写的简单并且免费,本文示例代码基于Python3.5,演示平台为JupyterNotebook。关于环境的搭建,Windows系统可直接安装Anconda,啥都给你安装好。至于Linux等其他系统,我就默认你为IT人士了,想来部署个开发环境应该是小菜一碟。我不准备进行详细介绍。&/p&&p&&b&财务数据的采集&/b& &/p&&p&啰嗦完了,言归正传,网络爬虫要解决问题主要有三个: &/p&&p&&b&1) 爬什么? &/b&&/p&&p&&b&2) 到哪里去爬? &/b&&/p&&p&&b&3) 数据清洗、储存?&/b&&/p&&p&&b&一、获取所有股票代码&/b& &/p&&p&为了爬取所有上市公司财务数据,我们首先需要取得所有上市公司的公司代码。这个在Python里面已经有了不错的解决方法。那就是使用Tushare财经库,可以获得所有股票代码、沪深300成份股等。如果没有安装,请使用 &b&pip install tushare&/b&安装tushare财经库。官网:&a href=&https://link.zhihu.com/?target=http%3A//tushare.org& class=& external& target=&_blank& rel=&nofollow noreferrer&&&span class=&invisible&&http://&/span&&span class=&visible&&tushare.org&/span&&span class=&invisible&&&/span&&/a& &/p&&p&1)看看是tushare是否装好: &/p&&p&新建一个Notebook,在一个cell中键入Python代码 &/p&&div class=&highlight&&&pre&&code class=&language-python3&&&span&&/span&&span class=&kn&&import&/span& &span class=&nn&&tushare&/span& &span class=&k&&as&/span& &span class=&nn&&t&/span&
&span class=&n&&t&/span&&span class=&o&&.&/span&&span class=&n&&__version__&/span&
&/code&&/pre&&/div&&p&输入后按SHIFT+ENTER运行,显示 &/p&&figure&&img src=&https://pic4.zhimg.com/v2-c48f9fe211bed_b.jpg& data-rawwidth=&638& data-rawheight=&200& class=&origin_image zh-lightbox-thumb& width=&638& data-original=&https://pic4.zhimg.com/v2-c48f9fe211bed_r.jpg&&&/figure&&p&这里是最新的0.8.2版。&/p&&p&2) 获取股票列表(在另一个cell中输入代码):&/p&&div class=&highlight&&&pre&&code class=&language-python3&&&span&&/span&&span class=&n&&stocks_df&/span&&span class=&o&&=&/span&&span class=&n&&t&/span&&span class=&o&&.&/span&&span class=&n&&get_stock_basics&/span&&span class=&p&&()&/span&
&span class=&n&&stocks_df&/span&
&/code&&/pre&&/div&&p&这两句代码的作用,一是通过tushare财经库获取所有股票列表以及基本信息,并返回一些股票基本信息,如区域、行业、总资产这些数据,返回结果是一个&b&pandas.DataFrame&/b&表格。取决于网络环境,该代码大概耗时5-6秒时间。返回结果: &/p&&figure&&img src=&https://pic4.zhimg.com/v2-dfe5cdd949dd043bb30d30b4e7f87429_b.jpg& data-rawwidth=&1661& data-rawheight=&727& class=&origin_image zh-lightbox-thumb& width=&1661& data-original=&https://pic4.zhimg.com/v2-dfe5cdd949dd043bb30d30b4e7f87429_r.jpg&&&/figure&&p&返回值有20多个字段,我们只需要其中的一部分数据,可以使用ix切片,把股票代码,名称,区域,行业切出来。(比如我们只截取 name,area,industry字段)&/p&&div class=&highlight&&&pre&&code class=&language-python3&&&span&&/span&&span class=&n&&stock_df&/span&&span class=&o&&=&/span&&span class=&n&&stock_df&/span&&span class=&o&&.&/span&&span class=&n&&ix&/span&&span class=&p&&[:,[&/span&&span class=&s1&&'name'&/span&&span class=&p&&,&/span&&span class=&s1&&'industry'&/span&&span class=&p&&,&/span&&span class=&s1&&'area'&/span&&span class=&p&&]]&/span&
&span class=&c1&&# ix[行条件,列条件],这里表示截取所有行,name,industry,area字段,返回一个DATAFRAME&/span&
&span class=&n&&stock_df&/span&
&/code&&/pre&&/div&&figure&&img src=&https://pic2.zhimg.com/v2-da071b38a3f0380dd3ab_b.jpg& data-rawwidth=&1292& data-rawheight=&672& class=&origin_image zh-lightbox-thumb& width=&1292& data-original=&https://pic2.zhimg.com/v2-da071b38a3f0380dd3ab_r.jpg&&&/figure&&p&如果你对一些新股不敏感,可以把数据保存为csv/xls文件方便多次使用 &/p&&figure&&img src=&https://pic1.zhimg.com/v2-769c1fdc153d0ff6c6a726c178d31aea_b.jpg& data-rawwidth=&1352& data-rawheight=&774& class=&origin_image zh-lightbox-thumb& width=&1352& data-original=&https://pic1.zhimg.com/v2-769c1fdc153d0ff6c6a726c178d31aea_r.jpg&&&/figure&&p&注意:将股票列表从文件中读出来后,股票代码前的‘0’会被自动处理掉,在做循环下载数据时要将‘0’加上去。&/p&&figure&&img src=&https://pic3.zhimg.com/v2-56acba8beefd546b64d295_b.jpg& data-rawwidth=&1715& data-rawheight=&273& class=&origin_image zh-lightbox-thumb& width=&1715& data-original=&https://pic3.zhimg.com/v2-56acba8beefd546b64d295_r.jpg&&&/figure&&p&自此股票列表就拿到了。&/p&&p&&b&二、寻找合适财务数据接口&/b& &/p&&p&由于Python能够直接处理的文件格式为xml/csv/json/xls文件,因此我们尽量查找能够提供此类格式的文本的数据接口。&/p&&blockquote&另,我比较喜欢csv格式的文本,这种文本内容紧凑,可以说一个无用字节都没有。但是取得的数据可能并非自己所需的格式,所以需要将数据转换为自己需要的内容(为了说明数据清洗及转换过程,我这里专门选择了一个xls格式的财务接口)&/blockquote&&p&2.1. 查找数据接口 &/p&&p&很多财经网站都有提供下载财务报表的接口,由于我们已经拿到了所有股票列表,将股票代码依次传入下载接口,就可以获得所有股票财务数据了,我们先来查找可用的财务数据接口。 &/p&&p&1) 打开任意财经网站&b&股票&/b&专栏
&/p&&p&2) 输入任意股票代码,比如600660,进入股票详情页 &/p&&p&3) 查找诸如&b&财务报表&/b&,&b&财务数据&/b&,&b&财务分析&/b&之类的字样,进入细分栏目。
&/p&&p&4) 在这个栏目应该能够找到,下载或者导出之类的功能。现在重点来了,右键点击连接,选择&b&复制链接地址&/b&&/p&&blockquote&如果,&b&下载数据 &/b&处是一个按钮而不是链接,可以使用Chrome先把数据下载下来,然后按&b&Ctrl+J&/b&查看下载历史,就能看到下载地址了,如果还是不行,可能就要使用抓包工具之类的方式了。&/blockquote&&p&5) 分析链接地址,查看传入股票代码的位置,比如,链接地址是: &a href=&https://link.zhihu.com/?target=http%3A//www.stock.com/report.jsp%3Fid%3D600660& class=& external& target=&_blank& rel=&nofollow noreferrer&&&span class=&invisible&&http://www.&/span&&span class=&visible&&stock.com/report.jsp?&/span&&span class=&invisible&&id=600660&/span&&span class=&ellipsis&&&/span&&/a& 那么这个600660就是传入的股票代码了。&/p&&p&2.2. 通过程序下载数据 &/p&&p&拿到接口地址后,我们可以通过程序下载数据了。 &/p&&div class=&highlight&&&pre&&code class=&language-python3&&&span&&/span&&span class=&kn&&import&/span& &span class=&nn&&requests&/span& &span class=&k&&as&/span& &span class=&nn&&ro&/span&
&span class=&n&&stock_code&/span& &span class=&o&&=&/span& &span class=&s1&&'600660'&/span&
&span class=&n&&bs_url&/span&&span class=&o&&=&/span&&span class=&s1&&'http://soft-f9.eastmoney.com/soft/gp15.php?code=&/span&&span class=&si&&{co}&/span&&span class=&s1&&01&exp=1'&/span&&span class=&o&&.&/span&&span class=&n&&format&/span&&span class=&p&&(&/span&&span class=&n&&co&/span&&span class=&o&&=&/span&&span class=&n&&stock_code&/span&&span class=&p&&)&/span&
&span class=&n&&ct&/span& &span class=&o&&=&/span& &span class=&n&&ro&/span&&span class=&o&&.&/span&&span class=&n&&get&/span&&span class=&p&&(&/span&&span class=&n&&bs_url&/span&&span class=&p&&)&/span&&span class=&o&&.&/span&&span class=&n&&text&/span&
&span class=&n&&ct&/span&
&/code&&/pre&&/div&&figure&&img src=&https://pic3.zhimg.com/v2-f2c2ae8aa626be9bdf427dc0248964df_b.jpg& data-rawwidth=&1634& data-rawheight=&705& class=&origin_image zh-lightbox-thumb& width=&1634& data-original=&https://pic3.zhimg.com/v2-f2c2ae8aa626be9bdf427dc0248964df_r.jpg&&&/figure&&p&看到一堆乱码(其实不是乱码,是xml,稍后就说说转化为csv文本)&/p&&p&&b&三、数据的清洗及保存&/b& &/p&&p&1) 数据清洗&/p&&p&获取的数据结构太过复杂,我们还需要将其进行清洗及转换,之前我在《几行代码获取EXCELL有效数据》这篇文章演示了数据的清洗,请参考原文,这里不再重复说明。 &/p&&figure&&img src=&https://pic3.zhimg.com/v2-e4a1eaedf_b.jpg& data-rawwidth=&1690& data-rawheight=&749& class=&origin_image zh-lightbox-thumb& width=&1690& data-original=&https://pic3.zhimg.com/v2-e4a1eaedf_r.jpg&&&/figure&&p&2) 数据保存 &/p&&p&财务报表是有效期比较长的数据,为了避免每次使用时反复下载,可以将数据存储到本地。存储方式一般有文件方式或数据库方式。由于数据量不大,直接存为文件csv就可以了。不过为了方便取用,文件命名方式可以稍微注意下,比如命名为&b&报表类型-股票代码.csv&/b&,这样以便于读取。 &/p&&p&&b&四、编写Python程序下载数据&/b& &/p&&div class=&highlight&&&pre&&code class=&language-python3&&&span&&/span&&span class=&ch&&#!/usr/bin/py&/span&
&span class=&c1&&# filename=RPDownloader.py&/span&
&span class=&kn&&from&/span& &span class=&nn&&modules.Utils&/span& &span class=&k&&import&/span& &span class=&n&&e2csv&/span&
&span class=&kn&&from&/span& &span class=&nn&&modules.Fi&/span& &span class=&k&&import&/span& &span class=&n&&tcode&/span&
&span class=&kn&&import&/span& &span class=&nn&&pandas&/span& &span class=&k&&as&/span& &span class=&nn&&Pd&/span&
&span class=&kn&&import&/span& &span class=&nn&&requests&/span& &span class=&k&&as&/span& &span class=&nn&&ro&/span&
&span class=&c1&&# 下载资产负债表&/span&
&span class=&k&&def&/span& &span class=&nf&&downloadBSRP&/span&&span class=&p&&(&/span&&span class=&n&&stocklist&/span&&span class=&p&&):&/span&
&span class=&n&&num&/span& &span class=&o&&=&/span& &span class=&mi&&0&/span&
&span class=&k&&for&/span& &span class=&n&&c&/span& &span class=&ow&&in&/span& &span class=&n&&stocklist&/span&&span class=&p&&:&/span&
&span class=&n&&bs_url&/span&&span class=&o&&=&/span&&span class=&s1&&'http://soft-f9.eastmoney.com/soft/gp15.php?code=&/span&&span class=&si&&{co}&/span&&span class=&s1&&01&exp=1'&/span&&span class=&o&&.&/span&&span class=&n&&format&/span&&span class=&p&&(&/span&&span class=&n&&co&/span&&span class=&o&&=&/span&&span class=&n&&tcode&/span&&span class=&p&&(&/span&&span class=&n&&c&/span&&span class=&p&&))&/span&
&span class=&n&&ct&/span& &span class=&o&&=&/span& &span class=&n&&ro&/span&&span class=&o&&.&/span&&span class=&n&&get&/span&&span class=&p&&(&/span&&span class=&n&&bs_url&/span&&span class=&p&&)&/span&&span class=&o&&.&/span&&span class=&n&&text&/span&
&span class=&n&&to_file&/span&&span class=&o&&=&/span&&span class=&s1&&'bs&/span&&span class=&si&&{co}&/span&&span class=&s1&&.csv'&/span&&span class=&o&&.&/span&&span class=&n&&format&/span&&span class=&p&&(&/span&&span class=&n&&co&/span&&span class=&o&&=&/span&&span class=&n&&tcode&/span&&span class=&p&&(&/span&&span class=&n&&c&/span&&span class=&p&&))&/span&
&span class=&nb&&open&/span&&span class=&p&&(&/span&&span class=&n&&to_file&/span&&span class=&p&&,&/span&&span class=&s1&&'w'&/span&&span class=&p&&)&/span&&span class=&o&&.&/span&&span class=&n&&write&/span&&span class=&p&&(&/span&&span class=&n&&e2csv&/span&&span class=&p&&(&/span&&span class=&n&&ct&/span&&span class=&p&&))&/span&
&span class=&n&&num&/span& &span class=&o&&=&/span& &span class=&n&&num&/span& &span class=&o&&+&/span& &span class=&mi&&1&/span&
&span class=&k&&return&/span& &span class=&n&&num&/span&
&/code&&/pre&&/div&&p&函数返回值为成功下载报表数目(这里没有做容错处理,如果下载量比较大,需要做容错处理,另外,还须解决程序异常退出后,下次再次进入后避免反复下载已经下载的数据,另外,为了避免IP地址被封,须在下载一个后加上一个延迟,这些内容就留给大家下面去研究了),测试一下代码:&/p&&figure&&img src=&https://pic1.zhimg.com/v2-56b51a6b26de794bdccb6f99d1a1ba9b_b.jpg& data-rawwidth=&1576& data-rawheight=&200& class=&origin_image zh-lightbox-thumb& width=&1576& data-original=&https://pic1.zhimg.com/v2-56b51a6b26de794bdccb6f99d1a1ba9b_r.jpg&&&/figure&&p&显示成功下载了两个股票资产负债表。&/p&&p&根据以上内容,利润表和现金流量表也就可以下载了。&/p&&p&写到这里,财务数据采集篇就算结束了。下一篇是说说如何使用这些数据进行财务分析。&/p&
内容提要1) 获取需要下载数据的股票代码列表 2) 寻找可以下载数据的数据接口 3) 下载并保存数据写在之前 之前我在《》和《如何通过财务报表分析行业特征》两篇文章中提到并使用了Python,从反应来看,大家对于如何使用…
&p&更新: 20:48&/p&&p&本文涉及的示例代码(Python Notebook文件及示例数据)已包含下载: &a href=&https://link.zhihu.com/?target=http%3A//pan.baidu.com/s/1mhYBxxu& class=& external& target=&_blank& rel=&nofollow noreferrer&&&span class=&invisible&&http://&/span&&span class=&visible&&pan.baidu.com/s/1mhYBxx&/span&&span class=&invisible&&u&/span&&span class=&ellipsis&&&/span&&/a& 密码: ak28&/p&&p&-----------------------------&/p&&p&小伙伴们周末好,在&a href=&https://zhuanlan.zhihu.com/p/& class=&internal&&Python与财务【上】--数据采集篇&/a&中,我们简单看了下数据的采集,本篇我们简单看下如何通过已采集的数据进行财务分析。&/p&&p&内容提要&/p&&blockquote&1) 获取会计科目数据&br&2) 编制财务指标&br&3) 显示及导出数据&br&4) 数据可视化&/blockquote&&h2&&b&第一部分、获取会计科目数据&/b&&/h2&&p&&b&用两种方法可以处理,这里都写出来,可以看出直接处理文件比使用Pandas性能高出很多&/b&,另外,在由于下载的数据里面包括一些无效数据,所以处理时容易出错,不推荐使用Pandas处理数据。&/p&&p&首先&/p&&blockquote&&b&要有数据!&/b& &b&要有数据!&/b& &b&要有数据!必须先将财务从网络上数据爬下来放到统一位置。代码里面对数据位置的引用也要修改。&/b&&/blockquote&&p&重要的事情说三遍。很多知友反映说代码得不到预期结果,很可能就是数据没有爬下来。代码里面引用也不正确。&/p&&p&方法一、PANDAS方法&/p&&div class=&highlight&&&pre&&code class=&language-python3&&&span&&/span&&span class=&c1&&# 获取会计科目数据&/span&
&span class=&c1&&# 方法一、通过Pandas库从csv文件获取数据&/span&
&span class=&c1&&# 写成函数,code为六位股票代码,itp为报表类型:'is for income_statement, bs for balance_sheet, cf for cash_flows&/span&
&span class=&c1&&# n为默认参数,0表示最近一期,1表示最近两期,以下同&/span&
&span class=&k&&def&/span& &span class=&nf&&select&/span&&span class=&p&&(&/span&&span class=&n&&code&/span&&span class=&p&&,&/span&&span class=&n&&itp&/span&&span class=&p&&,&/span&&span class=&n&&key&/span&&span class=&p&&,&/span&&span class=&n&&n&/span&&span class=&o&&=&/span&&span class=&mi&&0&/span&&span class=&p&&):&/span&
&span class=&kn&&import&/span& &span class=&nn&&pandas&/span& &span class=&k&&as&/span& &span class=&nn&&pds&/span&
&span class=&n&&s_file&/span&&span class=&o&&=&/span&&span class=&s1&&'/dev/shm/Finacials/&/span&&span class=&si&&{tp}{c}&/span&&span class=&s1&&.csv'&/span&&span class=&o&&.&/span&&span class=&n&&format&/span&&span class=&p&&(&/span&&span class=&n&&c&/span&&span class=&o&&=&/span&&span class=&n&&code&/span&&span class=&p&&,&/span&&span class=&n&&tp&/span&&span class=&o&&=&/span&&span class=&n&&itp&/span&&span class=&p&&)&/span&
&span class=&n&&df&/span&&span class=&o&&=&/span&&span class=&n&&pds&/span&&span class=&o&&.&/span&&span class=&n&&read_csv&/span&&span class=&p&&(&/span&&span class=&n&&s_file&/span&&span class=&p&&,&/span&&span class=&n&&encoding&/span&&span class=&o&&=&/span&&span class=&s1&&'gbk'&/span&&span class=&p&&,&/span&&span class=&n&&index_col&/span&&span class=&o&&=&/span&&span class=&mi&&0&/span&&span class=&p&&)&/span&&span class=&o&&.&/span&&span class=&n&&dropna&/span&&span class=&p&&(&/span&&span class=&n&&axis&/span&&span class=&o&&=&/span&&span class=&mi&&1&/span&&span class=&p&&)&/span&
&span class=&k&&return&/span& &span class=&n&&df&/span&&span class=&o&&.&/span&&span class=&n&&ix&/span&&span class=&p&&[&/span&&span class=&n&&df&/span&&span class=&o&&.&/span&&span class=&n&&index&/span&&span class=&o&&.&/span&&span class=&n&&str&/span&&span class=&o&&.&/span&&span class=&n&&contains&/span&&span class=&p&&(&/span&&span class=&n&&key&/span&&span class=&p&&)]&/span&&span class=&o&&.&/span&&span class=&n&&values&/span&&span class=&p&&[&/span&&span class=&mi&&0&/span&&span class=&p&&][&/span&&span class=&n&&n&/span&&span class=&p&&]&/span&
&span class=&o&&%&/span&&span class=&n&&time&/span& &span class=&n&&select&/span&&span class=&p&&(&/span&&span class=&s1&&'600660'&/span&&span class=&p&&,&/span&&span class=&s1&&'cf'&/span&&span class=&p&&,&/span&&span class=&s1&&'经营活动产生的现金流量净额'&/span&&span class=&p&&)&/span&
&/code&&/pre&&/div&&p&执行结果&/p&&figure&&img src=&https://pic2.zhimg.com/v2-b41e04b8dcfd2b5d61989a4_b.jpg& data-rawwidth=&1649& data-rawheight=&513& class=&origin_image zh-lightbox-thumb& width=&1649& data-original=&https://pic2.zhimg.com/v2-b41e04b8dcfd2b5d61989a4_r.jpg&&&/figure&&p&方法二、直接处理csv文件&/p&&div class=&highlight&&&pre&&code class=&language-python3&&&span&&/span&&span class=&c1&&# 获取会计科目数据:方法二、直接处理文本&/span&
&span class=&k&&def&/span& &span class=&nf&&select2&/span&&span class=&p&&(&/span&&span class=&n&&code&/span&&span class=&p&&,&/span&&span class=&n&&itp&/span&&span class=&p&&,&/span&&span class=&n&&key&/span&&span class=&p&&,&/span&&span class=&n&&n&/span&&span class=&o&&=&/span&&span class=&mi&&0&/span&&span class=&p&&):&/span&
&span class=&n&&s_file&/span&&span class=&o&&=&/span&&span class=&s1&&'/dev/shm/Finacials/&/span&&span class=&si&&{tp}{c}&/span&&span class=&s1&&.csv'&/span&&span class=&o&&.&/span&&span class=&n&&format&/span&&span class=&p&&(&/span&&span class=&n&&c&/span&&span class=&o&&=&/span&&span class=&n&&code&/span&&span class=&p&&,&/span&&span class=&n&&tp&/span&&span class=&o&&=&/span&&span class=&n&&itp&/span&&span class=&p&&)&/span&
&span class=&n&&ct&/span&&span class=&o&&=&/span&&span class=&nb&&open&/span&&span class=&p&&(&/span&&span class=&n&&s_file&/span&&span class=&p&&,&/span&&span class=&n&&encoding&/span&&span class=&o&&=&/span&&span class=&s1&&'gbk'&/span&&span class=&p&&)&/span&&span class=&o&&.&/span&&span class=&n&&read&/span&&span class=&p&&()&/span&&span class=&o&&.&/span&&span class=&n&&replace&/span&&span class=&p&&(&/span&&span class=&s1&&'--'&/span&&span class=&p&&,&/span&&span class=&s1&&'0'&/span&&span class=&p&&)&/span&
&span class=&n&&targ&/span& &span class=&o&&=&/span& &span class=&s1&&''&/span&
&span class=&n&&start&/span& &span class=&o&&=&/span& &span class=&n&&ct&/span&&span class=&o&&.&/span&&span class=&n&&find&/span&&span class=&p&&(&/span&&span class=&n&&key&/span&&span class=&p&&)&/span&
&span class=&n&&end&/span& &span class=&o&&=&/span& &span class=&mi&&0&/span&
&span class=&

我要回帖

更多关于 vb程序无法调用excel 的文章

 

随机推荐