Foreign Exchange/RSS

[Steve]

I know little about RSS feeds (am probably even using the wrong term)
but am interested in setting up a database that has automatically
updated foreign exchange rates eg USD vs Australian $ recorded.
This would need to have the date of the exchange rate as well as the
actual rate so would be building up over time obviously.
Am I kidding myself
TIA

[rkc]

If you can find a web service that provides that information then you
can
certainly send requests to it from an Access application using one of
several methods. The key part is finding a service.

[Steve]

I have found some RSS feeds (hence my reference to RSS) but have no
idea what to do from here

[lyle fairfield]

On Aug 13, 2:29 am, Steve <stevecox4...@gmail.com> wrote:

This is an ASP (using Javascript) function that gets a user foreign
exchange rate (CAD-Euro). This could be converted to VBA with a little
work. I've modified the site address to avoid annoying the bank.

function exchangeRate(){
try{
var xmlHttpRequest=new ActiveXObject('MSXML2.XMLHTTP.6.0');
var rawHTML=new String();
var regularExpression=new RegExp();
var line=new Array();
regularExpression=/Euro \(EUR\)<\/td><td align="center"
class="regulartext">(\d\.\d{0,4})<\/td><td align="center"
class="regulartext">(\d\.\d{0,4})<\/td>/;

xmlHttpRequest.open('GET', 'http://www.somebank.com/
ABC:Rc@5fY71A8UAAqnCsxI/rates/cashrates.html' , false);
xmlHttpRequest.send();
rawHTML=xmlHttpRequest.responseText;

line=regularExpression.exec(rawHTML);

return line[2];
}
catch(exchangeError){
return 0
}
}

[CDMAP...@fortunejames.com]

On Aug 13, 2:29 am, Steve <stevecox4...@gmail.com> wrote:

IIRC, one of the PDC 05 presentations briefly mentioned that RSS feeds
are implemented using XML. A quick search of microsoft.com produced:

Extreme XML
Revamping the RSS Bandit Application

Dare Obasanjo
Microsoft Corporation

http://msdn.microsoft.com/en-us/library/ms950799.aspx

It seems to contain much information that you will possibly need,
including the hints:

"XSLT to enable customizable views of news items"

and

"It takes a user-defined XSLT stylesheet and transforms the RssItem,
which implements the IXPathNavigable interface, into HTML."

Note that because Microsoft beefed up the tools available for working
with XML it may be possible to do everything without touching .NET at
all.

I haven't played with RSS feeds yet so I can't give you more details
at the moment. Hopefully, the article will give you some leads.

Then again, you probably aren't dealing with RSS at all and Lyle's
idea to grab the information directly from the HTML will work out
better for you.

James A. Fortune
CDMAP...@FortuneJames.com