Is there a way to get Tokyo and Osaka EOD data using Amiquote?
This data is available from Yahoo Finance but need to know the ticker symbol in order to download it. There maybe other sites that provide the full ticker list. If not then you need to get it from Japan Exchange Group.
TOKYO STOCK EXCHANGE Listed company search (tse.or.jp)
Replace the last zero digit in the stock code with .T (e.g. 13010 -> 1301.T) and you should be able to download the EOD from Yahoo Finance.
1 Like
At least for Nikkei 225:
7203.T,Toyota Motor
9984.T,Softbank
9432.T,Nippon Telegraph & Telephone
8306.T,Mitsubishi UFJ Financial
9433.T,KDDI
6758.T,Sony
6098.T,Recruit Holdings
8316.T,Sumitomo Mitsui Financial Group
7267.T,Honda Motor
6178.T,Japan Post
9983.T,Fast Retailing
2914.T,Japan Tobacco
8058.T,Mitsubishi
8411.T,Mizuho Financial
9022.T,Central Japan
7751.T,Canon
6902.T,Denso
6954.T,Fanuc
3382.T,Seven & I Holdings
6367.T,Daikin
7201.T,Nissan
4452.T,KAO
4063.T,Shin-etsu Chemical
8766.T,Tokio Marine
9020.T,East Japan Railway
4519.T,Chugai Pharma
4503.T,Astellas Pharma
4502.T,Takeda
6501.T,Hitachi
8001.T,Itochu
8031.T,Mitsui
4911.T,Shiseido
4568.T,Daiichi Sankyo
6301.T,Komatsu
6752.T,Panasonic
5108.T,Bridgestone
7269.T,Suzuki Motor
6503.T,Mitsubishi Electric
4523.T,Eisai
4578.T,Otsuka Holdings
5020.T,JX Holdings
8750.T,Dai-ichi Life
8802.T,Mitsubishi Estate
8801.T,Mitsui Fudosan
2503.T,Kirin Holdings
4901.T,Fujifilm
8035.T,Tokyo Electron
4543.T,Terumo
7270.T,Fuji Heavy Industries
6971.T,Kyocera
3407.T,Asahi Kasei
2502.T,Asahi Group
8053.T,Sumitomo
4507.T,Shionogi
8267.T,AEON
6326.T,Kubota
4689.T,Yahoo Japan
5401.T,Nippon Steel
1925.T,Daiwa House
8725.T,MS&AD Insurance
9613.T,NTT DATA
9735.T,Secom
1605.T,Inpex
8604.T,Nomura
8830.T,Sumitomo Realty & Development
8630.T,Sompo Japan Nip
8309.T,Sumitomo Mitsui
8002.T,Marubeni
6702.T,Fujitsu
9503.T,Kansai Electric Power
5411.T,JFE Holdings
4188.T,Mitsubishi Chem
6762.T,TDK
7202.T,Isuzu Motors
9021.T,West Japan Railway
7733.T,Olympus
4324.T,Dentsu
6988.T,Nitto Denko
8015.T,Toyota Tsusho
3402.T,Toray Industries
7011.T,Mitsubishi Heavy Industries
8308.T,Resona Holdings
9064.T,Yamato Transport
5802.T,Sumitomo Electric
9202.T,Ana Holdings INC
9502.T,Chubu Electric Power
9005.T,Tokyu Corporation
2801.T,Kikkoman Corporation
9531.T,Tokyo Gas
4151.T,Kyowa Hakko Kirin
8795.T,T&D Holdings
4755.T,Rakuten
1928.T,Sekisui House,
8601.T,Daiwa Securities
7211.T,Mitsubishi Motors
5713.T,Sumitomo Metal Mining
2269.T,Meiji Holdings
1801.T,Taisei
7951.T,Yamaha
5201.T,Asahi Glass
2802.T,Ajinomoto
7272.T,Yamaha Motor
4005.T,Sumitomo Chemical
4704.T,Trend Micro
4506.T,Sumitomo Dainippon
9007.T,Odakyu Electric Railway
6506.T,Yaskawa Electric
9532.T,Osaka Gas
6479.T,Minebea
7752.T,Ricoh
4004.T,Showa Denko
4021.T,Nissan Chemical
1812.T,Kajima
7731.T,Nikon Corporation
9501.T,Tokyo Electric Power
5332.T,Toto
7261.T,Mazda Motor
7912.T,Dai Nippon Printing
3861.T,Oji Paper
1803.T,Shimizu Corporation
1802.T,Obayashi
6305.T,Hitachi Construction Machinery
6701.T,NEC
9008.T,Keio
6724.T,Seiko Epson
2002.T,Nisshin Seifun
9062.T,Nippon Express
9001.T,Tobu Railway
6471.T,NSK
7186.T,Concordia Financial Group Ltd
7205.T,Hino Motors,
6504.T,Fuji Electric
9009.T,Keisei Electric Railway
7013.T,IHI
9602.T,Toho
1963.T,JGC
6841.T,Yokogawa Electric
8331.T,Chiba Bank
7911.T,Toppan
8355.T,Shizuoka Bank
9766.T,Konami
5333.T,NGK Insulators
3405.T,Kuraray
6770.T,Alps Electric
4902.T,Konica Minolta
4183.T,Mitsui Chemicals
4042.T,Tosoh
6473.T,JTEKT
3099.T,Isetan Mitsukoshi
8354.T,Fukuoka Financial
7012.T,Kawasaki
3289.T,Tokyu Fudosan
2768.T,Sojitz
5301.T,Tokai Carbon
6302.T,Sumitomo Heavy Inds.
3436.T,Sumco
8252.T,Marui Group
6952.T,Casio Computer
6857.T,Advantest
8304.T,Aozora Bank
8303.T,Shinsei Bank
1721.T,Comsys
3086.T,J Front Retailing
5901.T,Toyo Seikan Group
5233.T,Taiheiyo Cement
6113.T,Amada Holdings
2282.T,Nh Foods
1808.T,Haseko
5711.T,Mitsubishi Materials
2871.T,Nichirei
3401.T,Teijin
5101.T,Yokohama Rubber
6361.T,Ebara
9104.T,Mitsui OSK Lines
6976.T,Taiyo Yuden
5406.T,Kobelco
9101.T,Nippon Yusen
7735.T,Dainippon Screen
5214.T,Nippon Electric Glass
4061.T,Denki Kagaku Kogyo
8253.T,Credit Saison
8233.T,Takashimaya
2531.T,Takara
4208.T,Ube Industries
8628.T,Matsui Securities
8804.T,Tokyo Tatemono
2432.T,Dena Co
5631.T,Japan Steel Works
5801.T,Furukawa Electric
9301.T,Mitsubishi Logistics
6472.T,NTN
4272.T,Nippon Kayaku
3863.T,Nippon Paper
7762.T,Citizen Holdings
3105.T,Nisshinbo
6366.T,Chiyoda
6674.T,GS Yuasa
5714.T,Dowa
1333.T,Maruha Nichiro Corp
4043.T,Tokuyama
1332.T,Nippon Suisan Kaisha
6103.T,Okuma
9107.T,Kawasaki Kisen
5232.T,Sumitomo Osaka Cement
9412.T,Sky Perfect JSAT
5706.T,Mitsui Mining & Smelting
2501.T,Sapporo Group
5803.T,Fujikura
7003.T,Mitsui Engineering & Shipbuilding
3101.T,Toyobo
5703.T,Nippon Light
6703.T,Oki Electric
5202.T,Nippon Sheet Glass
7004.T,Hitachi Zosen
5541.T,Pacific Metals
5715.T,Furukawa
5707.T,Toho Zinc
3103.T,Unitika
2413.T,M3 Inc
5019.T,Idemitsu Kosan Co Ltd
4751.T,CyberAgent Inc
4631.T,DIC Corp
6645.T,Omron Corp
9201.T,Japan Airlines
8697.T,Japan Exchange Group Inc
7832.T,Bandai Namco Holdings Inc
Nikkei225.tls (1.8 KB)
1 Like
You can use Tradingview's stock screener to download a csv file of approximately listed 4000 Japanese stocks (this should work for other countries/exchanges too)
@Brossy,
All the ticker symbols for Tokyo Stock Exchange are in the pdf report.
Number of Listed Companies/Shares | Japan Exchange Group (jpx.co.jp)
@Peter2047 @Tomasz @short
Thanks for your input everyone. I was actually able to pull the full symbol list from here in excel format:
[Other Statistics | Japan Exchange Group]
With a small amount of manipulation I can get it into a simple form as CSV or TXT file to be able to pull the data in TLS format through Amiquote. All is well !!!
I'm still relatively new to the forum here, so still learning, but if others are interested in the TLS, TXT or TLS file (all basically the same info), I can try to figure the easiest way to provide for others. It's currently 4108 listings (actually 4109 because of IT OEN preferred shares not listing correctly - 2593P.T) I also have another file that specifies only the Japan ETFs if people are interested.
1 Like
Almost a replica of the TLS I created for the Japan Group listings. It's good to know I was on the right track. The one exception is 25935.T whereas I have it as 2593P.T I think its the preferred share for ITOEN group. I'm not sure which one is correct (according to Yahoo Finance for download purposes) because neither actually provide any actual charting data when downloaded. I'm unsure why that is, but maybe it's just that preferred shares data can't be properly acquired through Yahoo. Irrespective, I'm not sure I'd actually trade preferred shares anyways as there's not much price or volume action on these anyways.....more of a long term investors type of instrument. Thanks again @Tomasz for your insight on this.