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

 

Zimbabwe troops accused of 'systematic torture' of protesters (23 Jan 2019)

 

Brexit delay worse than no deal - minister (23 Jan 2019)

 

Emiliano Sala: Missing Cardiff City FC player 'sent message from plane' (23 Jan 2019)

 

Niagara Falls becomes a 'winter wonderland' (23 Jan 2019)

 

Yang Hengjun: Australia seeks information on writer 'missing' in China (23 Jan 2019)

 

Social media stars agree to declare when they post ads (23 Jan 2019)

 

Sabarimala: India woman who defied temple ban 'abandoned' by family (23 Jan 2019)

 

Priyanka Gandhi launches political career ahead of key India polls (23 Jan 2019)

 

Kevin Barnett: Sitcom writer and stand-up comedian dies aged 32 (23 Jan 2019)

 

Venezuela opposition set for mass protest against Maduro (23 Jan 2019)

more »

 

SF Gate

 

Ship traffic, January 23 (22 Jan 2019)

 

'I'm so fed up': With shoplifting all too frequent in Hayes Valley, some merchants are at wits' end (22 Jan 2019)

 

The highest-paying job in California isn't in tech, but a more traditional sector (22 Jan 2019)

 

AI policy is tricky. From around the world, they came to hash it out (22 Jan 2019)

 

EU’s antitrust cop lays groundwork for more tech scrutiny (21 Jan 2019)

 

Amazon knows what you buy, and it’s building a big ad business from it (21 Jan 2019)

more »


Site feed Updated: 2019-Jan-23 03:00