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

 

Polish PM accuses EU of blackmail as row over rule of law escalates (19 Oct 2021)

 

North Korea confirms 'successful' submarine-launched missile test (19 Oct 2021)

 

Navy report blames crew for devastating fire on the Bonhomme Richard (19 Oct 2021)

 

UK 'keeping a close eye' on rising Covid cases (19 Oct 2021)

 

School steps in to give classes to Afghan children living in hotel (19 Oct 2021)

 

Squid Game helps Netflix subscriptions bounce back (19 Oct 2021)

 

Rachel Levine: Transgender official sworn in as four-star admiral (20 Oct 2021)

 

Austria driver sought after two migrants found dead on bus (19 Oct 2021)

 

Myanmar: Mass release of political prisoners (19 Oct 2021)

 

Oleg Deripaska: FBI searches US homes linked to Russian oligarch (19 Oct 2021)

more »

 

SF Gate

 

13 Best Background Check Sites & Services: Search Criminal Records and Social Media Accounts Online (28 Jul 2021)

 

It pays to search for top-quality auto shop (6 Feb 2021)

 

Fired Boeing CEO is now working with Bay Area tractor startup (14 Dec 2020)

 

PG&E bills to rise over per year on average to fund wildfire risk reduction (5 Dec 2020)

 

Nasdaq seeks more diversity on boards of companies listed on exchange (2 Dec 2020)

 

Elizabeth Holmes Prosecutors Say Texts Show Theranos Beset With Problems (24 Nov 2020)

more »


Site feed Updated: 2021-Oct-15 09:00