Re: [WebDNA] Live Currency exchanege rates
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100696
interpreted = N
texte = :-) Take a look at this, just put this together very quickly, using the =20 Yahoo Finance downloadable .csv file. [text]EuroLookup=3D[tcpconnect host=3Duk.old.finance.yahoo.com] [tcpsend skipheader=3DT]GET /d/quotes.csv?s=3DGBPEUR=3DX&f=3Dsl1d1t1ba&e=3D= .csv =20 HTTP/1.0[unurl]%0D%0A[/unurl][!] [/!]Host: uk.old.finance.yahoo.com[unurl]%0D%0A%0D%0A[/unurl][!] [/!][/tcpsend][/tcpconnect][/text] [ListWords Words=3D[EuroLookup]&Delimiters=3D,] [index]: [word]
[/ListWords] Looks like it might be good enough for what I need. Mark. On 10 Sep 2008, at 17:22, Gil Poulsen wrote: > Uh oh. There goes my comparative dress pricing. ;-( > > On Sep 10, 2008, at 12:17 PM, Mark Derrick wrote: > >> Thanks for this, I'd already looked at something similar to this =20 >> earlier, but the following message I found on their site didn't =20 >> seem to indicate a long-term solution. :-( >> >> "The New York Fed announced its decision to discontinue the =20 >> publication of foreign exchange rates on December 31, 2008." >> >> Mark. >> >> >> >> On 10 Sep 2008, at 17:09, Gil Poulsen wrote: >> >>> Hi, Mark. Does this help you? I write include files with the =20 >>> exchange rate for the various countries noted. That allows me to =20 >>> show comparative pricing for used Irish dancing dresses on =20 >>> irishdancingexchange.com... >>> >>> >>> >>> >>> [text show=3DF]year=3D[date format=3D%Y][/text] >>> [text show=3DF]month=3D[date format=3D%m][/text] >>> [text show=3DF]day=3D[date format=3D%d][/text] >>> >>> >>> >>> [TCPConnect host=3Dwww.ny.frb.org&port=3D80] >>> [text show=3DF]ex_rates=3D[TCPSend skipheader=3DT]GET = /markets/fxrates/=20 >>> FXtoXML.cfm?FEXdate=3D[year]%2D[month]%2D[day]=20 >>> %2000%3A00%3A00%2E0&FEXtime=3D1200 HTTP/1.0[unURL]%0D%0A%0D%0A[/=20 >>> unURL][/TCPSend][/text] >>> [/TCPConnect] >>> >>> >>> [showIf [ex_rates]^frbny:] >>> >>> >>> [text show=3DF]ex_rates=3D[grep search=3Dfrbny:&replace=3D][ex_rates][= /=20 >>> grep][/text] >>> >>> [xmlparse var=3Dxml_rates][ex_rates][/xmlparse] >>> >>> [loop start=3D1&end=3D23] >>> [xmlnode ref=3Dxml_rates&var=3Dseries&path=3Dnamed:UtilityData/DataSet= /=20 >>> Series([index])] >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DAUD][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/USD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/AUD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf]=20 >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DUSD][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/CAD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/CAD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf]=20 >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DEUR][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/USD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/EUR.inc][value][/writeFile][/xmlnodes][/showIf][/showIf]=20 >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DNZD][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/USD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/NZD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf]=20 >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DGBP][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/USD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/GBP.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][/=20= >>> xmlnode] >>> [/loop] >>> >>> [/showIf] >>> >>> >>> >>> >>> On Sep 10, 2008, at 11:58 AM, Mark Derrick wrote: >>> >>>> Hi, >>>> >>>> Does anyone currently use a free feed for currency exchange rates? >>>> >>>> We're looking to move to offering multiple currency through our =20 >>>> store, and would like to pull the latest exchange rate 2-3 times =20= >>>> a day to ensure our advertised prices are correct. >>>> >>>> Google seems to offer one through it's API, but I'm not able to =20 >>>> find out much more about it. >>>> >>>> Anyone used anything like this? >>>> >>>> >>>> Thanks. >>>> >>>> Mark. >>>> >>>> >>>> >>>> ----------------------------------------------------------- >>>> The information contained in this e-mail and any attachments are =20= >>>> intended only for the addressees. If you are not the intended =20 >>>> recipient, please return the message to the sender by replying to =20= >>>> it and then delete the message from your computer. >>>> The views expressed in this e-mail are those of the individual =20 >>>> author and not necessarily those of Computer Warehouse Ltd. Prior =20= >>>> to taking any action based upon this e-mail you should seek =20 >>>> appropriate confirmation of its authenticity. This email is not =20 >>>> intended to impose nor shall it be construed as imposing any =20 >>>> legally binding obligation upon Computer Warehouse Limited. =20 >>>> Although Computer Warehouse Ltd routinely screens for viruses, =20 >>>> addressees should also scan this e-mail and any attachments for =20 >>>> viruses and Computer Warehouse Ltd makes no representation or =20 >>>> warranty as to the absence of viruses in this e-mail or any =20 >>>> attachments. >>>> ---------------------------------------------------------- >>>> 1 Amalgamated Drive . West Cross Centre . Great West =20 >>>> RoadBrentford . Middlesex TW8 9EZ >>>> >>>> Registered in England no. 2111018 >>>> ---------------------------------------------------------- >>>> Computer Warehouse - The UK's favourite Apple Mac Reseller >>>> http://www.computerwarehouse.co.uk >>>> >>>> Vote for Computer Warehouse at this years MacUser awards, and get =20= >>>> the chance to win prizes worth =A33,500. >>>> http://www.computerwarehouse.co.uk/MacUserAwards >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list
. >>>> To unsubscribe, E-mail to: >>>> >>> >>> -- >>> Gil Poulsen, Mac Wirehead >>> >>> ************************ >>> AltiM@c Consulting >>> 23 Marco Polo Court >>> Franklin Park, NJ 08823-1703 >>> Voice: 609-359-0103 >>> http://altimac.com >>> ************************ >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >> >> 3 > > -- > Gil Poulsen, Mac Wirehead > > ************************ > AltiM@c Consulting > 23 Marco Polo Court > Franklin Park, NJ 08823-1703 > Voice: 609-359-0103 > http://altimac.com > ************************ > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: ----------------------------------------------------------- The information contained in this e-mail and any attachments are=20= intended only for the addressees. If you are not the intended recipient,=20= please return the message to the sender by replying to it and then=20= delete the message from your=20= computer. The views expressed in this e-mail are those of the individual author=20= and not necessarily those of Computer Warehouse Ltd. Prior to taking any=20= action based upon this e-mail you should seek appropriate confirmation=20= of its authenticity. This email is not intended to impose nor shall it=20= be construed as imposing any legally binding obligation upon Computer=20= Warehouse Limited. Although Computer Warehouse Ltd routinely screens for=20= viruses, addressees should also scan this e-mail and any attachments for=20= viruses and Computer Warehouse Ltd makes no representation or warranty=20= as to the absence of viruses in this e-mail or any=20= attachments. ---------------------------------------------------------- 1 Amalgamated Drive . West Cross Centre . Great West Road=20= Brentford . Middlesex TW8=20= 9EZ Registered in England no.=20= 2111018 ---------------------------------------------------------- Computer Warehouse - The UK's favourite Apple Mac=20= Reseller http://www.computerwarehouse.co.uk Vote for Computer Warehouse at this years MacUser awards, and get the=20= chance to win prizes worth=20= =A33,500. http://www.computerwarehouse.co.uk/MacUserAwards
Associated Messages, from the most recent to the oldest:
:-) Take a look at this, just put this together very quickly, using the =20 Yahoo Finance downloadable .csv file. [text]EuroLookup=3D[tcpconnect host=3Duk.old.finance.yahoo.com] [tcpsend skipheader=3DT]GET /d/quotes.csv?s=3DGBPEUR=3DX&f=3Dsl1d1t1ba&e=3D= .csv =20 HTTP/1.0[unurl]%0D%0A[/unurl][!] [/!]Host: uk.old.finance.yahoo.com[unurl]%0D%0A%0D%0A[/unurl][!] [/!][/tcpsend][/tcpconnect][/text] [ListWords Words=3D[EuroLookup]&Delimiters=3D,] [index]: [word]
[/ListWords] Looks like it might be good enough for what I need. Mark. On 10 Sep 2008, at 17:22, Gil Poulsen wrote: > Uh oh. There goes my comparative dress pricing. ;-( > > On Sep 10, 2008, at 12:17 PM, Mark Derrick wrote: > >> Thanks for this, I'd already looked at something similar to this =20 >> earlier, but the following message I found on their site didn't =20 >> seem to indicate a long-term solution. :-( >> >> "The New York Fed announced its decision to discontinue the =20 >> publication of foreign exchange rates on December 31, 2008." >> >> Mark. >> >> >> >> On 10 Sep 2008, at 17:09, Gil Poulsen wrote: >> >>> Hi, Mark. Does this help you? I write include files with the =20 >>> exchange rate for the various countries noted. That allows me to =20 >>> show comparative pricing for used Irish dancing dresses on =20 >>> irishdancingexchange.com... >>> >>> >>> >>> >>> [text show=3DF]year=3D[date format=3D%Y][/text] >>> [text show=3DF]month=3D[date format=3D%m][/text] >>> [text show=3DF]day=3D[date format=3D%d][/text] >>> >>> >>> >>> [TCPConnect host=3Dwww.ny.frb.org&port=3D80] >>> [text show=3DF]ex_rates=3D[TCPSend skipheader=3DT]GET = /markets/fxrates/=20 >>> FXtoXML.cfm?FEXdate=3D[year]%2D[month]%2D[day]=20 >>> %2000%3A00%3A00%2E0&FEXtime=3D1200 HTTP/1.0[unurl]%0D%0A%0D%0A[/=20 >>> unURL][/TCPSend][/text] >>> [/TCPConnect] >>> >>> >>> [showIf [ex_rates]^frbny:] >>> >>> >>> [text show=3DF]ex_rates=3D[grep search=3Dfrbny:&replace=3D][ex_rates][= /=20 >>> grep][/text] >>> >>> [xmlparse var=3Dxml_rates][ex_rates][/xmlparse] >>> >>> [loop start=3D1&end=3D23] >>> [xmlnode ref=3Dxml_rates&var=3Dseries&path=3Dnamed:UtilityData/DataSet= /=20 >>> Series([index])] >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DAUD][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/USD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/AUD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf]=20 >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DUSD][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/CAD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/CAD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf]=20 >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DEUR][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/USD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/EUR.inc][value][/writeFile][/xmlnodes][/showIf][/showIf]=20 >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DNZD][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/USD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/NZD.inc][value][/writeFile][/xmlnodes][/showIf][/showIf]=20 >>> [showIf [xmlnodes ref=3Dseries&path=3Dnamed:Key&name=3DCURR&exact=3DT]= =20 >>> [value][/xmlnodes]=3DGBP][showIf [xmlNodeAttributes][name]/[value] = [/=20 >>> xmlNodeAttributes]^UNIT/USD][xmlnodes =20 >>> ref=3Dseries&path=3Dnamed:Obs&name=3DOBS_VALUE&exact=3DT][writeFile = /=20 >>> includes/GBP.inc][value][/writeFile][/xmlnodes][/showIf][/showIf][/=20= >>> xmlnode] >>> [/loop] >>> >>> [/showIf] >>> >>> >>> >>> >>> On Sep 10, 2008, at 11:58 AM, Mark Derrick wrote: >>> >>>> Hi, >>>> >>>> Does anyone currently use a free feed for currency exchange rates? >>>> >>>> We're looking to move to offering multiple currency through our =20 >>>> store, and would like to pull the latest exchange rate 2-3 times =20= >>>> a day to ensure our advertised prices are correct. >>>> >>>> Google seems to offer one through it's API, but I'm not able to =20 >>>> find out much more about it. >>>> >>>> Anyone used anything like this? >>>> >>>> >>>> Thanks. >>>> >>>> Mark. >>>> >>>> >>>> >>>> ----------------------------------------------------------- >>>> The information contained in this e-mail and any attachments are =20= >>>> intended only for the addressees. If you are not the intended =20 >>>> recipient, please return the message to the sender by replying to =20= >>>> it and then delete the message from your computer. >>>> The views expressed in this e-mail are those of the individual =20 >>>> author and not necessarily those of Computer Warehouse Ltd. Prior =20= >>>> to taking any action based upon this e-mail you should seek =20 >>>> appropriate confirmation of its authenticity. This email is not =20 >>>> intended to impose nor shall it be construed as imposing any =20 >>>> legally binding obligation upon Computer Warehouse Limited. =20 >>>> Although Computer Warehouse Ltd routinely screens for viruses, =20 >>>> addressees should also scan this e-mail and any attachments for =20 >>>> viruses and Computer Warehouse Ltd makes no representation or =20 >>>> warranty as to the absence of viruses in this e-mail or any =20 >>>> attachments. >>>> ---------------------------------------------------------- >>>> 1 Amalgamated Drive . West Cross Centre . Great West =20 >>>> RoadBrentford . Middlesex TW8 9EZ >>>> >>>> Registered in England no. 2111018 >>>> ---------------------------------------------------------- >>>> Computer Warehouse - The UK's favourite Apple Mac Reseller >>>> http://www.computerwarehouse.co.uk >>>> >>>> Vote for Computer Warehouse at this years MacUser awards, and get =20= >>>> the chance to win prizes worth =A33,500. >>>> http://www.computerwarehouse.co.uk/MacUserAwards >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> >>> >>> -- >>> Gil Poulsen, Mac Wirehead >>> >>> ************************ >>> AltiM@c Consulting >>> 23 Marco Polo Court >>> Franklin Park, NJ 08823-1703 >>> Voice: 609-359-0103 >>> http://altimac.com >>> ************************ >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >> >> 3 > > -- > Gil Poulsen, Mac Wirehead > > ************************ > AltiM@c Consulting > 23 Marco Polo Court > Franklin Park, NJ 08823-1703 > Voice: 609-359-0103 > http://altimac.com > ************************ > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: ----------------------------------------------------------- The information contained in this e-mail and any attachments are=20= intended only for the addressees. If you are not the intended recipient,=20= please return the message to the sender by replying to it and then=20= delete the message from your=20= computer. The views expressed in this e-mail are those of the individual author=20= and not necessarily those of Computer Warehouse Ltd. Prior to taking any=20= action based upon this e-mail you should seek appropriate confirmation=20= of its authenticity. This email is not intended to impose nor shall it=20= be construed as imposing any legally binding obligation upon Computer=20= Warehouse Limited. Although Computer Warehouse Ltd routinely screens for=20= viruses, addressees should also scan this e-mail and any attachments for=20= viruses and Computer Warehouse Ltd makes no representation or warranty=20= as to the absence of viruses in this e-mail or any=20= attachments. ---------------------------------------------------------- 1 Amalgamated Drive . West Cross Centre . Great West Road=20= Brentford . Middlesex TW8=20= 9EZ Registered in England no.=20= 2111018 ---------------------------------------------------------- Computer Warehouse - The UK's favourite Apple Mac=20= Reseller http://www.computerwarehouse.co.uk Vote for Computer Warehouse at this years MacUser awards, and get the=20= chance to win prizes worth=20= =A33,500. http://www.computerwarehouse.co.uk/MacUserAwards
Mark Derrick
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Multiple fields on 1 input (1997)
[showif]/[hideif] question (1997)
Bug Report, maybe (1997)
Removing [showif] makes a big difference in speed (1997)
[WebDNA] OT? - how to get webdna to tell browser to open SWF directly in the browser? (2009)
transferring password & username (2000)
cart ID (1998)
WebCatalog for Postcards ? (1997)
Auction made in webcat (2000)
Need relative path explanation (1997)
Mime Headers for Mail (1998)
WebCat2 several catalogs? (1997)
[WebDNA] HTTP crashes (2010)
Outsourcing partnership ... (2005)
Summing fields (1997)
Custom WebCat Prefs ... (1997)
webcat restarting script on Linux? (1999)
Banners and sort of random display (1997)
search/showif issues (2000)
Setting user/password with a form. (2000)