VB App to scrape UK FTSE100 market data

Download the PDF for a better formated version of this document: [login to view URL] I want to get UK FTSE100 stock market data from Yahoo and Digitallook.com. If you can get the same data from elsewhere then that will be fine. The collected data will be used to determine some basic trends and saved in a local database such as MS Access. FTSE 100 I want this data collated and displayed in a tabular (columns) format with specific columns. I want to be able to select which columns are visible and the order the columns are listed. Also, I want to be able to sort the list by any column. Share Portfolios. I want to be able to create and maintain share portfolios. Each portfolio will have many company shares that I purchase and record market data, which I can also amend, for each company at the time the shares are purchased. Some of this information will be calculated based on share data (e.g. largest drop in share price in the last 6 months). I want to be able to look at the companies in a portfolio and see how the shares are performing at any one time. That is get the latest details for these companies and recalculate some of the trends / scores. Sell shares. I want to be able to enter the total sell price and the system to calculate the percentage return / loss and normalised return on an annual basis. The company details will be removed from the portfolio and added to the system transactions for historical record. The two websites in question are: [login to view URL]^FTSE [login to view URL];action=constituents From Yahoo (may need to login to an account and select a pre-defined template). Symbol, Name, Market Cap, Prev Close, 52 Wk Range, P/E, Bid, Ask [login to view URL] Read / get data from the 6 months chart and extract a trend (largest drop in last 6 months): [login to view URL] From DigitalLook (again requires login to a free account): 30 day Chng, Broker Rec [login to view URL] What The Brokers Say: [login to view URL] Use the above (What the Brokers Say) details to create a score (details to be provided to bid winner) for each company. At the end you will supply full source code. Payment via Escrow.