Prime Interest Rate Past,Current and Future

[Tjoker]

Good day forumites.

I was hoping someone can help me obtaining the Prime Interest Rate of South Africa.

Busy working on an App that need these date/interest rate for my formula.

Is there an API or something I can use to populate my SQL table?

Preferably I would like automatically check the rate at 00:10 every morning.

I did however find this on our Reserve Bank website :

http://www.resbank.co.za/Research/Rates/Pages/SelectedHistoricalExchangeAndInterestRates.aspx

They have a date range which I can enter, and run the query, and then export to CSV. Does someone know how I can maybe run all this automatically in my app?

 

[guest2013-1]

Is it a windows application? Then you can use the browser control and automate the download/import with forced button presses etc

if it's a web app, you can use something like curl to do what you need/submit forms etc and get the file back like that