tungwaiyip.info

home

about me

links

Media

Yucatán Photos

St Lucia Photos

Photo Album

Videos

Blog

< June 2008 >
SuMoTuWeThFrSa
1 2 3 4 5 6 7
8 91011121314
15161718192021
22232425262728
2930     

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

 

Brexit: EU demands 'serious UK response' on citizens' rights (29 Apr 2017)

 

North Korea crisis: North in another 'failed' missile launch (29 Apr 2017)

 

Turkish authorities block Wikipedia without giving reason (29 Apr 2017)

 

France election: Marine Le Pen would make Dupont-Aignan PM (29 Apr 2017)

 

Tense moment plane lands without wheel (29 Apr 2017)

 

Italian woman 'returns mixed-race surrogate baby' (29 Apr 2017)

 

Hungary education law: Orban 'to meet EU demands' (29 Apr 2017)

 

El Salvador zoo: Prosecutors investigate 'suspicious deaths' (29 Apr 2017)

 

China deports US 'spy' Sandy Phan-Gillis after conviction (29 Apr 2017)

 

Ted 2017: Elon Musk's vision for underground road system (28 Apr 2017)

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)

 

California issues historic medical marijuana rules (29 Apr 2017)

 

In dot-com bubble time, it’s still only 1997 for U.S. equities (29 Apr 2017)

 

ICYMI: Trump’s job hard, dirty jeans scorned, Charmin for Butt (29 Apr 2017)

 

Craigslist sues Instamotor for allegedly re-posting car ads (29 Apr 2017)

 

Wait for calorie count on burgers, pizza may get longer (28 Apr 2017)

 

The biggest regrets people have after buying a home (28 Apr 2017)

more »

 


Site feed Updated: 2017-Apr-29 12:00