tag:blogger.com,1999:blog-5711178481632541002.post3481315003074018243..comments2024-01-01T05:10:45.288-08:00Comments on HC愛筆記財經: 利用Google試算表(Spreadsheet)取得台股(上市/上櫃)及美股股票報價(2017-05-14 更新)HChttp://www.blogger.com/profile/15438383368409221804noreply@blogger.comBlogger96125tag:blogger.com,1999:blog-5711178481632541002.post-89138757336781894312020-08-29T22:37:18.182-07:002020-08-29T22:37:18.182-07:00您好,我有三股抓不到股價想請教您,德麥(1264) 崑鼎(6803) 大地-KY(8437)
是否有...您好,我有三股抓不到股價想請教您,德麥(1264) 崑鼎(6803) 大地-KY(8437)<br />是否有解法?嘉https://www.blogger.com/profile/07192483268791005848noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-17570440044845564152019-12-02T18:02:26.529-08:002019-12-02T18:02:26.529-08:00=GoogleFinance("tpe:XXXX", "eps&quo...=GoogleFinance("tpe:XXXX", "eps")Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-27414468282198232352019-11-08T02:25:35.663-08:002019-11-08T02:25:35.663-08:00請問EPS的上市怎抓?請問EPS的上市怎抓?GINOhttps://www.blogger.com/profile/09217922686888300589noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-37141015965244573232019-10-03T19:27:42.500-07:002019-10-03T19:27:42.500-07:00上櫃股票如果比較冷門,開盤還未成交,會出現#VALUE,借樓主智慧加上一個檢查開盤價是否為"...上櫃股票如果比較冷門,開盤還未成交,會出現#VALUE,借樓主智慧加上一個檢查開盤價是否為"--"的算式,否則抓昨天的收盤價 *註:以下C4是股票代號<br /><br />=if(importXML(CONCATENATE("http://www.wantgoo.com/stock/",C4),"//*/div[3]/div[2]/ul/li[1]/b")="--",importXML(CONCATENATE("http://www.wantgoo.com/stock/",C4),"//*/div[3]/div[2]/ul/li[4]/b"),importXML(CONCATENATE("http://www.wantgoo.com/stock/",C4),"//*/div[3]/div[2]/ul/li[4]/b") +if(importXML(CONCATENATE("http://www.wantgoo.com/stock/",C4),"//*/div[1]/span[3]")<0, - right(importXML(CONCATENATE("http://www.wantgoo.com/stock/",C4),"//*/div[1]/span[2]"),len(importXML(CONCATENATE("http://www.wantgoo.com/stock/",C4),"//*/div[1]/span[2]"))-1), right(importXML(CONCATENATE("http://www.wantgoo.com/stock/",C4),"//*/div[1]/span[2]"),len(importXML(CONCATENATE("http://www.wantgoo.com/stock/",C4),"//*/div[1]/span[2]"))-1)))<br />Unknownhttps://www.blogger.com/profile/11614050856041916718noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-55257303465254274672019-04-30T20:28:31.380-07:002019-04-30T20:28:31.380-07:00請問這函式有辦法在未取得資料前先顯示處理中之類的文字嗎??請問這函式有辦法在未取得資料前先顯示處理中之類的文字嗎??Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-52393658192648195892019-03-21T22:45:24.483-07:002019-03-21T22:45:24.483-07:00請問如何捉台股上櫃個股的歷史年度高低價 ?
http://www.tpex.org.tw/web/s...請問如何捉台股上櫃個股的歷史年度高低價 ?<br />http://www.tpex.org.tw/web/stock/statistics/monthly/st42.php?l=zh-tw<br />jayshenhttps://www.blogger.com/profile/13397274246761851728noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-24595519173490732492019-01-04T05:18:08.630-08:002019-01-04T05:18:08.630-08:00請問可以給範例參考看看嗎?請問可以給範例參考看看嗎?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-85748946188776453942018-10-26T01:21:17.836-07:002018-10-26T01:21:17.836-07:00請問
=IFERROR(ARRAY_CONSTRAIN(importXML(CONCATENATE(...請問<br />=IFERROR(ARRAY_CONSTRAIN(importXML(CONCATENATE("http://m.wantgoo.com/s/","SHI"),"//*/div[2]/div/div[1]"),1,1))<br />這是顯示現在指數 <br />但如果我想要兩個欄位分別是漲跌數與漲跌幅度%應該怎麼改語法呢,感謝Anonymoushttps://www.blogger.com/profile/14442211346004349996noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-68616141339170592492018-09-24T00:01:43.681-07:002018-09-24T00:01:43.681-07:00很大的幫助非常感謝很大的幫助非常感謝Anonymoushttps://www.blogger.com/profile/07756553632075188252noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-58331064493828490962018-04-02T06:58:23.987-07:002018-04-02T06:58:23.987-07:00請問可抓到日股的股價嗎? 請問可抓到日股的股價嗎? Anonymoushttps://www.blogger.com/profile/14631631668993385122noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-29137935339738650292018-01-14T16:31:27.631-08:002018-01-14T16:31:27.631-08:00請問怎麼抓上櫃股票的一段時間歷史股價?
謝謝...請問怎麼抓上櫃股票的一段時間歷史股價?<br />謝謝...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-33452888410073770142018-01-10T01:29:02.162-08:002018-01-10T01:29:02.162-08:00請問要怎麼抓上櫃的昨天收盤價格,謝謝請問要怎麼抓上櫃的昨天收盤價格,謝謝Anonymoushttps://www.blogger.com/profile/08535077796521403050noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-16020821690225166332017-12-26T22:41:27.116-08:002017-12-26T22:41:27.116-08:00你好 想請問一下
我測試了一下想用函數直接抓大盤收盤指數
=GOOGLEFINANCE("...你好 想請問一下<br />我測試了一下想用函數直接抓大盤收盤指數<br /><br />=GOOGLEFINANCE("TWII" ,"close","2017/12/26")<br />若我參數這樣打會出現異常抓不到資料 但把日期改成25號 就可以正常 但抓出來是26號的資料 不知道這日期的部分是怎麼算的?<br /><br />另外想請問一下通常台股收盤之後 GOOGLEFINANCE抓當天收盤指數會延遲多久?<br />測試1430左右還是抓不到當天的收盤價資訊小四https://www.blogger.com/profile/17132028554416651940noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-6131818845809707472017-12-26T06:15:41.679-08:002017-12-26T06:15:41.679-08:00他是說停止投資組合功能,但我們只是要報價而已,並沒有受到影響。他是說停止投資組合功能,但我們只是要報價而已,並沒有受到影響。HChttps://www.blogger.com/profile/15438383368409221804noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-58471271349130573362017-12-26T02:05:08.990-08:002017-12-26T02:05:08.990-08:00現在google finance還可以用嗎
https://support.google.com/f...現在google finance還可以用嗎<br />https://support.google.com/finance/?hl=zh-Hant<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-51778636046027737632017-11-10T05:05:34.589-08:002017-11-10T05:05:34.589-08:00不能衹放這樣 指令應該是
GOOGLEFINANCE("TPE:2330",...不能衹放這樣 指令應該是<br /><br />GOOGLEFINANCE("TPE:2330","all",DATE(2009,1,1),DATE(2013,1,1),"DAILY<br />")Anonymoushttps://www.blogger.com/profile/09653548387741448675noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-7766641274157708792017-10-22T20:07:00.947-07:002017-10-22T20:07:00.947-07:00CONCATENATE 的部分建議都用雙引號
Ex:
=IFERROR(ARRAY_CONSTRAI...CONCATENATE 的部分建議都用雙引號<br />Ex:<br />=IFERROR(ARRAY_CONSTRAIN(importXML(CONCATENATE("http://m.wantgoo.com/s/","00679b"),"//*/div[2]/div/div[1]"),1,1))Unknownhttps://www.blogger.com/profile/14533969936433913248noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-91244574120506293902017-09-01T01:36:46.113-07:002017-09-01T01:36:46.113-07:00請問要抓上櫃股票的價差公式要怎麼改?請問要抓上櫃股票的價差公式要怎麼改?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-14450274449667961502017-06-07T18:47:58.612-07:002017-06-07T18:47:58.612-07:00上櫃指數又無法抓取了,請問該如何修改呢?上櫃指數又無法抓取了,請問該如何修改呢?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-33704741171027853912017-05-17T01:52:27.772-07:002017-05-17T01:52:27.772-07:00請問上證指數要怎麼抓?請問上證指數要怎麼抓?Anonymoushttps://www.blogger.com/profile/12325637818942932177noreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-17020066166360297832017-05-12T06:08:56.740-07:002017-05-12T06:08:56.740-07:00IFERROR(GoogleFinance(CONCATENATE(B17, ".TW&q...IFERROR(GoogleFinance(CONCATENATE(B17, ".TW"),"price"), IFERROR(ARRAY_CONSTRAIN(importXML(CONCATENATE("http://m.wantgoo.com/s/",B17),"//*/div[2]/div/div[1]"),1,1), ARRAY_CONSTRAIN(importXML(CONCATENATE("http://m.wantgoo.com/s/",B17),"//*/div[2]/div/div[1]"),1,1)))Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-23758038022908090222017-05-10T19:10:47.503-07:002017-05-10T19:10:47.503-07:00我要抓3689的股價沒辦法抓~~我要抓3689的股價沒辦法抓~~Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-33878319150451117062017-05-07T20:03:09.545-07:002017-05-07T20:03:09.545-07:00謝謝你~~~謝謝你~~~Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-64558135359293727332017-05-04T22:29:24.966-07:002017-05-04T22:29:24.966-07:00可以用耶,可是可轉債如37082上緯投控二 便掛了
可以用耶,可是可轉債如37082上緯投控二 便掛了<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5711178481632541002.post-65583382690635220952017-05-01T22:43:45.475-07:002017-05-01T22:43:45.475-07:00跪求大師解決,我也一樣跑不出股價跪求大師解決,我也一樣跑不出股價Anonymousnoreply@blogger.com