We have a simple feed that is basically a web url that returns certain values each time you query with this URL. The values returned represent the price of certain precious metals. We need this data queried each minute and then added to a table that also records the date/timestamp of when the reading was done.
We need the program to also be one where we can easily change the frequency of the reads. Sometimes we may want it to query the data even more often than every minute - so this should be a parameter that can be set in the application. The data will be saved to a msql table. The fields are:
TimeStamp
GoldSpot
SilverSpot
Platinumspot
Palladiumspot
In cases where the data cannot be read, then the values for each spot price should simply be a "-1"