ASX Stock Market Data

Hi I need a spreadsheet that updates daily with the following items. 1. Company Name 2. Stock Code 3. Current Share Price - should update during trading day 4. Daily Change - percent change since last close 5. Weekly Change - percent change over 1 week 6. Monthly Change - percent change over 1 month 7. 3 Month Change - percent change over 3 months 8. 6 Month Change - percent change over 6 months 9. 12 Month Change - percent change over 12 months 10. Trailing P/E - price to earnings ratio based on last reported year 11. Trailing P/S - price to sales for last reported year 12. Trailing P/B - price to book value for last reported year 13. Trailing P/CF - price to cash flow for last reported year 14. Trailing EPS - earnings per share for last reported financial year 15. Current EPS Year 1 - current forecast earnings per share for current year (year 1) 16. Current EPS Year 2 - current forecast earnings per share for following year (year 2) 17. EPS Year 1 (1 Month) - forecast EPS for year 1, but 1 month ago 18. EPS Year 2 (1 Month) - forecast EPS for year 2, but 1 month ago. 19. 52 Week High - highest intra-day price for last 52 weeks 20. 52 Week Low - lowest intra-day price for last 52 weeks 21. 50 day average price - arithmetic average for last 50 tradable days 22. 100 day average price - arithmetic average for last 100 tradable days 23. 200 day average price - arithmetic average for last 200 tradable days 24. Shares on issue - current diluted shares on issue 25. Market capitalisation - current price multiplied by shares on issue 26. Stock Beta 27. Liquidity - average daily dollar volume 28. Quick Ratio - current assets less inventory, divided by current liabilities 29. Debt to Equity Ratio - defined as ALL liabilities, divided by common equity 30. Interest Coverage - earnings before interest and tax (EBIT) divided by interest expense 31. Return on equity - net profit, divided by common equity for last financial year 32. Net profit margin - net profit, divided by sales 33. Sector - using S&P classification 34. Sub-sector - using S&P classification I would like the data for all ASX listed stocks, but I realise that some data (e.g. eps estimates) is not always available. You can get most of the data from [login to view URL] (but be sure to use Australian Dollars, and AUD estimates, not USD). You can also get some data from Google and Yahoo Finance. The spreadsheet should update daily, and work continuously through the day when the market is open. If this project works, I will have more stock market work for you. For example, I also need someone who can enter the historical (10 years) financials of a company into a spreadsheet. I would need all the primary financial statements, plus notes on revenue, expenses, segment information, geographical information and shares on issue. I would tell you the company code, and you would download the company reports and input the data in a spreadsheet and email to me. If you have the right skills, I would also like the information written up into a stock analysis report. The stock reports would be about 5-10 pages, and contain an overview of the company, financial segments, profitability and future prospects, plus some information on the industry. These reports would be submitted in word. These 2 projects are just some of the extra, and more valuable tasks that I would want in the future. But if you have an interest in this other work, please let me know. I am looking for work that contains some sort of quality assurance, or checking procedure to make sure data is right.