銘柄 |
ビックカメラ |
=IF(A2="","---",SUBSTITUTE(IMPORTXML(CONCATENATE("http://stocks.finance.yahoo.co.jp/stocks/history/?code=",A2),"//th[@class='symbol']"),"(株)","")) |
株価 |
1,175 |
=IF(A2="","---",IMPORTXML(CONCATENATE("http://stocks.finance.yahoo.co.jp/stocks/history/?code=",A2),"//td[@class='stoksPrice']")) |
単元株数 |
100 |
=IF(A2="","---",IMPORTXML(CONCATENATE("https://stocks.finance.yahoo.co.jp/stocks/detail/?code=",A2),"//div[@id='rfindex']/div[2]/div[10]/dl/dd/strong")) |
決算月 |
8月末日 |
=IF(A2="","---",IMPORTXML(CONCATENATE("https://stocks.finance.yahoo.co.jp/stocks/profile/?code=",A2),"//table[@class='boardFinCom marB6']/tr[12]/td")) |
配当 |
○(配当がある場合○,なければ×) |
=IF(A2="","-",IF(ISERROR(IMPORTXML(CONCATENATE("https://stocks.finance.yahoo.co.jp/stocks/detail/?code=",A2),"//div[@id='rfindex']/div[2]/div[4]/dl/dd/strong/a")),"×","○")) |
一株配当 |
12 |
=IF(A2="","---",IF(ISERROR(IMPORTXML(CONCATENATE("https://stocks.finance.yahoo.co.jp/stocks/detail/?code=",A2),"//div[@id='rfindex']/div[2]/div[4]/dl/dd/strong/a")),"---",IMPORTXML(CONCATENATE("https://stocks.finance.yahoo.co.jp/stocks/detail/?code=",A2),"//div[@id='rfindex']/div[2]/div[4]/dl/dd/strong/a"))) |
配当利回り |
1.02 |
=IF(I2="---","---",IMPORTXML(CONCATENATE("https://stocks.finance.yahoo.co.jp/stocks/detail/?code=",A2),"//div[@id='rfindex']/div[2]/div[3]/dl/dd/strong")) |
優待 |
○(株主優待がある場合○,なければ×) |
=IF(A2="","-",IF(ISERROR(IMPORTXML(CONCATENATE("https://info.finance.yahoo.co.jp/stockholder/detail/?code=",A2),"//div[@class='incentiveNomatch']/p")),"○","×")) |
参照URL |
■(ハイパーリンク) |
=IF(A2="","---",HYPERLINK(CONCATENATE("https://info.finance.yahoo.co.jp/stockholder/detail/?code=",A2),"■")) |