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

 

Plastic bag pollution

Recently I have come to aware of the issue of Great Pacific Garbage Patch from the media. It is large region in the Pacific Ocean that has accumulated much man-made garbage carried there by ocean current. Amount them are many plastic trash. On one hand plastic are very durable because they are not biodegradable. On the other hand plastic are photodegradable, meaning under the exposure of sunlight, they will slowly break down into smaller and smaller pieces. The result is a high concentration of pollutant in the water that is nearly impossible to clean up.

To most people this problem is nothing more than just a scientific interest. After all we don't venture into the middle of the ocean. So this problem is out of sight, out of mind. But today I have personally experienced the effect of photodegradation right in my own backyard.

Two years ago my mother has spent several months in my home. In her spare time she has built a vegetable garden in the yard. Being, shall I say, a resourceful person, she has reused many trash items to build a trellis. For example she scavenged many plastic bags that we would have throw away and used it as ties to the stakes.

Unfortunately, after she has left, we have not given the garden proper upkeep. It was quickly overrun by weeds. And finally I have to clear it out. As I was dismantling the trellis, I found the plastic bags have become very flaky. After exposed in sunlight for 2 years, the have all photodegraded. As I tried to remove them, they just break down into small pieces of white plastic and scattered all over the garden. There is just no way for me to mop up these tiny pieces from the soil. Who would have thought plastic bags can turn into a much bigger headache after it has degraded like this.

2008.06.14 comments

 

past articles »

 

BBC News

 

Afghan contractors: 'I wish I'd never worked for the UK government' (16 Aug 2022)

 

Trump warrant: Prosecutors oppose releasing search evidence (16 Aug 2022)

 

Scott Morrison: Ex-Australia PM held five additional portfolios, Albanese says (16 Aug 2022)

 

Sacheen Littlefeather: Oscars apologises to actress after 50 years (16 Aug 2022)

 

Five men held in Ukraine deny being mercenaries (16 Aug 2022)

 

Norway bridge collapse: Drivers of two vehicles rescued (15 Aug 2022)

 

Body found in world's highest battlefield 38 years on (16 Aug 2022)

 

Egypt church fire: Triplets and twins among 15 children killed (15 Aug 2022)

 

Kenya election result: William Ruto wins presidential poll (15 Aug 2022)

 

German households face levy of hundreds of pounds on gas bills (15 Aug 2022)

more »

 

SF Gate

 

These were the highest-paying Silicon Valley tech companies in 2021 (19 Jul 2022)

 

'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)

more »


Site feed Updated: 2022-Aug-16 00:00