tungwaiyip.info

home

about me

links

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

 

Dutch shooting: Utrecht police arrest suspect after three killed (18 Mar 2019)

 

Cyclone Idai: Mozambique president says 1,000 may have died (18 Mar 2019)

 

'No third Brexit vote without changes' (18 Mar 2019)

 

Three dead in record flooding in US Midwestern states (18 Mar 2019)

 

New Zealand shootings: Christchurch students perform Haka for victims (18 Mar 2019)

 

Italy's La Scala opera house to return Saudi millions (19 Mar 2019)

 

Yellow vest protests: Paris police sacked, rally bans planned (18 Mar 2019)

 

Rio state takes over running of Brazil's iconic Maracanã stadium (18 Mar 2019)

 

Armando, the 'Lewis Hamilton of pigeons' sells for record €1.25m (18 Mar 2019)

 

Russia human rights: Chechnya court jails Memorial activist (18 Mar 2019)

more »

 

SF Gate

 

Women in economics report rampant sexual assault and bias (18 Mar 2019)

 

The A-list heads to Apple as challenge to Netflix takes shape (18 Mar 2019)

 

Ship traffic, March 19 (18 Mar 2019)

 

Facebook’s messaging ambitions amount to much more than chat (17 Mar 2019)

 

A better way to break up big tech (17 Mar 2019)

 

Trump administration could hamper shift to more efficient light bulbs (17 Mar 2019)

more »


Site feed Updated: 2019-Mar-18 18:00