Adding functional currencies to GETRATES.AVB

[crampton]

Saw a thread from 2012 with the same subject as above.

Was working to add JPY exchange rates to GETRATES.AVB macro but after errors realized that it appears the website (

http://fx.sauder.ubc.ca/today.html)

only handles USD, CAD, and EUR translations.

Am I missing anything? It appears my JPY efforts may be futile using this website.

How do most people handle nowadays? Tairox update service? Macro with a different website?

Thanks in advance.

 

[ettienne]

JPY is there, but if you want something reliable then Tairox is the way to go.

Sage 300 Certified Consultant

 

[crampton]

Let me restate--it looks like this macro reads the column name downwards. Since the website only has columns for USD, CAD, and EUR translations, those are the only home currencies I can use the macro for. If I want to use currencies from the first column as home currencies and then convert back to USD, I'd have to completely redesign the macro, correct?