Data accumulation/cleaning is like foundation and reinforcement in home building for data analysis

Yahoo finance API used to do everything for us, however it has been closed off, so somebody like me have to find another way out to get access to those financial data before doing analysis.


I did some work to accumulate data myself to have a data source for analysis:
https://github.com/chenlocus/aushare

However, I found this is far from enough.  ASX has a lot of codes which were delisted but still in their website for people to download:
https://www.asx.com.au/asx/research/ASXListedCompanies.csv


First of all, I need to sort out those delisted symbols from the list above, then I need to remove those invalid data such as 'null', 'n/a', '-' in the data I crawled, thanks to pandas, doing a lot of work and make the job much easier.


I need to amass those balance sheet, income report, cash flow, as well as such information as market capitals, P/E, Dividend from websites and store them in various files. These data are to be cleaned thus provide a strong foundation and stump for my data analysis work.


I feel so excited that I can use these data analysis tools and techniques to re-play and prove my opinions and philosophies  in stock market investment from year 1997 since I was a university student.


These are something I figure out when Yahoo finance API was available, now I have to do these by building an API by myself.  I think a real investor can understand the importance of price you buy in. Charts like these can provide benchmark for evaluation of share price in different period.

ASX shares find out best performance shares

Google blogspot is so mess, if you cannot see them clearly, please go here:

https://steemit.com/invest/@chenlocus/asx-shares-find-out-best-performance-shares

In this post, I am going to pick up those companies whose share price increased at least 10%. I will figured out the percentage of these companies in their own industries.

Analyze Australian Share market with python/pandas

I have been on share market since I was a university student when I used my scholarship to trade in Chinese stock market. I have been struggling in the worst stock market in the world which is Chinese market. Also, I did investment in the most cruel market in the world, which is Hang Kong stock market. I survived with some profits  in those markets and I did learn a lot, not only about stock market but also about human nature and life.  I switched to Australian and US stock markets, I found they are much more efficient and fair than Chinese stock market, they can really reflect the real situation of the economic situation of the country, with severe and excellent supervisions, investors can obtain much more. Recently, I felt interested in quantitative trading using yahoo-finance API to find some good trading strategies. Then Yahoo and Google shut down their finance data APIs and I have to crawl data from website myself. However, I began to aware that to pick up good companies and buy in at reasonable prices and hold is much more important than a good trading strategy.