Microsoft Sharepoint Web Parts

Stock Quotes Sharepoint Web Part

MSN Stock Quotes Web Part - New Version*

The Stock Quotes Web Part uses the public Yahoo Finance Stock Quote Web Service to display selected stock quote information. The data are delayed by 20 minutes and provided by Yahoo Finance. The Web Part can be used with Windows Sharepoint Services V3, MOSS and Sharepoint 2010.  You can configure the following web part properties: the list stock symbol(s) to watch the amount of information displayed by selecting specific columns Stock Ticker or Table display Clicking on a company name in the list leads you to the related Yahoo Finance page for more information on the selected stock. Since the web part connects to an external web service, we recommend to deploy it to the Global Assemby Cache (GAC) for security reasons. Important Note to all customers using the original MSN based web part: On June 10, 2010 we have released a new version based on the Yahoo Finance service (since the original MSN web service has been shut down). Please re-download the new Yahoo-based version, extract and then replace the StockQuotesWebpart.DLL (followed by an "iisreset" command if you placed the DLL in c:\windows\assembly). Product Price Stock Quotes Web Part 30 Day Evaluation Version Free Stock Quotes Web Part License Key USD 80.00 Installation Instructions   You can also send us a PO via e-mail to info@amrein.com  or by fax to ++41 62 823 75 74

Table View (no table header) Ticker View Stock Index Display Sigle Stock Display

Installation Instructions: download the Stock Quotes Web Part Installation Instructions (PDF file, see above)  download the StockQuotesWebpart.zip file (see above) deploy the feature to your server/farm as described in the instructions. Navigate to a page where you would like to place the webpart and choose "Site Actions/Edit Page" Add the web part to the appropriate zone. The web part is listed in the "Amrein Engineering" web part gallery section Configure the Web Part properties in the Web Part Editor "Miscellaneous" pane section as described in the Installation Instructions. Stock Symbol(s): enter one or more stock sybols, separed by semicolons. If you enter just one stock symbol, the "Single Stock Display" applies, otherwise the stocks are rendered in Table View. You can lookup the available stock symbols on the Yahoo Finance web site. You can also request a stock index as eg. ^FTSE (FTSE 100)  ^NYA (NYSE Composite Index) ^DJI (Dow Jones Industrial Average Index) ^IXIC (NASDAQ Composite Index) ^GSPC (S&P 500 Index) ^RUI (Russell 1000 Index) ^N225 (Nikkei Index) ^HSI (Hang Seng) etc. Local Exchange stock quotes usually have a country prefix as eg. GB:EZJ (EasyJet/London Exchange) DE:MUK (Bayerische Gewerbebau AG/Frankfurt Exchange) Stock Detail Fields: add additional columns to the list, separated by semicolons. The following columns are available: - CompanyName - Change - PercentChange - Currency - Exchange - Last - LastTime - LastSize - Open - Close - High - Low - Ask - Bid - EPS - PE     - Volume - SharesOut - Currency - Exchange You can append a stock chart to the "Single Stock Display" by appending ";Chart" to the end of the field. ;Chart  adds a chart of the current trading day. ;Chart/v adds a chart of the past 5 days ;Chart/y adds a chart of the past year Example: Symbol;CompanyName;Last;Change;PercentChange;LastTime;Open;Close;Chart/y In case your Sharepoint site uses SSL, the chart is fetched from MSN Money Central (since Yahoo currently does not support https). In this case, the MSN stock symbol needs to be given as an additional parameter (you can lookup the available stock symbols on the MSN Money Central web site). Please note that the first parameter now is the number of days past to be displayed. Example: Symbol;CompanyName;Last;Change;PercentChange;Chart/10/$NYA.X Show Table Header: turn on/off the Stock Table headers: Center Text: center the text in the "Single Stock Display" mode UTC Offset Last Trade: enter the optional UTC offset (in hours) to correct the "Last Trade" info Footer Text: Enter an optional Footer text at the bottom of the web part. Show Stocks as a Ticker: display the stock quotes as a scrolling ticker: Ticker Scroll Delay: sets the Marquee scroll delay in millseconds (1=fastest, higher values=slower) You can also optionally specify the marquee scroll amount in pixels by appending the value (separated by a semicolon): Example: 1;3 Ticker Background Color: Enter the desired background color of the ticker (Default:white). Use either a hex RGB value (as eg. #FFCC99) or an HTML color name (as eg. orange) Ticker Font Style: Enter the optional Ticker CSS style if you want to override the standard Sharepoint font settings. Example: 20pt Lucida Sans You can optionally append more CSS styles as follows: 20pt Lucida Sans; font-weight:bold; color:red Ticker Delimiter: enter the desired Ticker delimiter character string (Default: "+++") Ticker Height: enter the desired Ticker height in pixels (Default = 20 pixels) Page Refresh Interval: enter the page refresh interval in minutes (0 = no page refresh) License Key: enter your Product License Key (as supplied after purchase of the license key). Leave this field empty if you are using the evaluation version.

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
Juerg Amren   2/27/2009 16:27  We have updated the ZIP package as of today since the DLL contained in the previous version was not strongly signed and thus could not be deployed to the GAC. Massimo   4/16/2009 19:51  I keep getting a "The "StockQuotes" Web Part appears to be causing a problem. The remote server returned an error: (407) Proxy Authentication Required." Why Brian   5/7/2009 15:40  I also periodically receive an error message indicating the "StockQuotes" Web Part appears to be causing a problem. Is it possible to trap errors in that web part so it doesn't prevent the page from loading? Brian   5/7/2009 15:42  The message we receive when the page doesn't load is "Object reference not set to an instance of an object." We use the web part to display the market indexes. ($INDU, $COMPX, $INX) Juerg   5/8/2009 11:48  It seems that sometimes the MSN Money Web Service does not properly respond (which we actually never have experienced over here so far, but other customers also told us about this problem). We have thus added some error handling to the web part which now prevents the page-level exception and just displays an informative message on the web part level. Please re-download the ZIP file, extract and replace the DLL in your GAC. You’ll also have to restart IIS in order to force re-loading of the DLL. Ryan   5/14/2009 01:04  any chance you could wrap this web part into a solution file to ease deployment to larger farms? Mark Chaaban   8/14/2009 21:41  is there a way for me not to display the symbol, I want to show the company name and change only. Juerg   8/17/2009 13:44  Mark, the display of the stock symbol cannot be suppressed. We thus would need to add this feature as an enhancement.. Nancy   8/18/2009 22:11  I have done all the steps and continue to get "Cannot import this web part" when I try to use this on a page in my site. ARGH! Juerg   8/19/2009 10:03  Nancy, can you check if you added the “SafeControl” entry to the right web.config file ? You should use the one located at: c:\inetpub\wwwroot\wss\virtualdirectories\80 Did you also check your Trust Level setting ? If your have a trust level of “WSS_Minimum”, please set it to <trust originUrl="" level="WSS_Medium" /> Finally, there might be a permission or proxy problem since the server needs to access an externalweb service at msn.com to fetch the stock data. Chet   8/25/2009 19:02  Hi. First I want to say thank you for the web part. It is great. Some of the things I have heard feedback on that would be nice to see if you update in the future are Column headers and comma's in dollar amounts that exceed 999.99. Thanks. Chet   8/25/2009 19:25  Also, for some reason our time is showing as Pacific, but all our server clocks and site region settings are Eastern. Any ideas? Juerg   8/26/2009 16:09  Chet, the "LastTime" information as supplied by the MSN Money web service is indeed in Pacific time. The web part does not attempt to translate this value into local time. Anne   9/2/2009 21:55  Great tool! It is working for for the stock symbols. But for some reason, it doesn't show a stock index like for example DJI. It is just empty when I enter that? Juerg   9/3/2009 15:37  Anne, the DJI symbol indeed seems to be not available anymore. Use $INDU (Dow Jones Industrial Average Index) or look up any of the many other Dow Jones indices at the MSN Money Central web site Fritz   10/17/2009 01:40  Hello there, after installing the Webpart, i´m getting the following Errormessage: MoneyCentral Web Service error: Fehler bei der Anforderung des Berechtigungstyps System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089. The only Stock-Quote i wanted to display was: DE:ALV ??? What is wrong Juerg   10/19/2009 10:42  Fritz, can you check your Trust Level setting in your web.config file? If you have a trust level of “WSS_Minimum”, please set it to <trust originUrl="" level="WSS_Medium" /> Fritz   10/20/2009 00:44  Dear Juerg, sorry but i don´t have a "trust originUrl" - Entry in my web.config. The only Thing i have is the "trustLevel name" Entry. Where do i have to place the "trust originUrl" - Entry in my web.config? Thanks Fritz Juerg   10/20/2009 09:36  Fritz, that's the correct entry ! If it reads      <trust level="WSS_Mimimum" originUrl="" /> then please change it to      <trust level="WSS_Medium" originUrl="" /> Jason   11/2/2009 21:57  Installed Stock Chart Webpart beautifully but cannot get Stock Quote Webpart to work. I've successfully added it to the Gallery and can add it to a Page but when I Modify it, I always get this error inside the Webpart text: MoneyCentral Web Service error: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. I've tried updating web.config trust level to WSS_Medium but this did not help. What else could be going on? THANKS! Juerg   11/3/2009 10:11  Jason, the web part accesses the external MSN web service and needs the appropriate rights to be able to do this. Can you change the „trust level” line in your web.config from <trust level="WSS_Medium" originUrl="" /> to <trust level="WSS_Medium" originUrl=".*" /> eg. insert the “.*” characters into the originUrl attribute. This should allow Web Service calls to any destination. If this does not help, check the „defaultProxy“ setting in your web.config file. By default it looks like: <system.net>   <defaultProxy>      <proxy autoDetect="true" />    </defaultProxy> </system.net> You might have to add your specific proxy information as follows: <system.net>    <defaultProxy>       <proxy usesystemdefault=”false” proxyaddress=”http://xxx:yyyy/” bypassonlocal=”true” />    </defaultProxy> </system.net> where “xxx” is your proxy server IP (ISA) and “yyyy” is the port of the proxy. Jason   11/5/2009 23:50  Thanks for the help. Unfortunately I'm still having trouble. My web.congig reads: <trust level="WSS_Custom"" originUrl="" /> I tried updating this to be "WSS_Medium" but that caused other serious problems on my site. So, I changed it back and updated the orginUrl=".*". That didn't work. When I try to add the webpart to a page I get a dialog box error reading: Unable to add selected web part(s). Next I looked for the <system.net> section of my web.config but there was none, so I added both of the ones you recommend. Both of them caused other problems so I removed them. I am having exactly the same problems with the Stock Chart webpart now too. Yet, both webparts preview fine from the Webp Art Gallery. Thanks for your help. Tried adding ".*" to my <trust level> tag. Juerg   11/6/2009 09:25  Jason, did you put the DLL into the GAC at c:\windows\assembly (as it should) ? Please note that we now have added a Sharepoint Solution file (contained in the Zip file) which allows to deploy the Web Part as a solution (please refer to the Installation PDF file). Jason   11/8/2009 17:07  I have located it at C:\WINDOWS\assembly\ <br><br> In this folder I also have subfolders called GAC, GAC_32 and GAC_MSIL. Should it be in one of these instead? Jason   11/8/2009 18:58  What is strangest is that I am able to get your StockChart web part to install and work no problem. I've duplicated the steps for both web parts and continue to have problems with just the StockQuote web part. The symptoms are that it successfully imports and will even be successfully added to the page, however, as soon as I "Modify the Webpart", and add Stock Symbols and/or Stock Detail Fields , I get the following error message in the web part: MoneyCentral Web Service error: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. This error does not occur when I leave the stock info blank and simply change Appearance properties. Juerg   11/9/2009 13:05  Jason, this is because your current Sharepoint Server settings do not allow you to call external web services (in this case the MSN Money Central Stock Quotes Web Service at "http://office.microsoft.com/Research/Providers/MoneyCentral.asmx). We recommend to place the DLL into c:\windows\assembly (instead of the application’s bin directory). The web part calls the web service only if you add one or more stock symbols to the “Stock Symbols” field. Juerg   11/9/2009 13:09  Jason, no, it should be in the c:\windows\assembly folder (not in one of the folders below it). You need to add the DLL using Windows Explorer (drag&drop) either directly at the server or via RDP (not via a network share). Allan   11/29/2009 22:55  Hi Juerg, The webpart initially works fine but it will send me a 407 Proxy Authentication Required after around 10 minutes. Then I need to go to modify the webpart and change the properties (ie. stock symbols, enable the ticker etc) many times to make it work again. However, it will stop working again after around 10 minutes. Any ideas what's causing this? O yeah, I am still using the trial version. Thanks Juerg! Juerg   12/1/2009 13:38  Allan, can you change the „trust level” line in your web.config file from <trust level="WSS_Medium" originUrl="" /> to <trust level="WSS_Medium" originUrl=".*" /> eg. insert the “.*” characters into the originUrl attribute. This should enable Web Service calls to any destination. If this does not help, can you also change the “defaultProxy” setting in your web.config as follows: <defaultProxy useDefaultCredentials="true">    <proxy usesystemdefault="false" proxyaddress="http://xxx:yyyy" bypassonlocal="true" /> </defaultProxy> where “xxx” is your proxy server IP (ISA) and “yyyy” is the port of the proxy. Allan   12/3/2009 00:53  Hi Juerg - Thanks. Yes, I did all that. I even added: <bypasslist>    <add address="[a-z]+ .*\.microsoft\.com" />    <add address="64\.4\.\..*" /> </bypasslist> under the <defaultproxy> Somehow, it is still not consistent, as it may display the quote for 5-10 minutes and then stops. James   4/27/2010 20:41  I have installed and added the stock ticker web part (evaluation version) and table view displays correctly but ticker view does not. Do I need to wait a period of time before it will begin to display? Juerg   5/3/2010 16:44  James, IE8 out-of-the box refuses to honor the MARQUEE HTML tag unless you loosen its security restrictions and also put it into compatability (Quirks) mode. We thus went on to replace the MARQUEE tag with a JavaScript ticker which is compatible with IE8. Please re-download the updated Zip file from our web site at /apps/page.asp?Q=5731 , extract and then replace the DLL (followed by an “iisreset” command if you placed the DLL in c:\windows\assembly) jabolfan   7/2/2010 19:34  I've installed the Stock Quaote Web part and getting an error of " MoneyCentral Web Service error: The remote server returned an error: (404) Not Found. " I tried to point my browser to http://office.microsoft.com/Research/Providers/MoneyCentral.asmx and got "Webpage cannot be found" The dll is in both the bin and assembly directory Shrikant   7/3/2010 08:42  I m getting following error: Yahoo Finance Web Service error: Index was outside the bounds of the array. Any suggestions Juerg   7/5/2010 10:39  Shrikant, can you check if you entered a trailing semicolon in the "Stock Detail Fields" box ? if yes, please remove it. Juerg   7/5/2010 10:46  jabolfan, it looks like you are still using the old MSN Money Central-based (pre June 10,2010) version of the web part. Please re-download the most recent version (which is now based on the Yahoo Finance web service). Stephen   7/6/2010 17:08  I have downloaded the latest version, copied the DLL to the GAC (c:\windows\assembly), run iisrest command, but I still receive the following error: "MoneyCentral Web Service error: The remote server returned an error: (404) Not Found." Juerg   7/6/2010 17:21  Stephen, can you check your web part version number (at the top of the web part's configuration pane) ? It should read 1.2.5: Stephen   7/7/2010 10:18  Hi Juerg, it still says "2009 AMREIN ENGINEERING AG" and there is no version number displayed, so it is still picking up the old version. I have also uploaded the new "StockQuotes.webpart" file to the Webpart Gallery and tried adding it as a new web part. Juerg   7/7/2010 10:29  Stephen, can you check if you originally placed the DLL in your application's BIN folder (so Sharepoint is still picking up this old version) ? If yes, please delete the old DLL in the BIN folder. Stephen   7/7/2010 11:35  Hi Juerg, I have now uninstalled the DLL from the GAC first, then copied the new DLL file again, reset iis and it now works. Thanks for your help. Mark De Souza   7/16/2010 01:05  We are evaluating the use of this stock quote web part and it looks great. however, when we attempt to show the graph for a single stock quote, we are getting the "secure/insecure warning. The culprit is the image that is being called from http://ichart.yahoo.com/c/bb/m/. Do you have a solution for this? Juerg   7/16/2010 10:20  Mark, Yahoo Finance has no SSL support for their charts but MSN Money Central does. Thus if your stock symbol is also available on MSN Money Central, we could provide a switch to use the MSN chart instead. Mark De Souza   7/16/2010 20:17  Juerg, Thanks for your quick response. On another note, is there a way to manipulate font sizes/styles at all? Juerg   7/18/2010 14:19  Mark, the web part now also applies the “Ticker Font Style” setting to the “Single Stock” display. We also now have added support for MSN Money Central charts if your site runs on SSL. Mark   7/21/2010 23:12  Hey Juerg, We are having an issue on one of our boxes so I tried just doing the full install on another server. It seems to have installed fine and I've deployed and activated it. However, when I go to add a web part I can't see it in the list of web parts. Any thoughts? Juerg   7/27/2010 14:02  Mark, did you activate the feature on the correct Sharepoint top level site (sometimes the feature is erroneously activated in the Central Admin site) ?