5

I need to get historical prices of certain non-US stocks (specifically, they are traded at Prague Stock Exchange, Czech Republic) but I am not able to find the proper "name" that Mathematica would accept. For example, is there a way to look up the Mathematica name for a stock if I know the ISIN code or the exchange (but probably not the exchange's Mathematica symbol) where the stock is traded?

J. M.'s missing motivation
  • 124,525
  • 11
  • 401
  • 574
Skumin
  • 585
  • 5
  • 13

2 Answers2

5

While it does not exist as curated data, fortunately for you, Prague stock exchange published the data out for free in a very similar fashion to Yahoo Finance historical data feed. So you need to Import[] the stocks/dates you need as a semicolon-separated table and add headers to create a Dataset:

headers={"Date","Open","High","Low","Close","Volume","Turnover","FractionalChange"};
Dataset[AssociationThread[headers->#]& /@
  Import["https://www.pse.cz/en/market-data/shares/historical-data/?ID_NOTATION=50736993&ISIN=CZ0005123620&L=1&c45275%5BDATETIME_TZ_START_RANGE%5D=01%2F01%2F2016&c45275%5BDATETIME_TZ_END_RANGE%5D=04%2F20%2F2017&c45275%5BDOWNLOAD%5D=csv"
  ,"Table","FieldSeparators"->";","HeaderLines"->1]]

ParallelMap over your list of ISINs and you're good to go.

For more info and stock lookup, go to PSE's site. Enjoy!

Gregory Klopper
  • 1,370
  • 9
  • 21
5

Data for Prague does not appear to be available from Mathematica's curated data.

enter image description here

Chris Degnen
  • 30,927
  • 2
  • 54
  • 108