StockQuote 2.1.2 released

This is a bug fix release for the price import error when importing price from Yahoo Finance, due to changes in its HTML code recently. No new feature was added.

Download this release at the download page.

StockQuote 2.1.1 released

This is a bug fix release for the price import error from Fundsupermart.com after it has changed its site layout. No new feature was added. Thanks to the feedback that reported this bug.

Download this release at the download page.

 

StockQuote 2.1 released

Since I have bought SGS bonds from Fundsupermart, I need to import SGS bond prices into my portfolio spreadsheet. So I updated StockQuote code base to add this functionality and released it as version 2.1 “Wisdom Tooth”.

Grab StockQuote 2.1 zip file at the download page. And also read the README.txt in the zip file on how to obtain ticker for SGS bond from Fundsupermart.

Looking forward to your feedback. Thanks.

Import stock quotes into Excel using web services

Excel is a very useful portfolio and investment tracking tool. You can customize it to your heart content with formulas and macros. However, I find it troublesome to enter stock price and currency rate manually from the web. I thought it would be nice to automate this using web services but I am not aware of websites that provide such services.

Well, I have found a web services sample code that grabs stock quotes from Yahoo Finance web page. With this, I can run the web services on my PC, and then use Excel macro to call the web services to extract stock quotes. Ya, I could have rewritten the sample code to Excel macro, so that Excel can call it without running the web services. But I am not good at writing Excel macro, and I am lazy to rewrite it, hehe.

So what do I have here?

I have packaged the web services sample code (SOURCE) with a simple web server (SOURCE), written some Excel macros to consume the web services, and here I have: StockQuote – my little program that imports stock quotes and currency rates into Excel, with a click of a button

How to use StockQuote? Download the latest release below, extract the zip file and read the README.txt for the instruction to setup. After setting up, open ‘StockQuoteDemo.xls’ (see screenshot below) to test it. Have fun!

PS: Besides using StockQuote, you can try the following two alternatives to import stock quotes and currency rates into Excel:

1. Use Excel web queries. Follow this GUIDE.
2. Use MSNStockQuote plug-in. Read this POST by Indexfundfan.

---

StockQuote Release History

• StockQuote 1.0. Download (247KB .zip). Released Oct 24, 2006.
  • Import stock price from Yahoo Finance
• StockQuote 2.0. Download (251KB .zip). Released Jan 14, 2007.
  • Added support for importing unit trust fund price from Fundsupermart.com
• StockQuote 2.1. Download (251KB .zip). Released Sep 03, 2008.
  • Added support for importing SGS bond price from Fundsupermart.com
• StockQuote 2.1.1. Download (251KB .zip). Released Dec 09, 2008.
  • Fixed price import error after Fundsupermart.com changed site layout.
• StockQuote 2.1.2. Download (251KB .zip). Released Apr 05, 2009.
  • Fixed price import error after Yahoo Finance changed site layout.