Gadget Currency Meter

[mikpoc]

I just downloaded this gadget but it does not work. Can someone please help?

 

[freebeerjkt]

OK. After I do that do I need to publish all over again ?. Then insert the new URL in "gadget.js".
Also if I want to put same thing on another computer do I have to start all over from fresh or can I use same published URL ?.
Can't tell you enough how much I appreciate all the help.
Many many thanks.

 

[81kab]

OK. After I do that do I need to publish all over again ?. Then insert the new URL in "gadget.js".
Also if I want to put same thing on another computer do I have to start all over from fresh or can I use same published URL ?.
Can't tell you enough how much I appreciate all the help.
Many many thanks.

You are welcome!

You don't need to publish the spreadsheet again. If you want to put the same thing on another computer, just use the same published URL.

 

[freebeerjkt]

Got it all working now on both my desktop and laptop. Can't thank you enough for all the help.
Have a great weekend.
Tony.

 

[kevin1999]

Hi there, I want to share my workaround for this issue.

First, when looking through the gadget code I noticed that it use 3rd-party service (Yahoo) to retrieve currency values. But unfortunately Yahoo has closed that service ( https/forums.yahoo.net/t5/Yahoo-Finance-help/http-download-finance-yahoo-com-d-quotes-csv-s-GOOG-amp-f/td-p/387096 ).

I decided to use Google Spreadsheets where it is possible to use GoogleFinance() function and export the spreadsheet to CSV file. In my case, I'm going to track USD/RUB and EUR/RUB pairs. I think you could easily replace them with yours.

[...]

Feel free to ask any questions, I will try to help.

Thank you. This works well for me for the values. I guess you'd also have to change the charts.js significantly for the charts to work.

I expect you may have seen tomazov has posted a "1.5" version that uses:

getDataURL('https/finance.google.com/finance/converter?a=1&from=' + currencyName0.value +'&to='+ currencyName1.value);

Available here:

https/drive.google.com/file/d/17DGKWgh5imybZ6xICgbatV1rkKzmV6n5/edit

This has the limitation that only one currency pair is allowed per widget but the charts work too.

Edit: Just for info, I copied the charts.js, charts.html, and charts.css from the 1.5 files into the 1.4 directory and now have a fully functional multi currency widget again. Thanks all.

 

[lamalado]

Hello
Thank you for this huge job.

I have a question and I wish you to help me.

By copying the code of the file "gadget.js" into http/unminify.com/ and clicking on "Unminify", I have the message "ERROR" "Unexpected error." and all stops. so I can not go to the next step.

Thank you in advance for your help.

 

[kevin1999]

Hello
Thank you for this huge job.

I have a question and I wish you to help me.

By copying the code of the file "gadget.js" into http/unminify.com/ and clicking on "Unminify", I have the message "ERROR" "Unexpected error." and all stops. so I can not go to the next step.

Thank you in advance for your help.

I had the same error. You don't need it though. The 1.5 version of the code is already unminified and you can take advantage of the charts code too. See my post above.

 

[colin.a.day]

Hi there, I want to share my workaround for this issue.

First, when looking through the gadget code I noticed that it use 3rd-party service (Yahoo) to retrieve currency values. But unfortunately Yahoo has closed that service ( https/forums.yahoo.net/t5/Yahoo-Finance-help/http-download-finance-yahoo-com-d-quotes-csv-s-GOOG-amp-f/td-p/387096 ).

I decided to use Google Spreadsheets where it is possible to use GoogleFinance() function and export the spreadsheet to CSV file. In my case, I'm going to track USD/RUB and EUR/RUB pairs. I think you could easily replace them with yours.

Step 1.
Create a new google spreadsheet. First column should contain your currency pairs divided by "/" symbol. Second column will have results of GoogleFinance() calculation.

Step 2.
Fill the table. For example, this is my table:

Currencies will update automatically.

Step 3.
Go to menu and select "File" -> "Publish to Web". Next shoose CSV format and click "Publish".
You will get a URL, something like https/docs.google.com/spreadsheets/.../pub?gid=0&single=true&output=csv . Save it to a safe place.

Step 4.
Now we will need to change URL in the gadget's code.
Go to folder C:\Users\[your user name]\AppData\Local\Microsoft\Windows Sidebar\Gadgets\Currency_Meter.gadget\

Find a file called "gadget.js" and open it with a text editor, e.g. Notepad.
You will see a lot of minified code, copy all the code and paste it to http/unminify.com/ . Click "Unminify".
Next, replace all minified code with unminified one. Save the gadget.js file.

Step 5.
In the gadget.js file find definition of function getData() (line #1393 for me). Replace all the code inside the curly brackets with this code:

getDataURL('YOUR URL FROM STEP 3');

Where you should paste URL from the Step 3 inside the brackets.

In my case:

Next, save the file.

Step 6.
Now you will need to disable the Currency Meter gadget and then enable it again. If everything goes well, you will see it is working again!

Feel free to ask any questions, I will try to help.