tag:blogger.com,1999:blog-5836657903081436281.post808714085029369168..comments2023-10-25T08:30:27.199-07:00Comments on 余氏物語 - 退而休則股: 20180804 免費的Google Finance getprices API 又下架了😭 余氏物語 - 退而休則股http://www.blogger.com/profile/09768564157159653954noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5836657903081436281.post-23488252429771667122018-09-19T02:02:02.888-07:002018-09-19T02:02:02.888-07:00Very good !!Very good !!Henryhttps://www.blogger.com/profile/18440106189778667335noreply@blogger.comtag:blogger.com,1999:blog-5836657903081436281.post-3230171557539906732018-08-16T02:32:05.020-07:002018-08-16T02:32:05.020-07:00後記:原來googlefinance可抓history, e.g. B1=googlefinance...後記:原來googlefinance可抓history, e.g. B1=googlefinance(concatenate("HKG:",left(sheet1!A28,4)),"all",today()-5*365,today(),"DAILY")<br />A2==DATEVALUE(SUBSTITUTE(LEFT(B2,IF(MID(B2,9,1)=" ",9,10)),"/","-"))<br />Datevalue Date Open High Low Close Volume<br />41505 2013/8/19 下午 4:00:00 23.1 23.15 22.95 23 8509207<br />41506 2013/8/20 下午 4:00:00 23 23.05 22.45 22.45 39277432<br />41507 2013/8/21 下午 4:00:00 22.5 22.5 22.15 22.4 25118674余氏物語 - 退而休則股https://www.blogger.com/profile/09768564157159653954noreply@blogger.comtag:blogger.com,1999:blog-5836657903081436281.post-6442513479776074642018-08-09T06:34:34.520-07:002018-08-09T06:34:34.520-07:00已用了googlefinance來抓price etc.但怎樣下載history呢?已用了googlefinance來抓price etc.但怎樣下載history呢?余氏物語 - 退而休則股https://www.blogger.com/profile/09768564157159653954noreply@blogger.comtag:blogger.com,1999:blog-5836657903081436281.post-59903806061612324402018-08-09T02:21:37.721-07:002018-08-09T02:21:37.721-07:00你可以試試GOOGLE SPREADSHEET 的自動取價功能
例如: =GOOGLEFINANCE...你可以試試GOOGLE SPREADSHEET 的自動取價功能<br />例如: =GOOGLEFINANCE(0823) , 都很方便的啊Henryhttps://www.blogger.com/profile/18440106189778667335noreply@blogger.com