JSON Stock Queries

For some reason it wasn't easy to figure out where I could get back a concise JSON response for a stock quote. I wanted this for my Portfolio Rebalance spreadsheet, where I needed to query for a stock price and then insert it into the spreadsheet.

Well after digging around I figured out you can use Google finance to get back a JSON response to any stock ticker.

http://finance.google.com/finance/info?client=ig&q=MSFT

for example, will return:

   {
      "id":"358464",
      "t":"MSFT",
      "e":"NASDAQ",
      "l":"25.06",
      "l_cur":"25.06",
      "s":"0",
      "ltt":"4:00PM EDT",
      "lt":"Sep 23, 4:00PM EDT",
      "c":"0.00",
      "cp":"0.00",
      "ccol":"chb"
   }

A load of Windows Phone Apps arrived recently

It seems like a big old truck of Windows Phone apps just arrived in the past few weeks. I've been missing these apps since switching over last year.

  • Doodle Jump
  • Angry Birds
  • Plants vs Zombies
  • New York Times
  • FlightAware
  • AccuWeather (so long weather channel)
  • AmazonFresh (only on Windows Phone)
  • American Airlines
  • Best Buy
  • Dictionary.com
  • Epicurious
  • Evernote

what's still missing?
  • FlighTrack Pro
  • Remember The Milk (official app)
  • Alarm.com (for my alarm company)

Amazon.com customer service continues to impress me

Talk about pro-active customer service. This is the kind of thing that makes a customer for life:

Because you may not have been able to playback one of your rentals or purchases in HD quality, we have issued you a one-time Amazon Instant Video credit of $1 for each of the HD movies and TV episodes you have purchased from us for a total amount of $32

I really have no idea why they would do this, but I'm not going to complain!

Avoiding plastic in kids dinnerware

It’s really hard to avoid plastic these days. It’s everywhere. A few years ago, when our first daughter was born, and before we all knew what BPA was, I did some research on the topic. It was all rather fascinating. Fast forward 5 years and you won’t find a baby bottle that contains BPA. They are all either made of Polymide.

By now you should know that there are three kinds of plastics

1)       Good Plastics

2)       Bad Plastics

3)       Unknown Plastics

Good plastics are as far as we know, safe for things like food (including heating them up). Things like Polypropylene, High-Density Polyethylene, Low-Density & Polyethylene are all “safe plastics”.

The bad plastics, things like Polycarbonate, are almost gone entirely as containers for food items, replaced by things like Eastman Tritan. They look the same (clear plastic), but are branded with new “BPA free” stickers. But we still have PVC and Polystyrene (the coffee lids you use from Starbucks) which I am sure are leaching into our bodies (the coffee lids at Microsoft are finally compostable and made of corn).

That leaves the “unknowns”. Things like melamine. Your kids dishes and cups are made of this stuff. That is unless they are ceramic, porcelain, glass or stainless steel. But, sadly all those things break. It’s not clear if they are safe or not. I am a skeptical person when it comes to this stuff. We only ask science to answer certain questions, and the answers to this one are not conclusive. For one thing melamine will melt in a microwave, does that mean it’s not going to leech chemicals in a dishwasher, which can reach in excess of 100 degrees?

It’s seriously hard to figure all this stuff out (that is if you care to figure it out, many people don’t). I do care, so when I have time, I do research on the topic. We’ve pretty much tried as hard as we could to use glass and stainless steel with our kids. We look for things like borosilicate glass (that’s what Pyrex is made of). But for dishes I recently discovered something that’s been around forever. Dishware made by Corelle. It comes in lots of colors and shapes, and they have a lot of styles that will appeal to kids. The best part is, they are made of glass, but are really resistant to breaking. It’s basically a laminated tempered glass (like your windshield). They are readily available from Amazon and Amazon Fresh.

Here is what we got for Sarah:

And so far, she is a big fan.

Here’s to one less plastic food vehicle in our house.