I want to automate the collection of the unit prices of mutual funds from each company's respective website page that displays the latest price for each fund. At the moment I have to visit each one and manually copy and paste the data, which is time consuming.
How do I identify the relevant information from the website concerned (it's all public domain info), how do I capture it, and how can I then insert it into a MySQL database? It would typically be displayed:
<Fund name1><Unit Price><Currency>
My aim is to be able to have a single page displaying my portfolio without having to spend half an hour every day doing the grunt work.
Any ideas? I get stuck on the first rung of how do I tell my system to go and get the right data... plus some!
TIA