{"id":51973,"date":"2009-11-19T00:01:00","date_gmt":"2009-11-19T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2009\/11\/19\/hey-scripting-guy-how-can-i-quickly-check-stocks-with-windows-powershell\/"},"modified":"2009-11-19T00:01:00","modified_gmt":"2009-11-19T00:01:00","slug":"hey-scripting-guy-how-can-i-quickly-check-stocks-with-windows-powershell","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-how-can-i-quickly-check-stocks-with-windows-powershell\/","title":{"rendered":"Hey, Scripting Guy! How Can I Quickly Check Stocks with Windows PowerShell?"},"content":{"rendered":"

\"Bookmark<\/a><\/p>\n

 <\/p>\n

\"Hey,<\/p>\n

Hey, Scripting Guy! I have a customized MSN home page. I really like the new layout, but it is rather inefficient to open Internet Explorer, and wait for a few minutes just to check out the latest stock prices. What I need is a Windows PowerShell script that I can use to quickly retrieve my stock information without the need to open Internet Explorer and scroll down half the page to find a current stock quote. I wrote a Windows PowerShell script that opens a page in Internet Explorer and scrapes the information, but it is only marginally faster than clicking on the Internet Explorer icon on my quick launch bar. Can you write a Windows PowerShell script to retrieve quickly a stock quote?<\/p>\n

— HM<\/p>\n

\"Hey,Hello HM, <\/p>\n

Microsoft Scripting Guy Ed Wilson here. the cool thing about using Windows PowerShell 2.0 to connect to Web services is there are hundreds of Web services on the Internet. Some are highly specialized and rather complex, and others such as the one for retrieving stock quotes are very straightforward. By performing a Bing search<\/font><\/a> for “Web service” or for “WSDL,” you can find hundreds of free and easy-to-use Web services that will do everything from resolving a ZIP code to performing currency conversions. <\/p>\n

HM, the Get-StockQuote.ps1 script uses a Web service to retrieve the latest quote for a given stock. The complete Get-StockQuote.ps1 script is seen here. <\/p>\n

Get-StockQuote.ps1<\/strong><\/p>\n

#Requires -Version 2.0<\/p>\n

<\/font><\/span><\/p>\n

Function Get-StockQuote($symbol)<\/p>\n

<\/font><\/span><\/p>\n

{<\/p>\n

<\/font><\/span><\/p>\n

 <\/span>$URI = “http:\/\/www.webservicex.net\/StockQuote.asmx?WSDL”<\/p>\n

<\/font><\/span><\/p>\n

 <\/span>$stockProxy = New-WebServiceProxy -uri $URI -namespace WebServiceProxy -class stock<\/p>\n

<\/font><\/span><\/p>\n

 <\/span>$stockProxy.getQuote($symbol) <\/p>\n

<\/font><\/span><\/p>\n

} #end Get-StockQuote<\/p>\n

<\/font><\/span><\/p>\n

 <\/font><\/p>\n

<\/span><\/p>\n

$quote = Get-StockQuote -symbol msft<\/p>\n

<\/font><\/span><\/p>\n

[xml]$quote |<\/p>\n

<\/font><\/span><\/p>\n

ForEach-Object {<\/p>\n

<\/font><\/span><\/p>\n

 <\/span>$_.stockQuotes.Stock<\/p>\n

<\/font><\/span><\/p>\n

} #end Foreach-Object<\/p>\n

<\/font><\/span><\/p>\n

The Get-StockQuote.ps1 script begins with the #Requires –Version 2.0<\/b> tag. This is a best practice to prevent the script from attempting to run on a computer with Windows PowerShell 1.0 installed. Because the New-WebServiceProxy<\/b> cmdlet does not work on Windows PowerShell 1.0, the script would generate an error. The #Requires<\/b> command is shown here:<\/p>\n

#Requires -Version 2.0<\/p>\n

<\/font><\/span><\/p>\n

It then uses the Function<\/b> keyword to create the Get-StockQuote<\/b> function. The Get-StockQuote<\/b> function accepts a single parameter—the stock symbol. This is shown here:<\/p>\n

Function Get-StockQuote($symbol)<\/p>\n

<\/font><\/span><\/p>\n

{<\/p>\n

<\/font><\/span><\/p>\n

The path to the StockQuote<\/b> Web Service Definition Language (WSDL) is assigned to the $URI<\/b> variable. The WSDL describes the Web service. As seen in the following image, the StockQuote<\/b> Web service contains a method named GetQuote<\/b> that accepts a stock symbol as a string:<\/p>\n

\"Image<\/p>\n


The path to the StockQuote<\/b> WSDL is assigned to the $URI<\/b> variable as shown here:<\/p>\n

$URI = “http:\/\/www.webservicex.net\/StockQuote.asmx?WSDL”<\/p>\n

<\/span><\/p>\n

The New-WebServiceProxy<\/b> cmdlet is used to create a new Web service proxy for the StockQuote<\/b> Web service. To do this, the New-WebServiceProxy<\/b> cmdlet requires the path to the WSDL for the StockQuote<\/b> Web service. The resulting proxy is stored in the $stockProxy<\/b> variable as shown here:<\/p>\n

$stockProxy = New-WebServiceProxy -uri $URI -namespace WebServiceProxy -class stock<\/p>\n

<\/span><\/p>\n

The getQuote<\/b> method from the StockQuote<\/b> Web service is used to retrieve the stock quote information. The getQuote<\/b> method requires a stock symbol as a string to return the information. This is shown here: <\/p>\n

$stockProxy.getQuote($symbol) <\/p>\n

<\/span><\/p>\n

} #end Get-StockQuote<\/p>\n

<\/span><\/p>\n

The entry point to the script calls the Get-StockQuote<\/b> function and passes a string value for the –symbol<\/b> parameter. The returned data is stored in the $quote<\/b> variable. This is seen here:<\/p>\n

$quote = Get-StockQuote -symbol msft<\/p>\n

<\/span><\/p>\n

The XML type accelerator ([xml]<\/b>) is used to cast the data that is returned from the Get-StockQuote<\/b> function into an XML document. The ForEach-Object<\/b> cmdlet is used to walk through the document, and the stock<\/b> property is used to return the stock quote. This code is seen here: <\/p>\n

[xml]$quote |<\/p>\n

<\/span><\/p>\n

ForEach-Object {<\/p>\n

<\/span><\/p>\n

 <\/span>$_.stockQuotes.Stock <\/p>\n

<\/span><\/p>\n

}<\/p>\n

<\/span><\/p>\n

When the Get-StockQuote.ps1 script runs, the following output is displayed:<\/p>\n

\"Image<\/p>\n

 <\/p>\n

Well, HM, as you can see, Web services are fun and can be relatively easy to use from within Windows PowerShell 2.0. Join us tomorrow as we open the virtual mailbag and address questions that require short answers. That’s right, it is time for Quick-Hits Friday.  <\/span><\/p>\n

If you want to know exactly what we will be looking at tomorrow, follow us on Twitter<\/font><\/a> or Facebook<\/font><\/a>. If you have any questions, send e-mail to us at scripter@microsoft.com<\/font><\/a> or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n

 <\/p>\n

Ed Wilson and Craig Liebendorfer, Scripting Guys<\/p>\n

<\/span><\/b><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

  Hey, Scripting Guy! I have a customized MSN home page. I really like the new layout, but it is rather inefficient to open Internet Explorer, and wait for a few minutes just to check out the latest stock prices. What I need is a Windows PowerShell script that I can use to quickly retrieve […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[3,4,45,165],"class_list":["post-51973","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell","tag-xml"],"acf":[],"blog_post_summary":"

  Hey, Scripting Guy! I have a customized MSN home page. I really like the new layout, but it is rather inefficient to open Internet Explorer, and wait for a few minutes just to check out the latest stock prices. What I need is a Windows PowerShell script that I can use to quickly retrieve […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/51973","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=51973"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/51973\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=51973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=51973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=51973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}