kaka
同學
UID 6717
精華
0
積分 0
帖子 6266
閱讀權限 99
註冊 2014-5-7 用戶註冊天數 3614
用戶失蹤天數 1720
140.114.124.27
|
|
增加新加坡的美股ADR代碼
資料來源 | Google Finance 中文網站 股票篩選器 | https://www.google.com.hk/finance | Google Finance 英文網站 | https://www.google.com/finance | 新加坡交易所 Singapore Exchange ( SGX ) ( Find a Company , 公司財報資料 , 市場報價 ) | 欄位使用customize display選取下列欄位 P/E , P/BV | http://www.sgx.com/wps/portal/sgxweb/home/company_disclosure/stockfacts | 各國ADR | http://www.adrbnymellon.com/dr_search_by_country.jsp | MorningStar 晨星 (ROE) | http://financials.morningstar.com/ratios/r.html?t=CIGRion=usa&culture=en-US | MorningStar 晨星 (本益比,股價淨值比) | http://financials.morningstar.com/valuation/price-ratio.html?t=RDS.BRion=usa&culture=en-US&ownerCountry=USA | 在按盈在表之前,為了節省按盈再表的時間,將新加坡交易所網站資料先用市值由大到小排列,將市值排名前3頁的公司股票資料複製到雲端試算表或Excel試算表,刪除不要的欄位,保留下列欄位,並且增加右邊的大概計算的ROE公式,方便刪除ROE太小的公司,刪除中國掛牌公司,刪除房地產及REIT,刪除不符合巴菲特6點選股方法(巴六點)的股票得到下列投資名單之後,才開始按盈再表刪除營再率太高的公司,及刪除ROE(使用常利計算)太小的公司
| ROE(大概計算的ROE , 不是使用常利)
| 行業
| Google Finance代號
| 美股ADR代號
| |
Google Finance | 公式 | Company Name | Code | Industry | Mkt. Cap.in S$ mm | Volumein mm | P/E | P/BV | 公式 =100*(P/B) / (P/E) | Singapore Telecommunications Limited | Z74 | Diversified Telecommunication Services | 67,672 | 35.71 mm | 18.3 | 2.9 | 16 | 電信 | SGX:Z74 | SGAPY | DBS Group Holdings Ltd | D05 | Banks | 49,728 | 5.3 mm | 12.5 | 1.3 | 11 | 金融 | SGX: D05 | DBSDY | Oversea-Chinese Banking Corporation Limited | O39 | Banks | 41,619 | 4.06 mm | 10.2 | 1.3 | 13 | 金融 | SGX:O39 | OVCHY | United Overseas Bank Limited | U11 | Banks | 36,699 | 3.95 mm | 11.6 | 1.3 | 11 | 金融 | SGX:U11 | UOVEY | Thai Beverage Public Company Limited | Y92 | Beverages | 19,084 | 19.71 mm | 22.0 | 4.7 | 21 | 食品 | SGX:Y92 | | Dairy Farm International Holdings Limited | D01 | Food and Staples Retailing | 17,002 | 0.13 mm | 24.2 | 8.6 | 36 | 食品 | SGX: D01 | DFIHY | Keppel Corporation Limited | BN4 | Industrial Conglomerates | 16,078 | 9.49 mm | 8.5 | 1.5 | 18 | 控股公司 | SGX:BN4 | KPELY | Jardine Cycle & Carriage Limited | C07 | Distributors | 14,584 | 0.29 mm | 13.4 | 2.4 | 18 | 汽車代理銷售 | SGX:C07 | JCYGY | Great Eastern Holdings Limited | G07 | Insurance | 11,871 | 0.01 mm | 13.5 | 2.0 | 15 | 金融 | SGX:G07 | GEHDY | Singapore Technologies Engineering Ltd | S63 | Aerospace and Defense | 10,675 | 2.04 mm | 20.2 | 5.0 | 25 | 工程 | SGX:S63 | SGGKY | Singapore Exchange Limited | S68 | Diversified Financial Services | 8,408 | 3.03 mm | 26.6 | 10.1 | 38 | 金融 | SGX:S68 | SPXCY | Sembcorp Industries Ltd | U96 | Industrial Conglomerates | 7,653 | 2.6 mm | 9.8 | 1.4 | 14 | 控股公司 | SGX:U96 | SCRPY | StarHub Ltd. | CC3 | Wireless Telecommunication Services | 7,221 | 7.14 mm | 19.5 | 48.4 | 248 | 電信 | SGX:CC3 | SRHBY | ComfortDelGro Corporation Limited | C52 | Road and Rail | 6,314 | 10.17 mm | 22.3 | 2.9 | 13 | 運輸 | SGX:C52 | CDGLY | Sembcorp Marine Ltd | S51 | Machinery | 6,133 | 2.93 mm | 11.0 | 2.1 | 19 | 食品 | SGX:S51 | SMBMY | Olam International Limited | O32 | Food and Staples Retailing | 4,833 | 2.01 mm | 8.7 | 1.2 | 13 | 農業 | SGX:O32 | OLMIY | SIA Engineering Company Limited | S59 | Transportation Infrastructure | 4,485 | 0.47 mm | 21.7 | 3.5 | 16 | 飛機修護 | SGX:S59 | SEGSY | Singapore Post Limited | S08 | Air Freight and Logistics | 4,153 | 12.39 mm | 29.2 | 4.0 | 14 | 郵政 | SGX:S08 | SPSTY | M1 Limited | B2F | Wireless Telecommunication Services | 3,568 | 0.9 mm | 20.3 | 9.0 | 44 | 電信 | SGX:B2F | MBOFY | SATS Ltd. | S58 | Transportation Infrastructure | 3,396 | 2.32 mm | 18.5 | 2.5 | 13 | 運輸 | SGX:S58 | SPASY | First Resources Limited | EB5 | Food Products | 2,851 | 3.06 mm | 12.4 | 2.0 | 16 | 棕櫚油 | SGX:EB5 | FSRCY | SMRT Corporation Ltd | S53 | Road and Rail | 2,435 | 2.55 mm | 28.1 | 2.9 | 10 | 捷運 | SGX:S53 | SPMRY | Mandarin Oriental International Limited | M04 | Hotels, Restaurants and Leisure | 2,268 | 0.12 mm | 17.0 | 1.7 | 10 | 東方文華酒店集團 | SGX:M04 | | Raffles Medical Group Ltd | R01 | Healthcare Providers and Services | 2,185 | 0.56 mm | 32.4 | 4.1 | 13 | 醫療 | SGX:R01 | RAFLY | Bumitama Agri Ltd. | P8Z | Food Products | 1,758 | 0.19 mm | 14.3 | 2.5 | 18 | 棕櫚油 | SGX: P8Z | | Super Group Ltd. | S10 | Food Products | 1,645 | 0.74 mm | 23.9 | 3.3 | 14 | 食品 | SGX:S10 | | OSIM International Ltd | O23 | Specialty Retail | 1,584 | 0.31 mm | 15.5 | 3.6 | 23 | 按摩椅,運動器材 | SGX:O23 | OMIMY |
|
|
|