This is the australian stock exchange.
Type in the companies code.You can find it in the raw data sheet of the google sheet.
You need to type in the companies 3 letter code. For quarter 1, you may need to search 2016. But for all the others (and sometimes for quarter 1) you need to search 2017.
When you go to "announcements" you will find the quarterly reports in there. Quarterly reports are either called quarterly reports, q1,q2,q3,q4 reports or Appendix 4c reports.
You will see that aconex has been "released from quarterly reports".
So we move to the next company in the spreadsheet.
Try searching for aeris environmental announcements using its 3 letter code aei (found in the raw data sheet) All 4 of its quarterly reports are in the 2017 search.
Once you have downloaded that pdf, you can use something like I use TABULA to turn the pdf into a table. http://tabula.technology/
I recommend this, but if you have other technology that is faster or better, you could use that too!
Using tabula, take pictures of the tables of following headings to extract the information from them:
"Cash flows from operating activities".
I am only interested in the "current quarter" column. I do not need year to date.
Copy and paste the results into "this sheet". Please make sure though that each piece of data lines up with names of the rows.
January 29, 2018
I am looking for a mix of experience and value