Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
litLIB: Calling webservices from Excel (Read 2051 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB: Calling webservices from Excel
06.11.09 at 11:14:16
 
litLIB: Calling webservices from Excel
 
The litLIB Excel addin can retrieve web pages. It retrieves the HTML body of the webpage and displays the result in the Excel cell. The litLIB WebPage function is used to achieve this.  
 
You can also use this function to call web services. I have an example that I would like to share with you today:
 
Stock quotes:
Display Yahoo Finance stock quotes.  
The following formula expects the ticker symbol to be in cell A1.
=WebPage("http://download.finance.yahoo.com/d/quotes.csv?s=" & A1 & "&f=sl1d1t1c1ohgv&e=.csv")
 
Ticker symbols can be found at finance.yahoo.com. Examples
Microsoft = MCRS, ^AEX = Amsterdam AEX index, ING.AS = ING NV at Amsterdam, TOM2.AS = Tom Tom at Amsterdam
 
ABC
Ticker SymbolCell FormulaCell Result
1MCRS      =WebPage("http://download.finance.yahoo.com/d/quotes.csv?s=" & A1 & "&f=sl1d1t1c1ohgv&e=.csv")      """MCRS"",27.45,""11/5/2009"",""4:00pm"",0.00,N/A,N/A,N/A,0"
2^AEX      =WebPage("http://download.finance.yahoo.com/d/quotes.csv?s=" & A2 & "&f=sl1d1t1c1ohgv&e=.csv")      """^AEX"",308.41,""11/6/2009"",""5:06am"",+0.58,308.44,309.75,307.94,0"
3ING.AS      =WebPage("http://download.finance.yahoo.com/d/quotes.csv?s=" & A3 & "&f=sl1d1t1c1ohgv&e=.csv")      """ING.AS"",9.682,""11/6/2009"",""4:30am"",+0.032,9.735,9.895,9.671,5725418"
4TOM2.AS      =WebPage("http://download.finance.yahoo.com/d/quotes.csv?s=" & A4 & "&f=sl1d1t1c1ohgv&e=.csv")      """TOM2.AS"",7.068,""11/6/2009"",""4:29am"",-0.011,7.249,7.25,7.061,1192489"

 
Back to top
 
« Last Edit: 06.11.09 at 11:22:43 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1