#Google currency full#
Next, we need to set triggers on our new script to fire up when we open the spreadsheet! This step is performed through the user interface and the full documentation can also be found on Google help portal FYI, scripting in google spreadsheet is quite powerfull and you can scan through entire documentation on official Google apps help portal Next we need to create a script for our spreadsheet and we can do this task if we click on “Tools” -> “Script Manager”. If you click here you will see the example of JSON data… This service returns JSON formatted date for all currencies and please note that the base currency is the US Dollar. The first thing is to find the source of our data and for this use-case we decided to give OpenSource Exchange rates JSON data a green light. Also, their labs service Google Finance is deprecated so we must get our hands dirty and take the JavaScript approach for populating our spreadsheet with REAL-TIME currency quotes.
One might guess that Google supports Exchange rates in their spreadsheets “AS-IS” but this is not the case. Managing your expenses in one or multiple exchange rates.Convert your revenue from Dollars to Euros.If you are doing business analysis or calculations in your Google Apps spreadsheets then you probably need some kind of currencies converter for doing all sorts of tasks…
0 kommentar(er)
