Create a PHP script (or other server side script) to query ASX trading data held in zip files in DropBox

1. Closing data for ASX stocks is stored (on a calendar year basis) in zip files in a DropBox folder. Naming convention: "[login to view URL]", [login to view URL]" etc. Earliest data is 2011 (i.e. "[login to view URL]") up to March 2016 (i.e. "[login to view URL]"). 2. The user will periodically upload new ASX closing price data (e.g. monthly). For 2016, the new file ("[login to view URL]") will replace the old file of same name. The new file will include the trading days since the last upload. Eventually, the data for 2016 will be completed (post 31 Dec 2016) and the same process would then be undertaken for 2017. 3. Each zip file contains a comma delimitered text file for each trading day that sets out the ASX code. The naming convention is "[login to view URL]". E.g. all ASX trades on 6 January 2016 would be in text file: "[login to view URL]" in the zip file: "[login to view URL]". No text files exist for non-trading days. 4. Each company is a line on the text file. The format for each line on the text file is: Stock Code, Open, High, Low, Close, Volume. For example, trading in Cardno Limited (ASX:CDD) on 5 January 2016 would appear as follows: "[login to view URL],20160105,1.2,1.2,1.14,1.185,752060". ".AX" means that the stock is quoted on ASX and can be ignored. I am only interested in searching a company's ordinary shares, rather than options etc. Limit in this way by filtering out any ASX code of more than three characters. For example, in the example below (which shows trading data from 5 January 2016), only the line item for [login to view URL] is relevant. [login to view URL],20160105,0.009,0.009,0.008,0.008,2278891 [login to view URL],20160105,0.003,0.003,0.003,0.003,0 5. Searching data - a simple HTML interface with the following options to filter queries: (a) Data range to sample. This should be from 1 Jan 2011 through to today. The search would only be run over this date range. I appreciate that as the archive grows execution time could become an issue, but I don't expect the user to be searching beyond a 5 year timeframe in any event. Also, this will not be an application that is available to the public, so the script will only be run by one user at a time. (b) Select a % price fall over a specified trading period. User would select % fall and no. of trading days. For example, a user might select 25% fall over a 5 trading day period. In that case, the PHP script is to look at closing price only (open, high and low prices can be ignored). In that case, the script would check closing price on each day against closing price on the day 5 trading days after. If the fall is equal to or greater than the % specified by the user, it is a hit (e.g. Trading Day 0 closing price = $1.00; Trading Day 5 closing price = $0.60; this would be a hit). Trading days are days on which some trading volume occurred. For example, the following entry (on 6 January 2016) indicates that there was no trading in the company on that day, so another day would be added to the comparison dataset (in the example above, assuming only one trading day has no volume, then the price check would roll to Trading Day 6). [login to view URL],20160106,0.16,0.16,0.16,0.16,0 (c) For any price hit, the user may elect to compare the closing price on Trading Day 0 (in the example above) against the closing price in either 3, 6 or 12 months time and if the closing price in that later period is greater than the closing price on Trading Day 0, then the company is excluded from the results (i.e. the only results would be those where the price did not recover in that period. The HTML page might be a simple check box which, if selected, gives the user the option to select 3, 6 or 12 months for the comparison. 6. The output would be a simple HTML page that identifies the code of the company and all of the trading data for that company over the relevant period in 5(b) above.