AMREIN ENGINEERING Agenda/X | Sharepoint | Office365 | Partners | Support | Search | About us | Home  
  AE Currency Rates Sharepoint Web Part Deutsch English  


Sharepoint Web Parts  

Digital Clock Web Part  

Stock Chart Web Part  

Stock Quotes Web Part  

Dilbert Web Part  

Quote of the Day Web Part  

"Spotlight On.." Web Part  

"Tip of the Day" Web Part  

Lightbox Web Part  

Weather Web Part  

Slideshow Web Part  

Currency Rates Web Part  

Media Player Web Part  

YouTube Player Web Part  

Map Chart Web Part  

Google Chart Web Part  

Bullet Graph Web Part  

RSS Feed Ticker Web Part  

SQL Viewer Web Part  

Google Map Web Part  

Quick Poll Web Part  

Quick Survey Web Part  

Audio Player Web Part  

Google GeoMapper Web Part  

SQL Chart Web Part  

Exchange Calendar Web Part  

Podcast Web Part  

Filter Web Part  

Image Rotator Web Part  

Navigator Web Part  

KPI Web Part  

Page Hits Web Part  

Picture Menu Web Part  

Timer Web Part  

Van Gogh Web Part  

SQL Bullet Graph Web Part  

User Spotlight Web Part  

List View Web Part  

Staff Directory Web Part  

Birthday Reminder Web Part  

News Carousel Web Part  

Team Members Web Part  

Christmas Web Part  

Classifieds Web Part  

Google Earth Web Part  

Timeline Web Part  

Banner Rotator Web Part  

AZ Index Web Part  

Blog Roll Up Web Part  

Discussion Roll Up Web Part  

Document Roll Up Web Part  

News Roll Up Web Part  

Task Roll Up Web Part  

Calendar Roll Up Web Part  

Quick Form Web Part  

Twitter Web Part  

Upcoming Events Web Part  

Welcome Web Part  

Color Calendar Web Part  

Image Carousel Web Part  

Metro Grid Web Part  

Goal Thermometer Web Part  

Swipe Gallery Web Part  

List Rotator Web Part  

List Search Web Part  

Flash Rotator Web Part  

Accordion & Tabs List Bundle  

Accordion List Web Part  

Tabs List Web Part  

Microblog/Chat Web Part  

Toast Notifications  

Vacation Planner Web Part  

Multilevel Tile Web Part  

Inspired Tiles Web Part  

Facebook Timeline Web Part  

Zip Creator  

Web Part Support  

Web Part Bundle  

Microsoft Sharepoint Web Parts

Currency Rates Sharepoint Web Part



Currency Rates Web Part - New Version*

The Currency Rates Web Part uses the public Currency Rate Web Service to display selected currency exchange rates. The data are delayed and are provided by Yahoo Fincancial Services.

The Web Part can be used with Windows Sharepoint Services V3, MOSS 2007, Sharepoint 2010, Sharepoint 2013 and Sharepoint 2016.

You can configure a list of currency exchange rates to watch.
The web part supports a List view, a Cross Table view, a Tiles view and a Ticker view.









Product Price
Currency Rates Web Part for SP 2007 and SP 2010
30 day Evaluation Version
Free download..
Currency Rates Web Part for SP 2013
30 day Evaluation Version
Free download..
Currency Rates Web Part for SP 2016
30 day Evaluation Version
Free download..
Currency Rates Web Part License Key
per Server License
USD 80.00
Web Part Installation Instructions download..
Deployment  Instructions for SP 2010/2013 download..

Cross Table View

List View


Tile  View


Installation Instructions:

  1. download the Currency Rates Web Part Installation Instructions (PDF file, see above)
  2. Follow the installation instructions in the PDF manual.
    You can either deploy the DLL manually or using the WSP solution to deploy the feature to your server/farm as described in the instructions.
  3. Navigate to a page where you would like to place the webpart and choose "Site Actions/Edit Page"
  4. Add the web part to the appropriate zone. The web part is listed in the "Miscellaneous" web part gallery section
  5. Configure the Web Part Editor "Miscellaneous" pane section as needed:

    • List of Currencies: enter one or more Currency Symbol(s), separed by semicolons.
      Use standard 3-digit abbreviations as eg.
      • USD (US Dollars)
      • EUR (Euro)
      • GBP (British Pound)
      • CHF (Swiss Francs)
      • CAD (Canadian Dollars)

        etc.. (a total of 172 currencies are supported by the Yahoo web service)
        You can download a list of the available symbols here.

        Friendly Currency Names:
        If you would like to display a “friendly currency name” instead of the default currency abbreviation please append it to the currency symbol, separated by the “|” pipe symbol.
        Example:
        USD|US Dollar;EUR|Euro;GBP|British Pound
    • Conversion Unit: enter the conversion unit number (Default=1). All currencies will be multiplied by this value.
    • Number of decimal places: enter the number of decimal places for the displayed currency values.
    • Cross Table Output: toggle between Cross Table View and Single Column List View.
    • Show Currencies as a ticker: display the currencies as a horizontal ticker.
    • Table CSS Style: enter the optional CSS styles to format the table cells.

      Example:
      background-color:lightskyblue;color:black
    • Text CSS Style: enter the optional CSS styles to format the table.

      Example:
      font:10pt Segoe UI;border-bottom:1px solid blue;padding:6px
    • Header Color: set the background color of the table header. Use either an #RRGGBB value or an HTML color name.
      The web part uses the standard Sharepoint style if the field is left empty.
    • Alternate Row Color: set the background color of the alternate table rows. Use either an #RRGGBB value or an HTML color name.
      The web part uses the standard Sharepoint style if the field is left empty.
    • Footer Text: enter an optional footer text displayed at the bottom of the conversion rates table. You can use HTML tags to embed hyperlinks etc.
    • Cache Retention Time: enter the data cache retention time in minutes (enter "0" to turn off the cache feature) to limit excessive calls to the web service.
    • Page Refresh Interval: enter the optional page refresh interval in minutes (0 = no page refresh)
    • License Key: enter your Product License Key (as supplied after purchase of the "Currency Rates Web Part" license key).
      Leave this field empty if you are using the free 30 day evaluation version. You can check the evaluation period via the web part configuration pane:


Please enter a comment below if you have problems with the installation, want to give feedback or have suggestions for improvements:

User Comments Post a Comment 

Taps  
6/5/2009 20:48 
Excellent Web Part but do you know how we can modify the color scheme?
Henrik  
6/9/2009 05:58 
I find the webpart very useful. However, during the past few days we have had the same issue - just diplays the link. We have not made any changes to the firewall or browsers.
Juerg  
6/9/2009 15:42 
Henrik,
the GoCurrency.com web service seems to have a technical problem.
We thus created a new version of web part which now uses the Yahoo Currency web service.
Please uninstall the previous web part and download the new version.
Juerg  
6/9/2009 17:15 
Taps, which colors would you like to be able to adapt (eg. Table header or background etc.) ?
PW  
6/10/2009 20:40 
Could you add on the web part a means for the user to enter the currency amount, select the target currency and display the converted amount?
Taps  
6/15/2009 13:41 
Really just the table header and the alternating row colors... the white is fine...! Many thanks in advance for any help you can provide.
Tommy  
6/16/2009 11:16 
Hello! Ive removed the old webpart due to the error that gocurrency had, and insstalled the new one based on the yahoo service. But all I get is this: Webpart General Error:Input string was not in a correct format. Do you have a fix for this ? Thanks for some great webparts!
Juerg  
6/16/2009 13:31 

Tommy,
please check your “List of Currencies” parameter. This error occurs when you use a leading or a trailing “;”

Correct:
USD;EUR;GBP;CHF;JPY;CAD;AUD

Incorrect:
USD;EUR;GBP;CHF;JPY;CAD;AUD

Incorrect:
USD;EUR;GBP;CHF;JPY;CAD;AUD

We also noticed that the web part also generates the same error for all system locales that use a non "." decimal separator. 
We have now updated the web part to automatically deal with this situation. 
Tommy  
6/16/2009 15:57 
Thank you guys for super fast support! The descimal symbol was the error. And the new DLL fixed everything! Thank you!
N_fcis  
7/14/2009 09:14 
I tried the web part but it displays only the following error "Error accessing the Yahoo Finance service:Unable to connect to the remote server" htough there is no network problems. could this be a security issue
Juerg  
7/14/2009 10:33 
N_fics, Your Sharepoint server is not allowed to access the Yahoo Web Service at http://download.finance.yahoo.com/ . This is most probably caused by your proxy/firewall settings.
Nanang Ars  
7/22/2009 10:22 
I have an error like this : Error accessing the Yahoo Finance service:Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed,... help me please ...
Ram  
7/24/2009 09:47 
Hi Juerg, I am using your few webparts in my site. I created my site on my development server & assign a port to my site(http://devsrv:5555). I put your webparts safe controls entry in the web.config file of my port 5555 (\\192.168.1.20\c$\Inetpub\wwwroot\wss\VirtualDirectories\5555) & drag the dll file in the assembly folder of development server, they are working fine when the site is running on development server but when i deployed my site on the production server, these web parts are not working though i copied the safe controls from the web.config of development to the web.config of my production server and dll of all the webparts in assembly of production server. The error is "A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe. ". And if i click on any web part from the web part gallery then it shows an error "can not import the web part". I have every thing on the production server to run web parts like their dll in the assembly & safe control in the web.config & the web parts are uploaded in web part gallery of the production server's port. Please help me... Regards Ram
Juerg  
7/29/2009 15:34 

Nanang,
you have to add the following line to the "<SAFECONTROLS>" section of your  Web.Config  file:

<SafeControl Assembly="AECurrencyRatesWebpart, Version=1.0.0.0, Culture=neutral, PublicKeyToken=585ba5e3cd32a386"  Namespace="AECurrencyRatesWebpart" TypeName="*" Safe="True" />

Please make sure that this is on one single line  (no line breaks).
Please also make sure that you placed the line into the right web.config file, since you might have multiple Sharepoint  applications installed  on the same machine. The default application typically is found in

Inetpub/wwwroot/wss/VirtualDirectories/80
Juerg  
8/21/2009 10:47 
Ram,
the “Type could not be found or it is not registered as safe” message clearly indicates that something is not OK with the SafeControl entry in the web.config file.
Can you check if you added the entry to the correct web.config file ?
TonySim  
11/4/2009 13:26 
Hi I am expierencing the same error as the user Nanang Ars. I have added the line to my web config, there are no line breaks and it is the correct file as I can see additional changes to web.config. When I try to modify the web part I recieve the error Exception occurred )(Exception from HRESULT: 0x80020009(DISP_E_EXCEPTION)) I would really appreciate any assistance. Is an IIS Reset may be neccessary? Thanks Tony
Juerg  
11/4/2009 13:54 
TonySim, did you put the DLL into c:\windows\assembly ?
TonySim  
11/4/2009 14:01 
I placed the dll in C:\Inetpub\wwwroot\wss\VirtualDirectories\80\bin Is this the correct location? Thanks very much
Juerg  
11/4/2009 14:04 
TonySim, no, you will have to move it into c:\windows\assembly (the "GAC"). Also then delete the copy in your BIN directory.
Please refer to step 2 of the installation instructions above.
TonySim  
11/4/2009 14:35 
I did this and it brought my entire site down with the error message Exception from result> I have removed all references and I will attempt this again. Thanks
tore  
11/24/2009 14:07 
I am not able to drop anything into "the GAC of your Sharepoint server (c:\windows\assembly)" as you say. How do I get the file into this directory?
Juerg  
11/24/2009 17:34 
tore, you need to perform this operation using Windows File Explorer either directly at the server or via RDP (this does not work via a network share!). You can then use drag&drop to put the DLL file into the c:\windows\assembly folder
Tore  
12/12/2009 01:16 
I am on the Server but it is not possible to add a file to the GAC (w:/windows/assembly directory. I am logged in a Administrator
tore  
12/12/2009 10:44 
OK. it was possible with drag&drop but not with copy/ past , CtrC and CtrV (I thought that should do the same).
Yatin  
3/27/2010 10:51 
I tried the web part but it displays only the following error "Error accessing the Yahoo Finance service:Unable to connect to the remote server". Internet is through proxy server.So what else i had to do
Yatin  
3/27/2010 11:21 
Error accessing the Yahoo Finance service:The remote name could not be resolved: 'download.finance.yahoo.com' .Internet is through proxy server
Juerg  
3/29/2010 09:37 
your Sharepoint server is not allowed to access the Yahoo Web Service at http://download.finance.yahoo.com/ (the web part tries to access this URL to fetch the Yahoo currency information) This is most probably caused by your proxy/firewall settings.
Mike  
2/21/2011 08:26 
Hi, Can you tell me how I'd like to change the default currency from USD to AUD in the list view? Thanks
Juerg  
2/21/2011 09:57 
Hi Mike, the first entry in the web part’s „List of Currencies“ settings is treated as the default currency in the list view. Thus you would need to put “AUD” at the first position.
Paul  
6/20/2011 11:00 
Hi, I'm adding this to a fixed width zone so I cannot get to the Edit Web Part while it is in Cross Table Output view. Is there a way to default it to list view? Thanks, Paul.
Juerg  
6/20/2011 11:56 
Paul, you can export the web part and then edit the exported webpart file to change the following line:

<property name="Cross" type="bool">False</property> to

<property name="Cross" type="bool">True</property>

You can then add the web part to the page using the re-imported webpart file.
Paul  
6/20/2011 17:33 
Thanks.
Paul  
6/23/2011 17:27 
Hi, can you provide us with some more information on its use. 1. Does it only update on a browser refresh. 2. Is it ‘real-time’. Do you know the update frequency on the RSS feed. Thanks, Paul.
Juerg  
6/24/2011 11:30 
Paul, we now have added the new "Page Refresh Interval" setting to automatically refresh the page every n minutes. We don't know the update frequence of the Yahoo Finance web service. The data is probably about 1 hour behind.
Paul  
6/24/2011 12:42 
Hi, when you say "we now have added the new "Page Refresh Interval" setting to automatically refresh the page every n minutes" is this new today or is it the Cache Retention Time?. I downloaded version 1.1.3 a few days ago. Thanks, Paul.
Paul  
6/24/2011 13:10 
Please ignore my last post, I can see it is now version 1.1.4. Thanks, Paul.
ARNascimento  
3/18/2015 10:18 
Hi Juerg,
I am using this webpart since Oct, 2014 and yesterday I start receiving the error "Webpart General Error:Input string was not in a correct format". I hadn't changed anything, so I started to build a new 'List of Currencies' and noticed this error occurs any time I have more than any two currencies! Can you help please?
Just for the record, my original list was:
EUR;USD;BRL|Real Br;AOA|Kwanza;MZN|Metical
Thanks,
Américo
Mark Matty  
3/18/2015 15:01 
Two days ago, we noticed that the currency web part stopped working with an error saying that the input string was not in the correct format. There were no changes made at our end. I did notice that it will work for two currencies. Once the third one is added, then the error appears. I checked to make sure that there were no leading or trailing ";" in my list. That list was USD;EUR;GBP;CAD;CNY;HKD
Juerg  
3/18/2015 15:08 
ARNascimento and Mark,
Yahoo recently changed their Yahoo Finance web service interface and we needed to adapt the web part.
Please re-download the updated Zip file, extract the WSP file and then update the web part solution.
ARNascimento  
3/18/2015 15:36 
Hi Juerg,

Great work! Thanks again.

Américo
lisa pease  
4/3/2015 17:31 
What is the new URL the webpart will point to now that http://download.finance.yahoo.com/ is no longer being used. I have to document it in a change control request before I can do the install.
Thank you
Juerg  
4/4/2015 15:05 
Lisa,
the web part still uses http://download/finance.yahoo.com
(there are also currently no plans to change this).
bwise  
6/19/2015 18:35 
Have the same issue as Mark Matty. Downloaded the update and installed but still having same issue. Webpart shows version as 1.1.5. Is that the current version?
Juerg  
6/19/2015 18:50 
bwise,
the current version is 1.2.0 (your version dates from July 2011).
Please update the web part as follows:
  • Download the current version
  • Extract the WSP file from the downloaded Zip file
  • place the WSP file on the server (C:\ root folder)
  • start the SharePoint Management Shell (right click: Start as administrator)
  • run the following cmdlet:
    Update-SPSolution –Identity AECurrencyRatesWebpart.wsp –LiteralPath c:\AECurrencyRatesWebpart.wsp –GACDeployment
collin krizmanich  
9/15/2016 20:23 
The newest version has a Table CSS Style and Options fields. Can you please instruct on how to use the Table CSS Style field and what additional options there may be that are not listed on this page?
Juerg  
9/16/2016 13:39 
collin,
please see the examples for the "Table CSS Style" and "Text CSS Style" at the top of this page.
The web part currently supports the below options:

Timestamp=1 (display the current date/time below the table)
Metro=1 (displays the currency rates as “Metro” tiles)
collin  
9/23/2016 19:17 
When I select the option to show country flags, many of the images are dead links. Can this be fixed?
Juerg  
9/23/2016 19:26 
Collin,
the web part currently only supports the 15 most used currencies.
The missing flags can be added to the below directory on the Sharepoint web frontend server(s):

c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\IMAGES\AECurrencyRatesWebpart

You also can send us a list of the currency symbols not showing the flag and we’ll send you the flag icons.
Haim  
2/22/2017 10:42 
Hi,

when I used the Tile view, the Tiles appears one below the other and not side by side.

can you please advise?

Thank,
Haim.
Juerg  
2/22/2017 11:39 
Haim,
to horizontally align the tiles, please also enter the below into the web part’s “Table CSS Style” setting:

background-color:orange;width:150px;height:150px;padding:5px;color:white;float:left;margin-right:10px
Sylvester  
4/28/2017 21:27 
Hi Juerg,

How do I upgrade Currency Rates Web Part version 1.2.0 in SharePoint 2007 which my current version is 1.1.5 ?

Thank in advance,
Sylvester
Juerg  
5/1/2017 10:23 
Sylvester,
to update the web part on Sharepoint 2007, please use the below STSADM command (assuming that you placed the WSP file in the root directory of your WFE server):

SET STSADM="c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\STSADM.EXE"
Update-SPSolution –Identity AECurrencyRatesWebpart.wsp –LiteralPath c:\AECurrencyRatesWebpart.wsp -GACDeployment
Sylvester Wong  
11/3/2017 02:46 
Hi Juerg,

Good day,

Intranet appearing "Error accessing the Yahoo Finance service:The remote server returned an error: (403) Forbidden." message this morning,

Can you please advise ,

Thank you,
Sylvester Wong
Juerg  
11/3/2017 11:49 
Sylvester,
we are aware of the issue and it looks like the Yahoo Finance web service is currently down.
If the issue will persist, we’ll proceed to switch to an alternate data provider early next week.

Technical Support Contact Information
If you find that you cannot resolve an issue using the above tools, our Technical Support staff will be ready to handle your technical support needs. You can reach our staff by phone or by email.

Phone: +41 (0)62 823 75 75 (9am - 5pm GMT)
Fax : +41 (0)62 823 75 74
Email: support@amrein.com
 
© 2017 AMREIN ENGINEERING AG


We are very satisfied with the ease of implementation of your products and your support.

Peter Hopkinson, Working Technology Pty Ltd





Subscribe to Newsletter
If you want to be kept informed about our new or enhanced Sharepoint web parts, subscribe to our Sharepoint Web Part Newsletter:

You can also subscribe to our Web Part News RSS Feed:

RSS Feed

Follow us on Twitter:

Web Part NewsFree Christmas Card Web Part
11/17/2017
The free Christmas Web Part allows you to display a Christmas Greeting Card with animated snowfall on your Sharepoint pages. The Web Part can be used with WSS3.0, MOSS 2007, SP 2010, SP 2013 and SP 2016. The Web Part allows you to configure the Card Heading, Message Text and Card background image.

SharePoint List Rotator Web Part
5/1/2017
The new "List Rotator" Web Part allows to rotate SharePoint List items manually and/or automatically using a freely configurable layout template. The web part can be used on SharePoint 2010, SharePoint 2013 and SharePoint 2016.

Upcoming Events Web Part
1/1/2017
The Upcoming Events Web Part displays the upcoming appointments of the selected Sharepoint Calendar.
The Web Part can be used with Windows Sharepoint Services V3, MOSS 2007, Sharepoint 2010 and Sharepoint 2013. 
A property filter, the field template, header & footer text, the data refresh interval and the number of items to be displayed can be configured. The web part expands both recurring and multi-day events.

Currency Rates Web Part Basic Annual Support
Basic technical support provides up to 4 incidents per year (1 business day response time) plus free service packs.
Price: USD 75.00

Currency Rates Web Part Premium Annual Support
Premium technical support provides an unlimited number of incidents per year (4 hours response time, office hours GMT+1),  free service packs, updates and new releases.
Price: USD 175.00