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

 

Embattled Trump nominee Brett Kavanaugh 'not going anywhere' (24 Sep 2018)

 

Rod Rosenstein: Russia inquiry chief set for Trump showdown (24 Sep 2018)

 

Electrical implant helps paralysed people to walk again (24 Sep 2018)

 

Brexit: No 10 says cabinet 'fully behind' PM's plan (24 Sep 2018)

 

Dellen Millard killed father as he slept and inherited millions (24 Sep 2018)

 

Indonesian teenager survives 49 days adrift at sea in 'fishing hut' (24 Sep 2018)

 

Weight Watchers drops 'weight' from name (24 Sep 2018)

 

Oil price jumps as Opec keeps output steady (24 Sep 2018)

 

S-300 missile system: Russia to upgrade Syrian air defences (24 Sep 2018)

 

Kenyan governor Okoth Obado charged over Otieno murder (24 Sep 2018)

more »

 

SF Gate

 

Why the gig economy may not be the workforce of the future (24 Sep 2018)

 

Telltale, San Rafael maker of video games, lays off most of its staff (24 Sep 2018)

 

Ship traffic, September 25 (24 Sep 2018)

 

Gilead facing doubts on Wall Street a year after billion Kite deal (24 Sep 2018)

 

Here are the celebs to look out for at this year's massive Dreamforce event (24 Sep 2018)

 

News site to investigate Big Tech, aided by Craigslist founder (24 Sep 2018)

more »


Site feed Updated: 2018-Sep-24 15:00