Retrieving Currencies rate?

[kidney514]

We are canadian based company that purchase our product in US dollars

 

I'm trying to create a function that will do this on the fly!

Lets says I enter a Price Cost US: 10, i would like to have the Price Cost CAD automatically calculated with the function.

Everything if ready, except I can get my head around extracting the currencies value to make the convertion.

Currencies_id = 3 want to extract the value of it and use in my calculation

 

This may be totally wrong, and help would be appreciated, but is what I have so far for the function......

 

US To CAD

START OF CODE ADDITION

*/

function updateCADcost() {

var currencies_value = get?????????;

var costus = document.forms["new_product"].products_cost_US.value;

costCAD = costus / currencies_value;

}

document.forms["new_product"].products_cost.value = doRound(netValue, 4);

}

/*

US to CAD

END OF CODE ADDITION

[kidney514]

anyone?

[kidney514]

pretty please!