Johnson ChanHow to save multiple spreadsheets as PDFs based on customised conditions?In this article, I would like to share with you how to save multiple spreadsheets as PDFs as you like. I would expect you having basic…May 14, 2020May 14, 2020
Johnson ChanHow to extract stock prices from Yahoo!Finance for multiple companies?Quick note: this is not financial advice. Please scrape data responsibly, do not extract data by spending a large number of requests.May 12, 2020May 12, 2020
Johnson ChanAnalytical thought about Xero LtdXero is a New Zealand domiciled public company headquartered in Wellington, listed on the Australia Stock Exchange. Xero offers a…Apr 25, 2020Apr 25, 2020
Johnson ChanHow to get time series data from Yahoo!Finance with PythonAs Google has deprecated its API, the best (free) way to get stock price data is Yahoo! Finance, here is a quick guide of how we can do…Apr 24, 20201Apr 24, 20201