Re: [其他] 用Excel做回测下集(附做好的回测档案)

楼主: kslman   2020-06-18 23:02:08
※ 引述《yahoo168 (努力就会有骚货)》之铭言:
: 上次有大大建议股价可以直接用google finance
: 不一定要用python或手动 蛮有道理的 大家可以参考看看
帮你补充下GoogleFinance取历史资料的写法:
这是抓2317:
=GoogleFinance("TPE:2317","close","2015/6/20","2020/6/18",1)
这是抓GOOG:
=GoogleFinance("GOOG","all","2015/6/20","2020/6/18",1)
资料会像这样:
https://imgur.com/XqfRdk6
想看其他参数详情可参考:
https://support.google.com/docs/answer/3093281?hl=zh-Hant

Links booklink

Contact Us: admin [ a t ] ucptt.com