楼主:
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