about me



< June 2008 >
1 2 3 4 5 6 7
8 91011121314

past articles »

Click for San Francisco, California Forecast

San Francisco, USA


Python Stock Quote

There are many free tools available to help people manage their stock portfolio. For example, you can use Yahoo! Finance to track your current holdings. For each stock it list many detail financial data as well as stock chart for various periods. Still, when you need to do more sophisticated analysis, there is nothing that beats the power of spreadsheet.

Fortunately it is easy to pull the data from the web tool to a spreadsheet. You can simple copy and paste the data into a spreadsheet to get a properly formatted table. For there you can add your custom formula or charts. The problem is unlike the web view, data downloaded on a spreadsheet is not updated with current market information. On the other hand if you download the again you will lose all custom formula you have added.

To get the best of both world, I have created a script to so that you can update your spreadsheet with the latest stock quote from the web. This is a simple Python script. It first looks for the stock symbols in your portfolio in your spreadsheet. It then fetches the (15 minute delayed) stock quote from a Yahoo web services. Finally it updates the cells in the spreadsheet with new data from Yahoo.

This tool requires Python 2.5, Excel and pywin32 extension. Click here to download the stock quote update script.

2008.06.22 [] - comments



blog comments powered by Disqus

past articles »


BBC News


Trump replaces National Security Adviser HR McMaster with John Bolton (23 Mar 2018)


Trump's cabinet: who's next in firing line? (23 Mar 2018)


'Highly likely' Russia behind attack - EU leaders (22 Mar 2018)


Pacific garbage patch 'growing rapidly' (22 Mar 2018)


Toys R Us founder Charles Lazarus dies at 94 as his company folds (22 Mar 2018)


Origin of 'six-inch mummy' confirmed (22 Mar 2018)


Syria war: Eastern Ghouta rebels announce ceasefire (22 Mar 2018)


Trump announces tariffs on in Chinese imports (22 Mar 2018)


Sex doll 'brothel': Xdolls escapes Paris council censure (22 Mar 2018)


Facebook data: What the social media giant knows about you (22 Mar 2018)

more »


SF Gate


Bay Area News (7 Jan 2012)


City Insider (11 Feb 2012)


Crime Scene (13 Feb 2012)


C.W Newius Column (10 Jan 2012)


C.W. Nevius Blog (11 Feb 2012)


Education News (10 Jan 2012)


KALW (11 Feb 2012)


Matier and Ross Blog (11 Feb 2012)


March for Our Lives gets a Lyft; can you name a woman in tech? (22 Mar 2018)


Meredith says it intends to sell Time, Sports Illustrated, Fortune and Money (22 Mar 2018)


Ship traffic, March 23 (22 Mar 2018)


YouTube bans firearm sales and how-to videos, prompting backlash (22 Mar 2018)


Uber’s new rival in Australia: an Indian upstart (22 Mar 2018)


Video shows Uber robot car in fatal accident did not try to avoid woman (22 Mar 2018)

more »


Site feed Updated: 2018-Mar-22 18:00