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

 

Copenhagen shooting: Gunman charged in court with murder (04 Jul 2022)

 

Marmolada glacier collapse in Italy kills seven (04 Jul 2022)

 

Tim Westwood: BBC reveals complaints against DJ (04 Jul 2022)

 

EasyJet deputy quits after major flight disruption (04 Jul 2022)

 

Scientists discover new giant water lily species (04 Jul 2022)

 

Jayland Walker: Ohio police release video of deadly suspect chase (04 Jul 2022)

 

Kellogg's loses court case over sugary cereal supermarket offers (04 Jul 2022)

 

Manipur landslide: 42 dead, 20 missing as rescue operations continue (04 Jul 2022)

 

Prices in Turkey rise at fastest pace for 24 years (04 Jul 2022)

 

Sydney floods: Tens of thousands told to evacuate (03 Jul 2022)

more »

 

SF Gate

 

'This will be somewhat painful': Elon Musk talks Twitter takeover in extended interview at TED2022 Vancouver (14 Apr 2022)

 

Best Background Check Services in 2022, Top 13 People Finder Sites Reviewed (5 Apr 2022)

 

Better.com employees got severance checks before they were laid off (9 Mar 2022)

 

Apple joins other Bay Area tech giants in responding to Russian invasion of Ukraine (1 Mar 2022)

 

Uber will now show you how you’re rated by drivers (18 Feb 2022)

 

The man behind Google’s Silicon Valley headquarters says fancy tech offices are ‘dangerous’ (24 Jan 2022)

more »


Site feed Updated: 2022-Jul-04 07:00